Course Outline
The outline below presents a suggested list of topics to be discussed during the training. The final curriculum may vary from the topics listed, depending on the participants' experience, expectations, and needs.
Customizing the Workspace
- Keyboard shortcuts and useful features
- Creating and modifying toolbars
- Paste Special options (e.g., transposing)
- Formatting techniques (styles, Format Painter)
- Using the 'Go To' feature
Organizing Information
- Sheet management (naming, copying, changing colors)
- Defining and managing cell and range names
- Protecting worksheets and workbooks
- Securing and encrypting files
Data Analysis
- Logical functions
- Core features
- Advanced features
- Building complex and multiple formulas
- Using Scenarios
- Search capabilities
- Goal Seek and Solver
- Creating charts
- Graphics options (shadows, AutoShapes)
Database Management (Lists)
- Data consolidation
- Grouping and outlining data
- Sorting data across multiple columns
- Advanced filtering techniques
- Database functions
- Subtotal calculations
- Tables and Pivot Charts
Work Automation
- Conditional Formatting
- Creating custom number formats
- Data validation checks
Requirements
- Basic computer literacy
- Familiarity with 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.
