Course Description:

Learning objectives: – Learn your way around the Excel 2010 environment. – 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 how to use the Save and Save As commands, save as a PDF, and save as an Excel 97-2003 compatible workbook. – Learn how to create a simple formula in Excel. – Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets and freeze rows and columns. – Learn how to preview your spreadsheet, modify margins, change page orientation, and print. – Learn how to create a complex formula in Excel. – Learn how to use functions to find values for a range of cells. – Learn how to sort data to better view and organize the data in your spreadsheet. – Learn how to outline your worksheet to summarize and control how your data is displayed. – Learn how to filter the data in your worksheet to display only the information you need. – Learn how to use styles to format tables in Excel. – Learn how to track changes, add comments, compare two versions of a worksheet, and share a worksheet. – Learn how to create a new workbook using an Excel template. – Learn how to insert and modify Excel charts to communicate information. – Learn how to insert sparklines and change their type and appearance. – Learn how to apply, modify, and delete conditional formatting rules in Excel. – Learn how to use PivotTables in Excel for stronger data analysis. – Learn how to use what-if analysis to answer different types of questions. – Learn how to merge copies of a shared workbook in Excel. – Learn all about using reference styles in Excel. – Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice. – Use these free resources to 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.