Half Day Courses

We developed 6 New Half Day courses that are in great demand, employees will be able to perform their regular work tasks and spend only 3 hours on their professional development. These courses are:

  • Data Validation is a Game Changer
    In this course clients learn that data validation can do a lot more than just creating drop lists. We also learn how to create multiple dependent drop lists, Searchable Drop lists and Reducing Drop Lists. How to deal with errors in Drop lists and allow editing. We’ll be also creating a Chart Drop list, Functions drop list and Slicer Drop list.
  • Conditional Formatting with Formulas:
    1. Format the Highest/Lowest Value in a Row/Column
    2. Highlight the Amount when Transactional Date meets Criteria
    3. Highlight a record based on Sales Criteria
    4. Create alternating colors in rows or columns in a range
    5. Highlight the record containing Sample Text
    6. Highlight the cell containing Intersecting values
    7. Display only Values with “No” or “Yes”
    8. Conditional Formatting with Date Math.
  • Mastering Date Math in Excel
    In this course you learn how to use and combine over 20 different date functions in Excel. Extremely useful for any Excel user specially Administrative, Accountants, Payroll, HR. In this course we create a project from ground up using Date functions combined with other functionalities.
  • Index and Match in Depth
    These are very popular and powerful functions in Excel, working together they create a dream team. Let’s explore what these amazing functions can do and how they serve as utility functions to charting and dashboards.
  • New Dynamic Array Functions
    If you are using Office 365, then you have access to the new calculation engine of Excel and the amazing dynamic array functions.
    in this course we explore some of them:
    Filter, Unique, Sort, Sequence, Randarray, Xlookup, Let functions … and more
  • Charting …Deep Dive
    In this course we learn about the advanced charting techniques. We create and format different types of charts. We switch charts using functions , drop lists and slicers.
VSTACK or PYTHON for Combining Tables

VSTACK or PYTHON for Combining Tables

Table of Contents Download your Exercise file by clicking the button below Download Exercise file Th...

Power Query Trick For Combining Files Without Renaming Table

Combining Files with Inconsistent Headers- No Mapping Table We have multiple files in a folder. Each...

The SCAN Function – How To Use It?

How to use the SCAN Function? Table of Contents Introduction 1 Arguments of the SCAN Function: 2 Let...

The Golden Shortcut of Excel

The ONLY Shortcut that opens 20 Different Dialog Boxes. Are You An Excel Enthusiast Looking To Maxim...

Progressive Data Bar For Your Tasks

Table of Contents If you have a list of tasks for any project, or a long To-Do list it’s good ...

Create Awesome Dynamic Charts with Reactions

Creating impressive charts with reaction labels can greatly enhance your data visualization. In this...

Intelligent Drop Lists and Evolution of Data Validation

New Intelligent Drop List in Excel Table of Contents Introduction 3 The Work Situation 3 The Old Met...

Coaching Sessions (Code:77000)

Brand New Course Exclusively by Office Instructor Coaching sessions in Excel for small groups of cli...

Excel for Job Promotion or Job Interview (Code:66500)

Brand New Course Exclusively by Office Instructor Excel knowledge is highly beneficial for job promo...

Build Your Own Custom Course by Selecting Topics (Code:66000)

Brand New Course Exclusively by Office Instructor You can customize your Excel course the way you li...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.