Microsoft Excel Intermediate to Advanced - Step by Step
- Course provided by Udemy
- Study type: Online
- Starts: Anytime
- Price: See latest price on Udemy
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
Locking and Protection
Formula Auditing and Comments
Filtering and Advanced Filtering
Pivot Tables and Pivot Charts
Named Cells and Named Ranges
Mixed Cell Referencing
Mathematical & Statistical 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.
- Use the paste special feature
- Apply conditional formatting to cells
- Lock and protect worksheets
- Create advanced charts
- Audit and apply comments to data
- Apply filter and advanced filter techniques
- Create pivot tables
- Use Functions (Vlookup, Nested, Text, Date, etc.)