Skip to main content
Professional training for organizations since 2008
info@jfl-media.com1-866-259-5647
JLJFL MEDIATRAININGBook a conversation

HomeTrainingMicrosoft ExcelBeginner

Microsoft Excel — Beginner

Microsoft Excel beginner

Build solid foundations, understand the environment and complete common tasks with a clear method.

Course plan

Three-hour modules in a logical sequence

Modules can be delivered as a complete path, selected individually or combined with another level.

01 · 3 h

Excel foundations, interface and workbook structure

  • Navigate the ribbon, worksheets and workbooks
  • Enter and edit data efficiently
  • Understand cells, ranges, rows and columns
  • Organize a workbook with a clear structure
  • Use the appropriate Excel file formats
  • Apply sound saving practices
02 · 3 h

Essential formulas and cell references

  • Build formulas with basic operators
  • Use SUM, AVERAGE, MIN, MAX and COUNT
  • Understand relative and absolute references
  • Copy formulas without creating errors
  • Diagnose common formula errors
  • Document important calculations
03 · 3 h

Formatting, sorting, filtering and printing

  • Apply consistent number formats
  • Create readable table styles
  • Sort by one or more criteria
  • Filter and search data quickly
  • Configure print areas and repeating titles
  • Prepare an accessible professional workbook

By the end of training

Directly observable skills

Navigate the ribbon, worksheets and workbooks

Practised in an exercise or work case.

Enter and edit data efficiently

Practised in an exercise or work case.

Build formulas with basic operators

Practised in an exercise or work case.

Use SUM, AVERAGE, MIN, MAX and COUNT

Practised in an exercise or work case.

Apply consistent number formats

Practised in an exercise or work case.

Create readable table styles

Practised in an exercise or work case.

Frequently asked questions

Prepare the right path

Can we choose only some modules?

Yes. The builder lets you select, remove and reorder modules according to the need.

How do we confirm this level is right?

Use the online assessment or share a few work examples with JFL Media.

Can the duration be adjusted?

Yes. The suggested duration is a starting point; the final plan considers the group, versions and objectives.

Can we work on real files?

Yes when files are authorized and prepared. Otherwise, equivalent examples are used.

JFL Media

Ready to build your plan?

Select the modules from this level, add other topics if needed and send your path to JFL Media.