Microsoft Excel Intermediate to Advanced - Step by Step

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Are you looking to improve your Excel skills to become an advanced level user?

This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel.

In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.

Microsoft Excel - Fundamentals of Advanced Level Users

  • Paste Special

  • Conditional Formatting

  • Locking and Protection

  • Advanced Charts

  • Data Validation

  • Scenarios

  • Formula Auditing and Comments

  • Subtotalling

  • Sparklines

  • Filtering and Advanced Filtering

  • Pivot Tables and Pivot Charts

  • Named Cells and Named Ranges

  • Mixed Cell Referencing

  • Mathematical & Statistical Functions

  • Vlookup Function

  • Nested Functions

  • Database Functions

  • Text Functions

  • Date Functions and Calculations

Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place. In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master!

See you there!

-Richard Walters (Microsoft Excel Trainer)

__________

Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project.

Expected Outcomes

  1. Use the paste special feature
  2. Apply conditional formatting to cells
  3. Lock and protect worksheets
  4. Create advanced charts
  5. Audit and apply comments to data
  6. Apply filter and advanced filter techniques
  7. Create pivot tables
  8. Use Functions (Vlookup, Nested, Text, Date, etc.)