Introduction to

Excel

Learn to effectively use Excel to manage spreadsheets for your personal and professional activities.  This workshop is for individuals with no experience with Microsoft Excel that are looking to learn how to use this important application.

 

Topics Include:

  • Getting Started

  • Cell Basics

  • Modifying Cells

  • Understanding Number Formats

  • Working with Multiple Worksheets

  • Page Layouts and Printing Tips

Excel:

Formulas & Functions

Expand your knowledge with the use of Formulas and Functions in Excel.  This workshop is for individuals looking to learn and improve their overall understanding of writing calculations with some experience using Microsoft Excel or who have taken the Introduction to Microsoft Excel Workshop.

 

​Topics Include:

  • Introduction to Formulas

  • Creating Complex Formulas

  • Relative & Absolute Cell References

  • Functions

  • Various Useful Functions

Excel: 

Presenting Data

Learn advanced techniques to present your data in Excel. This workshop is for individuals looking to improve their data analyzing and presenting skills or who have taken Excel: Formulas & Functions Workshop.

​Topics Include:

  • Sorting and Filter Data

  • Groups and Subtotals

  • Tables and Charts

  • Pivot Tables

  • Conditional Formatting

  • What-If Analysis

Practice Files

Intro to

Microsoft Excel

Challenge 1
Basics & Formatting
Challenge 2
Columns, Rows, & Cells
Challenge 3
Number Formats & Worksheets
Challenge 4
Printing & Layouts

EXCEL:

Formulas & Functions​

Challenge 5
Formulas
Challenge 6
Cell References
Challenge 7
Functions
PROPER
CONCATENATE
IF
AUTOSUM
COUNTA

EXCEL:

PResenting Data

Challenge 8
Sorting & Filtering
Challenge 9
Views
Challenge 10
Tables & Charts
Challenge 11
Conditional Formatting
Challenge 12
Pivot Tables

© 2020 Idaho Next Steps Coaching LLC