Microsoft Excel 2013 Simplified

Learn Excel 2013 from Excel 2013 tutorial for beginners and advance to next level. Simple and easy to understand
7 reviews
TAUGHT BY
  • 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

WHAT'S INSIDE
  • Lifetime access to 110 lectures
  • 9+ hours of high quality content
  • A community of 100+ students learning together!
SHARE

Microsoft Excel 2013 Simplified

Learn Excel 2013 from Excel 2013 tutorial for beginners and advance to next level. Simple and easy to understand
7 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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.
    • Over 110 lectures and 9 hours of content!

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Starting with Excel Workbook
  • 1
    Introduction to Excel
    07:29
  • 2
    What will you learn in this course?
    03:27
  • 3
    Creating a New Workbook
    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.
  • 4
    Saving the 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.
  • 5
    Open an Existing Workbook
    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.
  • 6
    Saving File Other than in Excel (.xlsx) Format
    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.
  • 7
    Navigating around in Excel Workbook
    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
  • 8
    Entering Text and Numbers 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.
  • 9
    Editing the contents of cells
    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.
  • 10
    Entering Numbers as Text
    05:22
    In this video you shall see how you can enter numbers as text in Excel.
  • 11
    Copy and Paste 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.
  • 12
    Keyboard shortcuts for selecting cells
    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.
  • 13
    Undo, Redo or Repeat Action 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.
  • 14
    Altering Row Height and Column Width
    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.
  • 15
    Insert and Delete - Rows and Columns
    10:40
    You shall learn about inserting cells, rows and columns in this video.
  • 16
    Hide and Unhide Rows and Columns
    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. 
  • 17
    Excel FILL Option
    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. 
  • 18
    Searching for values 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
  • 19
    Insert and Delete 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.
  • 20
    Moving and Copying worksheets within and between workbooks
    04:06
    In this Video you will get a detail understanding about how to move and copy worksheets within and between workbooks.
  • 21
    Hide and Unhide Worksheets
    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.
  • 22
    View two worksheets in SAME file side by side
    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.
  • 23
    View two worksheets in DIFFERENT file side by side
    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
  • 24
    Formatting Fonts in Excel (Part 1)
    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.
  • 25
    Formatting Fonts in Excel (Part 2)
    05:06
    So when you view this video you will learn to change font styles and apply subscript, superscript and strike-through effects.
  • 26
    Merging Cells
    05:07
    In this you will learn how to merge and unmerge cells in Microsoft Excel.
  • 27
    Number Formatting in 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.
  • 28
    Date and Time Formatting in Excel
    06:58
    In this tutorial you shall learn predefined Date and Time formatting available in Excel.
  • 29
    Alignment and Orientation of Text
    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.
  • 30
    Text Indentation 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.
  • 31
    Wrap 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.
  • 32
    Applying Borders to Cells
    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.
  • 33
    Clearing Cell Contents and Formatting in Excel
    04:03
    In this Video you will see how to clear contents and format of the cell in Excel.
  • 34
    Format Painter 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.
  • 35
    Themes in Excel
    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
  • 36
    Creating a Custom Template
    03:42
    In this tutorial you will see how to create a custom tempate in excel and save the custom template.
  • 37
    Creating a New Workbook from a 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
  • 38
    Cell Referencing and Basic Mathematical 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.
  • 39
    Mathematical Operation and Order of Calculation
    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.
  • 40
    Excel SUM Function
    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.
  • 41
    COUNTing Function in Excel
    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.
  • 42
    AVERAGE 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.
  • 43
    Finding Minimum and Maximum Values
    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.
  • 44
    Copy Formulas and Function in Excel
    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. 
  • 45
    Move Relative Reference Formula in Excel
    03:02
    This Video will show you how to move relative referancing formulas.
  • 46
    Show Formulas in Excel
    01:55
    This video will show you how to display formulas in excel.
  • 47
    Absolute Referencing 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.
  • 48
    Mix of Absolute and Relative Referencing in Excel
    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.
  • 49
    Formulas and Functions Cell Referencing Across Worksheets
    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
  • 50
    IF Function 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.
  • 51
    IFERROR Function in Excel
    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.
  • 52
    Logical Function in Excel
    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.
  • 53
    Logical Function in IF Conditions
    08:07
    With the help of this tutorial you will learn how to use the Logical function in IF condition.
  • 54
    SUMIF(s), COUNTIF(s) and AVERAGEIF(s) Function in Excel
    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 .
  • 55
    Date and Time Functions in Excel
    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.
  • 56
    Text Functions in Excel Part 1 - CONCATENATE, LEN, LEFT, MID, RIGHT
    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.
  • 57
    Text Functions in Excel Part 2 - LOWER, UPPER, PROPER, TRIM
    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.
  • 58
    Text Functions in Excel Part 3 - SEARCH, FIND, SUBSTITUTE
    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  .
  • 59
    RANK Function in Excel
    03:17
    In this Tutorial you will learn how to give Rank to a particular value from a list of values.
  • 60
    Name Ranges and its use in Formulas
    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.
  • 61
    3D Referencing Formulas in Excel
    07:06
    In this Video you will learn 3D referencing formula in excel.
  • SECTION 8:
    Conditional Formatting in Excel
  • 62
    Applying Conditional Formatting
    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.
  • 63
    Editing and Removing Rules from Conditional Formatting
    05:44
    In this video you will learn to edit and delete rules from conditional formatting.
  • 64
    Highlight Unique and Duplicate Values using 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.
  • 65
    Highlight Top and Bottom values using Conditional Formatting
    05:42
  • 66
    Using Color Scales in Conditional Formatting
    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.
  • 67
    Using Data Bars with Conditional Formatting
    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.
  • 68
    Applying Icon Sets in Conditional Formatting
    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
  • 69
    Print Preview in Excel
    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.
  • 70
    Inserting Header and Footer
    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.
  • 71
    Different Headers and Footers for First, Odd and Even Pages
    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.
  • 72
    Set Print Area
    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.
  • 73
    Margins in Excel
    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.
  • 74
    Repeat Rows and Columns on each printed page
    02:19
    In this Video you will learn how to repeat specific rows or columns on every printed page.
  • 75
    Print Gridlines, Row Numbers and Column Headers
    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.
  • 76
    Different Workbook Views - Normal, Page Layout and Page Break
    09:10
    This video will show you different types of layouts that can be used while editing the worksheet.
  • 77
    Change Page Orientation and Size in Excel
    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
  • 78
    Filtering Data in Excel
    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.
  • 79
    Sorting in Excel
    08:22
    This Video shall show you how to sort data in Excel 2013 by numbers, text, dates and colors.
  • 80
    Text to Columns in Excel
    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.
  • 81
    Remove Duplicate Values
    02:26
    This tutorial shows you how to remove rows of duplicate data or records from an Excel database.
  • 82
    Subtotals in Excel
    03:47
    Excel's Subtotal feature lets you find subtotals, average, max, and min values in a table of data.
  • 83
    Freezing Rows and Columns in Excel
    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.
  • 84
    Comments in Excel
    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
  • 85
    Insert Charts in Excel
    02:14
    In this video you will learn how to add charts quickly in Excel.
  • 86
    Changing Chart Types 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.
  • 87
    Changing Chart Style and Layout
    02:15
    In this video you will learn how to apply different type of predefined chart styles and layouts in excel.
  • 88
    Add Chart Titles, Asix Titles and Data Labels 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.
  • 89
    Adding and Removing Axis and Gridlines
    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.
  • 90
    Changing Axis Scale in Excel Chart
    04:19
    This video will show you how can you change scale of vertical axis in a graph.
  • 91
    Adding a Trend Line in Excel chart
    01:47
    Excel allows adding a trend line in an excel chart. This video will show you how to do that.
  • 92
    Move chart into separate sheet
    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
  • 93
    Sign in to 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.
  • 94
    Creating a New Workbook from SkyDrive
    03:12
    In this video you will see how to create a new excel workbook from Windows SkyDrive.
  • 95
    Accessing and Editing Files using 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.
  • 96
    Manage Folders in SkyDrive
    02:33
    This video will show you how to manage folder hierarchy in Windows SkyDrive. 
  • 97
    Download and Delete Files from 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.
  • 98
    Sharing Files from 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
  • 99
    Insert Shapes 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.
  • 100
    Format Shapes in Excel
    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.

UDEMY BY THE NUMBERS

38,500,000
Hours of video content
8,500,000
Course Enrollments
3,500,000
Students

RATING

  • 2
  • 4
  • 1
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
7
  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: