Course curriculum

    1. 04 : Launching Excel

    2. 05 : The Start Screen

    3. 06 : Exploring the Interface

    4. 07 : Ribbons, Tabs and Menus

    5. 08 : Backstage Area

    6. 09 : Quick Access Toolbar

    7. 10 : Useful Keyboard Shortcuts

    8. 11 : Getting Help

    9. Excercise 01

    10. Test

    1. 13 : Working with Templates

    2. 14 : Workbooks and Worksheets

    3. 15 : Saving Workbooks

    4. 16 : Entering and Editing Data

    5. 17 : Navigating and Selecting

    6. Excercise 02

    1. 19 : Formulas and Functions Explained

    2. 20 : SUM Function

    3. 21 : COUNT Function

    4. 22 : AVERAGE Function

    5. 23 : MIN and MAX Function

    6. 24 : Handling Errors in Calculations

    7. 25 : Absolute vs Relative Referencing

    8. 26 : Autosum and Autofill Options

    9. 27 : Flash Fill

    10. Excercise 03

    1. 29 : What are Named Ranges

    2. 30 : Managing Named Ranges

    3. 31 : Using Named Ranges

    4. Excercise 04

    1. 33 : Applying Number Formats

    2. 34 : Applying Date and Time Formats

    3. 35 : Formatting Cells, Rows and Columns

    4. 36 : Format Painter

About this course

  • Free
  • 34 lessons
  • 3.5 hours of video content

Discover your potential, starting today

Enroll today