This course begins with getting you familiar with the MS Excel interface, menu systems, and Ribbon and how to enter and organize, format data, how to create formulas using simple functions and learn how to use absolute and relative referencing with your functions in Excel. Then it progresses to more advanced features like building charts, conditional formatting, SmartArt, PivotTables and PivotCharts, working with multiple worksheets, using advanced functions like IF, VLookup, PMT. You will also learn to automate tasks using Macros and use data analysis tools like Goal Seek and the Scenario Manager.
Microsoft Excel Certification Course Objective
Understand Excel’s Menu system and perform simple to advanced calculations easily
Get time saving tips and tricks to improve efficiency
Learn how to perform printing and charting capabilities in Excel
Learn to work with multiple worksheets and workbooks
Learn data management and analysis techniques with data validation, sorting, and using filter
Understand how to create PivotTables and Pivot Charts to make your spreadsheets more appealing and easier to read
Automate routine steps with Macros to save your valuable time.
Course Content
Navigate and Explore Excel
Fill Data Easy with Fill Handle
Flash Fill
Basic Functions - Sum, Avg, Min, Max, Count
SubTotals
Date and Text Functions
Absolute and Relative Cell Reference
Advanced Function If, VLookup, PMT
What If Analysis tools - Goal seek and Scenario Manager
This is a professional training course. Each license type allows a set number of users to access the training course. Please select an option from the list below. This is a professional training course. This is a single delegate licence. This allows access for one delegate. The recorded training can be accessed through a secure website. Username and password will be sent via email.