Microsoft Excel 101 - Excel Basics Beginner Course

Learn and master the Basic Functions of Microsoft Excel
Rating: 3.9 out of 5 (30 ratings)
928 students
English
Students will learn the basics functions and tools of Excel to create data spreadsheets to analyse data
Students will learn how to manoeuvre multiple data spreadsheets and learn how to combine different data sources to form useful data reports
Students will also learn how to change the format and structure of their data tables and spreadsheets to create customized data reports
Students will learn how to troubleshoot data spreadsheets errors i.e. Data Duplicates, Blanks, errors etc. and learn how to fix them effectively.
Students will also learn how to enhance the security of their data spreadsheets for data protection and privacy needs.

Requirements

  • Students just need to have a general knowledge of working with Windows and have Microsoft Office 2010 or later installed.
  • Video was recorded with Excel 2016 and 2019. Concepts and Features are applicable across all versions of Excel on both Mac and Windows.
  • No prior knowledge or experience in Excel is required for this course.

Description

The Ultimate Master Course: Microsoft Excel 101 - Basics Beginner Course:
This is the Beginner Series - where we will hone your Microsoft Excel Skills at the Basic Beginner level.

Beginner Series
Students will get familiarized with Excel's system interface and learn the important functions of Excel how to handle and format data across multiple data worksheets.

Intermediate Series
Students will learn to use Pivot Tables in their data analysis for summarization, sorting, filtering, reorganizing and cluster-grouping, as well as formatting techniques for enhanced data visualization.

Professional Series
Students will learn about Pivot Charts and advanced Data Charting Visualization techniques to create Professional charts for high-impact data analysis reports and presentations.

SUPER PRO Series
Students will learn my expert Excel Shortcut techniques to be 500% faster in handling large data sets and also learn how to create interactive Dashboards and use VBA Macro to automate the data reports.

(Video Lessons were recorded with Excel 2016 and 2019 but works in 2008, 2010, 2013 (Office 365)]
Concepts and Features are applicable across all versions of Excel on both Mac and Windows.



Recent Student Review:

"The Ultimate Master Excel Dashboard Analytics course was way too good for how much it was selling! Can't believe I learnt all those awesome Excel tricks in just 6 hours! Can't wait to show my friends and colleagues what I can do now!

DEFINITELY ONE OF THE BEST COURSES THAT I'VE EVER HAD IN MY LIFE." - Felicia

"This Instructor is definitely the best Excel Instructor I've seen so far! Super-skilled and knowledgeable in Excel and Dashboard data analytics. Really wished I took this course earlier before I joined the work force. Would have helped me so much in my professional career if I knew earlier how to build these impressive dashboards!" - Derrick Y.



Enroll now to go through a deep dive
of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step-by-step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses, you will master Data Spreadsheet Analysis, learn advanced Data Visualization techniques, and be able to to build high-impact Interactive Dashboards and automate your Data Analysis Reports.

You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and more advanced level topics.

Upon course completion, you will come out with sheer confidence to handle any data analysis work with efficiency and grace.

Who this course is for:

  • Students whom are at the beginner level in Excel and would like to learn the basics functions and tools to create spreadsheets and analyse data
  • Students or Working Professionals who are looking to get a stronger grasp at analysing data and learning how to manoeuvre data spreadsheets
  • Students or Working Professionals who are looking to be able to handle dealing with multiple data spreadsheets to create useful data tables and summary reports

Course content

1 section10 lectures50m total length
  • Chapter 1: Getting Familiar with Excel
    04:43
  • Chapter 2: Understanding the Data
    11:15
  • Chapter 3: Format your Worksheet
    05:52
  • Chapter 4: Multiple Data Worksheets
    03:20
  • Chapter 5: Selecting / Copying / Pasting
    05:03
  • Chapter 6: Formatting Data as Tables
    03:41
  • Chapter 7: Check for Data Duplicates
    03:30
  • Chapter 8: Locating Blanks & Errors
    04:10
  • Chapter 9: Saving & Printing
    05:02
  • Chapter 10: Data Security & Protection
    04:10

Instructor

Maximizing Students' Learning in the Shortest Time.
Ultimate Masters Academy
  • 4.6 Instructor Rating
  • 224 Reviews
  • 9,346 Students
  • 3 Courses

Ultimate Masters Academy (U.M.A) is an Elite Masters Academy dedicated to teaching you highly-useful professional skills to supercharge your career and empowering you to finding your own financial freedom.

Widely-recognized for its best-in-class bite-sized lesson concepts, the Ultimate Masters Academy makes sure its students fully-maximizes their learning in the shortest time possible, rather than having to attend long lengthy courses.

Courses facilitated ranges from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses.

****************************************************

What Students said about the Ultimate Masters Academy:

"The Ultimate Master Excel Dashboard Analytics course was way too good for how much it was selling. Can't believe I learnt all those awesome Excel tricks in just 6 hours! Can't wait to show my friends and colleagues what I can do now. - Malcolm C.

DEFINITELY ONE OF THE BEST COURSES THAT I'VE EVER HAD IN MY LIFE." - Felicia  N.

"This Instructor is definitely the best Excel Instructor I've seen so far! Super-skilled and knowledgeable in Excel and Dashboard data analytics. Really wished I took this course earlier before I joined the work force. Would have helped me so much in my professional career if I knew earlier how to build these impressive dashboards." - Derrick Y.


****************************************************

With professional Instructors having over 10+ years of training (corporate training, 1-on-1 consulting and college courses), the Ultimate Masters Academy has taught thousands of students all the while maintaining a high level of delivery and satisfaction from the students he has taught.

Teaching Philosophy:

The Ultimate Masters Academy believes that each student learns best through the application of practical business situations through simulated real-life scenarios. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to any new technology and skills.