Course Outline
The outline below is a suggested list of topics to be discuessed during the course of the training. The final curriculum may differ from the presented topics below, depending on the experience, expectations and needs of the participants.
Adjustment of the working environment
- Hotkeys, facilities
- Create and modify toolbars
- Options paste special (transpose)
- Formatting (style, format painter)
- Tool - go to
Organization of information
- Management sheets (naming, copying, color change)
- Assign and manage the names of cells and ranges
- Protect worksheet and workbook
- Secure and encrypt files
Data analysis
- Logic
- Basic Features
- Advanced Features
- Creation of complex / multiple formulas
- Scenarios
- Search result
- Solver
- Charts
- Graphics support (shadows, charts, AutoShapes)
Database management (list)
- Data consolidation
- Grouping and outlining data
- Sorting data (over 4 columns)
- Advanced data filtering
- Database Functions
- Subtotal (partial)
- Tables and Pivot Charts
Automation of work
- Conditional Formatting
- Create your own formats
- Check the validation
Requirements
- Computer literacy
- Knowledge of any operating system
Testimonials (4)
I personally liked Roman's passion for excel, and explaining everything so everyone could understand especially since we all had different levels of excel knowledge.
Erica Naimit - Kneipp Corporation of America
Course - Excel in One Day
The trainer was very knowledgeable and I learned some great time-saving tips & tricks that I probably wouldn't have looked for or found on my own.
Katie HOLLER - Kneipp Corporation of America
Course - Excel in One Day
The trainer was very knowledgeable.
Humphrey Martino - Kneipp Corporation of America
Course - Excel in One Day
The level of Excel knowledge was great followed by the high volume of material covered.