Applications of Microsoft Excel (Level 2)

Course Description

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 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