skill upgrade training excel
TRANSCRIPT
![Page 1: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/1.jpg)
Luke VanWingerden@ljvanwingerden
excelbe afraid ofDON’T
“There are 3 kinds of lies - Lies, damned lies, and statistics.” - Mark Twain
![Page 2: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/2.jpg)
Is this what you see whenyou think about Excel?
![Page 3: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/3.jpg)
Image of an excel sheet from the HelpDesk metrics sheet
![Page 4: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/4.jpg)
Basic Excel Lay of the Land
![Page 5: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/5.jpg)
Tabs
![Page 6: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/6.jpg)
Cell Formatting
![Page 7: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/7.jpg)
Special Tools
![Page 8: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/8.jpg)
Page Setup/Printing
![Page 9: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/9.jpg)
Viewing more than 1 spreadsheet
![Page 10: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/10.jpg)
Tables & Sorting
![Page 11: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/11.jpg)
Filter & Sorting
![Page 12: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/12.jpg)
Formatting as a Table
![Page 13: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/13.jpg)
Freezing Rows/Columns
![Page 14: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/14.jpg)
Formulas
![Page 15: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/15.jpg)
Toolbar / Overview
![Page 16: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/16.jpg)
Just the Basics
![Page 17: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/17.jpg)
Combining 2 Cells
![Page 18: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/18.jpg)
Separating 2 Cells
![Page 19: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/19.jpg)
Charts
![Page 20: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/20.jpg)
Tool Bar / Overview
![Page 21: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/21.jpg)
Other
![Page 22: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/22.jpg)
Customize the Ribbon
![Page 24: Skill Upgrade Training Excel](https://reader030.vdocuments.us/reader030/viewer/2022032617/55aa320b1a28ab546e8b482f/html5/thumbnails/24.jpg)
Resources
Excel Training Links and Videos• Basic layout and features overview• Basic Math in Excel (SUM & SUMIF formula's)• Create a Chart• Sort and Filter Data• AutoFill and Flash Fill• Freezing or locking panes• Separate Text to Multiple Columns• Office Keyboard Shortcuts• Excel Quick Start Guide