microsoft excel 2016 training online free

Begin the course by learning how to find the application on the desktop and open it. During this course, you will familiarise yourself with the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Get started with Excel 2019, the spreadsheet application included with the Microsoft Office 2019 Suite. In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Excel Dashboards, and get noticed by top management & prospective employers.Intermediate Expert Beginner I am using Excel 2010 in this tutorial but you can also apply what I teach in Excel versions 2007, 2013, and 2016. In this Excel Pivot Table Course, you will learn the most important tools within a Pivot Table for Microsoft Excel 2016, 2013, 2010, or 2007 – for Beginners or Advanced users. I have spent the last 12 months reading most of the Pivot Table books available on Amazon, searching through articles and video tutorials online to come up with this comprehensive but short 1-hour Pivot Table tutorial.

Sure there are plenty of books out there but who has the time to muddle through pages of highly technical literature? In legacy versions of Excel, Pivot Tables were hidden deep inside the menu tabs and there were never any instructions on how to use its rich features.

JOIN OUR FREE ONLINE EXCEL PIVOT TABLE COURSE NOW >ĭespite their hidden gems, Pivot Tables are feared by more than 95% of Excel users worldwide. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read the table, highlight key information to management, and include graphs for your monthly presentations. Pivot Tables are one of the most powerful features of Microsoft Excel.

Microsoft excel 2016 training online free