• 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 Absolute References $ – The Missing Link

You are here: Home / Excel Formulas / Excel Absolute References $ – The Missing Link
September 24, 2010 by Mynda Treacy

Once you uncover the mystery of Absolute References, copying and pasting formulas becomes child’s play.

You might have seen cell references in formulas surrounded by ‘$’ signs. For example $D$3:$D$10.  What’s that all about?

Excel Absolute References

Well, the ‘$’ before the column or row reference instructs excel to keep the reference absolute.  Huh, I hear you say.  Ok, I’ll explain in English.

Looking at the table below we have a Commission Rate of 3% in cell G3.  In column E we want to calculate the commission as Total $k x Commission Rate 3%.

Excel Absolute References

I could simply enter the formula as =D3*3% and copy it down column E, but there are two problems with this that make it not ideal:

1)      I can’t easily see what the Commission Rate is without looking in the formula bar.  I could put it as part of the column heading e.g. ‘Commission $ @ 3%’, but that makes my heading bigger than it needs to be, and if I change the rate at a later date I have to go back and change the heading too, which is easily overlooked.

2)      If I change the rate I need to change the formula and copy it down the column again. Ok, so it might only take a few seconds to do this, but if you’re playing with scenarios and you want to change the rate a few times to see what the results are it’s much quicker and easier to just type a new figure in cell G3 and let Excel do the work to change the formula.

So assuming I’ve convinced you that referencing one cell for the commission rate is the best method let’s look at how absolute references work.

Absolute Reference example

First let’s look at what happens if you don’t use an absolute reference.  If you entered in cell E3 the formula =D3*G3 you would get the correct answer.  But if you were to copy that formula down the rest of column E Excel would dynamically update the formula to increase by one row as it goes down the page.  You can see this to the left where the reference to G3 goes G4, G5, G6 and so on.

How Absolute References Work in Excel

What we want Excel to do is dynamically update the cell reference to column D, but to keep the Commission Rate reference on cell G3. To do this we would use the ‘$’ signs to instruct Excel that this is an absolute reference, like this =D3*$G$3. Then when we copy the formula down the column it will be entered like example on the left here.

Other ways to use absolute references

  • Make a whole range of cells an absolute reference: $D$1:$F$1
  • Make only the column absolute $D3
  • Make only the row absolute D$3

As you can see in the examples above, whatever the ‘$’ sign prefixes is absolute. i.e. as you copy the formula anywhere in the spreadsheet the reference prefixed by the ‘$’ sign will not change.

Shortcut to entering Absolute References

The magical F4 key instantly enters the ‘$’ signs for you.  You can do it while you’re building your formula, or you can go back and edit the formula and enter them.  Of course you can also type them in but it’s quicker to use F4.

Let’s look at the different ways you can enter absolute references using the F4 key in more detail

1)      While you’re building your formula; as you can see below I have started to type a formula into the cell E3.  I have just selected cell G3, as you can see by the marching ants (dashed line) surrounding the cell.

How to enter Absolute References

At this point, before I press enter to finish the formula, I can press the F4 key and Excel will automatically put the ‘$’ signs around G3 for me like this.

F4 key shortcut

2)      Or I can go back to a cell at any time and press the F2 key to edit the cell.  I can then put my cursor anywhere in the cell reference I want absolute and press F4. See below.

F4 key editing shortcut

3)      If you want to absolute a range you have to highlight the cell range like the example below before pressing F4.

applying absolute references

4)      The above examples show you how to apply an absolute reference to the column and the row, but if you keep pressing F4 Excel will scroll through your options. Using =D3*G3 as an example, I want to absolute G3:

a.       With the first press of F4 you will get =D3*$G$3

b.      With the second press of F4 you will get =D3*G$3

c.       With the third press of F4 you will get =D3*$G3

d.      With the fourth press of F4 you will get =D3*G3

So, now you know how Absolute References work in Excel, and how to apply them quickly using the F4 key, you can start to build better spreadsheets that you can dynamically update.

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the workbook to practice here. Note: This is a .xlsx file. Please ensure your browser doesn't change the file extension on download.

TIP: Right-click the link and save the file

More Excel Formulas Posts

ai-aided excel formula editor

AI Aided Excel Formula Editor

Save time with this free AI Excel formula editor add-in that writes, edits, improves and interprets formulas for you!
top excel functions for data analysts

Top Excel Functions for Data Analysts

Must know Excel Functions for Data Analysts and what functions you don’t have to waste time learning and why.
excel advanced formula environment

Excel Advanced Formula Environment

