Microsoft Excel Level 2 - Intermediate Excel
Course Duration: 1 Day
About: This Intermediate Excel course builds upon the foundational skills acquired in the Introduction to Excel course, offering a deeper understanding of Excel's capabilities. The course covers common functions like IF, COUNTIF, and TEXTJOIN and works with lists, tables, and advanced formatting. It also introduces visualizing data through charts, sparklines, and SmartArt.
Audience profile
Students who have basic skills with Microsoft Excel who want to learn intermediate-level skills.
Prerequisites: Excel Level 1 or Basic Excel experience.
Functions and Formulas
- Using Named Ranges in Formulas
- Using Formulas That Span Multiple Worksheets
- IF and IFS
- AND and OR
- NOT
- COUNTIF, SUMIF, AVERAGEIF
- TODAY, WORKDAY, NETWORKDAYS
- CONCATENATE vs FlashFill
- TEXTJOIN and CONCAT
- Text Functions
- Date and Time
Charts
- Chart Basics
- Tools for Editing Charts
- The Format Tool Tab
- Using the Three Chart Buttons
- The Format Task Pane
- Line and Area Charts
- Hierarchy Charts
- Statistic Charts
- Combo Charts
- Using Recommended Charts
- Sparklines
- Add and Format Objects
- Working with Shapes
- Working with Icons
- Working with SmartArt
- Using the Quick Analysis Tool
Working with Tables
- Format Data as a Table
- Table Design Tool Tab
- Formatting Individual Cells
- Selecting Table Rows and Columns
- Structured References
- Convert a Table to a Range
Conditional Formatting
- What is Conditional Formatting?
- Conditional Formatting: Highlight Cells Rules
- Conditional Formatting: Top/Bottom Rules
- Conditional Formatting: Data Bars, Color Scales, and Icon Sets
- Conditional Formatting: Create a New Rule
- Removing Conditional Formatting