Excel Tutorial

 

 

 

Welcome to the Best Excel Tutorial in web. Here you are going to know in deep one of the most powerful tools - Microsoft Excel - and you can learn how to use Excel and all its functionalities. You are going to discover how to create Dashboards, Charts, Functions, Formulas, Tables, Pivot Tables, Analyze Big Data, Filter and so on. Lets begin and you are going to see it.

 

EXCEL BASICS

In the first part of the Excel Tutorial, your going to learn all about the first movements inside the program. How to use Excel Basics features, understand the layout, some navigation inside the applications, the menus, the buttons and beginning with the first basics calculation an operations in the Worksheets.

This first part contains the following Chapters:

1- The Excel Window Layout: Learn all about the main sections where you can navigate.

2- The Excel Ribbon: Understand where the Excel Buttons are.

3- The Excel Galleries: A lot of pre-designed forms and text utilities.

4- Excel Smart Tags: A New specific tool in Microsoft Excel to improve your reports.

5- Change Views: Learn how to change the view in the Excel Worksheet.

6- The Excel Worksheet Layout: Understand the parts to begin with Excel operations.

7- Navigate and Rename Worksheets: you can organize all your information in the workbooks.

8- Create and Move Excel Worksheets: Create great reports using different worksheets in Excel.

9- Copy and Delete Worksheets: Continue with basic operations with the Excel worksheets

10- Activate the Gridlines: Use this tools to organize your Worksheet.

11- The Excel Headings: Show or hide the headings to show reports.

12- Create a New Workbook: Start with a Blank Workbook or save time using a Template.

13- Save and Open Workbooks: Save your information an store it and use it later.

14- Arrange Excel Windows: See two or more Workbooks at the same time.

15- Find Text in a Workbook: Learn how to find an specific text in Excel.

16- Replace Text in a Workbook: You can find a text and replace it by another one.

 

EXCEL FORMATTING

In the second part of the Excel Tutorial, we are going to teach you all about one of the useful tools, the formatting will help you to obtain good looking reports and Dashboards.

That contains the following Chapters:

1- Formatting Fonts: Learn how to change the appearance of fonts in Excel.

2- Formatting Texts: Change the appearance of texts in Excel.

3- Formatting Numbers: You can change the appearance of numbers in Excel

4- Conditional Format and Styles: Save time using Pre-defined Styles and Formats in Excel

5- Width and Height in Cells: Improve your tables  changing the size of the Excel cells.

6- Draw Cell Borders in Excel: Create reports changing the cells borders.

7- Modify Workbook Colors: Change the colors configuration of a Workbook.

8- Change Workbook Fonts: Configure the type of font that you want in a Workbook.

9- Apply a Theme: Apply a entire Theme configuration in a Workbook.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 2 other subscribers

 

 

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips