Skip to content

8 Proven Websites To Sharpen Your Excel Skills – Even If You’re New To Excel

Today, I’m going to share 8 websites that data analysts can use to sharpen their Excel skills. 

Learning Excel is an absolute must for working with data today. Fortunately, there are places online where you can learn this invaluable skill – without paying a dime.

These websites will help you:

  • Automate your work
  • Use data to tell stories
  • Be the “go-to” data guru

Unfortunately, so many analysts get stuck in the basics of Excel. They work hard but don’t see results. The reason for that is a lack of practice.

Mastering Excel is hard!

Data analysts that don’t have a firm grasp of Excel won’t do well:

  • Reports are boring
  • Not using shortcuts
  • Struggling with formulas
  • Not able to get their point across

Fortunately, there are free websites for you to learn.

Here they are listed below. Pick one and get started.

1) SSFiddle

The goal of SSFiddle is to make working with spreadsheets as fast and convenient as possible, similar to CodePen and DBFiddle.

Learn more: ssfiddle.com

2) FormulaBoost

Format and analyze Excel formulas to check for errors, validate results, and more.

Learn more: formulaboost.com

3) Excel Exercises

Excel Exercises helps regular people learn Excel as quickly as possible.

Learn more: excelexercises.com

4) Automate Excel

This interactive tutorial will teach you how to use formulas in Excel. It covers the basics of creating formulas, formula shortcuts, named ranges, and more.

Learn more: automateexcel.com

5) W3Schools Excel

Learn Excel on the world’s largest web developer site.

Learn more: w3schools.com/excel/

6) Spreadsheet Center

Practice your Excel formula skills with exercises that you can do straight from your browser

Learn more: spreadsheetcenter.com

7) Excel Formula Beautifier

Beautify or convert Excel formulas to JavaScript. Useful for checking your Excel formulas for syntax errors and stray parentheses.

Learn more: excelformulabeautifier.com

8) Microsoft Official Excel Video Training

Official Microsoft training videos covering main topics with example workbooks included.

Learn more: microsoft.com

Practicing Excel for 30 minutes each day will help keep your data analytics skills sharp.

Check out each of these free Excel tutorial sites, find one that works for you, and get started

Leave a Reply

Your email address will not be published. Required fields are marked *

Tableau & Google Sheets Checklist

This one-page checklist PDF will help you learn how to upload your data into Google Sheets and build an awesome Tableau dashboard without wasting time.

You have Successfully Subscribed!

4 Things For Every Tableau Dashboard Creator

This free 4-page eBook PDF will walk you through the 4 most important steps for creating a Tableau dashboard

You have Successfully Subscribed!

Massive List of Tableau Tools

Tableau is even more powerful with these 20 tools you might not know about. The 2-page PDF includes a description and helpful links for each tool to get you started.

You have Successfully Subscribed!

Career Boosting Business Analytics Trends

Use this list as a road map to take you from boring data job to the GO-TO PERSON in your company that knows the answers to all the questions.

All set! Check your email :)

Massive List of Free Data Viz Books

List of 10 Awesome Data Visualization Books

All set! Check your email to download.

Tableau Dashboards
Beginner’s Guide

Get the full 2-page PDF with the 5 steps outlined in this guide + 3 bonuses to help you along the way

BONUS #1: 5 Beginner mistakes to avoid

BONUS #2: Video walkthrough

BONUS #3: Links to the the Google Sheet and final Dashboard

All set! Check your email :)

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Massive List of Tableau Web Data Connectors

Download the list of 21 different Web Data Connectors for Tableau in this Google Sheet (save a copy for yourself, too!) 

All set! Check your email :)

Slope Graph Examples PDF + Dashboard Walkthrough Video

4-page PDF showing 10 slope graph examples + a video walkthrough

All set! Check your email to download the bonus materials.

Tableau Tutorial Chart Redesign

Download the Tableau Tutorial PDF Checklist & Workbook

The step-by-step checklist for fixing busted charts with Tableau PLUS the full workbook with all of my formatting and calculations for free.

All set! Check your email to download.

Download the TableauHighlight Tables PDF Guide

The step-by-step guide for creating Tableau highlight tables
(plus direct links to the YouTube video walkthrough and link to final Tableau workbook)

You have Successfully Subscribed!

Tableau Scatter Plots: The Complete Guide

Get the step-by-step checklist guide to create scatter plots with Tableau

 

All set! Check your email :)

Rebuild a Busted Chart with Tableau

Enter your best email to get the PDF version of this tutorial + the companion Tableau workbook for free

All set! Check your email to download.

Download the Bonus Materials

Enter your best email to get the PDF checklist version of this guide and the companion Tableau workbook for free.

All set! Check your email :)