Improve your efficiency - Master the Basics of Excel 2013

Learn Basics of Excel step by step with practicing excercises and learning shortcuts.
5.0 (2 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.
975 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 23
  • Length 1.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 11/2015 English

Course Description

Have you been trying to learn Excel in the past and found it to be difficult? Looking for an Excel course for beginners where you can learn everything about basics of excel so that you do not have to enroll for different courses for different topics? - This online course is something for you.

If you are an office administrator, you probably use Excel. Ditto if you are a salesman. If you are a financial analyst, of course, you need Excel. For these and many other professions, working with spreadsheets is an essential tool in the daily routine.

In the 22 lectures with 1.5 hours of contents you will learn basic techniques from the very begining of customizing, creating, modifying worksheets to named ranges, flash fill, performing calculations and changing workbook appearance.

There are exercise files at the end of every lecture so that you do not only learn excel but master it, by practicing exercises!

Whether you use Excel for work or study, these tutorials will start you on your journey to becoming an Excel Ninja!

Best part about this course is that all the lectures are explained step by step and are to the point. And thats why none of the lectures are too lengthy to make you bore.


What are the requirements?

  • You just need to have a working copy of Microsoft Excel 2013 and the willingness to learn about the magic of Excel

What am I going to get from this course?

  • Customize the Excel 2013 program window.
  • Create and Modify workbooks.
  • Modify worksheets.
  • Merge and unmerge cells.
  • Enter and revise data.
  • Manage data by using Flash Fill.
  • Find and replace data.
  • Correct and expand upon worksheet data.
  • Define Excel tables.
  • Name groups of data.
  • Create formulas to calculate values.
  • Summarize data that meets specific conditions.
  • Work with iterative calculation options and automatic workbook calculation.
  • Use Lookup, Reference and array formulas.
  • Find and correct errors in calculations.
  • Format cells and define styles.
  • Apply workbook themes and Excel table styles.
  • Change the appearance of data based on its value.
  • Add images to worksheets and more...

What is the target audience?

  • Any beginner who is new to Excel or has tried to learn Excel in the past and found it to be difficult
  • Anyone looking to increase their chances of better paying jobs, through mastering MS Excel

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: Intoduction
Introduction
Preview
02:03
Section 2: Getting started with Excel 2013
04:27

After completing this lecture you will be able to do:

  1. Zooming in on a worksheet
  2. Arranging multiple workbook window
  3. Adding buttons to the Quick Access Toolbar
03:55

After completing this lecture you will be able to do:

  1. Customizing the ribbon
  2. Maximizing usable space in the program window
02:57

After completing this lecture you will be able to:

  • Save Workbook
  • Set values for your workbook’s built in properties
03:17

You will learn about the ways of modifying workbooks such as:

  • Renaming worksheets
  • Copying a worksheet from another workbook
  • Changing the worsheet's order
  • Changing the color of worksheets tab
05:30

In this lecture u'll learn how to:

  • Change width/height of column
  • Insert, delete and hide row/column
  • Insert and delete cells
  • Moving data
  • Merging and Unmerging cells
Section 3: Working with data and Excel tables
05:11

Methods of Entering and revising data:

  • Auto Fill
  • Fill Series
  • Ctrl Key
  • Auto Complete
  • Pick from drop down list
  • Ctrl+Enter
02:03

Learn Flash Fill, new in Excel 2013, to fill out data based on an example.

02:47

Learn how to Move cells, range or rows/columns in a workbook. And learn features like Paste live preview and paste special, useful in moving data.

03:47

Learn about find and replace feature in Excel

02:31

In this lecture you will learn about:

  • Spelling Check
  • Adding new words to Custom Dictionary
  • Thesaurus
03:34

In this lecture you will learn about:

  • Creating table
  • Adding data to table
  • Adding rows/column to table
  • Adding total row
  • Rename table
  • Convert to range
Section 4: Performing Calculations on Data
03:00

In this lecture you will learn about:

  • Creating named range
  • Defining labels to named range
  • Managing Named range
10:52

In this lecture you will learn about:

  • Creating Formula
  • Using Insert Function
  • Sum, Average, Count, Max, Min, Now, PMT Functions
  • Using named range in formula
  • Using Autocomplete in formula
  • Copy-Paste a formula
05:07

In this lecture you will learn about important functions:

  • VLOOKUP
  • HLOOKUP
  • MATCH
  • INDEX
07:00

In this lecture you will learn about functions:

  • IF
  • AVERAGE, AVERAGEIF, AVERAGEIFS
  • COUNT, COUNTIF, COUNTIFS
  • And some other functions
02:28

Working with iterative calculation in case of circular reference.

04:03

In this lecture you will learn how to use array formula in case you have to perform multiple calculations in one cell.

04:14

Types of Errors:

  1. ###### Error
  2. #Name?
  3. #N/A
  4. #REF!
  5. #Value!
  6. #NUM!
  7. #DIV/0!
Section 5: Changing workbook appearance
03:14

Learn about different ways to format cells to change the appearance of data in your spreadsheet.

02:03

Learn about applying predefined formats to your data.

02:33

Excel 2013 comes with many themes installed, learn how to apply those themes to your data, applying Excel tables styles and how to create your own custom table style.

02:57

Learn hot to change the cell formatting for idiosyncratic data types such as dates, phone numbers, or currency values.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Yasmin Ansari, Data Analyst

Yasmin is a Data Analyst at Value Research India Pvt. Ltd., an investment research company. She is responsible for data modelling and then presenting data in charts and tables with the purpose of making conslusion from the data for decision making purposes. She has expertise in MS Excel, VBA, Access, MySQL and other softwares used for data analysis purposes. She is also a student member of Institute of Actuaries of India and cleared two papers. She is graduate in Bachelor of Business Studies from Jamia Millia Islamia, New Delhi. Yasmin is also planning to start a software training centre soon.

Ready to start learning?
Take This Course