Excel Essentials: Tutorial for Beginners
4.4 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
25 students enrolled

Excel Essentials: Tutorial for Beginners

Learn to use Excel in under 2 hours! We not only cover the basics, but teach useful Formulas, Functions, & Analysis.
4.4 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
25 students enrolled
Created by Debbie McCusker
Last updated 10/2017
English
English [Auto]
Current price: $30.99 Original price: $44.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will learn how to create spreadsheets, use the backstage view, as well as Print and Save files.
  • You will be able to use AutoFill, Flash Fill, and Zoom.
  • You will learn how to use Mathematical Formulas and Functions to view data from different financial perspectives.
  • You will learn how to use Quick Analysis Charts, Tables, and Sparklines to visualize your data.
  • You will learn to use Themes, Styles, and Conditional Formatting to present your data visually.
  • And, you will learn how to properly Save, Print, Change Layouts & Views, Share, and Email spreadsheets.
Requirements
  • This course teaches Excel from the Beginning, so no experience is necessary.
  • To get the most out of this course, you should have a copy of Excel installed to be able to complete the practice exercises.
Description

Welcome to the Microsoft Excel Essentials Tutorial for Beginners. You will learn to use Excel to analyze numbers, keep track of data, and graphically represent your information. We will make your job easier by providing easy to follow steps to help you turn your data into usable information – and better information leads to better decision making!

This course will have you up and running in under 2 hours. Excel has some very advanced features that have been made very simple in the newer versions. This course mainly focuses on Excel 2013 and newer versions, but if you have an earlier version, you will still be able to learn effective Formulas, Functions, and Analysis.

Who this course is for:
  • Anyone who uses Excel for work or personal and needs to have an intermediate ability to work with spreadsheets.
  • Anyone who uses Excel for entering data, lists, formulas, functions, charts, and graphs.
Course content
Expand all 38 lectures 01:19:56
+ Introduction
7 lectures 12:19
Topic Objective To learn how to enter numbers and text into cells in a worksheet. Topic Summary Data is entered into cells. Click the cell you want, and type the desired entry. You can enter either numbers (values) or text (labels) in Excel. Once you have finished typing, you can press Tab or Enter
Excel Essentials - Exercise # 1 - Entering Data
1 question

This brief quiz is for you to review and confirm your knowledge of the information presented and practiced in Section 1: Introduction and Getting Started.

QUIZ - Section 1 Review
5 questions
+ Formatting
13 lectures 20:38
Topic Objective To learn how to check the spelling in your worksheet. Topic Summary To check your spelling, display the Review tab, and click the Spelling button (in the Proofing group).
Excel Essentials: Exercise # 2 - Spell Check
1 question
Topic Objective To learn how to use the Flash Fill feature in Excel. Topic Summary The Flash Fill feature was new to 2013. It finds connections in your data to help you fill in information. If you are using an earlier version of Excel, you will not be able to complete this exercise.
Excel Essentials: Exercise #3 - Using Flash Fill
1 question
Styles and Themes
02:49
Freeze Panes
02:11
Hide / UnHide Rows and Columns
02:03
Format as a Table
01:38

This brief quiz is for you to review and confirm your knowledge of the information presented and practiced in Section 2: Formatting.

QUIZ - Section 2 Review
8 questions
+ Formulas and Functions
10 lectures 30:20
Formulas and Functions Introduction
08:06
Formulas: Sum and Percentage
03:42
AutoSum Drop-Down
01:04
AutoComplete
01:09
Topic Objective To learn how to build a formula in Excel. Topic Summary All formulas begin with the = symbol. To enter a formula, click the cell where you want the formula and begin typing. When you click on another cell, the contents of that cell will be included in the formula. Press Enter.
Excel Essentials: Exercise # 4 - Entering Formulas
1 question
Topic Objective To learn how to copy a formula. Topic Summary In Excel, you often repeat the same formula, changing only the cells you are referencing. You can easily copy the formula instead of having to re-enter it multiple times.
Excel Essentials: Exercise #5 - Copying Formulas
1 question
Cell Reference: Relative vs. Absolute
03:20
Topic Objective To understand the difference between relative and absolute referencing and to learn how to use Absolute Referencing in a formula. Topic Summary Copying formulas works because of Relative Referencing. Formula references actually reference the cell relative to the formula location.
Excel Essentials: Exercise #6 - Cell Reference
1 question
Status Bar
01:33
Topic Objective To learn how to use the Status Bar to perform basic functions and to learn how to customize the Status Bar. Topic Summary The Status Bar provides a quick way to perform basic functions on highlighted cells. You can customize the Status Bar to show different functions.
Excel Essentials: Exercise #7 - Status Bar Calculations
1 question
Formatting and Formulas: Quick Analysis
03:49
Topic Objective To learn to use the Quick Analysis formatting tools in Excel. Topic Summary If you have a table of data that you want to analyze, there are several quick formatting options that can make your analysis easier. You can add data bars, a color scale, or an icon set for numbers.
Exercise #8 - Formatting & Formulas using Quick Analysis
1 question
Tip: Tell Me Help
00:44

This brief quiz is for you to review and confirm your knowledge of the information presented and practiced in Section 3: Formulas and Functions.

QUIZ - Section 3 Review
8 questions
+ Printing and Sharing
3 lectures 06:48
Topic Objective To understand the options available on the Page Layout tab of the Ribbon. Topic Summary The Page Layout tab is used to set up your page. There following groups of buttons are on this ribbon: • Themes • Page Setup • Scale to Fit • Sheet Options • Arrange
Exercise #9 - Page Layout Tab
1 question
Sharing Files
01:20
Topic Objective To learn how to share your workbook via email. Topic Summary The new Excel 2013 Share tab in the Backstage View allows you to easily send the current workbook using your default email application. You can send it as an attachment or you can send a link to the file.
Exercise #10 - Emailing your Workbook
1 question

This brief quiz is for you to review and confirm your knowledge of the information presented and practiced in Section 4: Printing and Sharing.

QUIZ - Section 4 Review
5 questions
+ Sorting and Filtering Data
5 lectures 09:51
Topic Objective To learn about the sorting and filtering options in Excel 2013 and newer versions. Topic Summary Excel allows you to sort your data in ascending or descending order by one or more columns. When you sort, Excel keeps your rows together.
Exercise #11 - Sorting and Filtering Data
1 question
Sort - Multiple Levels
02:02
Quick Analysis Sparklines
01:22

This brief quiz is for you to review and confirm your knowledge of the information presented and practiced in Section 5: Sorting and Filtering.

QUIZ - Section 5 Review
5 questions
Insert Slicer
02:07