Microsoft Excel - Excel for beginners
4.3 (22 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.
225 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Excel for beginners to your Wishlist.

Add to Wishlist

Microsoft Excel - Excel for beginners

This Excel course is the complete beginners guide to Microsoft Excel
4.3 (22 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.
225 students enrolled
Created by Colin Marks
Last updated 1/2017
English
English
Current price: $10 Original price: $40 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use Microsoft Excel with confidence in an Office environment.
  • learn how to use the most common Excel formulas and functions to carry out day to day spreadsheet tasks.
View Curriculum
Requirements
  • Students should have Microsoft Excel 2013 installed on their computer so that they can follow along with the lectures.
  • No Prior spreadsheet experience is needed to take the class.
Description

Do you hide when someone mentions Microsoft Excel, or do you pretend to know more about them than you do, hoping you won't get caught out. Worry no more, this Microsoft Excel 2013for beginners course, designed for all levels of learner, is taught from the bottom up and is focused on the most important parts of Microsoft Excel that you will need to enable you to work in a busy office, dealing with spreadsheets or even just to make your home budget work better for you. At the end of the course you will be a competent Microsoft Excel 2013 user that will be an addition to any office. Practice material is supplied for you to practice the skills that are being shown so that you can get the best from this course.

This Microsoft Excel for Beginners course will start of at the Basics like creating spreadsheets and work right up to the slightly more advanced features like if statements.

This Microsoft Excel for beginners course is taught using simple descriptions so anyone starting spreadsheets for the first time will be able to understand the terms that are used.

Sample exercises are provided so that you can practice the things that we learn in the lectures.

If you want to go from being a Microsoft Excel Beginner to an advanced user, this is the first step.


Who is the target audience?
  • This course is designed for anybody who has no spreadsheet experience but wishes to become a competent Microsoft Excel user.
  • This course can be used as a refresher course for users who have used Microsoft Excel 2010 and 2007.
Curriculum For This Course
25 Lectures
01:53:55
+
Introduction
1 Lecture 04:08

An Introduction to the course, A quick introduction to me just so you can see the type of things to expect from the course.

Preview 04:08
+
Using the Application
3 Lectures 09:30

In the first of our sections, we will look at the layout the Excel . We will take a tour of the Excel Program, highlighting all the main places of interest.

We will look at the most important parts of the program to make sure you can navigate it with ease.

Preview 03:17

In this section we will look at saving spreadsheets, we will look at the process of saving a spreadsheet in the default manor, and also saving spreadsheets in different file types.

We will also talk about the reasons for saving in different file types.

Preview 03:40

In this section we will look at the different ways that we can create a spreadsheet, either from the default "blank" template, or from one of Microsoft pre prepared templates.

Creating spreadsheets
02:33
+
Working with Cells
6 Lectures 21:30

In this section we will look at the cells that make up an Excel Spreadsheet. We will look at the way we can manipulate cells.

We will look at selecting cells and the different types of information that we can enter into cells.

Cells
02:38

In this section we will look at searching spreadsheet files to find data and we will also look at replacing data with new content.

Searching for data and replacing data.
03:59

We will look at the ways that we can sort data in a spreadsheet. We will look at sorting lists and the different methods that we can use.

Sorting Data in a spreadsheet
06:21

We will look at filtering data in a spreadsheet. We will look at the ways we can use filtering to get a better view of only the elements that you wish to see.

Filtering Data
03:06

In this section we will look at cutting and copying content and pasting it into another area in the same spreadsheet or into a totally different spreadsheet.

We will also look at deleting cell content from cells.

Cut, Copy and Paste Content and Deleting Cell Content.
01:56

In this section we will look at using the auto fill option in Excel, we will look at the situations that you will use it and the way it can be used.

Using the Auto Fill Tool
03:30
+
Managing Worksheets
2 Lectures 08:53

In this section we will look at the ways we can interact with rows and columns.

We will look at selecting rows and columns, both adjacent and non adjacent.

We will look at inserting and deleting rows and columns and modify the Heights of rows and the widths of columns.

We will also look at freezing and unfreezing columns and rows and the reasons for doing so.

Rows and Columns
05:10

In this section we will look at the way we can use different worksheets in the Microsoft Excel program.

We will look at adding and deleting worksheets, Renaming worksheets.

We will also have a look at moving and copying entire worksheets.

We will also look at giving the worksheet tabs a colour, so that they can be quickly identified.

Worksheets
03:43
+
Formulas and Functions
5 Lectures 22:54

in this section we will look at creating formulas using cell references and arithmetic operators (addition,subtraction, multiplication, division).

We will look at the good practices that can be used in order to achieve the best results.

Creating formulas
04:43

In this section we will look at absolute cell referencing, the process of setting up your formulas and functions to get the best result with minimum effort.

Absolute cell referencing.
02:40

In this section we will look at some of the most common functions that can be used in spreadsheets.

We will look at the SUM, AVERAGE, MIN, MAX, COUNT and COUNTA Functions.

Functions
04:28

In this section we will look at the IF statement and the way it can be used to determine a true or false outcome.

The If Statement.
09:12

We will look at the different error messages that Microsoft Excel can produce and the meanings to each of them.

Error Messages in Formulas and Functions
01:51
+
Formatting
2 Lectures 09:36

In this section we will look at the different types of formatting that we can apply to cells in our Microsoft Excel 2013 spreadsheet.

We will look at formatting cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.

We will also look at formatting cells to display a date style, to display a currency symbol and to display numbers as percentages.

Cell formatting
04:01

In this section we will look at changing the cell content appearance like font sizes and font types.

We will also look at applying formatting to cell contents like bold, italic, underline, double underline.

We will apply different colours to cell content, cell background.

We will look at copying the formatting from a cell and placing it on another cell so that we can keep formatting uniform.

Formatting cell contents
05:35
+
Charts
2 Lectures 05:05

In this section we will cover charts, will look at creating a chart from spreadsheet data. We will create different types of charts like bar chart, column charts and lie charts.

We will look at selecting the charts, moving and resizing a chart, we will also delete a chart.

Another aspect we will do is the option to change the type of chart we are using, i.e from column to bar chart.

Creating a chart
01:58

This section will cover adding, removing and editing a chart title.

We will add data labels to a chart so that we can see exact values/numbers or percentages.

We will look at changing the chart area background colour and also the colours that make up the "bars" in the charts and change the colour of text used within the chart.

Editing charts
03:07
+
Outputs
2 Lectures 10:07

In this section we will look at the following:

  • Change worksheet margins: top, bottom, left, right.
  • Change worksheet orientation: portrait, landscape. Change paper size.
  • Adjust page setup to fit worksheet contents on a specified number of pages.
  • Add, edit, delete text in headers, footers in a worksheet.
The Page Set up.
08:03

In this last section we will look at printing our finished spreadsheet. we will look at :

Previewing a worksheet and then printing a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, we will also look at printing the entire spreadsheet and a chart.

Printing
02:04
+
Practice Material
2 Lectures 22:12

In this lecture, we complete a sample exercise, this exercise will combine everything you have just studied throughout the course. You will need to download the files before hand. You may attempt the exercise first, or watch me doing it on the video as you try to recreate the outcome. 

Practice 1
22:07

Free eBook for download, This can be used as a quick reference guide for the course.

Bonus Lecture - Free eBook
00:05
About the Instructor
Colin Marks
4.5 Average rating
209 Reviews
1,619 Students
6 Courses
Certified Microsoft & Apple Trainer

I am an IT Trainer with over 8 years experience in delivering training in both Apple and Microsoft to a large array of clients, in both public training centres and corporate environments.

I have an IT teaching diploma and focus mainly on software training. I hold a current Microsoft Office Master certificate and have been teaching Microsoft Office Specialist (Word, Excel, Access, Powerpoint and Outlook all to an advanced level) for the past 6 years.

The training I deliver ranges from iPad and iPhone training to Office productivity applications like Pages, Numbers and Keynote. I also train in video editing software like Final Cut Pro X and iMovie.

I feel the most important part of training is developing a connection with your students, building trust in both sides.