
Download the exercise files for each section, open the separate workbooks with multiple sheets, and practice the shortcuts, tips, and tricks.
Learn practical shortcuts to insert today's date and current time in Excel, including ctrl+semicolon, ctrl+shift+semicolon, and the today and now functions, plus format cells tips.
Expose all formulas in a worksheet by pressing control tilde, doubling column widths for easy formula troubleshooting, and use the show formulas button on the formulas tab.
Learn practical Excel tricks to hide and reveal the ribbon, use ctrl+f1 and ctrl+shift+f1 for icons and full screen, and customize ribbon display for a cleaner worksheet view.
Discover how to use alt key shortcuts in Excel to navigate the home tab, apply comma format, and compute averages with sequences like alt h u a.
Explore practical excel techniques to restore missing labels and hide data for printing, using go to special, fill down, copy as values, sorting, and conditional formatting for clean, print-ready worksheets.
Learn to use Excel's status bar to view totals, counts, averages, and high/low values, customize with six measures, and apply consistent comma formatting across columns.
Switch between multiple workbooks efficiently using Ctrl+Tab and Ctrl+Shift+Tab, and speed your workflow by adding the Switch Windows option to the Quick Access Toolbar.
Master excel worksheet navigation with shortcuts, the three-dot menu, and arrows; add or rename sheets with shift+f11 or the plus icon, and move between sheets via control page up/down.
learn how to move columns, rows, and cells with the shift-drag technique, using the I-beam insert indicator and optional right-click drag to insert and rearrange data.
Speed up formulas with entire column references and the autosum shortcut (alt + =), then use sum, average, countif, and sumif across columns while formulas adapt as data grows.
Apply Excel's outlining and subtotals to present complex budgets clearly by auto outlining, collapsing and expanding sections, and using quick keyboard shortcuts for view changes.
Michael Bouwer, an Excel expert, guides Microsoft Excel users in elevating their proficiency with spreadsheets by sharing an array of helpful shortcuts and techniques.
He kicks off by unveiling top productivity enhancing tips. Then, he delves into effective methods for navigating, displaying, and selecting data swiftly.
The course further delves into strategies for data input and modification, clever formatting tricks, drag-and-drop techniques, as well as keyboard shortcuts designed to streamline formula manipulation.
It also covers smart data management approaches and innovative ways to manipulate charts.
Topics include:
Performing calculations without relying on formulas
Applying formatting using convenient keyboard shortcuts
Employing database techniques to effectively manage Excel data
Swiftly navigating within workbooks for improved productivity
Selecting noncontiguous ranges with ease
Quickly creating split screens for efficient multitasking
Easily converting formulas to values through simple drag-and-drop actions
Accessing the Ribbon directly from the keyboard
Instantly inputting today's date or time
Utilizing keyboard commands for undoing and redoing actions
Streamlining data movement through drag-and-drop functionality
Enhancing data entry efficiency
Working proficiently with charts, shapes, and linked images
This is the perfect course for Microsoft Excel users that want to up their Excel skills to the next level.
Impress your boss just that little bit more.
All the Resource Files are provided which can be downloaded for free.