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.5 (531 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,355 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 35
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2014 English

Course 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.

What are the requirements?

  • Have access to Microsoft Excel

What am I going to get from this course?

  • 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

What is the target audience?

  • Beginner

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Welcome
Welcome
Preview
01:35
Section 2: Introduction To Excel
01:55

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.

07:21

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.

02:28

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

03:53

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.

04:28

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

05:16

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.

03:18

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).

05:50

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 Add Borders To Define a Table
11:30
09:53

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.

05:13

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 Sort Simple Data and Related Data
08:09
How To Extract Specific Data Using Filtering
04:06
Summary and Next Steps
1 page
Section 3: Supporting Documents
1 page

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 1 - Showing Formula
1 page
Section 4: Developing The Spreadsheet Further
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
Section 5: Troubleshooting/ Answers to Questions From Students
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
Section 6: Quick Start Tips and Shortcuts
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 please use Command + Shift + T instead of Alt + =.

01:02

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.

Tip #3 - Renaming and Changing Colour of Worksheet Tabs
Preview
02:29
Tip #4 - Change The Colour of The Worksheet Gridlines
Preview
02:44
02:33

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

Section 7: (Course Preview) Quick Start: Creating an Accountancy Spreadsheet
Creating a Business Spreadsheet
07:17
Business Yearly Set Up (Image)
Article
04:25

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) 

07:05

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


Article

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


Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jennifer Bailey, 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.

Ready to start learning?
Take This Course