Search Results

Here's what we found

38 results for: excel courses

Excel VBA Data types, DIM & SET (Learn to use them correctly)

If you like to create efficient Excel macros, it’s important to assign the correct data type to each variable. In this tutorial find out why you need to use the DIM statement and when you should use SET instead.

All Tutorials in One File at XelPlus

Free Excel Tutorials (Power Query Hack Included)

Find the links to helpful and free Excel tutorials all in one place. These include videos, articles and downloadable Excel files. Whenever you get stuck, refer to this list.

Reset Dependent Drop-down in Excel

Excel data validation dependent drop-down values don’t automatically reset once you change the value of the first drop-down. Learn how to quickly reset this with a tiny bit of VBA.

Excel VBA IF THEN Statement (and a useful tip)

Learn one of the most useful statements in VBA (or any programming language, really): If Then. Once you master If, Then, Else, Elseif and And, you will be able to write Excel macros that are dependent on multiple conditions.

How to Add Up and Down Arrows to Your Excel Tables for Better Readability

Create better Excel Dashboards and Tables by adding up and down arrows that are conditionally formatted to highlight change.

Quick wins with ChatGPT

Quick Wins with ChatGPT

Uncover How ChatGPT Can Transform Your Workday! Discover a smarter way to work with Artificial Intelligence.

Automate With Power Query – Recipes to solve business data challenges

Do you want to become more confident using Power Query and automate your entire data workflow? Join this course and learn from real-world scenarios.

Financial Modelling in Power BI (eBook)

You’d like to create financial models in Power BI? This eBook will teach you how. Download the templates and get started today!

Google Sheets course cover

Google Sheets – The Comprehensive Masterclass

Master the Powerful Features of Google Sheets from data collection, automation to proper data analysis and visualization. This course will teach you everything you need to know about Google Sheets. Plus you’ll benefit from our EXCLUSIVE bonuses.

Learn Financial Analysis Course cover

Fundamentals of Financial Analysis

Whether you’re a newbie or have an MBA in Finance, you’ll FINALLY “get” the big picture.
This comprehensive course will equip you with these critical skills – even if you’ve never taken a finance or accounting class.

Power BI course image

Fast Track to Power BI

Stay ahead of the game in 2023.
Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional.
This course gets you started in Power BI – Fast!

Complete Guide to Microsoft Teams

This free training is your complete guide to Microsoft Teams. You’ll learn how to hold online meetings, schedule meetings, use channels, chat and upload files. Bookmark it for future reference.

Free Guide!

The ONE Critical Excel Skill You Need in 2023

This free QuickStart guide will help you to:

  • Pinpoint the skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill