Excel Tutorial

MS Excel Basics

This section will introduce the basics of Excel, such as: Excel Window, Ribbon, Workbook, Worksheet, Cells, Templates, Data Validation, print ..etc.

1. Excel window

When you start the excel application, excel window will appear and this section will let you learn the various important parts of excel window.

2. Excel Ribbon

The Ribbon is the strip of buttons and icons located above the work area. and it is organized into various tabs, such as: File, Home,Insert, Page Layout, Formulas, Data, Review, and View. while clicking on a tab, you will saw all of program’s features and commands. this section will guide you how to customize the Ribbon.

3. Excel Workbook

The workbook is a file that contains one or more worksheets , by default, the excel will create a blank workbook that contains 3 worksheets. this section will guide you how to create a new workbook or open an existing workbook or close a workbook.

4. Excel Worksheet

When you open an new workbook or start excel application, it will create 3 new blank worksheets. this setion will explain you how to create/insert/delete/move/copy/rename a worksheet.

5. Excel Cells

A Cell can be used in a formula to hold differnt types of data like Numbers, Dates, Currency, Text.. this section will guide you how to format cells /set the cell type/create or change a cell reference…

6. Excel Rows

How do I insert a new row in excel? How do I delete a row in excel? How to delete multiple rows in Excel workbook? How to hide a row from being displayed in excel? How to unhide the hidden rows in excel? This section will guide you how to Insert/Delete/Hide/Unhide/Sizing columns in Microsoft Excel.

7. Excel Columns

How do I insert a new column in excel? How do I delete a column in excel? How to delete multiple columns in Excel workbook? How to hide a column from being displayed in excel? How to unhide the hidden columns in excel? This section will guide you how to Insert/Delete/Hide/Unhide/Sizing columns in Microsoft Excel.

8. Excel Ranges

Excel Ranges is a collection of cells (two or more cells). This post will guide you how to use excel ranges from the below 5 topics:

9. Excel Templates

Excel template is also a workbook, the only different is that it can be as a template or module to create other similar workbooks. there are many free excel templates in the internet or you can create your own excel template.

10. Excel Data Validation

You can use Data validation to control what can be entered into a cell. such as: you can restricts the values allowed in a cell.

11. Excel Protect

How do I encrypt an excel file in excel 2013? How to encrypt excel workbook? How to encrypt an excel file with a password in Microsoft excel? This section will guide you how to encrypt excel file, protect workbook and protect worksheet in excel.

12. Excel print

How do I print a worksheet in excel? How do I print a workbook in Microsoft Excel 2013? How to quick print a excel work sheet? How to print a selection excel range? How to change the print setting to print the excel file base on your request. This section will explain you how to print a worksheet/ change the page scaling setting.

MS Excel Formulas/Functions

This section will explain how to use excel built-in functions or formulas in Microsoft excel.

All excel functions are categorized by their functionality, we will describe the excel functions from the below categories:

1. Text Functions

This section will learn how to use Excel’s Text functions such as:

CHAR, CLEAN, FIND, CODE, EXACT, DOLLAR, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TEXTJOIN, LEFT, UPPER, LOWER, CONCAT, VALUE, LEN, MID, FIXED

2. Lookup And Reference Functions

This section will learn how to use Excel’s Lookup And Reference Functions such as:

ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, Hlookup, HYPERLINK, INDEX, INDIRECT, LOOKUP, VLOOKUP, MATCH, ROWS, ROW

3. Date And Time

This section will learn how to use Excel’s Date And Time Functions such as:

Date, EDATE, Datedif, Day, Days, Days360, Hour, Now, Time, Weekday, WEEKNUM, WORKDAY, WORKDAY.INTL, YEAR,TIMEVALUE, TIME

4. Math And Trigonometry

This section will learn how to use Excel’s Date And Time Functions such as:

