Excel Basics

 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). Thispost 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.

Related Posts

How to Limit Data Entry in a Cell in Excel
limit data entry in cell8

This post will guide you how to limit cell entries to specific length and number of digits in Excel. How do I limit data entry to allow only text or only numbers entered into in a cell using Data Validation ...

Create Dynamic Drop Down List
create dynamic drop down list9

This post will guide you how to create a dynamic drop down list in Excel. How do I quickly create a dynamic drop down list in Excel. Create Dynamic Drop Down List Assuming that you want to create two drop ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...

Combine Duplicate Rows and Sum the Values
combine duplicate rows7

This post will teach you how to combine duplicate rows and sum the corresponding values or calculate numbers in specific column in excel. And how to merge duplicate rows and then sum the values with VBA macro in Excel. How ...

Sidebar