Tutorials Videos Menu
Website Pro NEW

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill Excel Move Cells Excel Add Cells Excel Delete Cells Excel Undo Redo Excel Formulas Excel Relative Reference Excel Absolute Reference Excel Arithmetic Operators Excel Parentheses Excel Functions

Excel Formatting

Excel Formatting Excel Format Painter Excel Format Colors Excel Format Fonts Excel Format Borders Excel Format Numbers Excel Format Grids Excel Format Settings

Excel Data Analysis

Excel Sort Excel Filter Excel Tables Excel Conditional Format Excel Highlight Cell Rules Excel Top Bottom Rules Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts Excel Charts Customization

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS MAX MEDIAN MIN MODE OR STDEV.P STDEV.S SUM SUMIF SUMIFS VLOOKUP XOR

Excel Exercises

Excel Certificate


Excel Overview


Overview

This chapter is about giving you an overview of Excel. Excel's structure is made of two pieces, the Ribbon and the Sheet.

Have a look at the picture below. The Ribbon is marked with a red rectangle and the Sheet is marked with a yellow rectangle:

First, let's start with explaining the Ribbon.


The Ribbon explained

The Ribbon provides shortcuts to Excel commands. A command is an action that allows you to make something happen. This can for example be to: insert a table, change the font size, or to change the color of a cell.

The Ribbon may look crowded and hard to understand at first. Don't be scared, It will become easier to navigate and use as you learn more. Most of the time we tend to use the same functionalities over again.

The Ribbon is made up by the App launcher, Tabs, Groups and Commands. In this section we will explain the different parts of the Ribbon.

App launcher

The App launcher icon has nine dots and is called the Office 365 navigation bar. It allows you to access the different parts of the Office 365 suite, such as Word, PowerPoint and Outlook. App launcher can be used to switch seamlessly between the Office 365 applications.

Tabs

The tab is a menu with sub divisions sorted into groups. The tabs allow users to quickly navigate between options of menus which display different groups of functionality.

Groups

The groups are sets of related commands. The groups are separated by the thin vertical line break.

Commands

The commands are the buttons that you use to do actions.

Now, let's have a look at the Sheet. Soon you will be able to understand the relationship between the Ribbon and the Sheet, and you can make things happen.