ABS, ACOS, ACOSH, Aggregate, ASIN, ASINH, ATAN, ATAN2, ATANH, CEILING, CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, DEGREES, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MDETERM, MINVERSE, MMULT, MOD, ODD, PI, POWER, PRODUCT, RADIANS, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, SUBTOTAL, SUM, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMXMY2, SUMX2PY2, TAN, TANH, TRUNC

5. Statistical

This section will learn how to use Excel’s Statistical Functions such as:

Avedev, Average, AverageA, AverageIF, AverageIFS, BETA.DIST, BETADIST, BETA.INV, BETAINV, BINOM.DIST, BINOM.INV, BINOMDIST, CHIDIST, CHIINV, CHITEST, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVAR, FORECAST, FREQUENCY, GROWTH, INTERCEPT, LARGE, LINEST, MAX, MAXA, MEDIAN, MIN, MINA, MODE, MODE.MULT, MODE.SNGL, PERCENTILE, PERCENTRANK, PERMUT, QUARTILE, RANK, SLOPE, SMALL, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA

6. Logical

This section will learn how to use Excel’s Logical Functions such as:

AND, FALSE, IF, IFError, IFNA, Nested IF function, nested if statements with ranges, OR, NOT, FALSE, TRUE, SWITCH

7. Information

This section will learn how to use Excel’s Information Functions such as:

Cell, Error.type, Info, ISBlank, ISError, ISNUMBER, ISERR, ISNA, ISTEXT, ISNONTEXT, ISREF, N, Type, NA

8. Financial

This section will learn how to use Excel’s Logical Functions such as:

Accrint, AccrintM, Amordegrc, Amorlinc, DB, DDB, FV, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, RATE, PV, SLN, SYD, VDB, XIRR

9. Database

This section will learn how to use Excel’s Database Functions such as:

Daverage, Dcount, DcountA, Dget, Dmax, Dmin, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP

10. Engineering

This section will learn how to use Excel’s Engineering Functions such as:

Bin2Dec, Bin2Hex, Bin2Oct, Complex, Convert

Excel Pivot Table

A Pivot Table allows you to extract certain data from a much larger data set to summarize complex data.

Excel VBA

This section will guide you how to use VBA in Microsoft Excel from the below topics.

1. Excel VBA Overview

This section will teach you how to use VBA(Visual Basic for Applications) in Microsoft Excel.

2. Excel VBA Macros

This chapter will guide you how to create a VBA Macros in Microsoft Excel. How to create a VBA Module in Excel? How to record a VBA Macro? How to customize the VBA macro security settings? How to add a VBA Macro to the Ribbon bar? How to protect VBA Macro in Microsoft Excel 2013.

3. Excel VBA MsgBox

The MsgBox function will be used to display a message box to wait user to click a button, and then returns an integer indicating which button the user clicked.

4. Excel VBA InputBox

The InputBox function will be used to display a prompt in a dialog box, and prompt the user to enter a value or click a button, and returns a string containing the contents of the text box.

5. Excel VBA Variables

This post will guide you how to declare, initialize and display a variable value in MS excel VBA.

6. Excel VBA Constants

This post will guide you how to declare a Constant and assign a value to it in MS excel VBA.

7. Excel VBA Operators

This post will describe the VBA operators in the MS Excel.

8. Excel VBA Decisions

This post will guide you how to use conditional statements in MS excel VBA. There are two most useful conditional statements as bellows: If …Then…Else and Select Case.

9. Excel VBA Loops

This post will guide you how to use loops statements in MS excel VBA. There are three most useful Loops statements as bellows: For …Next loop, Do … Loop and While …Wend loop

10. Excel VBA Strings

This post will guide you how to use VBA String functions to manipulate the String in MS excel VBA.

11. Excel VBA Data And Time

This post will guide you how to use VBA Date and time functions to convert date and time format in MS excel VBA.

12. Excel VBA Array

This post will guide you how to create one-dimensional array and two-dimensional array in MS excel VBA.