Tips and Tricks | MyExcelOnline

Start here
Blog Blog
Excel

Data analysis spreadsheet

Formulas

Pivot Tables

Macros & VBA

Analysis

Shortcuts

Charts

Power BI

Copilot

Word

Document creator

PowerPoint

Presentation software

Teams

Collaboration tool

Outlook

Email and calendar

Access

Database management tool

Forms

Survey and quiz creator

OneDrive

Cloud storage service

OneNote

Digital notebook

Power Apps

Custom app builder

Power Automate

Workflow automation tool

Project

Project management software

Sway

Interactive presentation creator

Visio

Diagram and flowchart tool

Accounting

Easy accounting tutorials

Podcast

Expert Insights on Excel
$1 Trial for 30 days!

Cancel Anytime

30+ Excel & Office Courses

Certificates of Completion

Practice Workbooks

5 Amazing Bonuses

Access for $1
Courses Courses
Beginner

Introduction

An introduction to Microsoft Excel taking you through the workbook interface, menu ribbon features, entering data into your worksheet and saving.

Learn More

Formulas

An introduction to Formulas, cell referencing, order of operations, relative v absolute references and exposure to common formulas that will get you up and going fast!

Learn More

Formatting

Learn the most used formatting features like adding/deleting columns or rows, copying & moving worksheets, font formatting, number formatting and conditional formatting.

Learn More

Charts

Introduction to Images, Shapes, Smart Art & various Charts to spice up your presentations!

Learn More

Printing

Learn how to properly layout your page, print your documents and create custom templates that you can reuse time and time again.

Learn More

$1 Trial for 30 days!

Cancel Anytime

30+ Excel & Office Courses

Certificates of Completion

Practice Workbooks

5 Amazing Bonuses

Access for $1

Intermediate

Formulas

Learn how to create Named Ranges, the various useful IF formulas, VLOOKUP, HLOOKUP, INDEX & MATCH, OFFSET, INDIRECT, SUMPRODUCT, TEXT formulas, nesting formulas, auditing your formulas and List formulas!

Learn More

Pivot Tables

Build your must have Pivot Table skills and learn its various powerful data analytic features including: Summarize Values, Group data, Filter & Sort, Slicers, Calculated Fields & Items, Pivot Charts plus Conditional Formatting!

Learn More

Macros & VBA

An introduction to Macros & VBA, recording Macros, creating Macro buttons and editing your Macros that will save you hours each week!

Learn More

Data & Analysis

Learn the must know analytical tools within Excel like: Sorting & Filtering, Excel Tables, Data Validation drop down menus, Text to Columns, Flash Fill plus MORE!

Learn More

Charts

Visualize your data with Charts like Column, Bar, Pie, Bubble, Scatter and Sparklines.

Learn More

$1 Trial for 30 days!

Cancel Anytime

30+ Excel & Office Courses

Certificates of Completion

Practice Workbooks

5 Amazing Bonuses

Access for $1

Advanced

Formulas

Advance your Formula skills with various nested formulas, Array formulas and advanced Lookup formulas like VLOOKUP, INDEX/MATCH, OFFSET, SUMPRODUCT plus heaps MORE!

Learn More

Pivot Tables

Learn the tips that Excel gurus use to analyze their data with a few mouse clicks, create KPIs on you business, interactive Excel Dashboards, learn the GETPIVOTDATA formula plus much MORE!

Learn More

Macros & VBA

Learn the key VBA concepts to automate your Excel reports & make you more productive, like: Worksheet & Range Objects, Relative References, Modules & Procedures, Variables & Data Types, Conditional Statements & Loops, Message & Input Boxes plus create interactive data entry User Forms! WOW!

Learn More

Power Query

Learn how to install Power Query, consolidate workbooks & worksheets and create management, clean up your dirty data and transform your data into easy to read reports!

Learn More

Power Pivot

Expand on your Pivot Table knowledge with this super charged add-in! You will learn how to import your data, create relationships, advanced calculations/measures plus various DAX formulas. This is Pivot Tables on STEROIDS!

Learn More

Data & Analysis

Gain insights on how to use the various data predictive tools like: Goal Seek, Solver, Data Table, Scenario Manager, Relationships and Forecasting!

Learn More

Charts

Expand on your Charting knowledge by learning the advanced Charts, formatting Charts and the new Excel 2016 Charts!

Learn More

Power BI

Learn Microsoft's most powerful Business Inteligent platform. Power BI is a business analytics service that delivers insights to enable fast, informed decisions. Transform data into stunning visuals and share them with colleagues on any device.

