Mastering Excel Shortcuts, Tricks & Tips for Productivity

Learn shortcuts to:

• Open New or Old Workbook and Close Workbook

• Navigate to other worksheets

• Save & Print

• Maximise, minimise and Restore

Learn to:

• Group & Ungroup Worksheets

• Add or Change data across Worksheets

Learn to:

• Rename Sheets

• Move or Duplicate Sheets

• Delete Sheets

Learn all the major Formatting shortcuts:

• Bold, Italic & Underline

• Font sizes

• Colour options

• Alignment options

• Adding borders

• Adding comments

• Clearing formatting & comments

Apply pre-formatted styles for easy data visualisation using:

• Cell Styles for easy Titles and Colours

• Format as a Table Styles for one click formats

Visually represent your data for clarity:

• Fill cells by Rules, Greater than, Less than

• Apply colour scales

• Data Bars

• Top/Bottom Rules

• Icon Sets

Supercharge your data with custom number formats by:

• Adding Text in a number cell

• Blank Cells with data inside

• Control the total digits in a cell

Customise options by:

• Adding/Deleting Tabs in the ribbon

• Adding the Developer Tab

Adding Quick Access Toolbar Options for easy access and fast sheet operations such as:

• Quick Print

• Macros

• Spelling

Navigate efficiently around large data:

• Got to the start, end, left and right with one click

  
  

Jump to cells fast with CTRL G

Adding Table Names to jump to Table Ranges fast.

Learn the Date logic in Excel:

• 1 = 01-Jan-22

• How numbers relate to dates

Entering Dates:

• Current Date & Times

• Dynamic Date & Times

• Differences between 2 days

• Adding or subtracting calendar days

Comprehensive date functions including:

• Rolling Dates/Times

• Adding or Subtracting days, months or years

• Calculating Days between dates

• Converting Days to Years

• Showing Week Numbers

How to efficiently convert Data into Tables:

• Adding totals

• Adding formulas in tables

• Adding or Deleting columns or rows in between data

Easily filter by:

• One or Multiple dependant conditions

• Remove Filters

• Filter by Date Periods dynamically

Easy formatting by preformatted Table Styles to save time:

• Styles

• Banded Rows or Columns

• Adding Totals

  
  

Add Pivot tables with shortcuts:

• Add Columns & Rows

• Add Values

• Sum/Count data

Customise Pivot Tables with:

• Label Headers

• % or running totals

• Sort Data

• Grouping Data in Pivots

• Expand and Collapse Data

• Visual Charts easily

• Discover options to suit your needs

• Plot Pie, Table and line charts

• Explore Combo Line/Bar charts with dual Axis

• Changing Chart styles

• Adding Brand colour/themes

• Sorting Date Order in Charts

• Dynamically update data in Tables to reflect in Charts

• Adding Slicers & Timelines for Easy Filtering

Easily add number formats with shortcuts:

• %

• Date

• Decimal

• Currency

Adding custom formats to your:

• Currency with Text

• Accounting formats in red

Learn comprehensive ways to:

• Round Up or Down

• Using Decimals of significance

• Truncating large numbers

Discover formatting functions such as:

• Format Painter

• Transpose to make data horizontal to vertical

• Ctrl C/Copy Variations to Paste Specials

• Undo easily using CTRL Z

• Use F4 to repeat the last action

• Easily replace errors or spelling corrections fast

• Go back to Original formats using Find & Replace

Easily select, highlight, add/delete rows and columns.

Adjust Height & Width with easy shortcuts.

Building Formulas Faster with the use of helper columns helps avoid mistakes.

• Using IF Formula with 2 conditions

• Using IF Formula with % and Price Thresholds

Using Named Ranges and Cells to easily identify formulas rather than looking at Cell References alone.

Power packed Lecture with :

• How to debug formulas

• Check your formula precendents or dependants

• Goal Seek - how to change values to get your desired target

• Forecast Analysis to see sales projections

Bonus Tricks to ease your day to day Excel Work with:

• Freeze Panes

• F4 - To Repeat the last Action

• Easy Filter by Cell Value

• CTRL K - Add a Hyperlink

• Easy Text highlight

• Data Validation - Dropdown Lists

• CTRL Q - Easy Data Analysis

• Change Date format from DMY to MDY

• Analyse Data with Excel's AI feature