Excel Tutorial

Explore Excel with ease — our step-by-step guide helps users master essential Excel skills. From formulas to data analysis, this tutorial covers everything you need to become proficient in Microsoft Excel, whether you're just starting or looking to advance your skills.

 Excel HOME

The heart of Excel — the HOME tab offers the basic tools for formatting, editing, and manipulating your data. Learn to navigate this essential section, featuring options like font styles, alignment, and sorting.

 Excel Introduction

What is Excel? A powerful spreadsheet application used for data analysis, reporting, and managing information. In this section, you'll understand Excel’s core functions, applications in the workplace, and why it’s a must-learn tool for professionals.

 Excel Get Started

New to Excel? No problem. This section guides you through the first steps of using Excel, from installing the software to creating your first worksheet. Perfect for beginners who need a simple introduction.

Excel Overview

Navigate Excel like a pro — get a thorough tour of the Excel interface. Learn how to use menus, toolbars, and ribbons to maximize your productivity.

 Excel Syntax

Formulas demystified — learn the structure of Excel formulas, including how to use arithmetic operators (+, -, *, /), parentheses, and cell references. Master the logic behind every formula and function you’ll need.

Excel Ranges

Selecting and working with ranges — learn how to highlight and manipulate specific ranges of cells for more efficient data management and analysis.

Excel Fill

Speed up your workflow — explore Excel’s Fill feature to quickly copy data, formulas, or formatting across multiple cells.

Excel Move Cells

Rearrange your data — understand how to move cells, rows, or columns without losing information.

 Excel Add Cells

Add more data with ease — learn how to insert additional cells, rows, or columns into your worksheet without disrupting existing data.

 Excel Delete Cells

Streamline your worksheet — remove unwanted cells, rows, or columns to keep your data clean and organized.

 Excel Undo Redo

Mistakes are fixable — master the undo and redo features to easily reverse or repeat actions in your worksheet.

 Excel Formulas

Automate calculations — this section introduces formulas, Excel’s key feature for performing calculations. From simple arithmetic to complex logic, you’ll learn it all.

 Excel Relative Reference

Dynamic formulas — understand how relative references work in Excel, allowing your formulas to adapt when copied to different locations.

Excel Absolute Reference

Lock your references — learn about absolute references and how to freeze certain cells in your formulas, ensuring consistency across your data.

 Excel Arithmetic Operators

Basic math in Excel — explore the use of arithmetic operators like addition, subtraction, multiplication, and division in Excel formulas.

 Excel Parentheses

Control your calculations — parentheses help you prioritize operations in a formula, ensuring Excel calculates everything in the right order.

 Excel Functions

Pre-built power — learn how to use Excel’s built-in functions like SUM, AVERAGE, IF, and many more to simplify complex tasks.

Excel Formatting

Make your data stand out — this section covers essential formatting tools that enhance the readability and presentation of your data.

 Excel Format Painter

Copy styles instantly — learn how to use Format Painter to duplicate formatting across different cells or ranges.

Excel Format Colors

Color-code your data — apply color formatting to highlight important data or categorize information for easier interpretation.

Excel Format Fonts

Customize your text — change font styles, sizes, and colors to make your data more visually appealing.

Excel Format Borders

Frame your data — add or customize borders around cells to make your tables more structured.

 Excel Format Numbers

Precision matters — control how numbers are displayed, whether it’s currency, percentage, or decimal formatting.

 Excel Format Grids

Organize your worksheet — manage gridlines and how they appear to ensure your data stays organized.

 Excel Format Settings

Advanced formatting — dive into detailed settings for customizing cell appearances beyond the basics.

Excel Data Analysis

Turn data into insights — analyze data efficiently using sorting, filtering, and summarization techniques built into Excel.

 Excel Sort

Organize data instantly — learn how to sort data in ascending or descending order, alphabetically, or numerically.

 Excel Filter

Zero in on key data — filter data sets to focus on specific criteria, making it easier to manage large volumes of information.

 Excel Tables

Dynamic data handling — convert your data into tables for automatic formatting, sorting, and filtering.

 Excel Conditional Format