Excel Advanced Formula Environment is a long awaited, new improved way to write, name and store Excel formulas.
Pro Excel Formula Writing Tips

Pro Excel Formula Writing Tips

Must know Excel formula writing tips, tricks and tools to make you an Excel formula ninja, including a new formula editor.
excel shaping arrays

New Array Shaping Excel Functions

The Excel Shaping Array Functions makes it easier than ever to reshape arrays and ranges using these purpose built functions
excel nested if functions what not to do

Excel IF Formulas and What Not To Do

Excel IF formulas can get out of hand when you nest too many IFs. Not only do they become unwieldy they’re difficult for anyone to understand
excel image function

Excel IMAGE Function

The Excel IMAGE Function enables you to embed images in a cell using a formula. It supports BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP files

Excel VSTACK and HSTACK Functions

New Excel VSTACK and HSTACK functions makes combining arrays of cells easy and with some clever tricks we can extend their capabilities.
identify overlapping dates and times in excel

Identify overlapping dates and times in Excel

How to identify overlapping dates and times in Excel with a formula that checks a range of cells. Works with Dates and Times.
New Excel Text Functions

TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions

TEXTAFTER, TEXTBEFORE and TEXTSPLIT are exciting new Excel Text functions. They’re fairly self-explanatory, however TEXTSPLIT has some cool features.


Category: Excel Formulas
Previous Post:vlookup sorted list formulaExcel VLOOKUP – Sorted List Explained
Next Post:Excel’s IFERROR Puts an End to Messy WorkaroundsIFERROR Function

Reader Interactions

