Get Started With Microsoft Excel In 1 Hour
4.7 (619 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.
22,414 students enrolled

Get Started With Microsoft Excel In 1 Hour

In this course I will show you step-by-step how to set up a fully functioning Microsoft Excel spreadsheet.
4.7 (619 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.
22,414 students enrolled
Created by Jennifer Bailey
Last updated 2/2019
English
English [Auto-generated]
Current price: $11.99 Original price: $19.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Name and Save a Microsoft Excel Workbook
  • Add Titles and Subtitles

  • Add Columns and Rows

  • Format Text
  • Autofill Data (Days of The Week, Months of The Year etc.)
  • Assign Cell Formats (Text, Dates, Number)
  • Use Basic Formula Including AutoSum and Averages
  • Absolute Referencing
  • Adding Cell Borders
  • Printing a Spreadsheet
  • Headers and Footers
  • Build a solid understanding on the Basics of Microsoft Excel
Requirements
  • This course was created with Excel 2013. But all features will work in Excel 2010, 2013, 2016 and most will work in 2007.
Description

Microsoft's Excel 2013 for Windows is a very useful and powerful piece of spreadsheet software - but it can appear daunting if you have never used it before. 

Be daunted and confused no more!

Microsoft Excel can be amazing when you get it to work FOR you. It can save you endless time and perform cool functions. You don't need to spend hours learning with Excel in order to get to grips with the basics and to create your first working spreadsheet.

Jennifer is a knowledgeable tutor who has taught at many ability levels. She uses her experience of teaching absolute beginners to paces this video course well, in bite-sized pieces and with step by step instructions. 

Jennifer prides herself on her ability to assume you know something already, to not leave you confused or as it you are missing a piece of the puzzle.

This Microsoft Excel course does exactly what it says on the tin - 'Get Started with Microsoft Excel in 1 hour'!  You will be able to perform some really key actions which nearly all spreadsheets need - in an hour - for example Jennifer covers how to format cells, enter data, autofill, basic formulas and absolute referencing.The course also contains bonus 'tip' videos to teach you extra features of Excel.

By the end of this introductory course, Jennifer gets you feeling confident about creating your first Microsoft Excel spreadsheet. As an example she uses a real working example of a spreadsheet - a timesheet so that you can use this yourself to calculate your hours worked, overtime, net and gross pay.

Let's get started! Enrol today and see how you too can harness the power of Microsoft Excel!

What do the students have to say about the course? 

"Well, I began this course knowing next-to-nothing about Excel. And I'm only at lesson #5 or #6 (after about 20 minutes time). Nonetheless, her diction is clear -- she's using (I'm assuming), a written script, and thus everything she says is easily understood. Better yet, there is a very-easily-seen yellow circle surrounding her mouse, so there isn't a second of time when one has ANY confusion about the various maneuvers she's employing with her mouse. AND, she neither speaks nor moves too quickly. All in all, I'm impressed . . . and eager to keep forward. (And no, I have no connection with, nor even the slightest knowledge about, the instructor. But she's really good at imparting new information to a total newbee such as myself!)"

"I feel that it was organized well & segmented enough to where it would not overwhelm & can be picked back up easily to continue further study.

"Strong introductory course"

"She is a very thorough instructor. I look forward to taking more classes in the future from her

"Awesome step by step for a true novice, never goes to fast and explains everything so you can't miss anything. Very refreshing for someone to really take the time and explain every details of the ongoing of steps and doesn't just assume you know everything already."


Who this course is for:
  • Beginner
  • For anyone who wants to learn Microsoft Excel from scratch
Course content
Expand all 39 lectures 02:20:09
+ Introduction and Welcome
3 lectures 08:13
Navigating The Udemy Dashboard and Viewing Settings
05:16
Introduce Yourself
01:22
+ Introduction To Excel
14 lectures 01:11:57

Learning Objective

You will learn how to:-

  • Create a new Microsoft Excel spreadsheet
  • Name a spreadsheet
  • Save a spreadsheet to a location so you can find it again!
  • Save a spreadsheet as you go
Preview 01:50

Learning Objective: 

You will learn how to:-

  • Format your Microsoft Excel spreadsheet
  • Add Titles and Subtitles
  • How to change the Width and Height of a cell
  • How to Centre (Center) or Align information
  • How to change Font and Size of Font
  • How to Merge Cells
  • How to Change Colours
  • How to Embolden and Underline Information
  • How to Wrap text
Preview 07:16

Learning Objective: 

You will learn how to:-

  • Use the AutoFill Function in your Microsoft Excel Spreadsheet
  • Autofill days of the week or dates etc. (easily adding sequential data to the spreadsheet)
Preview 02:23

Learning Objective: 

You will learn how to:-

  • Add Data into your Microsoft Excel Spreadsheet

  • Start using Simple Formulas 

  • Copy and Paste Data across Cells

  • Copy a Pattern of numbers 

Add Simple Data and Formulas to a Microsoft Excel Worksheet
03:48

Learning Objective: 

You will learn how to:-

  • Assign cell formats to specific data in your Microsoft Excel spreadsheet
  • Change date formats to suit your preference 
  • Change number formats for decimal places, negative number etc.
  • Change currency formats


Choose and Change Cell Formats
04:23

Learning Objective: 

You will learn how to:-

  • Add formula for multiplication (*), division (/) and subtraction (-) in a Microsoft Excel Spreadsheet 
  • Add a cell reference rather than a number in a formula
  • Use brackets in a formula 
  • Calculate percentage (%)
Add More Basic Formula in a Microsoft Excel Spreadsheet
05:11

Learning Objective: 

You will learn how to:-

  • Add a Totals Row in a Microsoft Excel Spreadsheet
  • Use the Autosum Function (to calculate the sum of a range of cells)
  • Use the Average Formula (Mean)
Add Total and Averages Formulas into a Microsoft Excel Worksheet
03:13

Learning Objective: 

You will learn how to:-

  • Use Absolute Referencing in a Microsoft Excel Spreadsheet to fix / anchor a cell reference - so when you copy formula these cells remain anchored (and not changed automatically).



Use Absolute Referencing to Anchor a Cell or Cells in a Microsoft Worksheet
05:46

Learning Objective: 

You will learn how to:-

  • Define a table using borders in a Microsoft Excel Speadsheet
  • Understand the difference between Gridlines and Borders
  • Turn Gridlines ON and OFF
  • Add Borders
  • Change the view of a Spreadsheet
  • Use Preset Borders
  • Use Custom Boaders
  • Change a colour of a border
Add Borders to Define a Table in a Microsoft Excel Worksheet
11:20

Learning Objective: 

You will learn how to:-

  • Print a Microsoft Excel Spreadsheet
  • Alter a margin
  • Set a Print Area to Print Selection 
  • Change Scaling to fit a spreadsheet on 1 page to print
  • Change a view of a Spreadsheet to Preview Printing
  • Change Page Orientation from Portrait to Landscape 
  • Select a Printer to print to
Print a Microsoft Excel Worksheet
09:43

Learning Objective: 

You will learn how to:-

  • Insert Headers and Footers in your Microsoft Excel Spreadsheet
  • Insert a Picture
  • Insert Page Numbers
  • Change Margins
Insert Headers and Footers into a Microsoft Excel Worksheet
05:02

Learning Objective: 

You will learn how to:-

  • Use the Sort Function in your Microsoft Excel Spreadsheet
  • Sort Unrelated Information
  • Sort Related Information
  • Sort Data by Multi Levels
Sort Simple and Related Data in a Microsoft Excel Worksheet
08:05

Learning Objective: 

You will learn how to:-

  • Extract specific data from your Microsoft Excel Worksheet
  • Using the Filter function in Microsoft Excel
Extract Data Through Filtering in a Microsoft Excel Spreadsheet
03:57
Summary and Next Steps
1 page
+ Supporting Documents
2 lectures 00:00

This PDF shows the completed spreadsheet created in Lectures 1 - 8 - showing the data entered I so that you can check that yours are the same.

Timesheet Spreadsheet Version 1 - Showing Data
1 page
Timesheet Spreadsheet 1 - Showing Formula
1 page
+ Developing The Spreadsheet Further
3 lectures 12:42

Learning Objective: 

You will learn how to:-

  • Use the Format As Table function in your Microsoft Excel Spreadsheet
  • Insert a Table into a Excel Worksheet
  • Working with Tables to find information quicker by filtering your table
  • Turning the filter button on and off
  • Design your table


Insert and Format a Table of Data in a Microsoft Excel Spreadsheet
06:04

Learning Objective: 

You will learn how to:-

  • Duplicate a Microsoft Excel Worksheet
  • Rename a Worksheet
  • Create a Microsoft Excel Workbook
Duplicate a Worksheet
03:39

Learning Objective: 

You will learn how to:-

  • Delete Data from an Microsoft Excel Table
  • Move a Worksheet in a Workbook
  • Insert a row keeping formulas in place 
Delete Data From a Table
02:59
+ Troubleshooting/ Answers to Questions From Students
5 lectures 15:04

Trouble Shooting Question - 

Fix Hashes (#####) displaying instead of Data

Why Do Hashes Appear In Columns Instead of Data? Fix
03:22

Trouble Shooting Question - 

How Excel does AutoFill to adjacent cells

How to change AutoFill Options


Why Does Excel Auto-Complete (Auto-Populate) Cells? Explanation
02:58

Trouble Shooting Question - 

AutoFill not working

How to turn AutoFill button ON / OFF

Why is My AutoFill Not Working? (Fix)
02:07

Trouble Shooting Question - 

AutoSum not selecting the whole range of cells


Why Isn't AutoSum Selecting Range of Cells? Fix
03:21
How To Duplicate An Existing Worksheet (To keep formatting)
03:16
+ Quick Start Tips and Shortcuts
6 lectures 09:29

Quick Start Tip

Add Up a Range of Cells with a Shortcut

Preview 01:08

Quick Start Tips

Insert Current Date and Time into a Microsoft Excel Worksheet

Preview 00:52

Quick Start Tip

How to Create Multiple Worksheets in Microsoft Excel

How to Change Worksheet Name

How to Change Worksheet Tab Colour

Preview 02:19

Quick Start Tip

How to change the colour of Gridlines in a Microsoft Excel Worksheet

How to Switch Gridlines ON and OFF

Preview 02:34

Quick Start Tip

How to Change the Colour of Text in Microsoft Excel

How to Change the Colour of a Cell

Preview 02:07

A Handy PDF to download of all the Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys
00:29
+ (Course Preview) Quick Start: Creating an Accountancy Spreadsheet
5 lectures 18:21
Creating a Business Spreadsheet
06:58

Lecture Objective: To set up the first month of your spreadsheet

I will show you how to: Creating a new worksheet (tab), rename the tab, create a title for the worksheet using a formula (referencing information from another worksheet) 

(First Calendar Month)Inserting Formula - Setting Up A New Worksheet With Titles
04:14

Lecture Objective: To be able to create and format an Excel table


Creating and Formatting an Excel Table With Monthly Accountancy Headings
06:52

This course is already available on Udemy. If you would like a discount on this course then please use the coupon PREVIEW15 to get 50% off the course price or click here: https://www.udemy.com/quick-start-excel-creating-an-accountancy-spreadsheet/?couponCode=PREVIEW15


Enjoy!

Jennifer


How Do I Get This Course?
00:06
+ Extra Support, Tutorials and Tips
1 lecture 01:23
Join my Free Facebook Group Now!
01:23