Advanced Excel 2013 Training + Build a Pro Excel Template

This MS Advanced Excel 2013 training course will teach you basic & advanced Excel online with a project & certification.
4.4 (14 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.
975 students enrolled
$19
$195
90% off
Take This Course
  • Lectures 200
  • Length 21.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

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.

About This Course

Published 10/2015 English

Course Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Do you seriously want to learn Microsoft Excel 2013 from scratch to advanced level, want to get employed by your local big companies and want to get up to 40% higher salary than the other employees in your company?

Then, DO NOT WASTE YOUR TIME and MONEY! Enroll into this most comprehensive Microsoft Excel 2013 training course.

The satisfaction with this course is guaranteed.

  • 30 Days FULL REFUND of your money is guaranteed if you are not satisfied with this course. If you really want to be a Pro user of Excel, just take this course. Nothing to lose. If you don't like the course, you will get FULL REFUND.
  • You will get LIFETIME ACCESS to this course. So, you will be able to re-take this course for unlimited times.

This course has some extra ordinary REVIEWS from students. Just check the review section at the end of the course.

----------------------------------------------------------------------------------------------------------------------------------------------------

How this Excel training course is designed for you:

  • Section 1: Welcome section. Course organization, get working files download link, and get new lectures and homework updates.
  • Section 2: Excel environment.
  • Section 3: Manage Excel workbook and worksheets
  • Section 4: Enter and edit data in a worksheet.
  • Section 5: Excel cells and ranges.
  • Section 6: Workbook and worksheet operations.
  • Section 7: Excel tables.
  • Section 8: Formatting worksheets.
  • Section 9: Advanced features related to Excel files.
  • Section 10: Excel templates.
  • Section 11: Setup and print Excel worksheets.
  • Section 12: Function and formula basics.
  • Section 13: Useful mathematical functions.
  • Section 14: Excel charts.
  • Section 15: Advanced formulas.
  • Section 16: Advanced chart techniques.
  • Section 17: Conditional formatting.
  • Section 18: Excel security.
  • Section 19: Graphic Objects.
  • Section 20: Data validation techniques in Excel.
  • Section 21: Excel as a database.
  • Section 22: Project: Build an Excel template from scratch.

----------------------------------------------------------------------------------------------------------------------------------------------------

By Enrolling into this course, you will be able to:

  • Learn Microsoft Excel 2013 from scratch to intermediate and advanced level.
  • Practice Excel problems regularly with new challenge. This course will provide you new new Excel problems in every week.
  • Get a very good job if you are about to graduate from university. Most of the businesses now a days use Excel heavily.
  • Increase your salary up to 40%. Search on Google with this query: "EXCEL USERS GET HIGHER SALARY". On average Excel users get 12% HIGHER SALARY.
  • Solve Excel problems with great efficiency.
  • Get solved your very own Excel problems. The instructor is a full-time Excel blogger. So, he loves to solve new problems in Excel.
  • Get prompt answers & support from the instructor within 24 hours!
  • Search any topic in Excel using the VIDEO INDEX DASHBOARD. Video Index Dashboard will help you to find out the relevant video number of a topic.
  • Get all the Excel related materials from one course. You will get 220+ Excel Keyboard Shortcuts PDF with this course.
  • Get downloadable Workbooks, Handouts and Materials during the course.
  • Enroll into another Excel course COMPLETELY FREE where you will build Excel related projects.

...want more? JOIN THE COURSE. Your any suggestion will be highly appreciated to make it the best Excel related course.

Join with over 917 successful students taking this course!!!

----------------------------------------------------------------------------------------------------------------------------------------------------

About the instructor of this course:

The instructor of this course has extensive experiences in Excel, Excel VBA and .NET frameworks:

  • The author of this course has a Computer Science and Engineering degree from the topmost university in his country.
  • He is a dedicated full-time Excel, Excel VBA and Business Analytic blogger.
  • He has a teaching experience of 18 years.
  • He learns new things in Excel, Excel VBA and Business Analytic regularly and shares free tutorial on his blog.
  • As a full-time Excel, Excel VBA and Business Analytic blogger, he will be here or on his blog with your every problem.
  • As a consultant in many Excel projects, he has vast knowledge on real-life Excel problems.

So, learn Excel from someone who loves Excel and Excel VBA, who lives with Excel and Excel VBA 365 days a year, who learns new things in Excel regularly, who runs a blog on Excel and who loves teaching.

----------------------------------------------------------------------------------------------------------------------------------------------------

What are the requirements?

  • Determination and dedication for learning this course from start to end.
  • Microsoft Excel 2013 Office Suite installed in a Computer.
  • An Internet Connection.

What am I going to get from this course?

  • You will learn Excel from the Scratch to Advanced Level to use it in your day to day job.
  • Wow your boss: Learn different Excel techniques from this course & make your boss wow.
  • Increase your salary up to 40%: You will be Pro-level Excel user and able to increase your salary up to 40%.
  • Build Excel Template: After finishing this course, you will be able to build professional Excel templates for any purpose.
  • Video Index: You can use this course as a video reference. Find any topic in Excel just searching our Video Index workbook.
  • This is not just a course. This is a long term learning process with probelm solving approach.

What is the target audience?

  • This Excel course is both for newbies who are not familiar with Excel, and for intermediate and advanced level Excel users looking for deep dive into Excel 2013.
  • If you consider yourself as a professional Excel user, this course is also for you.
  • If you are looking for a job, this course is mandatory for you as you will learn Excel from the very beginning.
  • This course is not for students who think they can learn Excel without practicing.

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: 01 Welcome to the Course! Be a Professional Excel User with this course!
02:24

What you will get from this Excel lecture:

  1. You will be welcomed to the course. The instructor of this course is thankful to you that you have enrolled into this course.
  2. You will know which versions of Microsoft Excel has been used to create this course. You will also get idea which versions you can use to follow this course.
  3. You will have an idea how to use this course to get the best from it.
Article

What you will get from this Excel lecture:

  1. This is the download section of the whole course. You will get all the working files, practice problems, Video Index Dashboard, Excel keyboard shortcuts PDF, and other Excel resources in one place.
  2. You will also get an idea how to instantly contact me when you face an Excel or Course related problem.
05:12
  1. You will see how to use the working files and other Excel resources the author has attached in the lecture above.
  2. For your ease of use, the working files and other Excel resources also have been attached with this lecture too.
Article
  1. You will get a list of websites where you can solve Excel related real life problems. If you cannot solve a problem, follow how other experts in the community solve that problem.
  2. Learn from trying to solve an Excel problem or learn from others who solve problems.
06:58

This video is actually about UDEMY platform. You will lea

  1. How to enter the course.
  2. How to use the platform to best view the course.
  3. There are several options in the platform. Without knowing them in details, you cannot expect to best use of the course.
Article
  1. Here you will get a list of Excel features so far the instructor has covered in this course.
  2. The more lectures will be added to the course time to time and on the basis on your demand.
02:40

In this video, you will see how you can get the certificate of your completion of the course.

Article

New lectures added to the course and homework updates will be announced here.

Section 2: 02 Getting Started with Excel
05:43

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
06:12

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.
06:18

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.
11:02

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.
11:53

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.
10:24

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.
06:14

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.
04:31

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

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

3 questions

Please take a look at the questions I have added to the quizzes. It will improve your learning.

Section 3: Managing Excel Workbooks & Worksheets Effectively
07:33

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.
09:50

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.
05:59

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.
09:18

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.
03:16

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.
14:11

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.
07:30

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.
10:24

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.
09:16

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.
3 questions

This quiz questions are for Section 3. Please take a look at the questions to improve your expertise in Excel.

Section 4: Entering & Editing Worksheet Data
06:19

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.
05:51

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.
10:21

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.
08:40

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.
04:29

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.
11:22

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.
06:30

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.
09:36

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

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

3 questions

This is quiz for Section 4. Try to answer the questions, it will improve your expertise in Excel.

Section 5: Working with Cells and Ranges
11:47

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.
07:44

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.
13:32

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.
09:04

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.
10:56

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.
06:44

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.
09:18

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.
07:42

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.
06:02

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.
07:16

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.
11:51

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.
10:11

Topics covered in this lecture

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

This is quiz for Section 5. Answer the questions. It will increase your expertise in Excel.

Section 6: Essential Workbook and Worksheet Operations
09:34

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.
07:45

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.
04:05

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.
06:00

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

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

Section 7: Introducing Excel Tables
06:42

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.
07:22

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.
06:12

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.
10:44
  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.
04:16
  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.
Section 8: Worksheet Formatting - Details Understanding
07:13
  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.
13:30

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.
16:25

In this video lecture,

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

In this video lecture,

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

In this video lecture,

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

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.
12:16

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.
12:41

In this video lecture,

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

In this video lecture,

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

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.

02:58

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.

04:41

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.

10:41

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.
05:48

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.

Article

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

Section 9: Excel Files - Advanced Features
06:19

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.

07:57

In this video lecture,

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

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.

07:22

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.
08:38

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.
05:11

In this video lecture,

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

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

Section 10: Page Setup and Printing Your Work
03:51

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.

07:36

In this video lecture,

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

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.
07:38

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.
05:16

In this video lecture,

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

In this video lecture,

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

In this video lecture,

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kawser Ahmed, Founder ExcelDemy.com | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

  • 1. Corporate Budgeting, Planning & Forecasting
  • 2. Mission-critical financial processes
  • 3. Month-end close processes
  • 4. Big Data Analysis using Excel
  • 5. Company Reports (Sales, Marketing, Administrative)
  • 6. Large Projects using Excel VBA
  • 7. Dashboard Design using Excel
  • 8. And Basic Accounting


I am always around you to help and support! 

Just knock me!

Ready to start learning?
Take This Course