Learn More

Excel Dashboards

Learn to create awesome interactive Excel Dashboards that showcase your Key Performance Indicators (KPIs) on one page by using Excel Charts, Formulas, Tables, Form Controls and more!

Learn More

Financial Modeling

Learn how to create a Financial Model using the core Excel concepts & formulas, learn various Financial Modeling skills and create a real life Financial Model business case with Profit & Loss, Cash Flow, NPV, IRR, payback periods, scenario analysis plus MUCH MORE!

Learn More

$1 Trial for 30 days!

Cancel Anytime

30+ Excel & Office Courses

Certificates of Completion

Practice Workbooks

5 Amazing Bonuses

Access for $1

Microsoft

Word

Use Microsoft Word to create business letters, business cards, resumes, product manual, reports, flyers, restaurant menus, invitation cards, labels, forms, and many more.

Learn More

PowerPoint

Microsoft PowerPoint is your tool to create slides for your presentations. PowerPoint supports audio, videos, and animation effects to help you give your presentation greater impact.

Learn More

Outlook

Microsoft Outlook is a powerful email client used by most corporate enterprises in the world. It also includes such functions as calendaring, task managing, contact managing, note-taking, journal logging and web browsing.

Learn More

OneNote

Microsoft OneNote is a feature-rich note-taking application. OneNote keeps your notes, plans, and thoughts all in one place. You create sections, pages, and sub-pages just like a tradition paper notebook and use color codes to organize your notes.

Learn More

Teams

Microsoft Teams is a feature-rich and secure collaboration and communication application. It supports instant message/chat, audio calls, video conferencing, and collaboration features. Other features include the ability to host meetings with thousands of participants, record your meetings, and to share your screen for when you are hosting a training session.

Learn More

Access

Microsoft Access is an application used to create databases to store and manage your business data. It provides you with tools to create data tables, queries, forms, reports, and tools to help you write Visual Basic codes to customize the functionality of your database application.

Learn More

SharePoint

Microsoft SharePoint is a cloud-based application used to build intranet websites to share and management information and collaborate with others within your organization. Features of SharePoint can be used to create as a document management tool, a knowledge base, a management workflow, a calendar of events, a ticketing system, and much more.

Learn More

Project

Microsoft Project is a powerful and popular tool to plan and manage projects. It provides the tools to management tasks, dependencies, milestones, Gantt chart and more.

Learn More

Visio

Microsoft Visio is a diagramming and vector graphics application. You can create diagram types such as Flowcharts, Org Charts, Floor Plans, Network Diagrams, UML Diagrams, Mind maps and more.

Learn More

Power Automate

Formerly Flow, Microsoft Power Automate is a cloud-based tool to help organizations develop workflows to automate tasks and processes. It's a useful tool to help bring automation to repetitive tasks, such as approval workflows, data collecting, or synchronize files between applications.

Learn More

Power Apps

Microsoft Power Apps is a collection of tools to help you build customized web-based and mobile apps to meet your business needs. It's biggest benefits are automation and workflow. These enable businesses to improve productivity and processes, streamline tasks, and minimize the use of paper.

Learn More

Forms

Microsoft Forms is a web-based application that allows you to create forms to collect data and feedback from users, such as surveys, questionnaires and polls.

Learn More

$1 Trial for 30 days!

Cancel Anytime

30+ Excel & Office Courses

Certificates of Completion

Practice Workbooks

5 Amazing Bonuses

Access for $1

Member Login
Corporate
Shop Shop
$19.00 $38.00

101 Most Popular Excel Formulas

101 Most Popular Excel Formulas

Learn the Most Popular Excel Formulas Ever: XLOOKUP, VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus Many More!
Buy E-Book (50% OFF) Buy at Amazon

$19.00 $38.00

101 Ways to Master Excel Pivot Tables

101 Ways to Master Excel Pivot Tables

Master Excel Pivot Tables in a Flash: Customizations, Calculations, Grouping, Sorting, Filtering, Slicers, Calculated Fields/Items, Pivot Charts, Dashboards, Conditional Formatting, Getpivotdata Plus Many More!
Buy E-Book (50% OFF) Buy at Amazon

$19.00 $38.00

101 Ready To Use Excel Macros

101 Ready To Use Excel Macros

Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away
Buy E-Book (50% OFF) Buy at Amazon

Ultimate Debt Repayment Tracker
$19.00 $38.00

