Excel Beginner Formulas [for Accounting and Finance] Part 3

Published: 01 December 2020
on channel: Paul Harris
3,164
110

Every Excel Formula You will Need [to audit/finance analyst] - https://www.buymeacoffee.com/paulharr...

Excel Support for "Every Excel Formula" Workbook - https://www.buymeacoffee.com/paulharr...

Financial Statement Template File [Small Company] –
https://www.buymeacoffee.com/paulharr...

If you found this video helpful then support the channel buying me a coffee - https://www.buymeacoffee.com/paulharris

Having worked in finance for over 8 years I am very familiar with what you will need to know in excel to work in accounting, finance and audit roles.

I have split a course into 5 parts.

This first part will be on excel basics and will include:
formatting
excel panel (what things do)
text-to-column
short-cuts
conditional formatting
simple stuff

link:    • Excel Basics and Formatting [for Acco...  

The second video included
copy - ctr C
paste - ctr P
Undo - ctr Z
add row/ clmn - shift+ctr+ '+'
highlight row - shift-space
highlight column - ctr-space
highlight all - ctr A
paste special - ctr + alt + V
auto sum - alt =
other stuff like that.....
   • Excel Shortcuts [for Accounting and F...  

This lesson included:
add, subtract etc
freezing cells
sum
if functions
right, left, mid
count
average

The next 2 lessons will be on:
harder formula
table, graphs and pivots

SUBSCRIBE TO STAY TUNED FOR THE NEXT 3 LESSONS.

Hopefully it help!


Watch video Excel Beginner Formulas [for Accounting and Finance] Part 3 online without registration, duration hours minute second in high quality. This video was added by user Paul Harris 01 December 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,16 once and liked it 11 people.