A collection of thoughts through personal stories, experiences and shared content.
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.
A look at the following formulas:
We will also talk about nesting formulas (formulas within formulas).
Continuing on with everything Pivot Tables!
Note: First Pivot Tables video is at https://iqu.iqmetrix.com/blog/excel-tip-pivot-tables
An introduction to what could be your next best friend, Pivot Tables! In a nutshell, Pivot Tables quickly analyze data. Have fun!
A look at some of the most used aggregation (sum, count, and average) formulas and their different variations.
Demonstrations of:· Freezing Panes· Windows and Arrangement· Auto-fill Data· Text to Columns· Removing Duplicates
Back to the basics with a demonstration of worksheets and quick dive into tables and how beneficial they are when working with data.
A quick look at shortcuts, navigating through your data and other quick copy functions.
A look at the IF statement, as well as using the "not exact" matching type for VLookup and the XLookup.
The new XLookup function and the difference between this new function and the now legacy VLookup (or the more unpopular HLookup).
Work From Home
What We're Learning
Tell us a little bit about yourself and you'll never miss out on exciting training content and news from iQUniversity.