# MS Excel Basic Concepts Tutorials

Tutorials Shared by the Internet Community

 Top Tutorials New Tutorials Submit Login Register

 Basic Concepts (16) Charts and Graphs (3) Data Entry (2) Functions (18) General Development (3) General Formatting (4) Interfaces (0) Security (0) Using Macros (0) Misc (1)

• ### Pivot Tables Learn how to use in Excel

Pivot tables are one of the most versatile and powerful tools available in Excel.
https://www.excelbuddy.com/excel-tutorial-database/pivot-tables-learn-how-to-use-in-excel/
• 1379 Hits
• Rating

• ### Find And Replace

Learn how to use the find and replace feature in Excel.
https://www.excelbuddy.com/excel-tutorial-database/find-replace/
• 644 Hits
• Rating

• ### Data Filtering Single and Multiple Filters in Excel

Data filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only the rows in your spreadsheet th
https://www.excelbuddy.com/excel-tutorial-database/data-filtering-single-multiple-filters-...
• 706 Hits
• Rating

• ### Calculate Compound Annual Growth Rate

Calculating the compound annual growth rate (CAGR) is an essential function regardless of industry. Excel makes this calculation extremely easy.
https://www.excelbuddy.com/excel-tutorial-database/calculate-compound-annual-growth-rate/
• 581 Hits
• Rating

• ### Calculate Annual Growth Rate

Calculating the annual growth rate is very easy in Excel. To calculate the annual growth rate, use the following formula.
https://www.excelbuddy.com/excel-tutorial-database/calculate-annual-growth-rate/
• 539 Hits
• Rating

• ### Using Check boxes in Excel

The following tutorial will show you how to use Check boxes in Excel. You can use check boxes are ways of displaying text or figures that can be used
https://www.excelbuddy.com/excel-tutorial-database/using-check-boxes-in-excel/
• 493 Hits
• Rating

• ### Selecting All Formula Cells in a Worksheet

Sometimes when working in Excel, it can be helpful to quickly identify or select all of the cells in a worksheet which contain formulas.
https://www.excelbuddy.com/excel-tutorial-database/selecting-formula-cells-worksheet/
• 477 Hits
• Rating

• ### Print to Fit on X Number of Pages

Sometimes when using Excel you may want to customize the way that you print the information you are working with.
https://www.excelbuddy.com/excel-tutorial-database/print-to-fit-on-x-number-of-pages/
• 392 Hits
• Rating

• ### Cell References in Excel: Absolute, Mixed and Relative

Cell references are very important in MS Excel. Cell referencing works in formulas and other automations performed within MS Excel. It is further clas
http://www.certiology.com/tutorials/excel-tutorial/cell-references-in-excel.html
• 8652 Hits
• Rating

• ### Worksheet in Excel: How to Select, Insert, Rename, Move

Worksheet plays a highly important role in MS Excel as all the automation in MS Excel requires worksheet as a key reference. In this tutorial you will
http://www.certiology.com/tutorials/excel-tutorial/worksheet-in-excel.html
• 7265 Hits
• Rating

• ### Workbook in MS Excel: How to Create, Open and Save work

In Excel, workbook contains multiple worksheets of account and other records. Now since, MS Excel is also associated with the record keeping and perfo
http://www.certiology.com/tutorials/excel-tutorial/workbook-in-ms-excel.html
• 5610 Hits
• Rating

• ### Ribbon in MS Excel

By default, the Ribbon contains 8 tabs in MS Excel 2013. In this Microsoft Excel Tutorial you will learn about Ribbon tabs and how to customize,
http://www.certiology.com/tutorials/excel-tutorial/ribbon-in-ms-excel.html
• 4508 Hits
• Rating

• ### Range in Excel: Working with Ranges in MS Excel

The term Range is used in MS Excel for the selection of one or more than one cell either horizontally or vertically or even in a block. There are vari
http://www.certiology.com/tutorials/excel-tutorial/working-with-ranges-in-ms-excel.html
• 4343 Hits
• Rating

• ### Excel Tutorial: Working with Rows, Columns and Cells in

In this step by step Excel tutorial, you will learn how to Insert and delete rows, Columns and cells in Microsoft Excel.
http://www.certiology.com/tutorials/excel-tutorial/working-with-rows-columns-and-cells-in-...
• 4496 Hits
• Rating

• ### Important terminologies in Microsoft Excel

Here you will find important terminologies that are used in Microsoft Excel. MS Excel is widely used all across the globe for its flexibility and high
http://www.certiology.com/tutorials/excel-tutorial/important-terminologies-in-microsoft-ex...
• 2988 Hits
• Rating

• ### Baby Boom: An Excel Tutorial on Analyzing Large Data S

Learn intermediate Excel functions and skills while uncovering odd and interesting insights in the US Social Security names database
• 38238 Hits
• Rating

• ### How to insert cells in Excel

When we work with spreadsheet sooner or later we will need to insert Cells into existing sheet. I will show a few ways we can achieve it.
http://excel.officetuts.net/training/basics/insert-cells.php
• 35654 Hits
• Rating

• ### How to Find Data in Excel

Finding data is very useful, when you have to deal with a lot of data on a worksheet.
http://excel.officetuts.net/training/basics/find-data.php
• 35919 Hits
• Rating

Ever notice how easy it is to navigate a book? Thats because they have a table of contents.
• 35504 Hits
• Rating

• ### Create a 3-D Illusion in Cells

Whether you have to give a presentation or you need to liven up your worksheets, giving it a 3D look could be just the thing.
http://www.excel-tutorials.org/cells/how-to-create-a-3-d-illusion-in-cells/
• 35312 Hits
• Rating

• ### Separate Raw Data into Columns

Organize into columns from raw data that you got from somewhere else.
http://www.excel-tutorials.org/columns/how-to-separate-raw-data-into-columns/
• 35097 Hits
• Rating

• ### Create a Mail Merge Using Microsoft Excel and Word

Learn how you can easily manage addresses using mail merge through Excel and Word.
http://www.excel-tutorials.org/worksheets/how-to-create-a-mail-merge-using-microsoft-excel...
• 35921 Hits
• Rating

« Previous 1 2 Next »