The Development Pod

Welcome to Everyday Excel!

What will I learn in the course?

The power of Microsoft Excel

What version of Excel do you need for this course?

For Mac users

Excel syntax and order of operations

Troubleshooting Excel formulas

Introduction to functions in Excel

Counting, summing, and averaging in Excel, Part 1

Counting, summing, and averaging in Excel, Part 2

Rounding and remainders

Examples: Rounding and remainders

Random numbers, combinations, and permutations

The CHOOSE function

OPTIONAL: The CONVERT function (for engineers and scientists)

Making named ranges dynamic

Previewing compatibility with earlier versions

IF, AND, and OR

Advanced logical functions in Excel

Flash Fill: Advantages and disadvantages

Text functions in Excel, Part 1

Text functions in Excel, Part 2

Excel's financial functions

Introduction to array formulas

Introduction to VBA user-defined functions

Applying a filter

Using the FILTER function (Office 365)

Creating an Excel Table

Data validation and drop-down lists

Sorting data in Excel

The SORT and SORTBY functions (Office 365)

Example: Sorting by columns

Cleaning your data

Removing duplicates

Consolidating data

One-way lookup functions, Part 1

One-way lookup functions, Part 2

The XLOOKUP function

Scatter plots in Excel, Part 1

Scatter plots in Excel, Part 2

Column and pie charts in Excel

Dynamic charts

Introduction to Pivot Tables

Slicers

Sparklines

Sharing worksheets and charts in Word and PowerPoint

Printing Excel worksheets

Example: Sales invoice as PDF file

For Fun: Importing Geographic information