Microsoft Excel 2013 Simplified

Learn Excel 2013 from Excel 2013 tutorial for beginners and advance to next level. Simple and easy to understand
  • Lectures 110
  • Video 10 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

Course 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.

What am I going to get from this course?

  • Over 110 lectures and 9 hours of content!

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: Starting with Excel Workbook
Introduction to Excel
Preview
07:29
What will you learn in this course?
Preview
03:27
01:43
In this video you shall learn how to create a new Excel Workbook. You will also learn keyboard shortcuts to create a new file.
03:07
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.
03:17
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.
03:11
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.
01: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.
Section 2: Data in Excel
03:47
So in this video you shall learn how to add text and numbers to an excel spreed sheet in two ways.
02:00
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.
05:22
In this video you shall see how you can enter numbers as text in Excel.
06:01
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.
06:05
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.
07:13
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.
07:55
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.
10:40
You shall learn about inserting cells, rows and columns in this video.
06:12
Sensitive or unwanted information can be hidden in excel. This video will show you how to hide and unhide rows and columns in excel. 
06:17
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. 
08:12
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.
Section 3: Working with Excel Worksheets
04:41
In this video you will learn how to insert a new worksheet in Excel. It also shows how to delete an existing worksheet.
04:06
In this Video you will get a detail understanding about how to move and copy worksheets within and between workbooks.
02:45
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.
03:34
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.
02:56
In this video you shall learn about how to view two worksheets from different file for comparison purpose.
Section 4: Formatting Excel Workbooks
06:32
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.
05:06
So when you view this video you will learn to change font styles and apply subscript, superscript and strike-through effects.
05:07
In this you will learn how to merge and unmerge cells in Microsoft Excel.
06:40
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.
06:58
In this tutorial you shall learn predefined Date and Time formatting available in Excel.
06:01
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.
02:11
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.
02:02
This Tutorial covers how to use Excel's wrap text Feature to type on multiple lines in single cell in Excel.
08:36
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.
04:03
In this Video you will see how to clear contents and format of the cell in Excel.
05:19
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.
03:22
In this tutorial  you will see how to apply built in themes in Excel workbook or customize themes in Excel.
Section 5: Templates in Excel
03:42
In this tutorial you will see how to create a custom tempate in excel and save the custom template.
03:53
This video lecture shows how to create a new workbook from existing template. We can use predefined template or search online as well.
Section 6: Formulas and Functions in Excel to do calculation
08:11
This video will introduce basic mathematical operation in excel. It will also show cell referencing and how can it be used in formulas.
06:13
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.
04:53
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.
05:26
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.
05:31
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.
04:54
Through this simple Video you will see how Excel 2013 functions can easily find out the maximum and minimum value in the spreadsheet.
04:06
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. 
03:02
This Video will show you how to move relative referancing formulas.
01:55
This video will show you how to display formulas in excel.
05:08
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.
10:53
This Video uses Mixed Cell References in Excel Formulas and use cell references that is  combination of relative and absolute cell referencing in excel.
05:10
In this Video you will see how  Excel formula can refere a cell or a cell range in different worksheets of the same file.
Section 7: Advanced Formulas in Excel
06:38
In this video you learn how to evaluate different results based on outcome of a condition. We can use IF formula to do this.
03:16
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.
07:30
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.
08:07
With the help of this tutorial you will learn how to use the Logical function in IF condition.
08:49
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 .
11:53
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.
07:11
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.
05:53
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.
07:24
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  .
03:17
In this Tutorial you will learn how to give Rank to a particular value from a list of values.
11:25
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.
07:06
In this Video you will learn 3D referencing formula in excel.
Section 8: Conditional Formatting in Excel
10:31
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.
05:44
In this video you will learn to edit and delete rules from conditional formatting.
03:07
Conditional formatting in Excel can be used to apply different icons to cells based on where they lie within a cell range.
Highlight Top and Bottom values using Conditional Formatting
05:42
03:31
 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.
02:34
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.
04:34
Conditional formatting in Excel can be used to apply different icons to cells based on where they lie within a cell range.
Section 9: Excel Page Setup and Printing
04:12
In this Video users can learn to activate Print preview mode and use functionality such as zoom in, zoom out and setup pages etc.
04:32
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.
06:43
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.
02:58
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.
05:32
In this tutorial you shall learn about Setting Excel page margins, specify custom margins, or center the worksheet horizontally or vertically on the page.
02:19
In this Video you will learn how to repeat specific rows or columns on every printed page.
02:30
In this Video you will see how to Print gridlines and row and column headings which often makes it easier to read data.
09:10
This video will show you different types of layouts that can be used while editing the worksheet.
02:32
In this Video you will learn how to change page Oritentation and size from Horizantal to vertical.
Section 10: Advanced Data Handling Operations
07:52
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.
08:22
This Video shall show you how to sort data in Excel 2013 by numbers, text, dates and colors.
07:08
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.
02:26
This tutorial shows you how to remove rows of duplicate data or records from an Excel database.
03:47
Excel's Subtotal feature lets you find subtotals, average, max, and min values in a table of data.
08:49
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.
06:10
Excel comments tutorial shows how to insert a comments, display or hide comments, format Excel comments and print Excel comments.
Section 11: Charts in Excel
02:14
In this video you will learn how to add charts quickly in Excel.
03:44
Excel allows different types of graphs and charts. This tutorial will show you once you insert a chart, how can you change it to another type later on.
02:15
In this video you will learn how to apply different type of predefined chart styles and layouts in excel.
04:14
This video will teach you how to add Chart Title, Horizontal and Vertical Axis titles and individual data labels in a excel chart.
02:43
In this tutorial you will see how to add and remove horizontal as well as vertical axis and grid lines in an excel chart.
04:19
This video will show you how can you change scale of vertical axis in a graph.
01:47
Excel allows adding a trend line in an excel chart. This video will show you how to do that.
01:52
When an excel chart is added, it is placed into existing worksheet. Sometimes you may want to move chart as a separate worksheet. This video will show you how to move existing graph into a new worksheet.
Section 12: Working with Windows SkyDrive
02:29
Windows SkyDrive allows you to manage your files and documents online. This video will show you how to log into your existing account or create a new account.
03:12
In this video you will see how to create a new excel workbook from Windows SkyDrive.
01:57
Once you create/upload excel file in Windows SkyDrive, you can access and edit it online. This video will show you how to open files in windows skydrive and edit it.
02:33
This video will show you how to manage folder hierarchy in Windows SkyDrive. 
02:10
This video will teach you how to download file on your desktop from Windows SkyDrive. It will also teach you how to delete files from windows skydrive.
03:13
Windows SkyDrive allows you to collaborate with people on single workbook. This video will show you how to share files from Windows SkyDrive with other people.
Section 13: Graphic Objects and SmartArt in Excel
03:53
There are many kinds of built in shapes, like basic geometric shapes, connector lines, banners and call outs etc.,  which can be added in Excel. This video will show you how to add those shapes in an existing worksheet.
04:28
There are various formatting option available for inserted shapes. This video will show you how to change color, borders and apply different kinds of fill effects to existing shapes.

Instructor Biography

Quant Master Academy , 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

Join the biggest student community

7,700,000

Hours of video content

28,000,000

Course Enrollments

7,500,000

Students

Reviews

Average Rating
4.1
Details
  1. 5 Stars
    2
  2. 4 Stars
    4
  3. 3 Stars
    1
  4. 2 Stars
    0
  5. 1 Stars
    0
Ready to start learning?
Preview this course