You already know how to use Excel to perform simple calculations and tasks, but Excel is capable of doing so much more. Build upon your foundational knowledge of Excel by learning more advanced tools for analysis and presentation of data. Topics include managing complex workbooks; building more complex functions; using data analysis tools like PivotTables and PivotCharts; making an impact with powerful chart and presentation features; and collaborating with other users. Prerequisite: Microsoft Excel Level 1.Textbook included.
Prerequisites: Successful completion of Microsoft Excel 2019 Level 1 or the ability to organize, calculate, analyze, revise, update and present data. Possess the ability to create and save worksheets; entering, move and manipulate data; use formulas and functions; format text, numbers and cells; create charts; complete data entry shortcuts; manage, print and share workbooks. Microsoft Windows proficiency.
For more information, please refer to our course outline.
This class is also part of the Microsoft Excel 2019 Series, which includes Levels 1, 2 and 3 at a discounted rate.