excel finance professionals

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel for Finance Professionals

Excel for Finance Professionals

resolvedResolved · Low Priority · Version 365

Martin has attended:
Excel for Finance Professionals course

Excel for Finance Professionals

Is there a text book that you would recommend as a useful reference when using the Power Query function? Whether a more general book like Excel Bible 2019 or a more specific book like Excel Power Pivot & Power Query for Dummies? (Am I right in thinking Excel 2019 and Excel 365 are the same apart from the license model?)

RE: Excel for Finance Professionals

Hi Martin,

Thank you for the forum question.

I found a couple of books on Amazon, but I do not have any of them, so I am sorry I cannot really recommend any of them. They look fine.

If I wanted to buy a book about Power Query, I would buy:

https://www.amazon.co.uk/Collect-Combine-Transform-Business-Skills-ebook/dp/B07HP9J35M/ref=sxbs_sxwds-stvp?cv_ct_cx=Excel +Query&keywords=Excel+Query&pd_rd_i=B07HP9J35M&pd_rd_r=7afaec25-559e-41cf-aa23-5e3477560181&pd_rd_w=MKFbD&pd_rd_wg=5UMKG&pf_rd_p=7dc56c0d-8a5f-4d97-9143-7233b106859a&pf_rd_r=MC927YKY1A9DK4AFMES9&psc=1&qid=1583244930

I have watched videos on YouTube to get my knowledge. Yes the query is the same in 365 and 2019

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 10 Mar 2020: Automatically marked as resolved.


 

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips


Server loaded in 0.12 secs.