| My iQU Browse Watch Read Coaching Log in

A collection of thoughts through
personal stories, experiences and shared content.

Excel Tip: Intro to Macros

excel jonathon l Apr 21, 2020
 

An introduction to macros and why you need them in your life! We will walk through a step-by-step example prepping you for your first macro.

-JL

Continue Reading...

Excel Tip: More Functions and Nesting Formulas

excel jonathon l Apr 13, 2020
 

A look at the following formulas:

  • Len (Length)
  • Right | Left | Mid
  • IF
  • Concat (Concatenate)

We will also talk about nesting formulas (formulas within formulas).

-JL

Continue Reading...

Excel Tip: Pivot Tables Continued

excel jonathon l Apr 07, 2020
 

Continuing on with everything Pivot Tables!

Note: First Pivot Tables video is at https://iqu.iqmetrix.com/blog/excel-tip-pivot-tables

-JL

Continue Reading...

Excel Tip: Pivot Tables

excel jonathon l Apr 03, 2020
 

An introduction to what could be your next best friend, Pivot Tables! In a nutshell, Pivot Tables quickly analyze data. Have fun!

-JL

Continue Reading...

Excel Tip: Basic Aggregation Formulas

excel jonathon l Apr 02, 2020
 

A look at some of the most used aggregation (sum, count, and average) formulas and their different variations.

-JL

Continue Reading...

Excel Tip: Basics

excel jonathon l Apr 01, 2020
 

Demonstrations of:
·       Freezing Panes
·       Windows and Arrangement
·       Auto-fill Data
·       Text to Columns
·       Removing Duplicates

-JL

Continue Reading...

Excel Tip: Worksheets and Tables

excel jonathon l Mar 31, 2020
 

Back to the basics with a demonstration of worksheets and quick dive into tables and how beneficial they are when working with data.

-JL

Continue Reading...

Excel Tip: Navigation Shortcuts

excel jonathon l Mar 30, 2020
 

A quick look at shortcuts, navigating through your data and other quick copy functions.

-JL

Continue Reading...

Excel Tip: IF Statement with XLookup and VLookup

excel jonathon l Mar 27, 2020
 

A look at the IF statement, as well as using the "not exact" matching type for VLookup and the XLookup.

-JL

Continue Reading...

Excel Tip: XLookup

excel jonathon l Mar 26, 2020
 

The new XLookup function and the difference between this new function and the now legacy VLookup (or the more unpopular HLookup).

-JL

Continue Reading...
Close

Keep in touch with iQUniversity

Tell us a little bit about yourself and you'll never miss out on exciting training content and news from iQUniversity.