FR
EN
Details
Goals
Being able to create tables and manage them; to format and manipulate data; to create and print charts from Excel data.
Prerequisite
Knowledge of the Windows work environment.
Contents
Excel environment
- The Excel environment: Quick Access toolbar, ribbon and tabs
- Customize Quick Access toolbar and the ribbon
- Live Preview and Paste Preview
Manage spreadsheets
- Add, rename, delete a worksheet
- Move and copy a sheet
- Define a tab color
- Change the height or width of the formula bar
Manage Tables
- Enter and validate data
- Manage rows and columns: add, resize, delete, hide / show
- Find / Replace data
- Copy / paste data
Document Management
- Create / open / save a document
- Headers and footers
- The « Page Layout » view
Calculate
- Enter and copy formulas
- Smart tags
Functions
- Insert Function using the wizard
- Insert function manually, semi-automatic formula input
Format table
- Format cells
- Using styles
- Predefined conditional formats
Present data with a graph(Chart)
- Create a chart
- Change / format a Chart
- Use the chart styles
- Create and use a chart template
- Sparklines
Analyze the data tables
- Create a data table (Insert Table)
- Sort and filter data tables
- List filters with search box
- Sort and filter by font or fill color
- The Flash Fill
To go further
These courses
may be of interest to you
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!
