Microsoft Excel in Accounting teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Microsoft Excel in Accounting is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.
- Accredited by CPD
- Instant e-certificate and hard copy dispatch by next working day
- Fully online, interactive course with audio voiceover
- Self-paced learning and laptop, tablet, smartphone-friendly
- 24/7 Learning Assistance
- Discounts on bulk purchases
Sneak Peek
Who should take the course
Anyone with a knack for learning new skills can take this Microsoft Excel in Accounting. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.Certification
Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.Accreditation
All of our courses, including this Microsoft Excel in Accounting, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.Course Curriculum
The detailed curriculum outline of our Microsoft Excel in Accounting is as follows:Microsoft Excel in Accounting- Microsoft Excel 2019 New Features
- Getting Started with Microsoft Office Excel
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbooks
- Managing Workbooks
- Working with Functions
- Working with Lists
- Analyzing Data
- Visualizing Data with Charts
- Using PivotTables and PivotCharts
- Working with Multiple Worksheets and Workbooks
- Using Lookup Functions and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Forecasting Data
- Excel Templates
We guarantee that all our online courses will meet or exceed your
expectations. If you are not fully satisfied with a course - for
any reason at all - simply request a full refund. We guarantee no
hassles. That's our promise to you.
Go ahead and order with confidence!
Easy to Access
Let's Navigate Together
Course Curriculum
| Microsoft Excel 2019 New Features | |||
| Introduction to Microsoft Excel 2019 New Features | |||
| CONCAT | |||
| IFS | |||
| MAXIFS | |||
| MINIFS | |||
| SWITCH | |||
| TEXTJOIN | |||
| Map Chart | |||
| Funnel Chart | |||
| Better Visuals | |||
| Pivot Table Enhancements | |||
| Power Pivot Updates | |||
| Getting Started with Microsoft Office Excel | |||
| Navigate the Excel User Interface | |||
| Use Excel Commands | |||
| Create and Save a Basic Workbook | |||
| Enter Cell Data | |||
| Use Excel Help | |||
| Performing Calculations | |||
| Create Worksheet Formulas | |||
| Insert Functions | |||
| Reuse Formulas and Functions | |||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | |||
| Search for and Replace Data | |||
| Use Proofing and Research Tools | |||
| Formatting a Worksheet | |||
| Apply Text Formats | |||
| Apply Number Format | |||
| Align Cell Contents | |||
| Apply Styles and Themes | |||
| Apply Basic Conditional Formatting | |||
| Create and Use Templates | |||
| Printing Workbooks | |||
| Preview and Print a Workbook | |||
| Set Up the Page Layout | |||
| Configure Headers and Footers | |||
| Managing Workbooks | |||
| Manage Worksheets | |||
| Manage Workbook and Worksheet Views | |||
| Manage Workbook Properties | |||
| Working with Functions | |||
| Work with Ranges | |||
| Use Specialized Functions | |||
| Work with Logical Functions | |||
| Work with Date & Time Functions | |||
| Work with Text Functions | |||
| Working with Lists | |||
| Sort Data | |||
| Filter Data | |||
| Query Data with Database Functions | |||
| Outline and Subtotal Data | |||
| Analyzing Data | |||
| Apply Intermediate Conditional Formatting | |||
| Apply Advanced Conditional Formatting | |||
| Visualizing Data with Charts | |||
| Create Charts | |||
| Modify and Format Charts | |||
| Use Advanced Chart Features | |||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | |||
| Analyze PivotTable Data | |||
| Present Data with PivotCharts | |||
| Filter Data by Using Timelines and Slicers | |||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | |||
| Use 3-D References | |||
| Consolidate Data | |||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | |||
| Trace Cells | |||
| Watch and Evaluate Formulas | |||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | |||
| Protect Worksheets and Workbooks | |||
| Automating Workbook Functionality | |||
| Apply Data Validation | |||
| Search for Invalid Data and Formulas with Errors | |||
| Work with Macros | |||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | |||
| MapData | |||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | |||
| Determine Potential Outcomes Using Scenarios | |||
| Use the Goal Seek Feature | |||
| Forecasting Data Trends | |||
| Excel Templates | |||
| Excel Templates | |||