Excel Tutorial

Excel can do much more than simply store numbers in rows and columns. It can help you organize information, work with formulas, analyze data, create charts, and complete everyday tasks faster. Once you understand the basics, many Excel features become much easier to use.

This Excel Tutorial brings together practical lessons to help you learn Excel at your own pace. You will find guides covering everything from creating and editing worksheets to using formulas, functions, formatting tools, data features, shortcuts, and other useful Excel options.

Whether you are opening Excel for the first time or looking to improve your existing skills, the topics below can help you learn useful techniques and become more comfortable working with Excel.

In this part of Excel tutorial, you will learn basics, use of templates, cell properties and how to password protect the file in Microsoft Excel.

In this part of Excel tutorial, you will learn the formatting which contains the formatting of font, numbers, borders, colors, alignment, conditional formatting and clipboard in Microsoft Excel.

In this part of Excel tutorial, you will learn the use of data which includes creating table, pivot-table, charts, sort, filter, what-if-analysis and much more in Microsoft Excel.

In this part of Excel tutorial, you will learn how to select objects, use of selection pane, go to, find and replace featues in Microsoft Excel.

In this part of Excel tutorial, you will learn how to do the review containing smart lookup, spell check, protect, comment, translate, hide ink etc in Microsoft Excel.

In this part of Excel tutorial, you will learn the different views such as normal view, page break view, custom views, zoom, show or hide gridline, formula bar, navigation, switch windows, record and view macros in Microsoft Excel.

In this part of Excel tutorial, you will learn the formulas and functions, error checking and fixing, define and manage name and calculation options in Microsoft Excel.

In this part of Excel tutorial, you will learn how to use the add-ins and keyboard shortcut keys in Microsoft Excel.