What you will learn

31 things about Excel that you could use every day to save time . Over 95% of lessons are less than one minute long allowing you to quickly find out what you want to know.

  • How to recover unsaved workbooks

  • How to prevent formulas from being overwritten

  • How to split the contents of a cell with a keyboard shortcut

  • How to increase numbers by a fixed percentage without formulas

  • And more ...

Course Content

  • 1

    31 Tips and Tricks in Excel

    • How to recover unsaved workbooks

    • How to recover unsaved changes to a workbook

    • Check for hidden rows columns and worksheets

    • Check for Comments, Links, Filters and Pivot Tables

    • Filling weekdays, not weekends

    • Filling dates

    • Filling consecutive Fridays

    • Filling Numbers

    • Filling Formatting

    • Keyboard shortcut to add numbers using SUM

    • Keyboard shortcut to add todays date

    • How to prevent formula from being overwritten

    • Hide formulas in your spreadhseet

    • How to hide cell content

    • Shortcut to Save new file

    • How to set up quick typing

    • How to include day and date in a cell

    • How to increase numbers by a fixed percentage

    • How to increase numbers by a fixed amount

    • How to show numbers as percentages

    • How to convert numbers to percentages

    • Columns to rows - rows to columns

    • Use copy and paste retaining column widths

    • Create linked formulas with copy and paste

    • Check compatibility with earlier versions of Excel

    • Use Excel without a mouse

    • How to find formulas in a worksheet

    • Using Excel drawing tools

    • How to split the contents of a cell with a keyboard shortcut

    • Automatically add population data to Excel

    • How to create a custom list