Excel Experts

                                                                                                                        Home  Gallery  Contact Us

Welcome to Excel Experts

We offer a tutorial (Introduction, Basics) on how to use Excel.Below you can find an overview of all chapters. Want to learn much more about Excel? You can find related examples and features (300 Examples) on the right side of each chapter. We keep it easy!

Introduction

This section is for users with no knowledge of Excel. Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.
1. Range:A range in Excel is a collection of two or more cells.

2.Formulas and Functions:A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

Basics

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

2
Workbook: A workbook is another word for your Excel file. Excel automatically creates a blank workbook when you open it.

3 Worksheets:A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.

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

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

6Templates: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 in Excel 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 some important print settings in Excel.

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


back to top                                                                                                                              previous page

Do you like this free website?.Please share this page on: