Course curriculum

    1. Welcome to the FREE Excel Course!

    2. Course Resources (Please Download the Files 🔽)

    1. 4 Ways To Protect Excel Workbooks, Worksheets And Cells

    2. Applying Document Themes in a Workbook

    3. Inserting, Deleting & Hiding Columns and Rows

    4. Navigate between Workbooks Quickly

    1. How to Create a Hyperlink to Other Worksheets

    2. How to Prevent Someone from Unhiding a Worksheet – Very Hidden Property

    3. Hiding Scrollbars in a Worksheet

    4. How to Create and Save Custom Views of a Worksheet

    1. Copy and paste visible cells only (not hidden cells)

    2. Solving the problem with Leading Zero

    3. How to Add Text to a Number

    4. Creating a Conditional Format based on a value

    5. Blocking a User from Interacting Outside a Specific Range

    6. Changing Values without Formulas

    1. The Paste Special Feature

    2. Using Fill Handle to Enter Sequences of Values

    3. Shrink your Pivot Data: Pivot Table Grouping Tool

    4. Using Pick from Drop-down List and Enter Data Quickly

    5. How to Create a Data Entry Form

    6. Highlighting Blank Cells and Sorting Columns with Them

    1. Combine LEFT and FIND Functions

    2. Meet the new FILTER function

    3. Filling Random Values into every cell in a selection

    4. How to Generate Random Decimal Numbers between 0 and 1

    5. How to use COUNTIF and Data Validation to Prevent Duplications

    6. The AutoSum Magic

About this course

  • Free
  • 34 lessons
  • 1.5 hours of video content

Watch the Video for a Quick Overview of the Course

Who is Teaching the Course?

Andreas Exadaktylos

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can. I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.  I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an Online Learning School.  I have a passion for software products that make people's lives easier. I teach Python Programming,  Microsoft Excel and all Microsoft software products for over 20 years. I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies. 

Get the Excel training that builds an unbeatable resume and warp drives your career

View more products

Take Your Career to the Next Level!

Enroll today

Join 60,000+ people who’ve enrolled in our courses

We get it, there are lots of great options to choose from. We’ve got Excel, Power BI, Finance, Python & Gmail courses

  • $19.99

    $19.99Excel Dashboard and Data Analysis Masterclass

    Join Now

  • $19.99

    $19.99Excel Financial Modeling and Business Analysis Masterclass

    Join Now

  • $14.99

    $14.99Excel Macros & Excel VBA Programming for Beginners

    Join Now

  • $19.99

    $19.99Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX

    Join Now

  • $9.99

    $9.99Microsoft Power BI Desktop Masterclass

    Join Now

  • $9.99

    $9.99Excel Charts, Infographics & Data Visualization Masterclass

    Join Now

  • $14.99

    $14.99Python for Absolute Beginners: Learn Python in a Week!

    Join Now

  • $9.99

    $9.99Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners

    Join Now

  • $9.99

    $9.99Gmail Complete Course: 25+ Google email Techniques

    Join Now

"I thought learning Excel Dashboards would take months, but this course broke everything down into simple, actionable steps. Within a week, I was creating professional dashboards that impressed my manager!"

James Carter

Sarah Mitchell

I hesitated because of the cost, but this course has saved me hours every week at work. It’s worth every penny! My reports are now automated, and I no longer spend hours manually updating spreadsheets.

David L.

I was worried that this would be too technical, but the explanations are crystal clear. Even as a beginner, I was able to follow along and create stunning dashboards that make data easy to understand.

Emily Johnson

I didn’t have much time to learn, but this course is structured perfectly. Short, to-the-point lessons made it easy to fit into my busy schedule. Now, my dashboards look better than ever!

Olivia Thompson

I used to struggle with messy, overwhelming spreadsheets, but this course showed me how to turn them into powerful, easy-to-read dashboards. It has completely changed the way I work with data!

Daniel W.

I always thought I needed expensive software to build professional dashboards, but this course proved me wrong. Now, I create dynamic, interactive reports using just Excel—saving my company thousands in unnecessary software costs!

Sophia Martinez

I was skeptical about online courses, but this one exceeded my expectations. The real-world examples and hands-on exercises made it easy to apply what I learned immediately. Now, my reports are not just numbers—they tell a story!

JOIN NOW