Category:

Course Description:

Learning objectives: – Learn your way around the Excel 2016 environment. – Learn all about working with your Microsoft account and OneDrive. – Learn how to create and open Excel workbooks. – Learn how to save and share Excel workbooks. – Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions. – Learn how to modify rows, columns, and cells in Excel. – Learn all about formatting text in Excel. – Learn all about formatting numbers in Excel. – Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets. – Learn how to use Excel’s Find and Replace features to search for specific data. – Learn how to use Excel’s spell check feature. – Learn how to use Excel commands that let you control the way your content will appear on a printed page. – Learn how to use cell references to create a simple formula in Excel. – Learn how to create a complex formula in Excel. – Learn all about absolute and relative cell references and how they’re used in Excel. – Learn the different parts of a function and how to create arguments to calculate values and cell references. – Learn these basic tips for working with data to help you organize it and find what you need. – Learn how to freeze panes and split your worksheet so you’re only seeing certain parts of your worksheet. – Learn how to sort data to better view and organize the contents of your spreadsheet. – Learn how to filter the data in your worksheet to display only the information you need. – Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet. – Learn how to use styles to format tables in Excel. – Learn how to insert and modify Excel charts to visualize comparisons in your data. – Learn how to apply, modify, and delete conditional formatting rules in Excel. – Learn how to use Excel’s track changes and comments features when proofreading workbooks. – Learn how to inspect and protect your Excel workbook. – Learn how to use PivotTables in Excel for stronger data analysis. – Learn how to do more with PivotTables in Excel to better summarize data. – Learn how to use what-if analysis to answer different types of questions. – If you’re considering purchasing Office 2016, learn about some important changes you should know about. – Discover some of the new features in Office 2016. – Learn all about using reference styles in Excel. – These free resources can help you better work with and manipulate data in Excel. – Test your knowledge of Excel by taking our quiz.

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.