Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Excel Masterclass- The Complete Microsoft Excel Course
Rating: 4.4 out of 5(91 ratings)
224 students

The Excel Masterclass- The Complete Microsoft Excel Course

Excel Essentials: A Step-by-Step Guide to Mastering Microsoft's Most Essential Business Tool
Created byIsaac Opare-Noe
Last updated 6/2023
English

What you'll learn

  • A full lesson on how to create your own Chat GPT in Excel
  • Master data analysis techniques, including PivotTables and PowerPivot
  • Learn how to work with data, including sorting, filtering, and data validation and more
  • Discover the power of formulas and functions, including VLOOKUP, IF, and SUMIF and many others
  • Get hands-on experience with real-world projects

Course content

4 sections • 92 lectures • 9h 48m total length

  • Welcome2:50
  • Practice Files - Level 10:02
  • The Excel Start Up Screen4:36
  • The Excel Interface4:45
  • Understanding The Excel Workbook6:26
  • Save, Save As, etc4:16
  • Entering Data into Excel3:23
  • Alignment in Excel3:36
  • Summation in Excel13:34
  • Summation in Excel Cont.7:51
  • Relative and Absolute Referencing15:52
  • Minimum and Maximum Function7:18
  • Average Function3:22
  • The Count Function2:14
  • Copying and Moving7:13
  • Inserting and Deleting Cells6:26
  • Deleting Cells, Rows and Columns3:52
  • Changing the sizes or Rows and Columns4:45
  • Hiding and Unhiding Rows and Columns2:39
  • Renaming and moving Sheets7:03
  • Formatting in Excel – Introduction3:38
  • Formatting – Changing Background5:57
  • Formatting – Changing Background 210:47
  • Formatting – Numbers, Currency etc10:27
  • Formatting – Adding Borders4:31
  • Formatting – Creating Styles6:54
  • Formatting – Conditional Formatting5:49
  • Formatting – More Borderlines4:12
  • Inserting Images and Objects12:32
  • Modifying Charts13:39
  • Pie Charts4:29
  • Formatting Charts4:45
  • End of Section Quiz
  • Yippee Level 1 Complete ??0:09

Requirements

  • No Prior Experience required. Come as you are😊.

Description

The Excel Master Class is a comprehensive course that provides you with the skills and knowledge needed to become proficient in using Microsoft Excel. The course is designed for individuals who want to enhance their proficiency in Excel, from beginners to advanced users.


Guess What, we have a full lesson on creating your own Chat GPT in Excel.


We also offer an optional Certified Certificate (in addition to the Udemy Certificate) from the prestigious Institue of Financial Accountants (IFA, UK).  The Digital Certificate demonstrates your proficiency in Excel and can be displayed on your resume, LinkedIn profile, or website. The certificate comes at an additional cost of $100.


The course is divided into three levels: Beginner, Intermediate, and Advance. Each level builds upon the previous one, gradually introducing you to more advanced features and capabilities of Excel. The course covers a wide range of topics, including creating and formatting worksheets, basic and advanced formulas and functions, pivot tables, macros, VBA programming, data analysis, and much more.


The Excel Master Class also includes practical exercises and quizzes to help you apply what you have learned and test your knowledge. The course is self-paced, allowing you to learn at your own speed and convenience.


Overall, The Excel Master Class is an excellent investment if you want to master Excel and become more productive in your work and personal life.

Who this course is for:

  • Excel beginners looking to get a solid foundation in the software Intermediate Excel users looking to take their skills to the next level Professionals in any field looking to improve their Excel skills and productivity Students and academics looking to get ahead in their studies or research
  • Intermediate Excel users looking to take their skills to the next level
  • Professionals in any field looking to improve their Excel skills and productivity
  • Students and academics looking to get ahead in their studies or research

Report abuse