Microsoft Excel Level 2
EXCEL is a great tool for turning complex information into more simple snapshots to inform your stakeholders, as well as organize your data. This course is meant for those who want to gain advanced skill sets necessary to work with functions and lists, analyze data, and use PivotTables and PivotCharts.
Upon course completion you will be able to create advanced workbooks and worksheets that provide a more in-depth understanding of organizational intelligence. The end goal of this course is for students to be able to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers at a high level.
Lesson 1: Using Page Setup
Lesson 2: Using Other Functions
Lesson 3: Using Conditional and Custom Formats
Lesson 4: Using AutoFilter
Lesson 5: Working with Tables
Lesson 6: Using Large Worksheets
Lesson 7: Working with Multiple Worksheets
Lesson 8: Managing Worksheets
Lesson 9: Using Range Names
Lesson 10: Creating Charts
Online Course Requirements:
You need two screens; one for exercises, one for virtual classroom. You need Microsoft Excel installed on your computer. Complete an online orientation prior to class (orientation instructions are emailed after registration approval). You should have basic computer knowledge. Registration will close two weeks prior to the start date to allow for online orientation completion.
Contact me when additional offerings for this course are scheduled.