Learn 5 Excel Tips for Finance Professionals Today

An introduction to Excel Tips for Finance Professionals on a white and orange background with an illustration.

Do you want to increase your productivity and learn Excel tips for finance professionals? Using Excel is part of the routine for you if you’re like the majority of financial professionals. It is a tool that has been in use for a long time because of how well it can modify, preserve, and show data.

Despite the widespread usage of this application, not all financial professionals are using Excel to its full potential. Also, Excel can dramatically boost your productivity when you utilize a few simple strategies. Here are five Excel tips for finance professionals you should know as a financial expert using this potent tool out of the many beneficial Excel capabilities.

Top 5 Excel Tips for Finance Professionals

Here is a detailed explanation of each of the tips.

#1: Excel Tip for Finance Professionals

How to make a Combo Chart in Excel?

#1: Excel tip: example of a Combo Chart

OFFICE 2019

  1. Select your chart
  2. Then, go to Design in the Excel Ribbon
  3. Select Change Chart Type
  4. After that, Choose Combo
  5. Lastly, click secondary Axis

Example of a Comb Chart in Office 2010

OFFICE 2010

  1. Select one of the series in your chart
  2. Subsequently, right-click “Format Data Series”
  3. After that, select Secondary Axis
  4. Then, right-click again on the series and choose “Change series Chart type”
  5. Choose another chart type

Secondary axis Excel

#2: Excel Tip

Learn how to link a Textbox to a specific cell in two easy steps.

1. Insert the Text Box

  • Click the Text Box button under the Insert tab.
  • Insert a textbox in your worksheet.

#2: Excel tip - Text Box

2. Type Formula

  • Select the text box.
  • Then, go to the formula bar.
  • Type in the “=” symbol.
  • Finally, click on the cell you want to link.

#2: Excel tip - typing Formula

#3: Excel Tip for Finance Professionals

Reporting Figures in thousands and millions.

NEED

  • You have to report figures in thousands or in millions.
  • You are dividing your numbers by 1,000 or 1,000,000 to show your numbers in thousands or in millions.

HOW TO DO IT

  1. Select your cell with the number you want to show in thousands
  2. Afteward, Right-click and select “Format Cells”
  3. The “Format cells” dialog opens
  4. Go to the “Number” view
  5. Then, in the Category, select “Custom”
  6. After that, type or select the following format: #,##0
  7. Afterward, if you want to show thousands, add a comma at the end of the syntax: #,##0,
  8. Furthermore, if you want to show millions, add two commas at the end of the syntax: #,##0,,

EXAMPLE
#3 Excel tip example
Here are some bonus tips:
 #1:

  • If you want to show a k after the figures for thousands, use: #,##0,”k”
  • If you want to show a k after the figures for thousands, use: #,##0,,”m”

#2:

  • If you want to show decimals, use the following format: #,##0.0, (for thousands).

#3:

  • Use this technique to convert your numbers format in your Pivot tables value to have automated reports.
  1. In the Pivot Table, select one of the cells with the value you want to format
  2. Then, right-click and select “Value Field Settings”
  3. Furthermore, click Number Format at the bottom of the dialog box.
  4. In the Format Cells dialog box, in the Category list, click the number format that you want to use

#4: Excel Tip

Learn how to solve Circular References.

NEED
Do you get Warnings from Excel about Circular References but never pay attention to them?

#4: Circular References

HOW TO DO IT
Just go to Excel Ribbon

  1. Click “Formulas”
  2. Click “Error Checking”
  3. Click “Circular references”

#4: Excel tip - how to do it

Then Excel shows you the list of cells with circular references if you have some.

#5: Excel Tip

Learn how to repeat Row Labels.

NEED
You have a table with row labels not repeated.
Problem: you can not use this table to make a pivot table.

#5: Excel tip table
HOW TO DO IT

  1. Select the columns with the empty row labels.
  2. Then, press the F5 function key
  3. Click Special…
  4. Afterward, select Blanks and click OK (all blank cells in the data will be selected)
  5. Press the = sign once and the UP arrow key once (you will see a formula appearing in a cell).
  6. Finally, press CTRL+ENTER to finish
  7. All the blank cells will now be filled in with the values. Note that they are all formulas and must be converted to values.
  8. Copy the entire range and paste it as a value

EXAMPLE

#5: Excel tip example
TOP 10 EXCEL SPECIALISTS TO FOLLOW

LEILA GHARANI
Leila created tutorial videos on the whole Microsoft Suite. I really like the ones on Excel and Powerpoint. Therefore, check her Youtube channel.

KAT NORTON
She is known as Miss Excel on Instagram and Tiktok. Moreover, Kat has a modern way of teaching Excel tricks and uses Instagram or Tiktok to communicate. Go check it.

PAUL BARNHURST
Paul is sharing his knowledge of FP&A, Excel, and Finance tools. In addition, he has great practical tips for finance professionals.

MATT BRATTIN
Matt is behind all the Excel free guides from TMB Analytics you can find on LinkedIn. Above all, he also publishes videos and has his own set of online courses.

CHRISTIAN WATTIG
Christian is one of the best experts on FP&A and gives practical tips on how to better use Excel when you are a finance professional.

KAREN ROEM
Karen is a trainer for Microsoft Office Suite and has a newsletter where she regularly shares productive tips (more than 700 tips listed to date!).

CHRIS REILLY
He is a financial modeling expert and even created a course on the topic! Furthermore, Chris an M&A and FP&A expert.

MIKE GIRVIN
Mike has his own Youtube channel, “Excel is Fun.” You will find their extended tutorials on Excel. Also, check his new 800 pages book!

DON TOMOFF
Don is regularly sharing tips on LinkedIn on Excel, PowerQuery, and other tools (he has already posted more than 700!).

JOHN MACDOUGALL
John has his own website called “How To Excel,” with many free Excel tips. Additionally, he sends a newsletter where you can receive his new tips.

The Bottom Line – Accelerate Your Finance Career with These Excel Tips for Finance Professionals

Finally, with these Excel tips for finance professionals, you’re on the right path to dominating Excel in your workplace. Still curious to know more? Additionally, if you want to learn more Excel tips and trick, you can take my course for finance professionals and become an expert.

Also, if you want to receive more finance tips like this, feel free to sign up for my newsletter. If you subscribe, every two weeks, you will receive an email from where I share best practices, career advice, templates, and insights for finance professionals.

 

Share This :

Further Readings:

Free Finance & Productivity Resources:

Free Finance & Productivity Resources

Reach Me

I help Finance professionals grow their skills in Finance, Controlling and FP&A.

If you need help, mentorship and guidance with your career, LET’S CONNECT.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Get My Ultimate Resource for Finance Professionals.

Grab the Top 10 Free Finance Resources packed in a ZIP file and enhance your expertise and productivity.

Unlock Excel Secrets

Enhance Your Finance Skills with Excel Tips.

Before you leave, grab my top 100 Excel tips designed specifically for finance professionals.

Boost your efficiency and accuracy!

Almost there.

Now check your email to confirm your subscription.

(Make sure to add my email address email as contact and move my emails to your main inbox in case it landed in Spam or in the Promotion tab).

Almost there.

Now check your email to confirm your subscription and start your download.

(Make sure to add my email address email as contact and move my emails to your main inbox in case it landed in Spam or in the Promotion tab).

Contact.

Fill out the form below, and we will be in touch shortly.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.