Loading...

Follow My Online Training Hub on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Creating a reducing Data Validation list is easy with the new dynamic array formulas. Let’s say we have a list of jobs currently in ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
My Online Training Hub by Philip Treacy - 6d ago
Typically if you need to lookup a value from a table you'd employ VLOOKUP or INDEX/MATCH. However if your data looks like this and you ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
My Online Training Hub by Mynda Treacy - 1w ago
Excel Goal Seek is another tool in the What-if Analysis suite on the Data tab of the ribbon. Goal Seek will find the value required to ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Dates and times are stored in Excel as decimals known as serial numbers. The date is represented by the whole number part of the serial ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
My Online Training Hub by Mynda Treacy - 3w ago
Excel Data Tables are one of the What-if Analysis tools that we have available to aid our decision making. They don't require knowledge of ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Following on from my Introduction to PowerApps and Excel, this post looks at some customizations we can do to our app. PowerApp Themes ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
What are PowerApps? Microsoft describe PowerApps as a suite of apps, services, connectors and data platform that provides a rapid ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Charting survey data can be tricky, and when you want a segmented survey data chart it adds another layer of complexity. Bart sent me the ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
My Online Training Hub by Mynda Treacy - 2M ago
Year on year charts or data over time is one of the most common data visualisations you’ll see. However, the message conveyed depends on ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview