Advanced Excel 2013 Training + Build a Pro Excel Template

In this lecture, I’m going to introduce you with the new features of Excel. The new features are:

1. The Magic Tool Flash Fill
2. Quick Analysis Tool
3. Recommended Charts Tool
4. Slicer with Excel Tables
5. Microsoft OneDrive
6. Embedding Worksheet in a Web Page
7. Power Map to show data in 3-D
8. New Functions in Excel 2013
9. And Separate Window for each open Workbook

In this lecture, you will learn:

1. How you can create an Excel workbook from nothing.
2. How you can rename the workbook.
3. In this lecture, I have introduced you with the different file extensions of Excel.
4. And finally I have showed you how you can show the file extensions in the Windows file system.

In this video, I will introduce you with the Excel User Interface. This is the first part of two lectures. In this lecture, you will learn:

1. How to create an Excel workbook with different number of worksheets
2. How to rename or delete worksheets
3. You will be introduced with the worksheet cells and their naming system
4. You will see that a worksheet has an invisible layer that holds Charts, Shapes and Pictures
5. And you will be introduced with the Chart Sheets of Excel.

This is the second part of the last video of introducing you with the Excel User Interface.

1. In this lecture, you will be introduced with the different parts of an Excel workbook.
2. To work in Excel environment, it is important to know all the icons and controls in an Excel workbook.

In this lecture, you will learn:

1. How to create a Microsoft Account using your any Existing email address.
2. How to create documents in OneDrive.
3. How to upload files from your computer to OneDrive.
4. You will work with so many options with the Files in the OneDrive like:
   
   1. Downloading file from OneDrive to your Local computer
   2. Sharing files in Email
   3. Sharing files in Facebook or other social network
   4. Embedding worksheets in a blog or in a webpage.
5. And so many topics.

In this lecture:

1. You will learn how to add, delete and rearrange commands in the Quick Access Toolbar
2. You will learn about Contextual Tabs
3. You will learn how to add contextual tab’s commands in the Quick Access Toolbar
4. You will learn how to reset Quick Access Toolbar to default
5. And you will know how you can add commands in the Quick Access Toolbar for only a specific workbook.

In this lecture, you will learn:

1. How to create an Excel workbook from an existing workbook
2. How to save a workbook using Save As and Save commands
3. And how to change the default Saving place for Excel workbook.

In this lecture, you will learn:

1. How you can open an Excel Workbook from your computer
2. How to save the open workbook using Save or Save As commands
3. And other features of Open window pane.

Here you will get a workbook where I have included practice problems related to Section 1 and Section 2.

In this lecture, you will learn:

1. How to make a worksheet cell active.
2. How to navigate through a worksheet using Mouse.
3. How to use the horizontal and vertical scroll bar effectively.
4. How to navigate fast and navigate slow.
5. How to use the Mouse Wheel to navigate through a worksheet.
6. How to use Name Box to select a cell.

In this lecture, you will learn:

1. How to Navigate from one worksheet to another using Keyboard.
2. How to use Navigational Keys to move from one cell to other.
3. Using Page Down, Page Up, CTRL + Page Down, CTRL + Page Up key, Home key and CTRL + Home key combination to navigate the worksheet and worksheet cells.
4. How to use CTRL and Arrow Keys to navigate from one range to another range.
5. And finally how to use the “Go To” dialog box to navigate from one cell to another.

In this lecture:

1. You will learn how to Hide and Display Excel Ribbon,
2. You will be introduced with the different commands in different Excel Ribbons,
3. And you will learn how to show Developer Tab in the workbook.

In this lecture:

1. You will see what happens when Excel Workbook are made small,
2. You will learn how to Enable Touch/ Mouse Mode,
3. You will learn details about contextual tabs,
4. And you will get introduced with different command buttons like: Simple button, Toggle button, Simple Drop Down Button, Split Button, Check Box Controls, Spinners and Dialog Box Launcher Control.

In this lecture:

1. You will learn how you can execute a command using keyboard,
2. And how you can navigate the Ribbon using keyboard.

In this video lecture, you will learn:

1. How you can add and delete a customized tab from the tab list
2. How you can customize a built-in tab
3. And how you can customize a group of commands in the built-in tab or in the custom tab.

In this lecture:

1. You will learn the four ways to add worksheets in a workbook.
2. And you will learn the four ways to delete worksheets from a workbook.

Topics covered in this lecture

1. In this video tutorial, you will learn the rules that you must follow to Rename a worksheet.
2. You will also know that you can Rename a worksheet in two ways.
3. You will know how to Rearrange or Move a worksheet tab from one place to another.
4. You will know how to Move a worksheet from one workbook to another workbook.
5. And finally you will know how to make a Copy of a worksheet.

