Sign yourself up (or your staff) for a comprehensive 2-day, 16-hour hands-on Excel workshop designed to make you more efficient at work. Become a needed and more productive member of your team. Excel is a highly-demanded skill set to have in office settings when working with data in office administration and other clerical tasks.
We will train you using a hands-on method that challenges you to actually learn the subject. This includes practices and a final test that we will grade at the end to measure what you have learned. At the workshop end, you’ll possess the proficiency to solve up to intermediate level problems using Excel.
Example Use Cases:
- Administrative assistant
- Virtual assistant
- Keeping records and reports
- Data entry
- Organizing data
- Accounting clerk
- Business analyst
- Cost estimator
- Data analyst
- Project manager
- Market research
- Information clerk
Takeaways:
Basics/Fundamentals
- Basic mathematic operations
- BODMAS (brack of division, multiplication, addition and subtraction)
- Relative and absolute cell reference
- Sorting
- Filtering
- Data validation
- Conditional formating
- Functions (sum, count, if-conditions, countif, sumif, max, min, and, or, transpose, ifError, sumProduct, concat)
Intermediate
- Vlookup
- Macros
- What-if-anaylysis
- Forecasting
- Index match
Our Teaching Method:
- We will teach and explain concepts with practical examples
- Students will be given practice exercises to complete during class
- Hands-on practicals are designed to keep learners engaged
- Graded tests at the end to measure each student’s learning
- Students will use graded test results to know what to revise more
Preparation:
- No prior knowledge of product management is required.
- Basic computer literacy and familiarity with using the web.
- For more indepth tasks, access to Excel Desktop version. The latest version (as of 2016) provides a robust platform for learning and mastering Excel. The online version doesn’t support features like macros, VBA (Visual Basic for Applications), advanced charting , advanced dashboarding, forecasting sheet and certain data analysis.
- Willingness to learn and engage in hands-on practical exercises.
- Ability to follow instructions and actively participate in the learning process.
- Access to a computer with internet connectivity for accessing course materials and completing assignments.
- A certificate will be awarded for completing this training.
Total Course Hours:
Refunds:
Need Custom Date/Time for Your Team?
We can customize workshop dates/times specifically for your team to fit your operation. Simply contact us with your request.
