Excel tips

Must-Know Excel Functions to Increase Your Productivity (3 of 3)

Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master.

Must-Know Excel Functions to Increase Your Productivity (2 of 3)

Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master.

Must-Know Excel Functions to Increase Your Productivity (1 of 3)

Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master.

Development Approach and Lifecycle Selection

In this seminar, we will dive into the Project Management Institute’s (PMI’s) PMBOK® Guide Seventh Edition to examine the Development Approach and Life Cycle Performance Domain and how our understandi...

Excel Power Query & Dashboards – 3 of 3

In this session we cover calculations without formulas, Append & Merge Queries, convert a single text string into multiple rows, and unpivot.

Excel Power Query & Dashboards – 2 of 3

In this session we cover calculations without formulas, Append & Merge Queries, convert a single text string into multiple rows, and unpivot.

Excel’s Advanced Data Tools: From GETPIVOTDATA to Calculated Fields

Excels GETPIVOTDATA and Calculated Fields are powerful tools for data analysis. Learn how GETPIVOTDATA ensures accurate data extraction from pivot tables, and how Calculated Fields allow you to create...