• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel_Factor

Excel Factor Voting Roundup

Excel Factor Voting Roundup

November 7, 2012 by Mynda Treacy

Back in June this year I had an idea to hold an X-Factor style competition where anyone could submit an Excel tip or trick that they were proud of. I didn't know how it would turn out, especially since there was no prize money. All I was offering was the opportunity to share an idea and be …

Read moreExcel Factor Voting Roundup
Excel Factor 21 Hyperlink Triptych

Excel Factor 21 Hyperlink Triptych

October 31, 2012 by Mynda Treacy

These Excel Factor tips were sent in by Zoran Stanojevic of Belgrade, Serbia. Words by Mynda Treacy Zoran has prepared 3 distinct ways we can apply hyperlinks that dynamically update depending on the selection we make. The selection can be controlled with either a data validation list or a spin button form control. Download the …

Read moreExcel Factor 21 Hyperlink Triptych
Excel Factor 20 Custom Number Format Disguise

Excel Factor 20 Custom Number Format Disguise

October 24, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Marc Joannette of Montreal, Canada. Words by Mynda Treacy. Marc's job involves reissuing airline tickets. Part of this process requires a 'reason code' to be selected from a list. So he built a form where you can select a reason from a data validation list and the …

Read moreExcel Factor 20 Custom Number Format Disguise
Excel Factor 19 Dynamic Dependent Data Validation

Excel Factor 19 Dynamic Dependent Data Validation

October 17, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Roberto Mensa of Italy. Words by Mynda Treacy. Data validation lists are a great way to control the inputs to your worksheets and having one list dependent on another is nothing new. I did a post on how to do this using a named range trick. But, …

Read moreExcel Factor 19 Dynamic Dependent Data Validation
Excel Factor 18 Dynamic Hyperlinks and the Magic Hash

Excel Factor 18 Dynamic Hyperlinks and the Magic Hash

October 10, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Jerry Beaucaire of Bakersfield, California. Words by Mynda Treacy Hyperlinks can make navigating your workbooks quick and easy but they (usually) take a bit of work to set up, especially if you use the Excel HYPERLINK Function. Excel HYPERLINK Function syntax =HYPERLINK(link_location, [friendly_name]) link_location is the cell …

Read moreExcel Factor 18 Dynamic Hyperlinks and the Magic Hash
Excel Factor 17 Lookup and Return Multiple Matches

Excel Factor 17 Lookup and Return Multiple Matches

October 3, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Bob Cooke of Lincolnshire, England. Words by Mynda Treacy Last week Bob emailed me with an example of how he uses the INDEX, SMALL, IF and ROW functions to lookup a list and return multiple matches like this:   It’s good timing as I actually had this …

Read moreExcel Factor 17 Lookup and Return Multiple Matches
Excel Factor 16 Dynamic Lookup

Excel Factor 16 Dynamic Lookup

September 22, 2012 by Mynda Treacy

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Words by Bryon Smedley. Enter your email address below to download the sample workbook. Get Workbook By submitting your email address you agree that we can email you our Excel newsletter. Please enter a valid email address. Download the Excel Workbook and …

Read moreExcel Factor 16 Dynamic Lookup
Excel Factor 15 The Lazy Lookup

Excel Factor 15 The Lazy Lookup

September 19, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Kathy Carmel of Santa Barbara, California. Words by Mynda Treacy. Kathy uses Excel’s intersect operator to quickly SUM a cell, or range of cells at the intersection of two ranges. You’re forgiven if you’re thinking I’ve just swallowed a load of Excel syntax, so let me show …

Read moreExcel Factor 15 The Lazy Lookup
Excel Factor 14 Interleave Data from Two Columns into One

Excel Factor 14 Interleave Data from Two Columns into One

September 12, 2012 by Mynda Treacy

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. I have to admit, this problem doesn't come up often, but when it does, this is a very slick way to eliminate hours of retyping or copy/pasting. Suppose you have two columns of data and you want to create a third column of data …

Read moreExcel Factor 14 Interleave Data from Two Columns into One
Excel Factor 13 Handy Tips & Tricks

Excel Factor 13 Handy Tips & Tricks

September 5, 2012 by Mynda Treacy

These Excel Factor tips are from Dr Isaac Gottlieb, professor at Temple University in Philadelphia. Every month Isaac publishes a series of Excel tips at his University website. He offered to share his tips with us….the problem I had was choosing just a few for this post, so feel free to visit his site and …

Read moreExcel Factor 13 Handy Tips & Tricks
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Next

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.