Create dynamic, interactive Charts with Microsoft Excel Offset Function.

What is the OFFSET() Function

Description

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single c...

As many of you know, I recently released a new course on working with Advanced Excel Formulas using the built in Index() and Match() functions. This course covers the basics of working with Advanced Formulas and builds into real world examples of working with two very...

It's May 22nd, only 9 more full days to participate in the Microsoft Office Specialist Practice Exam contest.

HOW TO PARTICIPATE

A quick reminder, all you need to do is...

• Watch at least 20 lectures in the course of your choice.

  • Master Microsoft Word Beginner...

It's that time again. Time for another Microsoft Office Specialist Practice Exam contest. I've run a few of these contests before and given away several free Microsoft Office Specialist Practice exam vouchers. These vouchers give you access to a practice exam for one o...

2018 is about you! Take all the time and knowledge you invest learning the Microsoft Office applications and get certified and let me continue helping you do this. All you need to is participate in the contest for a chance to win!

HOW TO PARTICIPATE

Participating in the...

The technique of NESTING Microsoft Excel functions within one another allows for more dynamic and powerful formulas.

I got an excellent question the other day, in one of my Excel courses on Udemy, asking how to look up the largest value in a column, then return an assoc...

Microsoft Excel offers many ways to work with and analyze your data. There are loads of functions to calculate and lookup data, charts to visualize, PivotTables to quickly summarize and much more. These features, and more, combine to make Microsoft Excel a very powerfu...

I'm excited to announce that I have a new Microsoft Excel course in the pipeline. I plan on having it released before the end of Oct. 2017, called...

Microsoft Excel Data Analysis and Dashboard Reporting

Below are the first few videos introducing the course and what you...

Its time for another CONTEST!

I’ve been getting a lot of students in my Udemy courses sending me message expressing interest in taking one of the Microsoft Office Specialist exams (MOS). So, I’ve decided to run a contest to help and inspire those interested. Whether you...

Got another great question from a student in my Excel VBA UserForms course on Udemy.

QUESTION:

I have built and Excel UserForm that allows users to interact with worksheets within a workbook. I don’t want the users to interact with the worksheets directly. How can I hide...