Microsoft Excel 101 - Excel Basics Beginner Course

Name: Microsoft Excel 101 - Excel Basics Beginner Course
Rating: 3.9 (60 reviews)

Learn and master the Basic Functions of Microsoft Excel

Created byUltimate Masters Academy

Last updated 10/2020

English

What you'll learn

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.

Course content

1 section • 10 lectures • 50m total length

Chapter 1: Getting Familiar with Excel4:43
[1] Understanding the Basic Functions of Excel
[2] Excel's Spreadsheet Interface: Ribbon, Worksheet, and Name Box
[3] What is a Cell, Data Range, Data Column and Data Row
[4] Changing the Width of a Column/Row
[5] Creation of a simple Table, Quick Formatting and Total Sum Analysis
Chapter 2: Understanding the Data11:15
[1] Zoom “In / Out” to a comfortable view
[2] Use “Freeze Top Pane” before analysing the Data Set
[3] Use “Filter” or hold “Alt + Up / Down ” to analyse Column Data
[4] Preview of how Pivot Table Analysis can help you understand the Data
Chapter 3: Format your Worksheet5:52
[1] Using “Font” and “Alignment” Panel in the Ribbon
[2] Using different alignment styles to format your worksheet
[3] Using different cell colors and font sizes for visual differentiation
[4] Learn to use the “Copy and Paste Special Format” technique
[5] Change the colour of your Worksheet
Chapter 4: Multiple Data Worksheets3:20
[1] Create new Data Worksheets
[2] Delete Data Worksheets
[3] Move or Copy Data Worksheets across different Data Workbooks
Chapter 5: Selecting / Copying / Pasting5:03
[1] Hold down “Shift” to select Multiple Data cells
[2] Use the “Clipboard” in the Home Ribbon to “Cut, Copy & Paste”
[3] Alternatively, you can use Keyboard Shortcuts “Ctrl + X, C, or V”
[4] Recap of “Paste Special” Technique in Chapter 3.
[5] Use Paste Special keyboard shortcut “Ctrl + Alt + V”
Chapter 6: Formatting Data as Tables3:41
[1] How to format your data set into an Excel Table
[2] Toggle around to select your preferred Table Style
[3] Default settings of an Excel Table has Filters and Banded Rows on
[4] Using Excel’s auto-prompt dropdown data table analysis
Chapter 7: Check for Data Duplicates3:30
[1] How to remove data duplicates?
[2] Always check for data duplicates when numbers don’t add up
[3] A good practice habit would be to create a copy of the data set before removing the data duplicates
Chapter 8: Locating Blanks & Errors4:10
[1] How to locate Blanks?
[2] What causes an Excel error?
[3] How do you locate and fix these Excel errors?
Chapter 9: Saving & Printing5:02
[1] How do you save and print your files?
[2] How do you save your files in different variations? i.e. PDF etc.
[3] How do you print just a specific area of the worksheet?
[4] How do you toggle printing between Landscape and Portrait form?
Chapter 10: Data Security & Protection4:10
[1] Protecting your Workbook with an encrypted password
[2] Protect current Sheet: Allow all users to use only limited function
[3] Mark as Final: Let readers know the workbook is final and read-only

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