Microsoft Excel (Level 2)

Participants will learn to summarize data with PivotTables, clean data using text functions, and automate tasks with logical functions like AND, IF, and OR. The course also covers lookup functions such as VLOOKUP and INDEX/MATCH, converting data into Excel tables, and adding objects like logos to workbooks. Additionally, participants will explore data protection techniques. By the end, participants will be equipped to handle more advanced tasks and increase productivity in Excel.

Course Dates TBD

Categories: Professional Development, Technology Skill Building

Course Content:

Reviewing Cell Names & Applying Range Names
Specialized Functions: SUMIF, COUNTIF, AVERAGEIF, PMT
Text Functions: LEFT, RIGHT, MID, TEXTJOIN, TRIM, UPPER, LOWER, PROPER
Logical Functions: AND, IF, OR
Excel Charts
Lookup Functions: LOOKUP, VLOOKUP, INDEX, MATCH
Excel Tables
PivotTables, Slicers, and Pivot Charts
Themes and File Protection

Applications and Hands-On:

Assign and use named ranges to simplify formulas and enhance worksheet navigation
Understand specialized functions to perform conditional calculations and financial analysis
Explore essential text functions for manipulating and cleaning data
Create conditional statements that return different results based on specific criteria
Create various charts (e.g., bar, line, pie) to visually represent data and make insightful reports
Master lookup functions to retrieve and manipulate data from large datasets
Create and manage Excel Tables for more dynamic and organized data management
Dive into PivotTables to summarize and analyze large datasets
Create Pivot Charts to create dynamic visualizations based on PivotTable data
Enhance your reports with Slicers for interactive filtering
Apply and customize Excel Themes for consistent and professional document formatting
Explore options for protecting workbooks and worksheets to restrict access or prevent changes

Resources Provided:

Individual computer access
Microsoft Excel software