Effective ExcelTM - 2 day workshops
Excel is today one of the most widely used spreadsheets in organisations. Imagine the productivity boost you would get if everyone in your office were able to improve their speed of working in Excel by just 10%. Imagine that report getting complete in 20 minutes instead of 2 hours. Or that month-end performance presentation in 10 minutes instead of a whole day! Or imagine a sensitivity analysis that you can actually take a decision from instead of being faced with a plethora of hard-to-read tables!
See the answered questions below to find out what makes our Excel workshop special.
The Effective Excel workshop is available in two options:
- Advanced - Covers advanced uses and applications of Excel with some Intermediate coverage. Two day workshop.
- Foundation - Covers basics of Excel with some Intermediate coverage. Two day workshop
Advanced ExcelTM - What does it consist of?
The Advanced Excel program is for those who already have a working knowledge of Excel. The program is designed for upto 20 participants and is covered in two days.
- Revisiting some underutilised fundamentals of Excel
- Understanding dynamic linking and cross referencing
- Understanding hyperlinking
- Nested Data and Drilling down worksheets
- Productivity tips
- Understanding the basic categories of formatting
- Custom number formats - use them for hard-to-do formats
- Conditionality and various applications
- The discipline of range names and formulas thereon
- Functions
- Dashboarding with Charts and Graphs
- Protection and special security tips
- Data Analysis and Working with masses of data
- Scenarios, grouping and other productivity tips
- Pivot Tables
- Validation
- Sensitivity and other Management decision models
- Introduction to Macros
- Data from the Internet
- Interfacing with Word and PowerPoint
- Printing & Output - special techniques for enhanced output
Foundation ExcelTM - What does it consist of?
The Foundation Excel program is for those who are just starting out in Excel. The program is designed for upto 20 participants and is covered over two days.
- Fundamentals of Excel
- Cells and the building blocks of spreadsheets
- Understanding the relation between data and information
- Worksheets - handling and formatting
- Excel interface and customisation
- Understanding how to build a basic table
- Understanding data referencing
- Beginning with Formulas
- File operations
- Basic printing and output
- Basic Functions
- Graphing
- Protections
- Introduction to data analysis
- Filtering data
- Using Excel for office work
- Building scenarios
What is special about the Excel course?
Its special becauses it doesn't focus on just the software. While the Excel software is covered, we focus on the application end of things. There are a whole lot of things managers need that software training alone will not accomplish. For example here are some of the questions we routinely handle during a Excel training workshop that are focus on everyday problems rather than just the software.
- How to conduct a sensitivity analysis
- How to display numbers in non-million digit groupings
- How to use charting to perform a BCG portfolio analysis
- How to use charting to perform a investment decision analysis
- How macros can be used to display inventory levels at the start of each day
- Depending on clients needs - we focus on the application of Excel to Finance, Marketing, Administration, MIS and Strategic Planning.
Free CD of tools - Every participant at our program gets a Free CD full of specially examples of complex solutions using functions, macros, plus a custom made business browser that connects participants to expert Excel sites on the Internet for solutions to questions they may have later.
Hands On - The participants actually work on the examples and solutions covered in the program at each stage. Participants are encouraged to bring their own spreadsheet files and collectively work out solutions to problems they might have encountered in their regular day-to-day work.
Free Reference Card - Every participant gets a free Full Color Excel Reference card full of shortcuts, menu expansions and tips in addition to the course material.
Personalised attention - To the extent possible, personal attention is given to participants to ensure they grasp the techniques properly.
If you would like to know more details about our workshops, you can call us or mail us at info@dats-it.net