Topics covered in this lecture

1. You will learn about two types of Dialog box: Typical Dialog Box and Stay-on-Top Dialog Box.
2. And you will learn how to navigate a dialog box using keyboard.

Topics covered in this Excel training video

1. You will learn how to present a number in scientific notation.
2. You will learn about number precision.
3. You will know about the highest and lowest number Excel can use.
4. And finally you will learn how Excel uses number precision not to show more than 15 digits.

Topics covered in this video lecture

1. You will learn about 3 types of Data Excel can handle.
2. And you will learn about how those data are aligned in the worksheet cells differently.

Topics covered in this video lecture

1. You will learn total 4 ways you can use to enter data in an Excel cell.
2. You will learn how to Cancel data when you are typing data into a cell.
3. And you will learn how to enter negative numbers into excel cells.

Topics covered in this video lecture

1. In this lecture, you will learn about Excel Date and Time System in details.
2. And you will learn how to enter Date and Time into an Excel cell.

Topics covered in this lecture

1. In this lecture, you will learn only one topic: How to Enter a number as a text in a worksheet cell.

Topics covered in this lecture

1. In this lecture, you will learn how to delete the contents of a cell and how to clear the formatting of a cell.
2. You will learn how to use the six commands in the Clear Drop down in the Editing Group.
3. You will learn how to use Copy, Cut and Paste options in Excel.
4. And you will learn how to Edit cell contents.

Topics covered in this lecture

1. You will learn how to Undo and Redo your actions in Excel.
2. You will see how you can Undo and Redo more than one action at a time
3. You will learn how to Undo and Redo for more than one open workbooks.

Topics covered in this lecture

1. In this video tutorial, you will learn how to use the Auto Fill Handle Tool Effectively.
2. You will also learn how to make your own Auto Fill List.
3. And you will learn how you can disable the Auto Fill Handle Tool.

Here you will get a workbook where I have included practice problems related to Section 3 and Section 4.

Topics covered in this lecture

1. In this lecture, you will learn multiple ways to select a range.
2. You will learn how to select a big range.
3. And you will learn how to select non-contagious cell ranges.

Topics covered in this lecture

1. In this video tutorial, you will learn how to Group contagious worksheet tabs, non-contagious worksheet tab and how to select all the worksheet tabs to make a Group.
2. You will learn how to format or enter data in multiple worksheet tabs.
3. And you will learn how to ungroup the worksheets that are in a Group.

Topics you will learn in this Excel training video.

1. In this lecture, you will learn how to find out the cells that have:
   1. Comments
   2. 4 types of Constants such as: Numbers, Text, Logical, and Errors.
   3. Formulas, Formulas are also 4 types: Number Generating Formulas, Text Generating Formulas, Logical Generating Formulas and Error Generating Formulas.
   4. Then you can find out Blank Spaces in the active zone of the worksheet.
   5. Current Region
   6. Current Array
   7. Objects
   8. Row Differences
   9. Column Differences
   10. Two types of Precedents: Direct Only and All Levels.
   11. Two Types of Dependents: Direct Only and All Levels.
   12. Last active cell in a worksheet.
   13. You can find out Visible Cells Only.
   14. You can find out all and same types of Conditional Formatting.
   15. And finally you can find out All data validation and Same type of Data Validation.
2. And you will be introduced with the following topics:
   1. Row and Column Differences Basic.
   2. What are Precedents and Dependents and their types?
   3. Outlining Worksheet, How to use Conditional formatting and Data Validation in cells.

Topics you will learn in this Excel training video.

1. In this lecture, you will learn how to find out the cells that have:
   1. Comments
   2. 4 types of Constants such as: Numbers, Text, Logical, and Errors.
   3. Formulas, Formulas are also 4 types: Number Generating Formulas, Text Generating Formulas, Logical Generating Formulas and Error Generating Formulas.
   4. Then you can find out Blank Spaces in the active zone of the worksheet.
   5. Current Region
   6. Current Array
   7. Objects
   8. Row Differences
   9. Column Differences
   10. Two types of Precedents: Direct Only and All Levels.
   11. Two Types of Dependents: Direct Only and All Levels.
   12. Last active cell in a worksheet.
   13. You can find out Visible Cells Only.
   14. You can find out all and same types of Conditional Formatting.
   15. And finally you can find out All data validation and Same type of Data Validation.
