Hello everyone and welcome to

The Excel Challenge

Watch all my videos and download my files for free!!!

Go to YouTube Channel

TECH-018

Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel

Watch Video Download File

TECH-017

Create a presentation in Excel and navigate through it like a website

Watch Video Download File

TECH-016

Create a countdown calendar and combine it with conditional formatting for each task

Watch Video Download File

TECH-015

Count total days by day of the week in a calendar in Excel

Watch Video Download File

TECH-014

Create a progress tracker with check boxes in Excel

Watch Video Download File

TECH-013

Create a bar chart with conditional formatting in Excel

Watch Video Download File

TECH-012

Create links in Excel to places within and outside of your spreadsheet

Watch Video Download File

TECH-011

Create a calendar in Excel that automatically updates colors by event category

Watch Video Download File

TECH-010

Fill several blank cells (empty cells) all at once

Watch Video Download File

TECH-009

Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically

Watch Video Download File

TECH-008

Create a bar chart with stacked images

Watch Video Download File

TECH-007

Create a survey in Excel using Option Buttons (also known as Radio Buttons)

Watch Video Download File

TECH-006

Create a list that automatically sorts data (alphabetically) as you enter data in Excel

Watch Video Download File

TECH-005

Create a quick and simple Time Line (Gantt Chart) in Excel

Watch Video Download File

TECH-004

Calculate total days between two dates in Excel

Watch Video Download File

TECH-003

Insert images in comments in Excel

Watch Video Download File

TECH-002

Find a value in intersecting rows and columns in Excel

Watch Video Download File

TECH-001

Compare data in charts selecting values from dropdown menus

Watch Video Download File