Course

Microsoft Excel Refresher («MEREFR»)

This one-day Microsoft Excel Refresher course is designed to refresh your existing knowledge of MS Excel and lay the foundation for further Excel courses.
Duration 1 day
Price 650.–
Course documents Digital Digicomp courseware

Course facts

  • Gaining confidence in using Excel
  • Speeding up the completion of your own work
  • Acquiring an ideal foundation for further courses

1 Working with formulas

  • Arithmetic operators
  • Calculations with percent
  • Calculate working time

2 Cell references

  • Copy formulas
  • Relative, absolute and mixed cell references

3 Basic functions

  • Enter or call functions
  • Help on functions
  • TOTAL
  • MAX, MIN, AVERAGE
  • NUMBER, NUMBER2
  • TODAY, DAY, MONTH
  • CHAIN

4 Filter and sort data

  • Requirements
  • The most important filter options
  • Reset filter
  • Export filtered data
  • Easy sorting
  • Sort by multiple criteria

5 Format as table

  • From the static to the dynamic range
  • Advantages and disadvantages

6 Customise table structure

  • Adjust columns and rows
  • Insert and delete columns and rows
  • Hide and show columns and rows
  • Connecting cells

7 The most important formatting

  • Alignment
  • Fill colors and cell styles
  • Frame
  • The most important number and date formats
  • Transfer and delete formats

8 Page layout and printing

  • Print preview
  • Page set up
  • Repeat lines (print title)
  • Header and footer
  • Set and cancel the print area
  • Print

9 The View tab

  • Arrange windows
  • Multiple windows of the same file
  • Fix the window

10 The most important keyboard shortcuts

Users who have already created Excel files and want to refresh their knowledge. This course is not suitable for beginners.

You already have some experience working with Excel and creating your own files with tables and calculations.

This course is suitable for users of Excel 2019, 2016 and 2013.

Download

Questions

Choose your date

Further courses