Level 1 (2 Days)
Microsoft Office Excel 2013 is a powerful and easy-to-use spreadsheet program. This level is intended to help all novice computers get up to speed quickly. This level is also intended to help more experienced users who have little to no experience with Excel 2013 and the ribbon interface.
Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Spark lines (charts within individual cells). In this level, everyday users of Excel will become more proficient wit the tool by expanding their knowledge of functions, formulas, and new Excel features.
Level 2 (1 Day)
Level 2 is intended to help regular users of Excel become even more proficient by expanding their knowledge of Excel’s data analysis tools, consolidation tools, advanced functions, and PivotTables. This course will cover a variety of organizing tools and What-If analysis tools that will help Excel users get the most out of their data. In addition, two key advanced spreadsheet tools (PivotTables and Pivot Charts) will be discussed at length. Following that, advanced concepts dealing with Excel functions, AutoFill lists, and consolidating and combining data will also be covered. The new Slicer features and Power Pivot add-on, two important tools for working with PivotTables and Pivot Charts, are covered as well.