Excel

Most videos will take a few seconds to load based on your connection.

365/2016 and 2013 Excel - NEW ITEMS
Add-in - create add-in with function code
Advanced Filter
AND function - how to create
Array - How to Build Simple Arrays
Array - Using SUM function
Array - SUM function using 3 ranges
Array - Using SUMIF function
AutoFill
AutoFill macro and the text file AutoFillMacro.txt
Clear - Comments, formatting, content, etc.
Conditional Formatting
Connecting multiple cell content into one cell
Count Colors within a range (column) - sorry 4:27
COUNTIF - how to create
Cut, Copy & Paste
Data List using Data Validation feature
Data Validation feature explained
Date Funtions: Today, DatedIf & Year, Month & Day
Date Funtions: EDate, EOMonth, NetWorkDays & WorkDay
Drop down list created from another file (Validation)
DAX introduction
Duplicates - Finding using conditional formatting
Duplicate records - formula to help find dups
Excel Tips & Tricks
Filtering (Using Sort & Filter - Filter)
Filter - use advance filtering for text & dates
Filter - using Sort & Filter on color
Flash Fill
Freeze Pane
Headers and Footers
IF function - how to create
IFERROR - how to use
Name ranges
Navigating in Excel
Nested function - using LEFT & FIND
Order of Operation
Personal workbook - create for macros
PivotTable Adding Difference From columns
PivotTable - Simple first step
PROPER & TRIM function - how to create
Quick Access Toolbar
Repeat Heading on each page
Selecting areas on your spreadsheet
Setting up Excel (basics before starting)
Sheet Tabs: adding, naming, color & hide/unhide
Side by Side Windows - placing the sheets side by side
Simple Budget for Home
Sorting: basic, multiple levels & by color
SUMIF function - how to create
SubTotals feature not the function
Two hotkeys - select table and check corners
Unique list - how to pull unique items from a column
Vlookup function - how to create

Non-video

BCA Excel Level 1
BCA Excel Level 1 Class Files
Boeing Excel Level 1 class PDF
Boeing Excel Level 1 Charts Intro PDF
Boeing Excel Level 1 Chart file
Boeing Excel Charts book PDF 1/2 day
Boeing Excel Charts class file 1
Boeing Excel Charts class file 2
Boeing Excel Class files for Level 1, 2, & 3
Boeing Excel Class book Level 2 PDF
Boeing Excel Class book Level 3 PDF
- Monday (3) - Monday - Wednesday
Boeing Excel Class File Level 3 Macros
Boeing class Web data
Boeing Excel PivotTable book PDF part 1
Boeing Excel PivotTable book PDF part 2
Boeing Excel PivotTable class file part 1
Boeing Excel PivotTable class file part 2
Boeing Excel PivotTable Example of Ctrl + q
Boeing Excel PowerPivot book
Boeing Excel PowerPivot classs files
Boeing Excel PowerPivot Section 2 complete
- link to flag Module 4 & Pictograms link
Boeing Spa Services
Chart Examples
Count color - # of cells in column that match a color PDF
Count color workbook for testing - UDF (user-defined function)
Define Relationship for Pivot Table - PDF
Define Relationship for Pivot Table - workbook
Excel 2013 Class Files (Level 1, 2, & 3)
Excel Step One (class files)
Exercise: Learn a few features (10) in a few steps
Formulas & Functions file updated 12/01/2018
Formulas & Functions Tutorial
Level 1 book
Library class files for Excel
Most shortcut keys for Excel
PivotTable Consolidation
PivotTable Difference From Previous - PDF
PivotTable Difference From Previous - workbook
PivotTable - Define Relationship
PivotTable - examples of 50 features PDF
- Website where the examples came from
PivotTable Tutorial very basic - great place to start
Quick Access Toolbar file (to import w/recent edited files button)
Quick - Excel Quick Start Guide 2013
Quick overview feature practice 2016/365
Specifications and limits of Excel
Spa Services
Sponsors
SumIFS & CountIFS formulas PDF
Vlookup Directions - used in class
Vlookup exercise workbook
30 Tips in 30 minutes