This is it. This the course you’ve been looking for. If your goal is to become the best at using MS Excel and you want to master everything in MS Excel then we welcome you to this Microsoft Office 2016 Excel Advanced course.
MS Excel is much more than just a simple spreadsheet creating tool. Yes, of course, it can create spreadsheets and do basic calculations, but it’s capable of so much more than that. Using Excel to create just spreadsheets and doing basic calculations is like using a Lamborghini to do just 40 mph, yes it’ll do it but it can go so much faster than that.
Take this course and learn how to use MS Excel to do professional business analysis and use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn to visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and many more.
Take this course and master the powerful tool that is Microsoft Excel.
If you don’t have any prior skills in MS Excel then we recommend you take our Microsoft Office 2016 Excel Beginners and Microsoft Office 2016 Excel Intermediate course. These courses will give you the basic and some intermediate skills that’ll make it easier for you to understand this advanced-level course.
Course Curriculum
-
Use Links and External References
00:12:00
-
Use 3-D References
00:06:00
-
Consolidate Data
00:05:00
-
Use Lookup Functions
00:12:00
-
Trace Cells
00:09:00
-
Watch and Evaluate Formulas
00:08:00
-
Collaborate on a Workbook
00:19:00
-
Protect Worksheets and Workbooks
00:08:00
-
Apply Data Validation
00:13:00
-
Search for Invalid Data and Formulas with Errors
00:04:00
-
Work with Macros
00:18:00
-
Create Sparklines
00:07:00
-
MapData
00:07:00
-
Determine Potential Outcomes Using Data Tables
00:08:00
-
Determine Potential Outcomes Using Scenarios
00:09:00
-
Use the Goal Seek Feature
00:04:00
-
Forecasting Data Trends
00:05:00
14-Day Money-Back Guarantee
-
Duration:2 hours, 34 minutes
-
Access:1 Year
-
Units:17


Want to get everything for £149
Take Lifetime Pack