Microsoft Excel Intermediate

Description

Elevate your Excel skills with this comprehensive intermediate course designed to enhance your confidence in working with spreadsheets. You’ll master essential formulas, functions, and cell references, including relative and absolute references, and improve your navigation skills with quick tips. Dive into Excel essentials like conditional formatting, data validation, and date management while gaining expert tips for printing. Explore advanced workbook management with three-dimensional cell references, named ranges, and range-based functions. Unlock the power of graphing by learning various chart types, formatting, and data manipulation. Master the IF function for dynamic decision-making and explore powerful lookup functions like VLOOKUP and XLOOKUP. Finally, prepare your data with tables and discover the full potential of PivotTables and PivotCharts, including the use of slicers and timelines for interactive data analysis.

Who Should Attend

Students who have some experience using Excel and are comfortable with the basics of the structure and functionality.

Learning Objectives

Students will gain intermediate Microsoft Excel skills, including:

• Working with Workbooks & Ranges
• Charting Data
• Utilizing the IF Function
• Looking up Data Dynamically
• Tables
• PivotTables & PivotCharts

Course Outline

Review of Spreadsheets
• Formulas, Functions and Cell References
• Relative and Absolute Cell References
• Viewing the Excel Screen

Understand Excel Essentials
• Freezing Row and Column Headings
• Conditional Formatting
• How Dates Work
• Printing Tips

Work with Workbooks & Ranges
• Managing Sheets
• Three-Dimensional Cell References
• Naming Ranges
• Ranges in Functions

Chart Your Data
• Chart types
• Chart formatting
• Editing a chart
• Changing the source data

Utilize the IF Function
• IF: Letting Excel Make a Decision for You
• Calculating within an IF Function

Lookup Data Dynamically
• VLOOKUP
• XLOOKUP
• Data Validation

Tables: Prep to Pivot
• Intro to Tables
• Sorting & Filtering

Insert PivotTables & PivotCharts
• Into to PivotTables
• Into to PivotCharts
• Slicers
• Timelines

Prerequisites

Excel Introduction or equivalent skills.

Instructors

Dawn Monroe