Excel: Tips and Tricks [Released: 7/15/2025]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 8m | 632 MB
Instructor: Dennis Taylor
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 8m | 632 MB
Instructor: Dennis Taylor
In this course, Dennis Taylor—an Excel expert who has 25+ years of experience in spreadsheet authoring and training—dives into the capabilities of Excel and how you can harness its full potential. Discover how to utilize key shortcuts and techniques that streamline your workflow, and improve your proficiency in tasks like data entry, sorting, filtering, moving, and copying data. Explore ways Excel can manage large datasets effectively, and leverage formulas to maintain accuracy in your calculations.
Learn how to enhance your presentations with visually appealing charts and shapes that can dynamically represent your data. Glean useful tips on managing lists, adjusting formats, and keeping your spreadsheets organized and accessible. Plus, get hands-on experience using Excel to transform raw data into clear and insightful reports. By the end of this course, you will be equipped with the skills to handle Excel with confidence and create impactful, polished documents effortlessly.
Learning objectives
- Apply time-saving keyboard shortcuts and navigation techniques to increase Excel workflow efficiency by at least 30%.
- Create advanced formulas with minimal keystrokes using formula building techniques and function autocomplete features.
- Implement professional-level spreadsheet formatting using conditional formatting, custom number formats, and cell styles to enhance data visualization.
- Master Excel's latest data analysis tools including dynamic arrays, XLOOKUP, and Power Query to transform complex data into actionable insights.
- Design interactive dashboards and reports using PivotTables, charts, and data visualization techniques to effectively communicate data stories.