shifiverse
Excel Essentials: Formulas & Formatting

Professional Skills

Excel Essentials: Formulas & Formatting

A practical recorded lesson on clean tables, SUM and AVERAGE formulas, relative references and readable formatting.

Time
39 min
Level
Easy
Intensity
Low
Language
English
Price
Free
Do it in the Shifi app

Guided playback with a timer and easier options lives in the app, and it counts towards your circle’s points.

You’ll need

  • Laptop or Desktop Computer

Step by step

How it goes

  1. 01

    Build a clean table 13 min

    Create headers, consistent data types and one simple dataset.

    Use practice data only. Avoid uploading confidential customer or company information to unapproved tools.

  2. 02

    Add formulas 13 min

    Use SUM, AVERAGE and relative references, then copy formulas safely.

  3. 03

    Format and check 13 min

    Apply readable number formats and inspect for obvious errors.

Listen to your body: stop if anything hurts, and check with a doctor if you have a health condition.

Sample profile photo Guided by Dev Malhotra Sample Professional Skills & Career Mentor

More professional skills

You might also like

See all