Details
Goals
Being able to use the basics functions of an Excel table.
Prerequisite
None.
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
- Paste options
Document management
- Create / open / save a document
- Headers and footers
- The « Page Layout » view
Format table
- Format cells
- Using styles
Calculate
- Simple formulas
- Simple functions
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!