Microsoft Excel Basics (English) (Virtueel)

Lesmethode :

Virtueel

Algemeen :

During this one-day Excel Basics course you will learn the basics of this very popular Microsoft program. You will learn how to correctly set up a worksheet, how to efficiently enter data, format tables, calculate with formulas and functions, and create charts. Processing data and many tips and tricks will also be covered.

We also offer this course in Dutch, check it out here: Microsoft Excel Basis.

Doel :

With this Excel Basics course you will be able to use basic formulas and functions.

Doelgroep :

This course is for everyone who wants to work with Excel.

Voorkennis :

Experience in working with Microsoft Windows is required.

Onderwerpen :

- The Fluent Interface
   - Lint, Backstage, Quick Access Toolbar
   - Mini toolbar, the more-menu, Contextual tab
   - Screen layout
   - Customise settings
   - Customise Quick Access Toolbar
- Introduction
   - Create a new spreadsheet
   - Enter and modify data
   - Close spreadsheet
   - Work folders
   - Open workbook, save
   - Save working folder externally
- Working with selections
   - Selections
   - Move and Copy
   - Clipboard
   - Search and Replace
- Calculations
   - Functions and formulas
   - Commonly used functions, SUM, MEDIUM, MIN and MAX, NUMBER
   - Logical functions, ALS, ALS nested, combine functions
   - Check worksheet, relations between cells, error messages
   - Relative and absolute addresses
- Insert, delete, modify
   - Insert
   - Delete
   - Customise, sort
- Tables
   - Create table
   - Sort and filter a table
   - Add or delete table rows and columns
   - Add total row
   - Customise table style
   - Convert table to data range
   - Print table
- Worksheets
   - Set up worksheet, insert, delete, rename, modify
   - Move and/or copy worksheet
   - Calculate multiple worksheets
- Display and Formatting
   - Display
   - Number notation
   - Align
   - Themes
   - Formatting
- Print
   - Print preview
   - Title rows
   - Header and footer
   - Print settings
- Preparing for distribution
   - Properties
   - Spelling check
   - Workbook check, encryption
   - Mark working directory as final
   - SmartArt
   - Use, insert, edit SmartArt
   - Convert image to SmartArt
   - Remove background from image
   - Format SmartArt, Change Layout
- Graphics
   - Creating Charts
   - Sparklines
   - Change, copy, move, delete charts
   - Print charts