Obtain powerful analysis from your desktop.Make fast, effective comparisons from lists of data.Access the right tools, at the right time.What's new in Excel 2010 Learning Outcomes.Making the switch to Excel 2010 Lesson Summary.Work between new and old Excel versions.Making the switch to Excel 2010 Learning Outcomes.Module 1: Making the switch to Excel 2010 Every office has its ‘Excel experts’ who stand apart from their peers so sign up for this training course to become one of them. The program is a vital business budgeting tool and is employed worldwide by a range of industries. You can use Microsoft Excel 2010 to keep track of almost any data, from work schedules to stocks and beyond. We also lay out the steps required to calculate dates using formulas and check conditions with the ‘IF’ function before we describe the ‘save’ and ‘run’ macros.
MICROSOFT EXCEL CLASS ONLINE HOW TO
This course explains how to work with formulas and functions before covering the use of ‘VLOOKUP’ to search through a spreadsheet’s data. It can automatically perform calculations once you add in the formula, which makes it a great tool for analyzing data in accounts, budgets, billings and many other areas. We demonstrate how to visually represent data to indicate trends, patterns and comparisons across charts, tables or other templates.Įxcel 2010 boasts many improvements and new features. We present practical exercises and sample spreadsheets to show you how Excel handles basic math while we add and delete columns and rows and prepare the worksheet for printing. We explore the program’s menus and examine the different tasks it can perform. This course teaches you how to make full use of the revised 2010 version of Microsoft Excel.