Excel and PowerPoint Speed

Fast, accurate work in banking software: a mouse-free set-up, house formatting standards, slide templates, add-ins, timed drills and a personal checklist of the errors you actually make.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Excel and PowerPoint Speed, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🏦 Investment Banking & Advisory

Excel and PowerPoint Speed

Getting fast and accurate in banking software: keyboard shortcuts, model formatting standards, slide templates, plug-ins and a personal checklist of common errors.

  1. Mouse-free Excel and PowerPoint set-up
  2. Quick Access Toolbar built for banking tasks
  3. Baseline timing on five standard banking tasks
  4. House model formatting standards on one page
  5. Bank PowerPoint template and master slides walkthrough
  6. Inventory of the bank's add-ins and plug-ins
  7. First version of your personal error checklist
  8. Choosing a keyboard and screen set-up for long sessions
  9. Personal shortcut card from your own habits
  10. Daily ten-minute shortcut drill
  11. One new shortcut every week
  12. Monthly refresh of the error checklist from markups
  13. Personal macro and snippet library upkeep
  14. Reusable slide layout library
  15. Monthly timed speed test rerun
  16. Add-in and settings check after software updates
  17. Chart template library for banking exhibits
  18. Quarterly review of formatting standards against house changes
  19. Navigation and selection without the mouse
  20. Lookup and aggregation formula fluency
  21. Paste special, fill and format keystrokes
  22. Formula tracing and navigation keystrokes
  23. Data tables and sensitivity grids at speed
  24. PowerPoint alignment, grids and guides
  25. Moving tables and charts from Excel into PowerPoint cleanly
  26. Custom number formats for banking outputs
  27. Linked or pasted exhibits decision for your group
  28. Speeding up slow and heavy model files
  29. Macro use within the bank's IT and compliance rules
  30. Moving your templates from older lookups to XLOOKUP
  31. Crash-proofing large files before a deadline
  32. Personal starter model shell
  33. Excel modelling test preparation for recruiting
  34. First week on the desk software set-up
  35. Moving to a new laptop or Office version
  36. Timed page build with a peer
  37. Shortcuts session for the incoming intern class
  38. Pre-internship speed plan for students
  39. Ten-week summer intern speed priorities
  40. Career switcher adapting habits from accounting or consulting
  41. Mac user switching to Windows for banking
  42. Associate review of analyst formatting at speed
  43. Working fast on a laptop away from the desk
  44. Hand and wrist strain from long keyboard hours
  45. Recorded and written macros for repetitive formatting
  46. Dynamic arrays and LAMBDA for repeatable analysis
  47. Power Query for cleaning data exports
  48. Team formatting toolkit for your group
  49. Advanced chart add-in work for complex exhibits
  50. Benchmarking against the fastest people in your group

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Mouse-free Excel and PowerPoint set-up

Most speed is lost before any skill comes into it: calculation set to the wrong mode, ribbon shortcuts unknown, files opening in the wrong view. An hour spent on settings once, on the machine you actually bank on, removes small frictions you would otherwise repeat thousands of times a year.

First tasks

  • Open Excel options and record the current calculation and save settings
  • Press Alt in Excel and note the key path for your ten most used commands
  • Set PowerPoint to show rulers, guides and the selection pane
  • Write every changed setting into a single note titled machine set-up

Quick Access Toolbar built for banking tasks

Commands buried three ribbon levels deep, such as paste values, align middle or trace precedents, become a single Alt plus number press once they sit on the Quick Access Toolbar. Choosing the positions deliberately, and keeping the same order in Excel and PowerPoint where the commands overlap, builds muscle memory that survives a change of machine.

First tasks

  • Tally the commands you click with the mouse during one working afternoon
  • Place the top nine Excel commands on the toolbar in a fixed order
  • Add align, distribute, group and send to back to the PowerPoint toolbar
  • Export both toolbar customisation files to your personal folder

Baseline timing on five standard banking tasks

You cannot tell whether drills are working without a starting number. Timing yourself on five repeatable tasks, such as formatting a raw comps export, building a sensitivity table, rebuilding a bar chart, aligning a messy slide and linking a table into PowerPoint, gives a baseline you can rerun every month.

First tasks

  • Choose five tasks you do every week and write each one in a sentence
  • Save a clean starting file for each task in a timing folder
  • Time each task once with a stopwatch and count the errors
  • Enter the five times and error counts in the speed log

Make it yours.

Install Excel and PowerPoint Speed, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.