⭐⭐⭐⭐⭐
Easily create a debt repayment schedule using 3 fully automated debt repayment strategies (snowball, avalanche or custom)!

✓ Gain Complete Debt Transparency

✓ Minimize Debt Strain

✓ Reach Debt Milestones

✓ Editable in Microsoft Excel (All Versions)

Buy Now! (50% OFF)

Ultimate personal finance tracker
$19.00 $38.00

⭐⭐⭐⭐⭐
Track your Income, Savings, Expenses and Debts with the ULTIMATE Personal Finance Tracker!

✓ Gain Complete Financial Transparency

✓ Minimize Financial Strain

✓ Reach Financial Milestones

✓ Editable in Microsoft Excel (All Versions)

Buy Now! (50% OFF)

Ultimate small Business Bookkeeping tracker
$19.00 $38.00

⭐⭐⭐⭐⭐
Easily manage your small business Income & Expenses with this fully automated bookkeeping tracker!

✓ Gain Complete Business Transparency

✓ Minimize Business Strain

✓ Reach Business Milestones

✓ Editable in Microsoft Excel (All Versions)

Buy Now! (50% OFF)
Consulting
Login

Free Excel eBook Free Excel eBook

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-introduction.svg" alt="Introduction" width="48" height="48" /> Introduction

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" width="48" height="48" /> Formulas

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formatting.svg" alt="Formatting" width="48" height="48" /> Formatting

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" width="48" height="48" /> Charts

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-printing.svg" alt="Printing" width="48" height="48" /> Printing

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" width="48" height="48" /> Formulas

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-pivot-tables.svg" alt="Pivot Tables" width="48" height="48" /> Pivot Tables

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-macros-vba.svg" alt="Macros & VBA" width="48" height="48" /> Macros & VBA

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-data-analysis.svg" alt="Data & Analysis" width="48" height="48" /> Data & Analysis

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" width="48" height="48" /> Charts

$1 Trial for 30 days!

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-formulas.svg" alt="Formulas" width="48" height="48" /> Formulas

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-pivot-tables.svg" alt="Pivot Tables" width="48" height="48" /> Pivot Tables

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-macros-vba.svg" alt="Macros & VBA" width="48" height="48" /> Macros & VBA

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-query.svg" alt="Power Query" width="48" height="48" /> Power Query

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-pivot.svg" alt="Power Pivot" width="48" height="48" /> Power Pivot

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-data-analysis.svg" alt="Data & Analysis" width="48" height="48" /> Data & Analysis

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-charts.svg" alt="Charts" width="48" height="48" /> Charts

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-power-bi.svg" alt="Power BI" width="48" height="48" /> Power BI

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-dashboards.svg" alt="Excel Dashboards" width="48" height="48" /> Excel Dashboards

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-financial-modeling.svg" alt="Financial Modeling" width="48" height="48" /> Financial Modeling

$1 Trial for 30 days!

Word

PowerPoint

Outlook

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-onenote.svg" alt="OneNote" width="48" height="48" /> OneNote

Teams

Access

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/courses/icon-sharepoint.svg" alt="SharePoint" width="48" height="48" /> SharePoint

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-project.svg" alt="Project" width="48" height="48" /> Project

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-visio.svg" alt="Visio" width="48" height="48" /> Visio

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-automated.svg" alt="Power Automate" width="48" height="48" /> Power Automate

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-powerapps.svg" alt="Power Apps" width="48" height="48" /> Power Apps

<img loading="lazy" src="https://www.myexcelonline.com/wp-content/themes/meo-theme/web/assets/img/menu/icon-forms.svg" alt="Forms" width="48" height="48" /> Forms

$1 Trial for 30 days!

101 Most Popular Excel Formulas

101 Most Popular Excel Formulas

101 Ways to Master Excel Pivot Tables

101 Ways to Master Excel Pivot Tables

101 Ready To Use Excel Macros

101 Ready To Use Excel Macros

Ultimate Debt Repayment Tracker

Ultimate personal finance tracker

Ultimate small Business Bookkeeping tracker

Categories

Tips and Tricks Related Articles

$1 Trial for 30 days!

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Introduction

Formulas

Formatting

Charts

Printing

Formulas

Pivot Tables

Macros & VBA

Data & Analysis

Charts

Formulas

Pivot Tables

Macros & VBA

Power Query

Power Pivot

Data & Analysis

Charts

Power BI

Excel Dashboards

Financial Modeling

OneNote

SharePoint

Project

Visio

Power Automate

Power Apps

Forms