Skip to content

As part of the transition to Digication, Portfolio is going away! Portfolio will be fully decommissioned on July 1, 2024. As of July 1, 2023, there will be a new content freeze in Portfolio. You will not be able to add new pieces of content to your personal or organizational Portfolio. Existing content is still editable. Please continue to migrate your existing content from Portfolio to Digication. For more information about Digication, click here. For a discussion of options for transitioning your content on Portfolio, click here. To learn more about using Digication in your courses, click here.

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	https://go.microsoft.com/fwlink/?linkid=866285	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	https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home	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

The content displayed on this portfolio may not be accurate. Portfolio content is managed by individual users and is not property of the University of Denver.

This portfolio last updated: 21-Sep-2022 11:59 AM