Goals
- Discover the new features of Office
- Know the main features of Excel
- Be able to perform calculations and use functions
- Know how to handle graphics and pivot tables
- Introduction to VBA programming
Program
Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)
The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell
Creating tables
Automatic formatting
Creating a custom style
The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations
Layout Page
breaks
The printing area
Printing and printing options
The different display modes
Show / hide information
Zoom
Freeze the panes
Duration
5 days
Price
£ 1725
Audience
Everyone
Prerequisites
Knowledge of the PC environment
Reference
BUR407-F
Using a referent cell ($)
Basic
formulas Conditional formulas
Date and time
functions Other functions
Formula audits
Sorting, sorting options
Automatic filters
Custom filters
Select data
Choose a chart type according to needs
Insert a title, legend, data labels
3D charts
Modify values
Modify chart type
Structure of a PivotTable
The PivotTable and PivotChart wizard
Edit a PivotTable
Format a PivotTable
Convert and consolidate
Data validation
Scenario analysis
Adding and modifying comments
Protect your workbook and sheets
Using the Microsoft OneDrive service
Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro
Objectives of the VBA language
Presentation of VBA
Some definitions
Use of VBA
Principle of operation of a macro
Modifying the code of a macro
Language syntax
Variables
Arrays
Constants
Operators
The Application object
The Workbook object
The Worksheet object
The Range object
Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)
Synthesis
Questions / Answers
Review of the important elements Revisions before certification
Passing of the TOSA certification on Excel
Sessions
Contact us for more informations about session date