• 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

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

About The Provider

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

Read more about IT's Easy Training

Tags

Reviews