• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel beginner to advanced

Microsoft Excel beginner to advanced

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 6 hours

  • All levels

Description

Embark on a comprehensive journey from the basics to the advanced functionalities of Microsoft Excel with our meticulously designed course. This program is tailored for individuals who are new to Excel as well as those looking to refine their skills and master the application. Starting with the fundamentals, you will learn how to navigate the Excel interface, manage worksheets, and enter data efficiently. As you progress, the course will introduce you to formulas and functions, essential tools for data analysis and interpretation. You'll gain hands-on experience with formatting techniques to present data in a visually compelling way, and delve into the art of creating and customizing charts. The course also covers the powerful features of data management, such as sorting, filtering, and using pivot tables for dynamic data summarisation. Advanced modules will guide you through complex functions, macro creation for automation, and integration with other Microsoft Office applications. By the end of this course, you will have the confidence to leverage Excel's full potential, making you an invaluable asset in any data-driven environment. Whether for personal growth or professional development, this course will equip you with the skills to excel in Excel.

Course Content

Overview
  1. Excel Promotional video
Introduction Level
  1. The basics
  2. Locking Cells
  3. Filling Data Quickly
  4. Flash Fill
  5. Sorting Data
  6. Find and Replace
  7. Charts
  8. SmartArt
  9. How to use Sparklines
  10. Printing Sections
Intermediate Level
  1. Named Cells and Ranges
  2. Conditional formatting
  3. Linking Sheets
  4. Linking Files
  5. Grouping Rows and Columns
  6. SubTotals
  7. Count Functions
  8. SUM functions
  9. Text Functions
  10. Date Functions
  11. Common Functions
  12. LOOKUP functions
  13. Lookup an Image
  14. Dynamic data return with SUMIF and Concatenation
  15. Joining Text and Fields with Concatenation
  16. Mastering Filters
  17. Summarising Filtered Data
  18. The TAKE function
  19. The DROP function
Advanced Level
  1. Pivot tables
  2. PowerPivot and KPIs
  3. How to create a Gantt chart
  4. How to create a Dial chart
  5. Combine Data using VSTACK
  6. How to create an Appointment Calendar
  7. Data Validation
  8. What-IF Analysis
  9. The IF Function
  10. The AND function
  11. Nesting Functions
  12. INDEX and MATCH functions
  13. The LAMBDA feature
  14. Basic Macros
  15. Introduction to Office Scripts
  16. Developer Controls
Exercise Section
  1. Introduction Level Exercise
  2. Intermediate Level Exercises
  3. Advanced Level Exercises

About The Provider

Since 1998, I have been a trainer at...

Read more about IT's Easy Training

Tags

Reviews