Excel Beginners Training From Scratch
4.3 (25 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.
3,702 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Beginners Training From Scratch to your Wishlist.

Add to Wishlist

Excel Beginners Training From Scratch

Learn to master Microsoft Excel with easy to follow step-by-step lessons using practical case studies and projects.
4.3 (25 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.
3,702 students enrolled
Last updated 8/2014
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn to navigate around Excel using the ribbon interface
Format worksheets and cells
Perform simple mathematical calculations
Use some of Excel’s built in functions
Create and edit different types of charts
Build a budgeting spreadsheet from start to finish
View Curriculum
Requirements
  • Excel 2007 or above (Windows)
Description

The Excel beginners training from scratch course will introduce you to the industry standard and popular spreadsheet software. This Excel training course is perfect for those wanting to learn Excel from the very beginning and you will become comfortable using some of the core features that Excel has to offer.

The course will introduce you to a number of features, tool and techniques of Excel and is perfect for students, entrepreneurs, housewives, business owners, professionals or anyone else looking to learn Excel. By the end of the course you will have mastered the basics of Excel and will be able to manage workbooks, use formatting, perform calculations, use formulas and create charts.

This is a hands-on beginners Excel course and you will learn by watching the instructor as he describes each action as he performs it. The course takes a project based approach, which means that you will be able to practice as you are learn and by the end of the course you will even complete a project from beginning to end – creating a fully functional budgeting spreadsheet with charts, formulas and a host of other features.

Note: The instructor uses Excel 2010 to teach the course, but the course should be suitable for those with Excel 2007 onwards. There are some differences in the menu structure if you are using Excel 2013.

Instructor: Abhijat Saraswat (Ab)

The course is taught by Ab, who is an Excel whizz and has been using Excel for over 10 years, since Excel 95. He uses Excel almost on a daily basis and has taught Excel to a large number of students including executives of large organisations, small business owners and entrepreneurs.

Who is the target audience?
  • This is course intended for beginners introducing them to the various features of Excel. The target audience is anyone interested in learning how to use Excel
  • Students, entrepreneurs, housewives, business owners or professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 46 Lectures Collapse All 46 Lectures 03:30:04
+
Introduction & files
3 Lectures 03:52
+
Navigating Excel
5 Lectures 14:57


Excel toolbars
04:28

The Excel file menu
02:35

Tips & Tricks
03:15
+
Working with Worksheets
6 Lectures 22:37
Working with worksheets
00:45

Creating, moving and deleting sheets
03:02

Renaming sheets
01:16

Copying and moving sheets
02:25

Worksheet organisation
02:37

Formatting cells and worksheets
12:32
+
Number Formats
7 Lectures 18:03
Introduction to number formats
00:34

Different number formats
02:07

Assigning number formats
03:50

Number format options
02:18

Custom number formats
03:22

Dates in Excel
02:10

+
Functions and calculations
6 Lectures 34:05
Formulas introduction
00:58

Math calculations
02:57

Introduction to functions
06:34

Absolute vs relative references
07:54

Most commonly used functions
13:32

Section wrap-up and exercise
02:10
+
Charting
8 Lectures 38:28
Charting introduction
00:34

Do you need to use a chart
02:48


Chart types
02:11

Creating a column chart
07:37

Creating a line chart
06:10

Creating a bar chart
09:49

Creating a pie chart and wrap-up
06:33
+
Course project
5 Lectures 36:52
Project introduction
00:49


Creating the data section
06:43

Creating the overview section
11:55

Creating the chart and conditional formatting
14:13
+
Course wrap-up
2 Lectures 01:31
Course wrap-up and thanks!
01:15

Please complete a short survey to help be improve and create better courses: complete the quick survey now.

Post course survey
00:16
+
Bonus content
4 Lectures 39:23

This lecture explains, in depth, how to use one of the most popular and powerful functions of Excel - Lookups.

Specifically, we go through vertical and horizontal lookups (vlookup & hlookup), including why,when and how to use them.

Lookups (V & H lookups)
11:36

Ever wondered if you could use words and name instead of cell references? Wouldn't you rather point your looks to the volumes table rather than $A$1:$B$18? Well named ranges allow you do just that - in this lecture you learn how to create, modify and use named ranges, including in lookup formulas.

Named ranges - adding meaning to your formulas
09:54

In this lecture I show you how to create, edit and delete comments in Excel. The lesson also discusses when comments should be used and when to avoid them.

Lastly I show you how to print comments.

Adding comments to your spreadsheets
06:44

In this lesson you will learn how to print excel spreadsheets. You will learn how to prepare documents so you can print what you want to. I will show you how to set up documents, go through different page views and learn how to add the same (column) header to each of your page.

Lastly I will show you how to save your documents in PDF so they can easily be sent via emails or otherwise distributed.

Printing and exporting spreadsheets
11:09
About the Instructor
Abhijat Saraswat
4.3 Average rating
25 Reviews
3,702 Students
1 Course
Udemy course instructor

Abhijat is a self-taught computer geek and has taught a large number of students including company executives, small business owners and entrepreneurs.

He has a background in data analysis, reporting and visualisation which he developed through working with a number of large organisations during which time he was involved with, and managed data driven projects for big name brands.

Abhijat has worked with Excel for most of his professional life and uses it frequently at home. He is a huge advocate of harnessing the power of Excel to guide better decision making and to problem solving. He has strong belief in learning software through projects and experimentation and encourages his students to put into practice what they learn to solve real-world problems.

All of his courses are designed to quickly get users up-to-speed and become more efficient in their day-to-day lives.

When he is not solving problems in Excel and exploring data-sets Abhijat likes to build websites, rock climb and go running. He is also a professional photographer.