Microsoft Excel Intermediate to Advanced - Step by Step

Unlock Your Excel Potential: Master Advanced Features & Become an Excel Expert

Ready to take your Excel skills to the next level? This course dives deep into advanced Excel features, building upon the foundation you gained in our introductory Microsoft Excel course. We'll explore powerful techniques to analyze and visualize data like a pro.

What You'll Learn:

• Advanced Excel Functions: Go beyond the basics with complex formulas for powerful data manipulation.
• Advanced Charts: Create compelling and insightful visualizations to communicate your data effectively.
• Paste Special: Master the art of selective pasting for efficient data integration.
• Scenarios: Model different possibilities and analyze their impact on your data.
• Formula Auditing & Comments: Track down errors and collaborate effectively with clear formula explanations.
• Locking and Protection: Secure your spreadsheets and control access to sensitive information.
• Data Validation: Ensure data accuracy and consistency with built-in validation rules.
• Pivot Tables & Pivot Charts: Summarize and analyze large datasets with interactive pivot tables and charts.
• Named Cells & Named Ranges: Simplify formulas and improve readability with named references.
• Mixed Cell Referencing: Utilize various referencing styles for flexible formula creation.
• Mathematical & Statistical Functions: Perform complex calculations with a wide range of functions.
• Vlookup Function: Efficiently retrieve data from other tables.
• Nested Functions: Create powerful and complex formulas by combining multiple functions.
• Database Functions: Work with data stored in databases.
• Text Functions: Manipulate and extract information from text strings.
• Date Functions & Calculations: Perform date-related calculations and analysis.

This course is perfect for anyone looking for a comprehensive understanding of Excel formulas, data analysis, and spreadsheet management. Whether you're a business professional, data analyst, or simply want to enhance your productivity, this course will equip you with the skills to excel in today's data-driven world.

Taught by Richard Walters, a Microsoft Certified Trainer with 9 years of experience training Microsoft Excel users throughout the UK. Richard possesses a deep understanding of all Microsoft Office applications, including Word, PowerPoint, Visio, and Project.

Each engaging lecture is designed to be concise – averaging 10-18 minutes, with no single lecture exceeding 20 minutes. Enroll today and begin your journey to becoming an Excel master!

See you in class!

-Richard Walters (Microsoft Excel Trainer)