Excel 2013 Tutorials

Our Tutorials are created to teach you the basic and advanced features of Microsoft Excel. This course consists of richly illustrated lessons and examples. In order not to bore you we tried to keep the perfect balance between practice and theory. The site is divided into categories that will help you find the subject you are interested in. You can also use the search option to find the phrase even faster.

Below, you can find a quick overview of all categories.


Getting Started

It’s usually good to know a little bit of theory before practice. This lesson is an introduction to the world of spreadsheets.

History of spreadsheets – Learn a bit of history since the very first spreadsheet application.

Excel features – Here you will learn, what makes Excel the most popular spreadsheet in the world.

What's new in Excel 2013 – The new features that were added to Excel 2013.


Interface

Here, I write about the revolutionary change of the Excel 2007 interface, and it’s newest metro-style version in Excel 2013. In this lesson, I will be discussing the most important parts of the UI, such as:

Start Screen – This is the screen that is visible right after you open Excel.

Application window – A brief description of each element of the Excel interface.

Worksheets – Learn what’s the difference between worksheet and workbook and how you can navigate inside them.

Ribbon – The revolutionary change in Excel 2007. It is still present in Excel 2013 and will probably be in the future releases.

Quick Access Toolbar – Let’s see how to use and customize the toolbar with the shortcuts to the most popular Excel features.

Formula Bar – A place where you can enter and edit you formulas, text, dates, etc.

Status Bar – A simple bar at the bottom of the screen which show you information about current activities in the worksheet.

Backstage View – It’s a feature that first appeared in Excel 2010. You can find it under the FILE button.


Basics

In this category you can find lessons where I discuss the most important things you need to learn in order to use Excel at the basic level. Once you master these features you can learn more advanced concepts.

Data Types – A brief introduction to the types of data that can be used in Excel.

How to copy, cut and paste data – In this lesson I show the basic operations you can use to copy, cut and paste data.

Windows and Office clipboard – How they differ from each other and where you can use them.

Paste Special – This is Excel’s more advanced way to pasting data.

AutoCorrect – Microsoft Office feature to automatically correct most popular typos.

AutoComplete – A helpful feature that will speed up entering data.

AutoFill – You can fill cells by dragging.

Flash fill – A more complicated tool than filling data, a bit similar to autofill.

Spell check – Checks the correctness of the entered text.

Undo and Redo – If you want to move to the previous modification in the document use undo, if you want to go forward use redo.

Hyperlinks – A link to website, document or email address.

Data Validation – Check if data is correct using the validation tool.

Comments – Add comments to your worksheet to remember what is it about.

How to select cells – Select cells using both mouse and keyboard.

How to select rows and columns – Here, you can find a multiple methods for selecting rows and columns.

How to insert cells – If you need to insert cells between other cells- use this option.

Cell references – How to refer to other cells. You will learn about relative, absolute and mixed cell references.

How to merge cells – Merge multiple cells into one.

How to merge text with numbers – Sometimes you may want to merge data from multiple cells into one cell.

Text to Columns Wizard – The opposite of merging cells. Split data from one cell into multiple cells. The data has to be consistent.

Aligning data – In cell, you can center data horizontally, move it to the left or right, but also to the top or bottom.

Adjusting text – How to adjust text, so it can be entirely visible on the screen.

Text orientation – Write text horizontally, vertically or at an angle.

Color, type and font size – Learn how to change font family, size and color of your text.

Bold, italic, underline, and strikethrough – Highlight text using these features.

Filling cells – Excel allows to fill cells not only with color, but also with gradient and pattern.

Cell borders – Create borders for cells you want to stand out.

Number formatting – Excel can format numbers in many different ways.

Simple fractions and decimal fractions – Two types of fractions and a few methods to convert one type to another.

Currency and accounting format – Two different types of currency notation.

Custom number formatting – Excel has a few formatting options, if none of them suits you- create your own.

Go To Special – A more advanced tool to find cells that meet specified criteria.

Cell Ranges – You can name single cells and cell ranges.

How to insert rows and columns – Inserting row or column between other rows and columns.

How to delete rows and columns – Delete row or column if you no longer need it.

How to hide rows and columns – If you don’t want to see row or column, but you don’t want to delete it either, you can hide it now and unhide it later.

How Excel stores date and time – Excel doesn’t use the special “date” format, but rather it stores dates as integer and time as fraction.

Mathematical operations on date and time – Because Excel stores date and time as numbers, you can use elementary arithmetic on them.

Formatting date and time – Learn how to format date in many different ways.

Saving files – Save an Excel file using one of many different formats.

Recovering files – If you forgot to save your file and the power went off, you can use this feature to recover it.

Print Preview – Preview your worksheet before printing it in Excel.


Formulas and Functions

In Excel, you can find hundreds of functions. Some of them are available since the very first Excel release, and some were added later. Here, I try to describe the most important functions and show a few different ways you can create them, creating it by hand or by clicking it from the ribbon.

Formulas – An introduction to formulas. You will learn how to enter and edit a formula, and which formula errors you can encounter when working in Excel.

Adding numbers using the SUM function – Just click one button and this feature will automatically add all the cell you want.

Adding numbers using AutoSum – If you forgot to save your file and the power went off, you can use this feature to recover it.

Subtracting in Excel – After you learn about adding numbers in Excel, learn how you can subtract them.


Data Analysis

Tables – When you work with Excel, you need a way to organize your data. It can be a different kind of information- from expenses, to a simple list of guest for a birthday party. Either way, a good method to manage your data is by using tables.

Removing duplicates – Sometimes you can avoid having a large amount of information in your table. In this situation removing duplicates by hand is not the best idea. In Excel you will find a special tool to achieve this.

Slicers – Slicers are a good way to filter your data. They are not as powerful as Filter Options, but they look nice.

Charts – Charts represent data visually. Excel charts evolved greatly since the first release of Excel. They have been constantly improved over the years and now (Excel 2013) you get a powerful, highly customizable tool.

Column Chart – This is probably the most popular chart in Excel. The data in column chart is displayed in vertical bars.

Line Chart – It's a good type of chart if you want to show trends in data.

Pie Chart – This chart can be used to when you want to show relative proportions to a whole.

Trendlines – When you want to predict how your data is trending- use this feature.

Sparklines – Sparklines were introduced in Excel 2010. They are miniature charts that occupy only one cell.

Pivot Tables – With pivot tables you can summarize a large amount of data without writing a single formula, you can use pivot tables. The interactivity of pivot tables allows you to rearrange information in many different ways..


VBA

VBA is a programming language used in Microsoft Office Suite. It is used in many different ways, mainly to automate tasks you do frequently.

Introduction to VBA – Learn, what is a macro and when it's a good idea to create your own.

Visual Basic Editor (VBE) – In Visual Basic Editor you can create and manage your macros.

The Macro Recorder – Macro recorder will create a macro without the need of writing your own code.

Objects in VBA – Because VBA is an object oriented language. Everything in VBA is an object.

Subroutines and Functions – Learn how you can write a subroutine and functions and what's the difference between them.

Variables – A variable is a reserved chunk of computer memory that can change value.

Constants – A constant is a reserved chunk of computer memory that cannot change value.

Data Types – Each variable or constant has some data type.

Variable Scope – Learn about one of three variable scopes in Excel: procedure level, module level and public level.

Conditional Statements – If you want your procedure to behave differently depending on the conditions it meets you have to use one of the conditional statements

Loops – Loops are used to repeat the same chunk of code many times.

Developer Tab – This is the tab that is, by default, hidden from the ribbon. It's useful when we work with VBA.