Vertical analysis, also called common-size analysis, takes the Sales and looks at each line items so that you can easily compare the income statements and balance sheets. Vertical analysis on an income statement will show the sales number (sometimes listed as Revenue) as 100%, and every other account will show as a percentage of the total sales number.
Audience: Accounting students, department managers, CEOs, finance students, MBA students, accountants, and Executive MBA students.
Excel skills used in this vertical analysis
Fill without formatting
Copy and Paste
YouTube Video on Vertical Analysis of financial statement by Chris Menard
Coming up next week:
Rank function in Excel along with a comparison of Vlookup vs Index and Match functions.
I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I’m not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I’ve created come from questions asked during MS Office training.
A little about me
I teach Microsoft Office to clients in Atlanta but I've trained clients in Sonoma, California; Orlando, Florida; and Dallas Texas. Contact me for MS Office training for your company.
A little more about me
Basically, I train everywhere. When I'm not training I create free technology video on YouTube that covers Excel, Word, PowerPoint, Outlook, Gmail, Google Calendar, Google Forms, G-Suite, Adobe Acrobat, and other technology tips.
My dog Gracie edits my training videos and recruits new clients. I'm just joking about Gracie. She doesn't do editing.