2. And you will be introduced with the following topics:
   1. Row and Column Differences Basic.
   2. What are Precedents and Dependents and their types?
   3. Outlining Worksheet, How to use Conditional formatting and Data Validation in cells.

Topics covered in this lecture

1. In this video tutorial, you will learn the 3 ways to Copy a cell or a range.
2. You will learn 3 ways to Cut a cell or a range.
3. You will learn 4 ways to Paste copied or cut cell content.
   
4. You will learn that you can’t copy or cut non-contagious cells or ranges.
   
5. You will learn how to work with Clipboard Pane.
   
6. In essence, in this video tutorial, you will learn How to Copy, How to Cut and How to Paste like a professional Excel user.
   

Topics Covered in this Lecture

1. In this video tutorial, you will learn how to Cut, Copy and Paste using Dragging and Dropping System.
2. And you will learn how to Copy, Cut and Paste from one worksheet to another worksheet and even in another workbook.

Topics covered in this Lecture

1. In this lecture, you will learn how to insert a new column or a new row between two columns or two rows.
2. You will also learn how you can enter more than one column or more than one row between two columns or two rows.
3. And finally you will learn how to delete a cell.

Topics covered in this lecture

1. In this video tutorial, you will learn how you can increase or decrease the Column Width and Row Height.
2. You will learn how you can auto-fit column width and row height.
3. And you will also learn how to use the Cell Size commands in the Format drop down.

Topics covered in this lecture

1. In this lecture, you will learn how to Hide a Row or a Column in multiple ways.
2. You will also learn how to unhide a Row or a Column in more than one way.

Topics covered in this lecture

1. In this video tutorial, you will learn how to Find a content in a worksheet or in a workbook.
2. You will learn how to filter your searching in Excel in 5 ways.
3. You will also learn how to find a content using cell format.
4. And finally you will learn how to Replace cell contents with something else.

Topics covered in this lecture

1. In this lecture, you will learn how to Create, Edit and Delete Name Ranges.
2. You will learn how to Use Named Ranges.
3. And finally you will learn how to use Named Ranges in Formulas.

Topics covered in this lecture

• In this lecture, you will learn in details how to add comments to a worksheet cell.

In this lecture:

1. You will learn, how to activate a workbook rather than the “Activated” one.
2. You will learn Four ways to travel from one workbook to another when you have more than one workbooks open:
   
   1. Two ways are using keyboard shortcuts.
   2. Third way is using the workbook list under “Switch Windows”.
   3. And the last way is clicking on the Excel icons on the Windows Task bar.
3. You will learn how to arrange the workbooks in a single screen using the four commands under “Arrange Windows” dialog box. The commands are:
   
   1. Tiled
   2. Horizontal
   3. Vertical
   4. Cascade
4. You will also learn how to scroll two workbooks at a time.

In this lecture:

1. You will learn how to view two different worksheets of the same workbook simultaneously using the “New Window” command.
2. You will learn how to split a worksheet into panes.
3. You will also learn how to Freeze the first row, first column and even a zone.

In this lecture:

1. You will learn in two ways you can hide one or more than one worksheet.
2. You will learn in two ways you can unhide one or more than one worksheet.
3. You will also learn that you cannot hide all the worksheets in a workbook.

In this lecture:

1. You will learn how to watch some cells of your worksheet all the time using the “Watch Window” task pane.
2. You will learn how to “Add” and “Delete” cells to the “Watch Window” task pane.
3. You will also learn how to work with the options in the “Watch Window” task pane.

Here you will get a workbook where I have included practice problems related to Section 5 and Section 6.

Topics covered in this lecture

1. In this video tutorial, you will learn about the basics of a table.
2. You will learn how to create a table.
3. You will learn the differences between a table and a range.

Topics covered in this lecture

1. In this video tutorial, you will learn how to Insert and Delete columns and rows in a table.
2. You will also learn how to add Total Row in a table and how to work with the Total Row.

In this video lecture, you will learn basically two topics:

1. How to highlight duplicate values from a table or a range.
2. And how to remove duplicate values from a table or a range.

1. In this video tutorial, you will learn how to Sort a Single Column or Multiple Columns of a Table.
2. You will also Learn how to Filter a Column or Multiple Columns of a Table.
3. And finally you will be introduced with the Custom Auto-filter dialog box that you can use to Filter more options.

1. In this video tutorial, you will learn how you can Insert Slicer to Filter a Table.
2. You will learn how to Delete a Slicer.
3. You will also learn how you can Remove Filtering from a Slicer.
4. And you will be introduced with different Slicer Settings.

