Kellie Keeling
Daniels College of Business - Business Information & Analytics
Kellie Keeling
Daniels College of Business - Business Information & Analytics
-
MS Excel Resources
-
Formulas, Functions and Some basics like sort, filter, pivot tables, and charts
Introduction to Formulas: Cell References to create simple formulas
https://edu.gcfglobal.org/en/excelformulas/simple-formulas/1/https://youtu.be/xc14gFFyiTw GCF Global Learning Relative and Absolute Cell References https://edu.gcfglobal.org/en/excelformulas/relative-and-absolute-cell-references/1/
GCF Global Learning Absolute References with F4 Key https://youtu.be/SVPlRHK-XbI GCF Global Learning INTRO TO EXCEL TEMPLATE (download, open in Excel or Browser): Add, Fill, Split, Transpose, Sort & Filter, Tables, Drop Downs, Analyze, Charts, Pivot Tables
https://templates.office.com/en-us/welcome-to-excel-tm10000137
Microsoft Template EXCEL FORMULAS & FUNCTIONS TEMPLATE: (download, open in Excel)
Basics, Introduction to Functions, AVERAGE, MIN, MAX, Date & Time, Joining text and numbers, IF Statements, VLOOKUP, Conditional Functions, Function Wizard, Formula Errors
Microsoft Template -
(Thanks to Megan Wydick Martin Meredith College for curating these videos)
-
More Resources if you want to learn more
Excel Video Training- More Topics Microsoft Pivot Tables https://templates.office.com/en-us/PivotTable-tutorial-TM16400647 Microsoft Template COUNTIF https://go.microsoft.com/fwlink/?linkid=2127708 Microsoft If you have suggestions for more - email kkeeling@du.edu