Microsoft Excel 2013 Simplified
4.0 (6 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.
208 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 Simplified to your Wishlist.

Add to Wishlist

Microsoft Excel 2013 Simplified

Learn Excel 2013 from Excel 2013 tutorial for beginners and advance to next level. Simple and easy to understand
4.0 (6 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.
208 students enrolled
Last updated 4/2013
English
Current price: $10 Original price: $50 Discount: 80% off
11 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description
In this Excel For beginners course, you shall learn how to use Microsoft Excel 2013 from qualified instructors at Quant Master Academy   The Excel 2013 tutorial course is aimed at introducing you to Excel and take it to next advanced level. You shall be learning from very basic of how to create your worksheet. And then slowly we will be introducing advanced topics in excel like advanced formulas, sorting and filtering data in excel. You shall also be learning how to use SkyDrive and collaborate with other people in developing Excel Workbook.

 By the end of the Excel 2013 tutorial course, you shall be very comfortable in using Excel with a lot of ease. We shall be introducing lot of keyboard shortcuts as well to increase efficiency while working with Excel.

Take this Excel for beginners/intermediary course right now and learn Excel 2013.



Most of the functionality taught in this course is valid for Microsoft Excel 2007 and 2010 as well.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 110 Lectures Collapse All 110 Lectures 09:01:23
+
Starting with Excel Workbook
7 Lectures 23:25


In this video you shall learn how to create a new Excel Workbook. You will also learn keyboard shortcuts to create a new file.
Preview 01:43

In this tutorial you shall learn, once you enter data in excel, how to save that file for future reference. Also we shall show keyboard shortcuts and quick access toolbar shortcuts for saving file.
Preview 03:07

In this Video you shall learn how to open an existing File in Excel and you will also see that if you are already working on the workbook and if you want to open another file then you can go through this video.
Preview 03:17

You shall see in this video that how to save a file other than Excel File like PDF, CSV, Excel 97-2003 and many more formats after you go through this video briefly.
Preview 03:11

So with the help of this tutorial you shall see how to navigate throught a workbook. You will also learn the keyboard shortcut to navigate throughout the workbook.
Preview 01:11
+
Data in Excel
11 Lectures 01:09:44
So in this video you shall learn how to add text and numbers to an excel spreed sheet in two ways.
Entering Text and Numbers in Excel
03:47

By default, you can edit the contents of a cell directly in the cell. You can also edit the contents of a cell in the formula bar as well. This video show the methods to edit cell contents.
Editing the contents of cells
02:00

In this video you shall see how you can enter numbers as text in Excel.
Entering Numbers as Text
05:22

Copy and Paste is the most used functionality in Excel. This video shows how to use these commands in Excel. It also shows keyboard shortcuts to do copy and paste.
Copy and Paste in Excel
06:01

In this video you will learn how to use keyboard shortcuts to select data. Keyboard shortcuts are very useful when dealing with large data in excel.
Preview 06:05

This Video will help you to Undo, Redo and repeat Action you have performed in Excel. You will also learn keyboard shortcuts for that in Excel.
Preview 07:13

Basically in this video you will learn how to resize your table rows and columns manually using mouse. It will also show how to adjust the column width and row height by using auto fit option.
Altering Row Height and Column Width
07:55

You shall learn about inserting cells, rows and columns in this video.
Insert and Delete - Rows and Columns
10:40

Sensitive or unwanted information can be hidden in excel. This video will show you how to hide and unhide rows and columns in excel. 
Hide and Unhide Rows and Columns
06:12

Excel provides a very useful function to extend/copy data or fill the series. This video will show various ways to fill the series in excel. 
Excel FILL Option
06:17

You can easily search for a particular value in excel. Newer version of excel allows to specify formatting along with data to search for a value. This video will show ways to search data in excel.
Searching for values in Excel
08:12
+
Working with Excel Worksheets
5 Lectures 18:02
In this video you will learn how to insert a new worksheet in Excel. It also shows how to delete an existing worksheet.
Insert and Delete Worksheets
04:41

In this Video you will get a detail understanding about how to move and copy worksheets within and between workbooks.
Moving and Copying worksheets within and between workbooks
04:06

In this Tutorial you will come across how to Hide and Unhide worksheets which is a very simple way to protect your data, or just a way to reduce some sheet tabs.
Hide and Unhide Worksheets
02:45

In this video you will learn ways to display multiple worksheets of the same file side by side. This is very useful when comparing data present in two worksheets.
Preview 03:34

In this video you shall learn about how to view two worksheets from different file for comparison purpose.
Preview 02:56
+
Formatting Excel Workbooks
12 Lectures 01:01:57
In this Tutorial you will see how to format the fonts and text we enter into the cell. This Video will also give you the idea as in how to change the font size, font face, font color using the command in the font group.
Formatting Fonts in Excel (Part 1)
06:32

So when you view this video you will learn to change font styles and apply subscript, superscript and strike-through effects.
Formatting Fonts in Excel (Part 2)
05:06

In this you will learn how to merge and unmerge cells in Microsoft Excel.
Merging Cells
05:07

After you go through this video you will learn number formatting in excel spreadsheet which will be used to change the appearance of the numbers in the cells of the spreadsheet.
Number Formatting in Excel
06:40

In this tutorial you shall learn predefined Date and Time formatting available in Excel.
Date and Time Formatting in Excel
06:58

This video will show you how to use different horizontal and vertical text aligning options. It will also show how to change text direction/orientation in excel.
Alignment and Orientation of Text
06:01

In this Video you will learn how to Increase indentation and Decrease indentation in Excel 2013 which will be used to enhance the apperence of the table data by indenting the text in Excel.
Text Indentation in Excel
02:11

This Tutorial covers how to use Excel's wrap text Feature to type on multiple lines in single cell in Excel.
Wrap Text in Excel
02:02

In this video you shall learn about how to apply borders to cells and cell ranges. You will also see how to use different types of lines and colors in Excel.
Applying Borders to Cells
08:36

In this Video you will see how to clear contents and format of the cell in Excel.
Clearing Cell Contents and Formatting in Excel
04:03

This video will allow you to quickly copy formatting from one cell or group of cells to another part of the worksheet and you can easily apply the same formatting.
Format Painter in Excel
05:19

In this tutorial  you will see how to apply built in themes in Excel workbook or customize themes in Excel.
Themes in Excel
03:22
+
Templates in Excel
2 Lectures 07:35
In this tutorial you will see how to create a custom tempate in excel and save the custom template.
Creating a Custom Template
03:42

This video lecture shows how to create a new workbook from existing template. We can use predefined template or search online as well.
Creating a New Workbook from a template
03:53
+
Formulas and Functions in Excel to do calculation
12 Lectures 01:05:22
This video will introduce basic mathematical operation in excel. It will also show cell referencing and how can it be used in formulas.
Cell Referencing and Basic Mathematical Calculation
08:11

In this tutorial we will show you some more mathematical operators that can be used in excel formula. We also show order of evaluation for mathematical operators.
Mathematical Operation and Order of Calculation
06:13

This video introduces excel functions. In this you shall learn how to write SUM function in excel. SUM function is used to calculate total/sum of multiple numeric values.
Excel SUM Function
04:53

COUNT function in excel is used to count number of cells having numeric values in specified cell range. This video will also shows one more variant COUNTA function in excel.
COUNTing Function in Excel
05:26

From this Tutorial you will learn that Excel's AVERAGE function can be used to find the average value, or arithmetic mean, of values in a selected range of cells.
AVERAGE Function in Excel
05:31

Through this simple Video you will see how Excel 2013 functions can easily find out the maximum and minimum value in the spreadsheet.
Finding Minimum and Maximum Values
04:54

In this Video you will see how to copy a formula from one place to another and Excel will readjust the references to reflect the relative change in the cells. 
Copy Formulas and Function in Excel
04:06

This Video will show you how to move relative referancing formulas.
Move Relative Reference Formula in Excel
03:02

This video will show you how to display formulas in excel.
Show Formulas in Excel
01:55

Till now we have seen relative referencing formulas. This video will teach you how to write absolute referencing formulas in excel. It will also show keyboard shortcut to convert relative referencing to absolute referencing.
Absolute Referencing in Excel
05:08

This Video uses Mixed Cell References in Excel Formulas and use cell references that is  combination of relative and absolute cell referencing in excel.
Mix of Absolute and Relative Referencing in Excel
10:53

In this Video you will see how  Excel formula can refere a cell or a cell range in different worksheets of the same file.
Formulas and Functions Cell Referencing Across Worksheets
05:10
+
Advanced Formulas in Excel
12 Lectures 01:28:29
In this video you learn how to evaluate different results based on outcome of a condition. We can use IF formula to do this.
IF Function in Excel
06:38

In this video you will learn how to return a value you specify if a formula returns an error ; otherwise, returns the result of the formula in  IFERROR Function.
IFERROR Function in Excel
03:16

In this Video you will come across different Logical Function for e.g AND, OR, NOT,which can be used to evaluate combination of more than one condition.
Logical Function in Excel
07:30

With the help of this tutorial you will learn how to use the Logical function in IF condition.
Logical Function in IF Conditions
08:07

In this video you will learn how to Sum the cell ranges, count the number fo cell ranges in that data and find the average of those cell in the worksheet  based on more than one condition .
Preview 08:49

In this Video you will learn Excel's Date and Time Functions which can be used to add the current date, the current time, or the day of the week to a spreadsheet. It can also be used to retrive different parts (Day, Month, Year, Hour, Minute, Second) from date and time value.
Date and Time Functions in Excel
11:53

In the First part of the Video you will learn how to manipulate text function in excel. That is how to use the CONCATENATE function, LEN function and LEFT, RIGHT and MID. Function in excel.
Text Functions in Excel Part 1 - CONCATENATE, LEN, LEFT, MID, RIGHT
07:11

In the Second part of the text function Video you will learn how to use the LOWER, UPPER & PROPER Function to change case of text and how to use the TRIM Function to remove leading and lagging spaces in Excel.
Text Functions in Excel Part 2 - LOWER, UPPER, PROPER, TRIM
05:53

In the Third Part of the video you will learn how to use the FIND and SEARCH Function to search any characters or text within the worksheet. And SUBSTITUTE Function in Excel to replace part of the text with another text  .
Text Functions in Excel Part 3 - SEARCH, FIND, SUBSTITUTE
07:24

In this Tutorial you will learn how to give Rank to a particular value from a list of values.
RANK Function in Excel
03:17

In this video you will learn how to define a name refering to a single cell or cell range. This name can be used in formulas and functions to specify cell range.
Preview 11:25

In this Video you will learn 3D referencing formula in excel.
3D Referencing Formulas in Excel
07:06
+
Conditional Formatting in Excel
7 Lectures 35:43
In this Particular Video you shall see how to use conditional formatting in excel which helps you to highlight the cells meeting certain condition and criteria.
Applying Conditional Formatting
10:31

In this video you will learn to edit and delete rules from conditional formatting.
Editing and Removing Rules from Conditional Formatting
05:44

Conditional formatting in Excel can be used to apply different icons to cells based on where they lie within a cell range.
Highlight Unique and Duplicate Values using Conditional Formatting
03:07

Highlight Top and Bottom values using Conditional Formatting
05:42

 This Video will give you an opportunity to create visual effects in your data to see how the value of a cell compares with the values in a range of cells with the help of color scales in Excel.
Using Color Scales in Conditional Formatting
03:31

This video will give you the Idea as in how to use the data Bars which will give you the comparesion of cell ranges in Excel.
Using Data Bars with Conditional Formatting
02:34

Conditional formatting in Excel can be used to apply different icons to cells based on where they lie within a cell range.
Applying Icon Sets in Conditional Formatting
04:34
+
Excel Page Setup and Printing
9 Lectures 40:28
In this Video users can learn to activate Print preview mode and use functionality such as zoom in, zoom out and setup pages etc.
Print Preview in Excel
04:12

From this Video you will Learn what a header and footer is, and where it is located in Excel 2013. And then add the date, time, page numbers, filename or any other text to a header or footer.
Inserting Header and Footer
04:32

With the help of this video you will be able to specify a different header or footer for odd and even pages or use a different header or footer for the first page.
Different Headers and Footers for First, Odd and Even Pages
06:43

In this Video you will learn how to set a print area for a range of cells so only those cells are printed.print area for those cells.
Set Print Area
02:58

In this tutorial you shall learn about Setting Excel page margins, specify custom margins, or center the worksheet horizontally or vertically on the page.
Margins in Excel
05:32

In this Video you will learn how to repeat specific rows or columns on every printed page.
Repeat Rows and Columns on each printed page
02:19

In this Video you will see how to Print gridlines and row and column headings which often makes it easier to read data.
Print Gridlines, Row Numbers and Column Headers
02:30

This video will show you different types of layouts that can be used while editing the worksheet.
Different Workbook Views - Normal, Page Layout and Page Break
09:10

In this Video you will learn how to change page Oritentation and size from Horizantal to vertical.
Change Page Orientation and Size in Excel
02:32
+
Advanced Data Handling Operations
7 Lectures 44:34
From this Tutorial you shall see how to use AutoFilter to filter data in a quick and easy way to find and work with a subset of data in a range of cells or table.
Filtering Data in Excel
07:52

This Video shall show you how to sort data in Excel 2013 by numbers, text, dates and colors.
Sorting in Excel
08:22

This Video will give you a chance to use the Text To Columns command on the Data menu to split data in multiple columns based on a delimeter.
Text to Columns in Excel
07:08

This tutorial shows you how to remove rows of duplicate data or records from an Excel database.
Remove Duplicate Values
02:26

Excel's Subtotal feature lets you find subtotals, average, max, and min values in a table of data.
Subtotals in Excel
03:47

In Excel 2013, lock or freeze rows or columns to keep them in view, or split panes in your worksheet that can scroll separately from each other.
Freezing Rows and Columns in Excel
08:49

Excel comments tutorial shows how to insert a comments, display or hide comments, format Excel comments and print Excel comments.
Comments in Excel
06:10
5 More Sections
About the Instructor
Quant Master  Academy
4.0 Average rating
6 Reviews
208 Students
1 Course
Entrepreneur at Quant Master Academy

At Quant Master Academy, we focus on providing high quality training in Quantitative Finance and Technology space. Our expert instructors makes learning very simple and easy. Our approach will always remain practical. We strongly focus on teaching things that will help people enhance their skills and apply them in practical use with ease. You can visit us at www.quantmaster.in