1. In this lecture, you will see how you can format a worksheet within 3-4 minutes.
2. You will learn about different tools that you can use to format a worksheet.
3. And you will be introduced with the Mini Toolbar and Format Cells dialog box.

In this video lecture, you will learn:

1. How to change the Font of a cell content and increase or decrease the Font Size.
2. How to Bold, Italicize, and Underline a cell content,
3. How to apply Strike through, Superscript and Subscript effects on a cell content
4. And how to change the color of a cell.

In this video lecture,

• You will learn all the ways you can align text into an Excel cell.

In this video lecture,

1. You will work with borders.
2. You will learn how to use borders around Excel cells.

In this video lecture,

1. You will learn multiple ways to format numbers in Excel.

This is Part 1 of Creating and Using Custom Number Formatting.

In the Part 1 and Part 2 video lectures,

1. You will learn how to use and create custom number formats.

This is Part 2 of Creating and Using Custom Number Formatting.

In the Part 1 and Part 2 video lectures,

1. You will learn how to use and create custom number formats.

In this video lecture,

• You will learn how to use and create custom number formats with around 100 examples.

In this video lecture,

• You will learn how to use and create custom number formats with around 100 examples.

Understanding Dates and Times system in Excel is important thing. In this video, you will learn how to format Excel's data and time format. Excel dates system has a bug if you use the 1900 Dates System. It is also discussed in this lecture.

Adding background image gives your worksheet a professional look. Even you can use your company logo as the background image of your worksheet. That brands your worksheet. When you will create PDF from your worksheet, the background image will be used as the watermark.

In this video lecture, you will learn how to add and delete background image from a worksheet.

The most important formatting tool that I use frequently is this Tool: Format Painter Tool. When you have already done some formatting in part of a worksheet, it is useless and a dumb policy to do the same formatting again in another part of the worksheet. You just use the Format Painter Tool.

In this video lecture, you will learn how to use the Format Painter tool effectively.

Themes change the overall workbook. It formats a workbook newly. You can brand your style of worksheet presentation with a theme that goes with your personality.

In this Excel training:

1. You will learn how to use built-in Excel themes for your workbook.
2. You will also learn how to create a customized theme for your workbook.

Clearing Cell contents and clearing cell contents is not the same thing. In this Excel training video, you will learn the differences between these two things.

Here you will get a workbook where I have included practice problems related to Section 7 and Section 8.

The most important thing now a days is data. And most of the small companies store data in Excel worksheet. So it is a big question where to save the important Excel workbooks. In this lecture, I have showed you some storing places and their pros and cons. Select one that is affordable to you.

In this video lecture,

1. You will learn about how protected view feature protects your Excel files from malwares.

If you are working for a small business or a Fortune 500 companies, you might work with the same Excel workbook daily. And you might want that when you will open the Excel program, the files will be opened automatically.

In this Excel video, you will learn how to open an Excel file automatically.

In this video lecture, you will learn:

1. How to add document properties to an Excel file
2. And how to organize Excel files using their document properties.

In this video lecture, you will learn two important Excel features:

1. One is how to inspect your document using Document Inspector dialog box
2. And another one is how to fix errors and warnings of your Excel workbook using Accessibility Checker task pane.

In this video lecture,

• You will learn how to check compatibility issues of your workbook with the older versions of Excel.

Here you will get a workbook where I have included practice problems related to Section 9.

You have to print your worksheet, when you will submit report to your boss. So you have to learn well how to print a worksheet. This lecture will given an idea where you will get the printing options in Excel.

In this video lecture,

• You will learn how to use the Page Layout and Page Break Preview tools to get a better print out.

In this video lecture,

1. You will learn how to print titles in every page
2. You will also learn how to print an area only from the whole worksheet.

In this video lecture,

• You will work with the commands in the Page Layout ribbon. The commands will be from basically three groups:
  
  • Page Setup
  • Scale to Fit
  • And Sheet Options.

In this video lecture,

• You will learn how to use the Page Breaks commands effectively.

In this video lecture,

• You will learn how to use a watermark in your print out.

In this video lecture,

• You will learn how to set header and footer section in your worksheet.

In this video lecture,

• You will learn how to copy print settings from one worksheet to another worksheets in the same workbook.

In this video lecture, you will learn:

1. How to prevent cells from being printed
2. And how to prevent objects from being printed.

In this video lecture,

• You will learn how to create different views for your worksheet.

In this video lecture,

1. You will learn how to create a PDF from an Excel worksheet.

In this video lecture,

• You will learn how to spell check your worksheet before printing.

In this video lecture,

• You will learn how to work with the options of Print Pane.