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
Organizer
Keyjob
Where does it take place?
Key Job
65
Avenue de la Gare Luxembourg
You could like it :
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!