Excel Tutorial

Microsoft Excel Tutorial

Microsoft Excel (a.k.a MS Excel or Excel) is a spreadsheet application software developed by Microsoft and is a proud part of Microsoft Office Suite.

This product is widely used all across the globe for its flexibility and high support for mathematical, statistical and financial calculations. Professionals, around the world, highly recommend and use this product for their calculation-centric tasks.

MS Excel has taken over Lotus 1-2-3 which, in DOS times, was an ultimate spreadsheet tool and an industry standard. However, this all changed and MS Excel became the industry standard for spreadsheet software. Its high quality support for complex calculations, macro based programming, and smart elements, has distinct MS Excel in the line of spreadsheet applications.

Features of Microsoft Excel

Basic Operations

MS Excel has all the basic functions and features required for a spreadsheet software. It has a grid of cells arranged in rows and columns (where rows are numbered 1,2,3,… and columns are labeled with letters A,B,C,…) to manage data inputs and perform various functions and formulas to produce or acquire desired information in a desired manner.

Data Charts

MS Excel has a rich library for Data Chart. It supports almost all of the industry recognized data chart formats that includes Pie Charts, Bar Charts, Pivot Charts etc. MS Excel provides the flexibility to customize all the charts in terms of their color, labels, types etc. so that the user can produce the desired look.

Support for Macros

MS Excel is quite renowned for its support for Macros based solutions. Although Macros are supported in all products of MS Office suite however, this feature is quite extensively used in MS Excel.

Excel Tutorials

•  Important Terminologies in Microsoft Excel
•  Working with Rows, Columns and Cells in Excel
•  Working with Ranges in MS Excel
•  Formulas and Functions in MS Excel
•  Ribbon in MS Excel
•  Workbook in MS Excel
•  Formatting Cells in MS Excel
•  Templates in MS Excel
•  Data Validation in MS Excel
•  Excel Keyboard Shortcuts
•  Protecting a Workbook in MS Excel with Password
•  Print Gridlines in an Excel Worksheet
•  How to Share MS Excel Data
•  Count and Sum Function in Excel
•  Logical Functions in Excel
•  Date and Time Function in Excel
•  Worksheet in Excel
•  Find and Select in Excel
•  Cell References in Excel
•  Text Functions in Excel
•  VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE Function in Excel
•  The ROUND, ROUNDUP and ROUNDDOWN function in Excel
•  Statistical Function in Excel
•  Sort in Excel
•  Filter in Excel
•  Formula Errors in Excel
•  Array formulas in Excel
•  Financial Functions in Excel
•  Conditional Formatting in Excel
•  Clear Rules in Excel
•  Solver in MS Excel
•  Analysis ToolPak in Excel
•  Analysis ToolPak in Excel
•  Create a Macro in Excel
•  MsgBox in Excel
•  Charts in Excel
•  Pivot Table in Excel
•  Table in Excel
•  What if Analysis in Excel
•  Workbook and Worksheet Object in MS Excel
•  Excel VBA Range Object
•  MS Excel VBA Variable
•  Excel VBA Array
•  Excel VBA function and Sub
•  Excel VBA If Then Statement
•  Loop in Excel VBA
•  Excel VBA ActiveX Controls
•  Excel VBA Events
•  Macro Errors in MS Excel VBA
•  Excel VBA String Manipulation
•  Date and Time in MS Excel VBA
•  Application Object in Excel VBA

Excel Examples