Improve your efficiency - Master the Basics of Excel 2013
4.0 (4 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.
978 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Improve your efficiency - Master the Basics of Excel 2013 to your Wishlist.

Add to Wishlist

Improve your efficiency - Master the Basics of Excel 2013

Learn Basics of Excel step by step with practicing excercises and learning shortcuts.
4.0 (4 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.
978 students enrolled
Created by Yasmin Ansari
Last updated 11/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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...
View Curriculum
Requirements
  • You just need to have a working copy of Microsoft Excel 2013 and the willingness to learn about the magic of Excel
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.


Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
01:29:33
+
Intoduction
1 Lecture 02:03
+
Getting started with Excel 2013
5 Lectures 20:06

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
Preview 04:27

After completing this lecture you will be able to do:

  1. Customizing the ribbon
  2. Maximizing usable space in the program window
Preview 03:55

After completing this lecture you will be able to:

  • Save Workbook
  • Set values for your workbook’s built in properties
Creating Workbooks
02:57

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
Modifying Workbooks
03:17

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
Modifying Worksheets and Merging/Unmerging cells
05:30
+
Working with data and Excel tables
6 Lectures 19:53

Methods of Entering and revising data:

  • Auto Fill
  • Fill Series
  • Ctrl Key
  • Auto Complete
  • Pick from drop down list
  • Ctrl+Enter
Entering and revising data
05:11

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

Managing data by using Flash Fill
02:03

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.

Moving data within a Workbook
02:47

Learn about find and replace feature in Excel

Finding and replacing data
03:47

In this lecture you will learn about:

  • Spelling Check
  • Adding new words to Custom Dictionary
  • Thesaurus
Correcting and expanding upon worksheet data
02:31

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
Defing Excel Tables
03:34
+
Performing Calculations on Data
7 Lectures 36:44

In this lecture you will learn about:

  • Creating named range
  • Defining labels to named range
  • Managing Named range
Naming groups of data
03:00

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
Creating formulas to calculate values
10:52

In this lecture you will learn about important functions:

  • VLOOKUP
  • HLOOKUP
  • MATCH
  • INDEX
Lookup and Reference Functions
05:07

In this lecture you will learn about functions:

  • IF
  • AVERAGE, AVERAGEIF, AVERAGEIFS
  • COUNT, COUNTIF, COUNTIFS
  • And some other functions
Summarizing data that meets specific conditions
07:00

Working with iterative calculation in case of circular reference.

Working with iterative calculation options and automatic workbook calculation
02:28

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

Using array formulas
04:03

Types of Errors:

  1. ###### Error
  2. #Name?
  3. #N/A
  4. #REF!
  5. #Value!
  6. #NUM!
  7. #DIV/0!
Finding and correcting errors in calculations
04:14
+
Changing workbook appearance
4 Lectures 10:47

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

Formatting Cells
03:14

Learn about applying predefined formats to your data.

Defining Styles
02:03

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.

Applying workbook themes and Excel table styles
02:33

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

Making numbers easier to read
02:57
About the Instructor
Yasmin Ansari
4.0 Average rating
3 Reviews
978 Students
1 Course
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.