Excel Basics and Formatting [for Accounting and Finance] Part 1

Every Excel Formula You will Need [to audit/finance analyst] - www.buymeacoffee.com/paulharr...
Excel Support for "Every Excel Formula" Workbook - www.buymeacoffee.com/paulharr...
Financial Statement Template File [Small Company] -
www.buymeacoffee.com/paulharr...
If you found this video helpful then support the channel buying me a coffee - 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
The next 4 lessons will be on:
- shortcuts
- simple formula
- harder formula
- table, graphs and pivots
SUBSCRIBE TO STAY TUNED FOR THE NEXT 4 LESSONS.
Hopefully it help!

[@cameron9699]

Great video Paul, looking forward to the upcoming shortcuts !

[@MrYasinsheikh]

Thanks a lot! This is really helpful, cant wait for the next few videos.

[@digitalboy4415]

Keep spreading the knowledge. 👏

[@johnnyg397]

I have an interview coming up for PWC I wish I get someone like you as my manager, someone who is very thoughtful and understanding. I have seen many videos where a lot of people seem lost when they start their career as an auditor and don’t have the guidance or support needed to succeed. You are great value to people looking to go into auditing and finance careers keep up the great work I’m glad I came across your channel. Great stuff and thank you for the amazing support.

[@simonclasse9435]

Thank you ! I start as an auditor with KPMG in 7 days. Can't wait for the shortcuts :p I will finally know how my teachers was making tables so quickly only using the keyboard.

[@Tecknoc]

Thank you so much for this video👌👌👌! We have a course that teaches us excel in university, but they go too quickly and it always feels embarrassing to go visit them individually to ask for further help (not to mention finding the time)

[@atifmj4994]

Very important
That kind of stuff that I really want

[@el_contador0181]

thank you

[@00martaa]

Welcome back 🙌🏻

[@colmsmyth5937]

Paul. Never stop. Also your series of UK stock analysis videos were excellent. If you ever have time please do a video on the specific brokers you use and also how you manage your total portfolio across several platforms.
Regardless, excellent work.

[@isitpossible7492]

yes welcome back - i would love if you dd more videos on stocks - your videos hands down are some of the best for the uk market.

[@derrickomondi7393]

Thanks

[@pyungte]

Amazing!!! Thank you, I’m starting as an auditor with PwC in April! I’m sure this will be super helpful - thanks

[@thewongtim]

You starting in Birmingham?

[@pyungte]

@@thewongtim yes

[@optixbiggestfan]

Back in the game

[@ryanwinchy]

Thanks for another great video, you are eloquent and professional honestly feels like you should have 100k subs! I run a finance podcast go get insights from people in industry (mostly aimed at students), if you Paul or any of your subs want to come on that'd be great !

[@almasarabi475]

Missed your videos

[@keithefan3697]

Can you share shortcut or hot keys which you use to edit this table? Thanks

[@vishnumsathyan1741]

Feeless teaching . I gained little bit knowledge about excel . Keep doing spread knowledge and all the guys wants to practice this things also. Other wise you guys will be forgotten this use full things

[@moneylover202]

Is there a way we can get the sample data to follow along with the video?

[@giseleteghen4247]

So ur not only looking cute but super intelligent ... with an irresistible accent
I love and appreciate if u can do a video for fix asset register using advance formulae please and also a loan schedule

[@atifmj4994]

Bro can you help me to find out which videos important for audit associate.. please suggest me

[@robertrubin4682]

Hi Sir?is possible to apply in audit firm if your age is 30 years and above?

[@campbellblk7484]

I don't see the point of the cont/1 format, can't I just replace the minus with a bracket manually? Plus it's kind of confusing or hard to remember.

[@avidreader-pe7vm]

can you please share the excel file so we can practice along the video

[@ammarsaleem5949]

Hey paul just wanted to ask if kaplan has good teaching standards

[@PaulHarrisYoutube]

hey, i thought they were good overall however it will largely depend on the tutor you get

[@vanissasoberano4597]

Omg I was so lost with your eyes!

[@chad14533]

thank you