Excel Tips & Tricks
Issued by
University of North Dakota
In this session, badge earners will learn how to quickly navigate in Excel worksheets and tabs, create a chart with one keystroke, link charts to Word and PowerPoint files and use a feature called FlashFill that automatically fills your data when it senses a pattern. We will also talk about using an Excel feature called QuickAnalysis to create charts, tables, and totals automatically. Then, we will look at some common functions and work with Excel lists.
- Type Learning
- Level Foundational
- Time Hours
- Cost Free
Earning Criteria
-
The badge earner learned how to navigate in Excel worksheets and tabs.
-
The badge earner learned how to create a chart with one keystroke.
-
The badge earner learned how to link charts to Microsoft Word and PowerPoint files and use FlashFill to automatically fill data when it senses a pattern.
-
The badge earner learned how to use QuickAnalysis to create charts, tables, and totals automatically.
-
The badge earner learned some common functions with Excel Lists.