Microsoft Excel Refresher («MEREFR»)

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.