Quick Start Excel: Getting Started With Excel
4.8 (553 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
22,367 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Quick Start Excel: Getting Started With Excel to your Wishlist.

Add to Wishlist

Quick Start Excel: Getting Started With Excel

In this course I will show you step-by-step how to set up a fully functioning Excel spreadsheet.
4.8 (553 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
22,367 students enrolled
Created by Jennifer Bailey
Last updated 11/2016
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Name and Save a Excel Wordbook
  • 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
View Curriculum
Requirements
  • Have access to Microsoft Excel
Description

Microsoft's Excel 2013 for Windows is a very useful and powerful piece of software - but it can appear daunting if you have never used it before. Jennifer will teach you step-by-step how to create a basic spreadsheet (using the example of a basic timesheet). She covers how to format cells, enter data, autofill, basic formulas and absolute referencing which will get you started quickly.

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

Who is the target audience?
  • Beginner
Students Who Viewed This Course Also Viewed
Curriculum For This Course
35 Lectures
02:16:39
+
Introduction and Welcome
1 Lecture 01:35
+
Introduction To Excel
14 Lectures 01:13:20

Objective: How to Create a New Workbook, Name it and Save it.

You will be able to name it and save it in a location and in a way that it can be easily found.

Preview 01:55

Lecture Objective: To be able to add titles/ subtitles/ headings to a Excel worksheet and format them.

In this lecture we cover: merge and center, wrap text, column and row resizing, emboldening/ underlining, changing font size and color, alignment.

Preview 07:21

Lecture Objective: Be able to use the autofill function to add sequential data to am Excel worksheet.

Preview 02:28

Lecture Objective: To be able to add numerical data into a cell. In our time sheet we add the rate of pay plus use simple formula to calculate 'time and a half' and 'double time' pay (rate of pay x 1/5 and rate of pay x 2). Copy and pasting values down columns which automatically adjusts the formulas.

How To Add Simple Data and Formulae
03:53

Lecture Objective: To assign cell formats to specific data such as currency/ accounting, date, number and general.

How To Assign Cell Formats
04:28

Lecture Objective: Be able to add simple multiplication and subtraction formula, as well as a basic understanding of how to use brackets and calculating percentage.

How To Add More Basic Formula
05:16

Lecture Objective: To be able to use Auto Sum and Average Formula

In this lecture I will show you how to use autosum to calculate the sum of a range of fields, we will also use the average formula too to quickly calculate averages (mean).

How To Calculate Totals and Averages (Using Formula)
03:18

In this lecture I am going to show you how to use absolute referencing - which is way of referencing specific cells - so when you copy formula these cells remain anchored (and not changed automatically).

How To Use Absolute Referencing
05:50

How To Add Borders To Define a Table
11:30

Objective: To be able to print your spreadsheet

In this lecture I show you how change print settings to get your spreadsheet to print onto one page by : altering margins, changing page orientation, using scaling. I also cover how to print a selection of a worksheet and how to set a print area.

How To Print Your Spreadsheet (Print Settings)
09:53

Objective: To Add a Header and a Footer to a Spreadsheet.


By the end of this lecture you should be able to add a header and a footer to your spreadsheet. I demonstrate how to add a picture to the header (and adjust the margins so it fits) and how to add page numbers to the footer.

How To Insert Headers and Footers
05:13

How To Sort Simple Data and Related Data
08:09

How To Extract Specific Data Using Filtering
04:06

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 13:13
How To Format Data As A Table
06:15

How To Copy a Worksheet Within a Workbook
03:49

How To Delete Data From a Table
03:09
+
Troubleshooting/ Answers to Questions From Students
5 Lectures 16:21
Why Do Hashes Appear Instead of Data in Columns?
03:43

Why Does Excel Auto-populate Cells? (Paula's Question)
03:08

Why Doesn't My Autofill Work?
02:23

Why Isn't Autosum Selecting The Whole Range of Cells?
03:38

How To Duplicate An Existing Worksheet (To keep formatting)
03:29
+
Quick Start Tips and Shortcuts
5 Lectures 10:06

In this Quick Start Tip video I show you how to total a column or row using keyboard shortcut keys (Insert Sum).


If you are using a Mac then please use Command + Shift + T instead of Alt + =.

Preview 01:18

In this Quick Start Tip video I show you how to total a column or row using keyboard shortcut keys (Insert Sum).


If you are using a Mac then use Ctrl + SEMICOLON (;) for date (same as in the video) and' Command + SEMICOLON (;) for time.

Preview 01:02



Objective: Be able to change text colour (recap from Lecture 3) and also change the colour of cells.

Preview 02:33
+
(Course Preview) Quick Start: Creating an Accountancy Spreadsheet
5 Lectures 19:04
Creating a Business Spreadsheet
07:17

Business Yearly Set Up (Image)
00:11

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:25

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


Creating and Formatting an Excel Table With Monthly Accountancy Headings
07:05

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
About the Instructor
Jennifer Bailey
4.5 Average rating
732 Reviews
29,117 Students
6 Courses
Experienced off-line and on-line tutor

I have been creating websites for several years now and have been using WordPress as well as Serif software. I enjoy building websites for other people as well as myself.

I achieved my BSc(Hons) in 1996, and then my Post Graduate Certificate In Education in 2001. I am also a member of the Institute for Learning.

Since qualifying I have worked in education with a spectrum of ages and abilities in colleges, the workplace and though private work.

I am a specialist in teaching English, Maths, ICT and Food Studies, both off and on-line. I also have experience in curriculum design, e-Learning and assessing.

I use technology wherever possible in my courses and I try and cater for all learning styles.I have tailored my on-line courses to promote learning using small bite-sized steps so that the learner can work at their own pace and not to be baffled by terminology, nor bored by waffle!

When selecting FREE video tutorials within each course

1. Select video

2. Hit play button

3. Go to bottom right corner of each video player and change resolution from 320 to 720HD for best viewing.