1. Basic Microsoft Excel Download
2. Basic Microsoft Excel Training
3. Basic Microsoft Excel
4. Basic Microsoft Excel Information
5. Basic Microsoft Excel Training Pdf

This section explains the basics of Excel.

1 Ribbon: Excel selects the ribbon's Home tab when you open it. Learn how to use the ribbon.

Excel is an electronic spreadsheet program that is used for storing, organizing and manipulating data. Data is stored in individual cells that are usually organized in a series of columns and rows in a worksheet; this collection of columns and rows is referred to as a table. Lifewire / Adrian Mangel. Microsoft Excel for Beginners 2.0 hours This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet. I am Sumit Bansal, your instructor for this Excel Training. I have been training people in basic/advanced Excel and dashboards for more than 10 years now. I have also been honored with the Microsoft Excel MVP status for my expertise in Excel. Learning Excel becomes a cake walk when you do it the right way. Microsoft Excel is a spreadsheet program used for calculations, making charts, and recording data about all sorts of business processes. Most companies with their staff to have adequate knowledge on how to use this application. Take this quiz to see how well you know some Excel basics. In Excel, you have a bunch of options on the home tab for formatting. The font group gives you the options to format the font by making it bold, italic, and underline. You can change the font style, its size, and color of the font and the color of the cell as well.

2 Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.

3 Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

4 Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.

5 Find & Select: Learn how to use Excel's Find, Replace and Go To Special feature.

6 Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.

7 Data Validation: Use data validation to make sure that users enter certain values into a cell.

8 Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.

9 Print: This chapter teaches you how to print a worksheet and how to change print settings.

10 Share: Learn how to share Excel data with Word documents and other files.

11 Protect: Encrypt an Excel file with a password so that it requires a password to open it.

Basic Excel Categories:

Excel Data Input
Keyboard Shortcuts

Basic Microsoft Excel Download

Cell References
Excel Dates & Times
Converting Between Data Types
Excel View Options
Excel Formatting
Excel Subtotals
Excel Hyperlinks
Excel Filtering
Pivot Tables
Password Protection
Saving to PDF

This page introduces some of the Basic Excel skills that will help when you are using functions and formulas in Excel.

Many useful Excel basics are described in the links below, but if you are a complete beginner, you might also find some useful tips on the Microsoft Office Basic Excel page.

Excel Data Input

There are several different ways of entering data into a spreadsheet. Many of these methods are shortcuts that will help you to save time and therefore work more efficiently.

Click on the links below for details.

EXCEL DATA INPUT

INSERT A NEW LINE IN AN EXCEL CELL

EXCEL AUTOFILL

INPUTTING EXCEL FUNCTIONS

EXCEL COPY AND PASTE

EXCEL FIND AND REPLACE

DATA VALIDATION: CREATE A DROP DOWN LIST

SPELL CHECK IN EXCEL

Keyboard Shortcuts

It is worth spending a little time learning the Excel Keyboard Shortcuts for the actions that you perform most frequently in Excel. You will find that the time invested in learning these shortcuts will soon be repaid many times over.

COMMON EXCEL KEYBOARD SHORTCUTS

Cell References

An understanding of absolute and relative cell references is essential when you are copying formulas between Excel cells. Click on the links below for details.

Basic Microsoft Excel Training

EXCEL CELL REFERENCES

EXCEL REFERENCES STYLES

EXCEL NAMED RANGES

Excel Dates and Times

Did you know that Excel stores Dates & Times as numbers? An understanding of how this works will help you to work much more effectively when using Dates & Times in Excel. Click the links below for more details:

EXCEL DATES & TIMES

HOW TO SUBTRACT DATES IN EXCEL

HOW TO SUBTRACT TIME IN EXCEL

Converting Between Excel Data Types

In order to prevent problems, you may need to convert between the different Excel data types before using values in Excel functions and formulas.

CONVERT TEXT TO A NUMBER

CONVERT A NUMBER TO TEXT

CONVERT TEXT TO A DATE

CONVERT A DATE TO TEXT

Excel View Options

Basic Microsoft Excel

Excel allows you to change the view of your spreadsheet by zooming in or out, showing formulas, etc. Some of the more popular options are explained in the following links.

HOW TO FREEZE PANES IN EXCEL

EXCEL ZOOM

SHOW FORMULAS

HIDE & UNHIDE COLUMNS IN EXCEL

HIDE & UNHIDE ROWS IN EXCEL

HIDE GRIDLINES

Basic Microsoft Excel Information

Excel Formatting

There is much more to Excel Formatting than just making spreadsheets look good.

In addition to making your spreadsheet look professional and smart, the formatting of data in Excel can also change the way the data is interpreted. The wrong formatting can sometimes result in data being read incorrectly and may give the impression that your function has failed to evaluate correctly. Click on the links below for more details.

BASIC FORMATTING

EXCEL DATE FORMATTING

EXCEL CUSTOM NUMBER FORMATTING

MERGE CELLS

WRAP TEXT IN EXCEL

CONDITIONAL FORMATTING

Excel Subtotals

You can quickly and easily display subtotals in your data table using the built-in Excel subtotal command.

EXCEL SUBTOTAL COMMAND

Basic Microsoft Excel Training Pdf

Excel Hyperlinks

The correct use of hyperlinks can turn a simple worksheet into a complete record-keeping system, which looks professional and is easy to use. Click on the links below for details.

CREATE A HYPERLINK IN EXCEL

REMOVE HYPERLINKS IN EXCEL

Excel Filtering

One of the basic Excel requirements for anyone working with large amounts of data is the Excel filter. Excel has two main filtering types, which are described in the links below.

EXCEL AUTOFILTER (BASIC FILTER)

EXCEL ADVANCED FILTER

Pivot Tables

Learn how to use Excel Pivot Tables to quickly and easily analyse large amounts of data.

EXCEL PIVOT TABLES - (Basic Introduction)

Password Protection

Sometimes you may want to protect your spreadsheet from being viewed or written to by others. The following pages describe how to password protect an entire workbook or individual sheets within an Excel file.

PASSWORD PROTECT EXCEL FILE

Saving To PDF

Click the link below for details of how to produce a PDF version of your Excel spreadsheet.

CONVERT EXCEL TO PDF