Superwebdesign Software Trainers are Microsoft Certified Application Specialists
Superwebdesign Software Trainers are Adobe Certified Experts
nl | fr

Training Course Excel

Computer training Microsoft Office Excel in English, French or Dutch

Basic Excel Training

  • To discover the working environment and the basic options of a worksheet in Excel
  • Office Assistant in Excel
  • For 2007 : work with the new environment : ex. "ribbons" and the Office button instead of toolbars in Excel
  • To type, change, correct data; to create, open, save and print a file in Excel
  • To move and copy data in Excel
  • Use of AutoSum function, to create formulas manually,  to use the wizard to create simple functions
  • Layout of a text : bold, underlined, font, font size, etc. ...
  • Layout of numbers (autodate, ‘EUR’,…), alignment, borders and shading in Excel
  • Protecting cells in Excel
  • To change margins, to define paper size and page orientation, to insert headers and footers, to insert page numbering, to choose page ends

 

Excel Intermediate Training

Working with Charts in Excel

  • Create a chart with the aid of the Chart Wizard 
  • Format text; colours, and line weight in a chart in Excel
  • Modify the scale of the axis; add titles and legend; add free text and graphical elements; change chart type 3D charts.
  • change chart type; 3D charts in Excel
  • Add or modify data range; create combined charts in Excel
  • Import external graphical objects into a chart in Excel
  • Export a chart to Word or Powerpoint in Excel
  • Create a dynamic Pivot table in Excel

Managing and analyzing Data in Excel

  • Basic database concepts in Excel
  • To create and modify a list of data in Excel
  • Sorting data in Excel
  • Filtering data with the ‘Autofilter’ or the ‘Advanced Filter’ (or based on the colours in Excel 2007)
  • Validating data in Excel
  • Remove duplicates (in Excel 2007)
  • Calculating subtotals in Excel
  • Creating Pivot tables : Pivot table report and Pivot Chart

Functions & Formulas in Excel

  • Where do you find a formula ? Basic functions and function wizard (+ Function Library in Excel 2007). Verification and correction of formulas in Excel
  • To understand selection principles from the basic functions : Sum - Average - Min - Max in Excel
  • To create a logical function with IF) in Excel
  • New IF functions in Excel 2007 (averageif, iferror, etc...)
  • To create a formula with data from different sheets (calculations in 3 dimensions) in Excel
  • Searching data in a database (Lookups) in Excel
  • Using time functions in a calculation (Today, Now,…) in Excel
  • Overview of the other functions : text, information, financial, mathematical in Excel
  • Creating a comparison with an unknown element
  • Creating tables based on a function or a formula
  • Creating different versions of a table : the scenarios

 

Excel Expert Training

  • Working with sheets in Excel
  • Working on different windows in Excel
  • Navigating in a worksheet in Excel
  • To save and use Excel templates
  • To work with Fill handle, format painter and their smart tags
  • To format cells with Styles (and Themes in Office 2007)
  • Conditional format of cells (very extended in 2007)
  • To name a range of cells to get access to them or to use them in a calculation in Excel
  • To create rules to fill cells in Excel
  • To make a chart starting from a table in Excel
  • To obtain information from a table to present them, filtering, Pivot tables, MS Query possibilities
  • To import data in Excel
  • To create a form in Excel
  • To share documents in Excel
  • Introduction to macros in Excel

Program in PDF

 

Advanced Excel & VBA Training

Working with cell names

  • What is a cell name
  • Defining a cell name
  • Using 'Name Manager'

Formulas and Functions

  • Absolute and relative cell addressing
  • SumIf(s), CountIf(s), Vlookup, IfError…

Data Validation

  • Limiting the contents of a cell using 'Data Validation'
  • Adjusting error messages
  • Look up incorrect values in the workbook

Conditional Formatting

  • Change the background colour of a cell based on the value in the cell
  • Data bars - Colour shades - Using small icons
  • Returning double values
  • Combined conditional formatting
  • Using formulas in conditional formatting

PivotTables

  • Creating PivotTables
  • Show calculations as percentages compared to the total
  • Grouping in PivotTables

Import Data

  • From the Internet
  • Via MS Query

Charts

  • Creating, changing and formatting
  • Creating a chart linked to the result of a form field

Form Fields

  • Working with the combobox

VBA

  • Introduction to the VBA Environment
  • VBA Overview & Terminology
  • Event driven programming
  • VBA Programming Environment
  • Creating the User Interface
  • VBA Programming Language
  • Error handling and debugging
  • Working with more advanced controls

 

 

Excel dashboards and pivot tables training

  • Dashboard structure
  • Choices & Scenarios
  • Dynamic charts, Sparklines, ...
  • Functions used in Scorecards & dashboards (INDIRECT, NA, SMALLEST, LARGEST, DSUM, nested IF, HLOOKUP, INDEX, REPT, ...)
  • Camera Object
  • Pivot Table: standard options
  • Advanced Pivot Table calculations (Calculated Items, Calculated Fields, Groups, % Totals, ...)
  • Slicers (if Excel 2010)
  • Conditional Formatting: dashboard items & formulas
  • Forms Controls: Scroll bar, Check Boxes, Combo boxes, Group Boxes,..
  • Slider, Star Ratings
  • Interactive Webpages, Microsoft Docs.com
  • References to websites and free dashboards
  • Case studies (10)
  • Add-Ins: Example Gauge Add-in
  • Questions & Answers

 

All Office courses:

Some clients: Cefora, IBM, Holcim, CBR, Total, Bpost, Cisco, Shape,Colruyt, Telelingua, Nestlé, CPAS Molenbeek, Fabricom, Club Med, NATO, G4S, Fonds de participation, Roularta, Georg Fischer, SGC, STIB, Federal Police, Flemish Government, KBC, Fortis, ING, Tetrapak, Royal Canin, GSK, ULB, Starwood hotels, Jetair, Belgacom, VRT, National Bank of Belgium, Hansgrohe, Buildings Agency, General Electric, Hiscox, Prace, Toyota,...

More computer courses in Brussels

Computer training Brussels

 

 

50% discount for self-employed and small companies in the Region of Brussels

50% discount for self-employed
and small companies
via the Region of Brussels

 

Valid HTML 4.01 Transitional Valid CSS!