Advanced Level Microsoft Excel 2016 Course from Simpliv

Advanced Level Microsoft Excel 2016 Course from Simpliv


  • Course Fee

    Last Date: 31-12-2018

    USD 15

Invite friends

Contact Us

Page Views : 4

About The Event


This training will boost your knowledge beyond the intermediate skills of Excel in this Advanced course of Microsoft Excel.

Build upon what you’ve already learned in my Intermediate course, and after taking this class you’ll have even more features and tools to work with in Microsoft Excel.

Developed and taught by the most experienced and multi-certified Microsoft Office trainer on the web, this course provides the most comprehensive Advanced coverage to Microsoft Excel. A Microsoft Certified Trainer and Professional, Microsoft Office Specialist, Expert and Master Instructor since 2000, with over 16 years of experience teaching individuals of all ability levels on “how to use” and “certify” in Microsoft Office, Kirt Kershaw has added, refined, designed and perfected this course to make it easy for you to master additional features in Microsoft Excel.

As you participate in this course you will master advanced Excel tools that will add to your skills, making you more proficient and save you even more time.

At completion of this course you will have mastered the advanced Excel tools, and come out with confidence to complete these Excel tasks with efficiency and grace.

Completion of this course, along with my Microsoft Excel 2016 Beginner Level 1, and Microsoft Excel 2016 Intermediate Level 2 includes all the training you need to help you pass both the Microsoft’s Excel 2016 Core (77-727) and Expert (77-728) Exams and become certified!


Basic knowledge
  • Prerequisites: Microsoft Excel 2016 Beginner Level 1 and Excel 2016 Intermediate Level 2
  • To work on the exercises after having watched the videos, to practice what you’ve learned, then you’ll need Microsoft Excel installed
  • This Microsoft Excel course was created in Excel 2016 and most features will work and is compatible with previous version of Excel including: Excel 2007, Excel 2010, or Excel 2013


What you will learn

In only four and a half hours of videos, provided to you in 47 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:

  • Learn how to create more productive worksheet views with the Custom Views in Excel
  • Learn how to quickly do repetitive tasks with Macros in Excel
  • Learn how to apply formatting using formulas in Excel using Conditional Formatting
  • Learn how to get more accurate data entry in Excel with Data Validation
  • Learn how to password protect your worksheets from unwanted changes
  • Learn how to prevent others from editing selected cells without a password in Excel.
  • Learn how to find and remove personal or hidden information quickly with Document Inspector in Excel
  • Learn how to prevent others from inserting, deleting, moving, renaming, coloring, hiding worksheets in Excel
  • Learn how to require a password to open, and/or modify your workbook in Excel
  • Learn how to automatically have Excel always create a backup
  • Learn how to work at the same time in Excel by sharing your workbook across the network
  • Learn how to upload, share and set permissions to your Excel workbook using Microsoft’s OneDrive
  • Learn how to track any changes made to your workbook in Excel, as well as how to accept, or reject them
  • Learn how merge one workbook into another to compare differences and accept, or reject those changes in Excel
  • Learn how to confirm the identity of who sent you the workbook by using Digital Signatures
  • Learn how to let others know the workbook is complete by using the Mark as Final feature in Excel
  • Learn how to have Excel trace data to formulas, or formulas to the dependent data using the Trace Precedents and Dependents features
  • Learn how to have Excel automatically circle invalid data
  • Learn how to watch formulas throughout anywhere in your worksheet with the Excel Watch Window feature
  • Learn how to step by step evaluate your Excel formulas using the Evaluate Formula feature
  • Learn how to group and outline ranges of Excel data that can be expanded for details and collapsed for totals
  • Learn how to insert a small Excel line chart into a cell for a selected row, known as Sparklines
  • Learn about the NEW Excel 2016 3D Map! Which allows you to visually plot your data on a 3D map by geographical regions as well as over time. Even create visual tours!
  • Learn how to create many scenarios of varying groups of data in Excel and quickly switch between them
  • Learn how to get the answer you want out of function using Excel’s Goal Seek
  • Learn how to get more than one answer out of a function using the Excel Solver Add in
  • Learn how to take a random sample out of a range of data in Excel
  • Learn how to create attractive visualizations and report summaries in Excel using Power View
  • Learn how to quickly summarize ranges of data throughout your Excel workbook and consolidating results into a single output range.
  • Learn how to link data from one Excel workbook into another so any changes made will automatically be updated
  • Learn a more robust way to manage external data and importing it into Excel by using the Power Pivot feature
  • Learn how to convert other database’s data into an Excel friendly format, or Excel data into another database by using XML
  • Learn how to apply more advanced custom number formats in Excel including adding symbols, text and colors
  • Learn even more tips, tricks and shortcuts about Excel
  • And so much more in this Excel course.

Additional bonus materials include:

  1. Exercise Files – you can download all that are used in the Excel videos for your personal, “hands-on” practice
  2. Quiz – you can download the Excel quiz that has one questions per video to test on what you’ve learned
  3. Instructor Notes – you can download as a quick Excel reference guide of the main points covered in each video, without having to watch the video over again.

Another great part of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION.

All three of my Excel classes are guaranteed to teach you Microsoft Excel, and if desired, to help you pass the Excel Core and Expert Exams and become certified. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review, or to learn new material about how to use Excel. Described as “fun” and “easily understandable” and “amazing” Kirt Kershaw’s Excel training will forever change the way you work with numbers. Try this course for yourself and see how you too can quickly and easily learn Microsoft Excel.

Click Here to Register