Learn Excel 2016 Intermediate Level - Beyond the Basics

Unlock Your Excel Potential: Intermediate Skills for Data Mastery

Elevate your Excel skills with this comprehensive intermediate course, designed to take you beyond the basics and establish you as an Excel power user. This 4.5-hour course features 39 individual video tutorials, offering a clear, step-by-step approach to mastering advanced Excel techniques.

What You'll Learn:

• Data Handling & Analysis: Gain proficiency in working with data using powerful tools like DataTables, Data Slicers, and Pivot Tables. Learn to efficiently organize, analyze, and extract insights from your data.
• Dynamic Formulas: Master Dynamic Formulas to create flexible and adaptable calculations that respond to changes in your data.
• Named Ranges: Learn to define and utilize Named Ranges for cleaner, more readable, and maintainable formulas.
• Charts & Graphs: Achieve mastery of charts and graphs to visually represent your data effectively. Create compelling visualizations to communicate your findings.
• Excel Navigation & Efficiency: Discover keyboard shortcuts and optimize your Excel view for faster and more efficient workflow.
• Indexing & Lookups: Understand and apply Indexing and Lookups functions to retrieve specific data from tables. Explore case study examples.
• Advanced Data Manipulation: Go beyond basic functions and explore advanced techniques for data cleaning, transformation, and analysis.

Why Choose This Course?

• Step-by-Step Tutorials: Easy-to-follow instructions ensure you grasp each concept quickly.
• Flexible Learning: Learn at your own pace, fitting the course into your busy schedule.
• Practical Exercises: Reinforce your learning with included exercise files to practice real-world scenarios.
• Professional Instruction: Professionally produced videos with detailed explanations and illustrations.
• Boost Your Career: Develop valuable skills that will make you more productive and sought-after in the workplace. Ideal for professionals, entrepreneurs, and anyone looking to enhance their data analysis capabilities.
• Excel 2016 Focused: Specifically designed for Excel 2016, ensuring you learn the most relevant and up-to-date techniques.
• Updated for 2017: Includes closed captions in English for improved accessibility.

Who is this course for?

This Intermediate Excel course is perfect for individuals who:

• Have basic Excel knowledge and want to advance their skills.
• Need to perform more complex data analysis tasks.
• Want to improve their efficiency and productivity in Excel.
• Aim to become a more valuable asset in their workplace.
• Desire to use Excel for personal projects or business ventures.

Student Testimonials:

"Simon is a great instructor...The course is also supplemented by neatly designed responsive exercises within Excel Sheets that are informative and challenging." - Vivek Soni

"This course...is going to make a lot of my work faster and more importantly CLEANER + MORE AUDITABLE." - Mohammed Ali Rizvi

"I am amazed at the new key combos that I have learned...Wow!" - Rob

"It's a good site for E-learning...example file in zip format was too very helpful in understanding scenarios." - Digvijay Singh Rathore

"For anyone that does know excel, this is very thorough and clear...because the course gives you files to follow along with it makes the learning process a bit easier." - Jessica Roden