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.
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.
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.
- VBA Logical Operators in Microsoft Excel June 7, 2017
- What is the PRICE Excel Function Used for? April 21, 2017
- Using the ODDFPRICE Function in Excel April 19, 2017
- Visual Interactions in Power BI April 19, 2017
- Reshaping your data easily – Case study [Pivot tables FTW] April 17, 2017
Subscribe to Blog via Email