I'm sharing a comprehensive list of Excel shortcut keys from Microsoft and AutomateExcel. These keyboard commands are perfect for speeding up your workflow, covering everything from basic navigation to advanced data formatting.
I share four rules for building Excel models faster, focusing on why you should never use a mouse. I detail essential shortcuts like F2, F4, and Alt-menu navigation that can make your workflow ten times faster.
I created in-cell Excel charts and staffing plans using text formulas and conditional formatting instead of standard chart tools. This method aligns data perfectly by using thin cells and simple logic to visualize timelines and bars.
I demonstrate how to improve Excel table formatting through specific visualization tips. Use these basic methods to enhance clarity and professional appearance beyond the standard software defaults.
I explore how to use the HTML accesskey attribute to define keyboard shortcuts for better website accessibility. This technique allows users to navigate via key combinations, following the principles of the Dive Into Accessibility guide.
I built a set of Excel user-defined functions to bring Unix-style list processing to spreadsheets. These macros allow you to chain functions like UNIQUE, GREP, and UNION into single-cell array formulas for powerful data manipulation.