Comments

  1. Kee Wei Kiat

    November 14, 2018 at 3:14 pm

    May i know how i can make the @ in the formula? any step to use it as i try copy to new file but its not working as previous file
    =IF([@IBO]>0,[@IBO]/90,IF([@PL]>0,[@PL]/180,0))

    Reply
    • Catalin Bombea

      November 14, 2018 at 3:47 pm

      Hi,
      If you intend to use the formula in a different file, you need to have the table name in front of the column reference: Table1[@IBO]
      Be careful that @ refers to the current row context from that table, it does no have the same meaning if used in another file.

      Reply
  2. Farid Ahmed

    October 17, 2018 at 3:59 pm

    Thanks A lot for Such a great help, by running this Forum.

    Excel was never too easy for me to understand before that.

    Reply
    • Philip Treacy

      October 17, 2018 at 4:06 pm

      You’re welcome.

      Reply
  3. Lisa Gadonniex

    March 24, 2018 at 8:35 pm

    Hi I’m having a hard time trying to write this formular. I have written it out they way I want it in the formular.

    If job # equals “120” then add “Accrual Amount” to “Remaining 2017 Accrual Amount” if Job # equals “120/invoice” then subtract “invoice amount” from “Remaining 2017 Accrual Amount”

    Is this something you can help with?

    Reply
    • Catalin Bombea

      March 26, 2018 at 2:03 pm

      Can be something like this, in a new column:
      =IF(A1=120,B1+C1,IF(A1=”120/invoice”,C1-D1,”Other case”))
      I assume that column A has job #, Column B has Accrual Amount, column C has Remaining 2017, Column D =invoice amount, change the references to point to the real location.
      You can also try our forum, you can upload there sample files if you want.
      Cheers,
      Catalin

      Reply
      • Lisa Gadonniex

        March 27, 2018 at 10:37 am

        Thanks Caitlin. I will try this.

        Reply
  4. Karen Fourie

    January 12, 2018 at 3:36 pm

    Thank you for these wonderful explanations. I really enjoy your Excel tutorials. So glad I found your website.

    Have an awesome day

    Reply
    • Mynda Treacy

      January 13, 2018 at 12:32 am

      Glad you found it helpful, Karen 🙂

      Reply
  5. Paul Danville

    November 18, 2017 at 1:25 pm

    very well done easy to follow thanks for the help

    Reply
    • Mynda Treacy

      November 18, 2017 at 3:57 pm

      Glad I could help, Paul.

      Reply
  6. musadiq hussain

    September 26, 2017 at 3:05 am

    excellent,easy to follow thanks

    Reply
    • Mynda Treacy

      September 26, 2017 at 8:39 am

      Cheers, Musadiq! Glad you liked it 🙂

      Reply
  7. Sam

    April 25, 2017 at 8:36 am

    Excellent walk-through, easy to follow. Thank you.

    Reply
    • Mynda Treacy

      April 25, 2017 at 9:52 am

      Thanks, Sam!

      Reply
  8. John J Gordon

    December 21, 2016 at 6:59 am

    Thanks, I will learn Excel with your help. The workbooks are great so you can instantly practice what you have just reviewed.

    Reply
    • Mynda Treacy

      December 21, 2016 at 8:34 am

      Glad we can help, John.

      Reply
  9. Anand Kumar

    December 3, 2016 at 5:01 pm

    Great Explanation Mynda.

    But I just curious to know that why sign $ only adopted to make freeze. why not any other sign like @.

    Reply
    • Mynda Treacy

      December 3, 2016 at 7:41 pm

      Hi Anand,

      I have no idea why the dollar sign was chosen to set absolute. I suspect it dates back to Lotus 1-2-3. Microsoft may have copied how it worked since Excel came after Lotus 1-2-3.

      Mynda

      Reply
  10. Peter Githinji

    November 5, 2016 at 4:49 am

    Thank you so much Mynda, you are God sent.

    Reply
    • Mynda Treacy

      November 5, 2016 at 5:12 am

      Glad I could help, Peter.

      Reply
  11. Kathleen Beazley

    October 28, 2016 at 11:17 am

    Thoroughly enjoyed working out Absolute references 🙂 thank you

    Reply
    • Philip Treacy

      October 28, 2016 at 11:19 am

      You’re welcome Kathleen.

      Reply
  12. jarwanna

    October 18, 2016 at 2:38 am

    =$E6/15-MAX(H$1:J4) help!!!!!!!!

    Reply
    • Mynda Treacy

      October 18, 2016 at 11:32 am

      Help with what, Jarwanna?

      Reply
  13. Ernest

    September 13, 2016 at 8:58 am

    Hi Mynda,
    I visited your website today and found it very educative and interesting. I now understand what is absolute reference. Thanks

    Reply
    • Philip Treacy

      September 13, 2016 at 9:32 am

      You’re welcome Ernest, glad you found the site useful.

      Reply
  14. Ahmed Nasry

    February 13, 2016 at 7:21 pm

    the following link is not working:

    https://www.myonlinetraininghub.com/wp-content/moth-practice-files/Excel_Blog_Workbooks.xlsx

    Reply
    • Philip Treacy

      February 13, 2016 at 7:59 pm

      Hi Ahmed,

      The link is ok, it’s probably your browser not downloading the file properly.

      Please try right-clicking the link and then ‘Save As’ or ‘Save target’ to save the file.

      Regards

      Phil

      Reply
  15. Liezel Enriquez

    October 26, 2015 at 4:30 pm

    Amazing. Please continue to give me updates.
    This would be a big help for me. 🙂

    Reply
  16. iqbal hussain

    April 20, 2015 at 4:49 pm

    dear madam how can get the tutorial videos of practice workbook, I m facing some problem while practicing

    Reply
    • Mynda Treacy

      April 20, 2015 at 7:30 pm

      Hi Iqbal,

      This tutorial doesn’t come with a video but you can download the workbook from the link towards the bottom of the post.

      Kind regards,

      Mynda

      Reply
  17. Rachana

    February 11, 2015 at 12:04 am

    The link – Download the workbook to practice here. does not open anything. Please can you advise the step.

    Reply
    • Mynda Treacy

      February 11, 2015 at 8:51 am

      Hi Rachana,

      You need to right-click the link and choose ‘File Save As’ or the equivalent for your browser. Make sure when you save the file that the file extension is .xlsx and then once downloaded you can open it like any other Excel workbook.

      Kind regards,

      Mynda

      Reply
  18. adam junkeer

    October 10, 2014 at 9:28 pm

    When i write formula instead of total it is showing Date in the cell how can i fixed this.

    Reply
    • Mynda Treacy

      October 11, 2014 at 8:19 pm

      Hi Adam,

      There are a few reasons for this:

      1. the cells are already formatted as a date – you can change it by pressing CTRL+1 and then on the ‘Numbers’ tab select a different number format, or use the Number formatting on the Home tab of the ribbon.

      2. If adjacent cells are formatted as a date Excel will think you want the same formatting and automatically apply it for you.

      3. If your formula references cells formatted as dates it will format the formula result as a date automatically.

      I hope this explains the reasons and you can figure out the best solution.

      Kind regards,

      Mynda

      Reply
  19. savita r

    October 9, 2014 at 5:15 pm

    g8t to see your blog. its awesome. help me lot to understand the absolute references. i will share this my friends. Can you provide free more advanced excel training.

    Reply
    • Mynda Treacy

      October 9, 2014 at 9:46 pm

      Hi Savita,

      Great to hear you found it useful. There are plenty more advanced tutorials on our Excel Blog.

      Cheers,

      Mynda

      Reply
      • savita r

        October 9, 2014 at 11:06 pm

        Hello Myndra,

        Thank’s a lot again for your prompt response.

        Kind Regards
        Savi

        Reply
        • Philip Treacy

          October 10, 2014 at 12:40 pm

          You’re welcome

          Reply
  20. Nagraj K V

    August 7, 2014 at 2:38 am

    Thank you… very kind of you…

    Reply
    • Mynda Treacy

      August 7, 2014 at 7:27 am

      You’re welcome, Nagraj.

      Reply
  21. maggie pont

    May 28, 2014 at 1:04 pm

    Always sensational

    Every group I train, I refer them to your web site.

    Kind regards

    maggie

    Reply
    • Mynda Treacy

      May 28, 2014 at 1:09 pm

      Wow, thanks Maggie 🙂

      Reply
  22. rahul

    May 8, 2014 at 11:33 am

    Thnx…its a nice tutorial…

    Reply
    • Mynda Treacy

      May 8, 2014 at 11:37 am

      Cheers, Rahul.

      Reply
  23. George Mousavi

    February 21, 2014 at 4:26 pm

    I really enjoyed reading your blog.

    Reply
    • Mynda Treacy

      February 21, 2014 at 8:48 pm

      Cheers, George 🙂

      Reply
  24. Dell

    February 11, 2014 at 6:38 am

    I read your article regarding drop-down boxes and absolute validations. I didn’t quite get it. I have a formula in the SOURCE box of the Data Validation field that keeps moving with the subsequent boxes in the column. My formula is =data!A1:A12. My goal is to have that value in every cell of the column. When I check “apply these changes” it cuts off A1 and only leaves A2-A12 in the cell. The next cell cuts off A2 leaving A3-A12 and so on. I put in a new formula =data!$A1:$A12 (absolute reference) and it did the same thing! I don’t know what I’m doing wrong. Can you assist?

    Reply
    • Mynda Treacy

      February 11, 2014 at 9:56 am

      Hi Dell,

      There are two components to every cell/range reference that you can absolute which are the Column reference and the Row reference.

      The reference $A1 only has the column reference absolute i.e. the $ sign is before the A, where as A$1 only has the row reference absolute. If you want to absolute everything then you need to put the $ sign before both the column and row references like this: $A$1.

      Likewise when referencing a range: $A$1:$A$12

      Let me know if you get stuck.

      Kind regards,

      Mynda.

      Reply
  25. Patty

    August 4, 2013 at 2:20 am

    I know a few excel basics, am trying to learn more. I am confused about the formula above using the absolute value. It looks like the running total will be the sum of the first number(the absolute value) and the last value entered. Skipping the ones in between. What am I missing?

    Reply
    • Mynda Treacy

      August 4, 2013 at 3:56 pm

      Hi Patty,

      I’m not sure which formula you’re referring to. Can you please clarify.

      Cheers,

      Mynda.

      Reply
  26. khalid

    July 2, 2013 at 5:11 pm

    Dear Sir,

    Thx a lot for such informative mails.May GOD bless you.It help me a lot.

    Reply
    • Mynda Treacy

      July 2, 2013 at 8:16 pm

      You’re welcome, Khalid 🙂

      Reply
  27. ahsan

    April 27, 2013 at 1:23 am

    Hi

    thanks for the nice article.

    I understand that absolute reference can be added to each cell using F4. But is it possible to convert more then one cell to absolute reference at the same time / simultaneously. cause i have a column of cells which are linked to cells on another sheet and i want to convert them to absolute reference

    Reply
    • Mynda Treacy

      April 27, 2013 at 9:00 pm

      Hi Ahsan,

      You can convert a whole formula to absolute by first selecting the whole formula while in edit mode and then pressing F4, but you can’t absolute more than one formula at a time.

      Kind regards,

      Mynda.

      Reply
  28. Jay Jain

    April 3, 2013 at 1:34 pm

    Thank you. very well illustrated and explained.

    Reply
    • Carlo Estopia

      April 4, 2013 at 11:31 am

      Hi Jay,

      On behalf of Mynda,
      You’re welcome!

      Cheers,

      CarloE

      Reply
  29. Narasimha Rao

    December 21, 2012 at 3:23 am

    Really I Got a good friend thats you. After learning the lessons of Excel from you I got good name in my Department, while applying the formulas teaching by you. In view of this I won’t leave you upto learnt about the Excel completely. Do you give support to my interest?

    Reply
  30. Mahipal Singh

    December 14, 2012 at 2:40 am

    it helped me a lot. it really makes everything easiest.
    thanks for the great help…

    Reply
    • Mynda Treacy

      December 14, 2012 at 9:58 am

      You’re welcome, Mahipal 🙂

      Reply
  31. patricia

    November 1, 2012 at 8:48 pm

    i just love how you teach..thank you.. and God bless..

    Reply
    • Mynda Treacy

      November 2, 2012 at 9:50 pm

      🙂 wow. Thanks, Patricia.

      Reply
  32. Kumar Subramanian

    August 17, 2012 at 3:27 am

    I have no word to express my gratitude towards your service free service to those aspiring in this field. Receive my kudos.

    Reply
    • Mynda Treacy

      August 17, 2012 at 3:05 pm

      Thanks, Kumar 🙂

      Reply
  33. Kumar Subramanian

    August 17, 2012 at 3:24 am

    I have no word to express my gratitude. very good effort towards the humanity. Those who wanted to strive hard in this ms excel need not do any more like that but very easily they can prolong their work in this chapter because your spoonfeeding worksheets.

    Reply
  34. Ramamoorthy

    June 5, 2012 at 9:29 pm

    The tip is simple and easy to understand.
    Thank you
    Ram

    Reply
    • Mynda Treacy

      June 6, 2012 at 2:52 pm

      Thanks. Glad you liked it 🙂

      Reply
  35. Agatha Amadhila

    May 4, 2012 at 8:07 pm

    Huh, it was so wonderful to have a new knowledge of an F4 trick. It really helped me. am going to write my test on the excel, am certain I will pass

    Thanks for your help

    Reply
    • Mynda Treacy

      May 4, 2012 at 9:00 pm

      Thanks Agatha. Glad you liked it.

      Good luck with your test 🙂

      Kind regards,

      Mynda.

      Reply
  36. Bill

    May 3, 2011 at 12:11 am

    I didn’t know about the F4 trick, but the tutorial was a good review. I always like to know how to use functions that have real examples. Keep it up.

    Reply
    • Mynda

      May 3, 2011 at 1:41 pm

      Thanks, Bill. Glad you liked it 🙂

      Reply
  37. Click here

    November 26, 2010 at 12:26 pm

    Nice article and i want to know more on this blog.

    Reply
  38. aparadekto

    October 26, 2010 at 1:25 am

    = Comment moved into Tech Support =

    Reply
    • Philip Treacy

      October 26, 2010 at 8:11 pm

      Hi,

      Thanks for your comment aparadekto

      If you have any other technical questions or issues please use the Contact Us form or the Helpdesk to let us know.

      Regards

      Phil

      Reply
      • Philip Treacy

        November 1, 2010 at 12:08 pm

        Hi apardekto,

        Upon investigation it may be that you have “Fit to width” turned off in Opera.

        If you are seeing text beside the large images above, or text in tables, like on the the syllabus pages running together or overlapping, please click at the bottom right of your Opera screen and make sure “Fit to width” is turned on.

        Regards

        Phil

        Reply
  39. Janine

    September 29, 2010 at 1:31 pm

    I feel so silly I didn’t know about this before. thanks for the workbook download it made it much clearer

    Reply
    • Mynda

      September 29, 2010 at 8:25 pm

      You’re welcome @Janine. I’m glad it helped you out.

      Reply

Trackbacks

  1. Microsoft excel conditional formatting explained with examples says:
    January 12, 2011 at 9:02 pm

    […] absolute reference for column F is instructing Excel that the conditional format is dependant on column F.  If you […]

    Reply
  2. Excel Running Total Formula says:
    November 30, 2010 at 7:45 pm

    […] Use a SUM formula with a combination of absolute and relative references. […]

    Reply
  3. Excel HLOOKUP Formulas Explained says:
    November 28, 2010 at 4:11 pm

    […] Note: you’ll notice the table range I1:P2 has dollar $ signs around it.  For more on this read my previous tutorial on absolute references. […]

    Reply
  4. Excel Drop Down Lists says:
    November 21, 2010 at 11:13 pm

    […] the validation to any other cells the reference remains on your list.  If you aren’t sure how to make the reference absolute, let Excel do it for you by clicking in the Source box, then with your mouse, highlight the range […]

    Reply
  5. Excel 2007 – AND and OR Functions Explained says:
    October 2, 2010 at 9:31 pm

    […] For more on Absolute References go here (they’re the formulas with the $ signs in the cell reference e.g. $H$1) […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

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.