Excel Beginner Formulas [for Accounting and Finance] Part 3
2.9 هزار بار بازدید -
4 سال پیش
-
Every Excel Formula You will
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!
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!
4 سال پیش
در تاریخ 1399/09/11 منتشر شده
است.
2,983
بـار بازدید شده