Description
Thanks to this training, you’ll be able to learn the basic principles of Excel. Taking our Excel Introduction training course? Then you’ll have chosen the ultimate springboard to the other training courses like Excel Databases and PivotTables and Excel Functions & Formulas.
Objectives
Do complex calculations feature in your daily tasks?
Once it’s finished, you’ll effortlessly be able to:
- Set up a simple spreadsheet with numbers, text and formulas
- Use the basic Excel functions
- Sort tables and filter data
Target Group
Everyone who needs to carry out calculations regularly and wants to leave this task to Excel.
Prerequisites
Participants are familiar with the Windows environment.
Content
Working with workbooks and worksheets
- What do the various extensions xlsx, xls, xlsm, xlsb, xltx, xltm mean?
- Copying, adding, deleting, moving sheets
- Making selections
- Adding and Removing Rows/Columns
Format
- Basics of cell formatting (number format, font, alignment, background, and borders)
- Basics of conditional formatting
Tables
- How do you make a table?
- What are the advantages of a table?
- Sorting
- Filtering
Calculations
- Drafting Formulas
- Copying formulas with the “Fill handle”
- Absolute and Relative cell addressing ($)
- Built-in basic functions (Sum, Min, Max, Average, Count, Counta)
Charts
- Creating a chart
- The various parts of a chart
- Adjusting a chart using the ribbon/side menu
Printing
- Printing a workbook or worksheet
- Page Settings
- Defining print areas
- Setting headers and footers
- Print Preview
- Page layout