Highlight important data — apply conditional formatting to visually distinguish critical data based on rules you set.

Excel Highlight Cell Rules

Draw attention to key values — set rules that highlight cells based on their contents, such as high values or specific dates.

Excel Top Bottom Rules

See the extremes — use conditional formatting to highlight the highest and lowest values in a data set.

Excel Data Bars

Visualize trends — add data bars to your cells, turning numbers into easy-to-interpret visual bars.

 Excel Color Scales

Gradients for insight — apply color scales to give your data a more visual representation, showing variations in values.

 Excel Icon Sets

Symbols for clarity — enhance data with icon sets, making it easier to spot trends or key data points.

 Excel Manage Rules (CF)

Control your formatting rules — manage and edit your conditional formatting rules to ensure they work as intended.

 Excel Charts

Transform data into visuals — learn how to create charts and graphs that turn raw data into easy-to-understand visuals.

Table Pivot

Summarize your data efficiently — this section introduces Pivot Tables, which let you summarize and analyze large data sets easily.

 Table Pivot Intro

Getting started with Pivot Tables — a beginner-friendly introduction to the power of Pivot Tables for dynamic data analysis.

Excel Case Real-world examples — apply what you’ve learned through practical case studies that mimic real-world scenarios.

Case: Poke Mart

Inventory management simplified — a case study focused on managing product data for a fictional store, Poke Mart.

Case: Poke Mart, Styling

Format, and style data — improve the appearance of data for Poke Mart, focusing on styling techniques for better presentation.

Excel Functions

Advanced functionality — a deep dive into Excel’s most useful and powerful functions.

• AND: Test multiple conditions within a formula.

• AVERAGE: Calculate the average of a range of numbers.

• AVERAGEIF: Compute the average based on a specific condition.

• AVERAGEIFS: Find the average for multiple criteria.

• CONCAT: Combine multiple text strings into one.

• COUNT: Count the number of numeric entries in a range.

• COUNTA: Count all entries, including text, in a range.

• COUNTBLANK: Count empty cells in a range.

• COUNTIF: Count cells based on a condition.

• COUNTIFS: Count cells based on multiple criteria.

• IF: Return a value based on a condition.

• IFS: Evaluate multiple conditions and return a result.

• LEFT: Extract a certain number of characters from the left side of a text string.

• LOWER: Convert text to lowercase.

• MAX: Return the largest number in a range.

• MEDIAN: Calculate the middle value in a data set.

• MIN: Return the smallest number in a range.

• MODE: Find the most frequent value in a data set.

• NPV: Calculate the net present value of an investment.

• OR: Test multiple conditions and return TRUE if any are met.

• RAND: Generate a random number between 0 and 1.

• RIGHT: Extract characters from the right side of a text string.

• STDEV.P: Calculate the standard deviation for an entire population.

• STDEV.S: Calculate the standard deviation for a sample.

• SUM: Add up a range of numbers.

• SUMIF: Sum values based on a condition.

• SUMIFS: Sum values based on multiple conditions.

• TRIM: Remove extra spaces from text.

• VLOOKUP: Look up data in a vertical table.

• XOR: Return TRUE if one, and only one, of the conditions is TRUE.

Excel How To

Quick tips and tricks — solve common Excel problems with these easy-to-follow tutorials.

• Convert Time to Seconds: Learn how to convert time values into seconds.

• Difference Between Times: Calculate the difference between two time values.

• NPV (Net Present Value): Understand how to calculate NPV in Excel.

• Remove Duplicates: Clean up your data by removing duplicate entries.

Excel Examples

Practice makes perfect — a collection of real-world exercises to reinforce your Excel skills.

 Excel Exercises

Sharpen your skills — practice what you’ve learned with guided exercises designed for every skill level.

Excel Certificate

Prove your proficiency — complete our tutorial and earn a certificate to showcase your Excel skills.

Excel References

Cheat sheets for pros — a handy list of references, including shortcuts and formula tips, to keep your Excel skills sharp.

Excel Keyboard Shortcuts

Work faster in Excel — a list of essential keyboard shortcuts that can boost your productivity and automate your tasks.