Microsoft Excel Essentials (Bookkeeping & Accounting)

Microsoft Excel basicsSubtitles/captions available in English, French, Hindi, Simplified Chinese, and SpanishAdding numbers, subtracting, multiplying, and dividingUsing formulas to work with numbersInserting columns and rowsUsing cell format (bold, font size, highlight, etc.)Using Format Painter to quickly copy cell formattingUsing Wrap text in a cellFormatting numbers using dollar sign, percentage, decimalsConditional formatting to add colors to make sense of cell dataUsing charts (i.e. pie chart) to present your dataSorting and filtering numbersUsing Freeze Panes to see columns and row headingsVLookup, HLookup, SumifPivot TablesShow moreShow lessIn this course you will learn the basics of Microsoft Excel as quickly as possible. By the end of this course, you will have a solid understanding of how to use basic functions of Microsoft Excel that you can apply to your professional or personal life.You can use any version of Microsoft Excel to take this course, including Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.Each lesson is around 3-5 minutes, and you can learn at your own pace.WHAT STUDENTS SAY ABOUT THIS COURSE:- This is such a great course for beginners. It taught me so many new tricks to use Excel more easily. – Nora A.- I enjoyed all the lessons. I felt like each one had at least one thing that I could take away from. I really enjoyed learning how to add charts and pivot tables to my spreadsheets for an easy summary of information. The sound quality was good. The instructor was clear and precise. The information was presented in a way that was easy to understand and also covered a vast amount of information. Definitely glad that I took this course. Would take another course provided by him, hands down. – Brittany A.- Sum function, formatting numbers, mean, median, mode, and count, Sumif, VLookup and HLookup were the most helpful lessons for me. They taught me new lessons that will help me in the future. The lessons were very easy to follow. I would have Excel open and ready to input the same criteria when the video started, and could pause where I needed to do the exercises on my own. – B. AlvarezYOU WILL LEARN:Navigating around Microsoft ExcelEntering text and numbersAdding numbers (SUM function), subtracting, multiplying, and dividingCorrecting cells and moving around cellsInserting columns and rowsAdding and deleting cell format (bold, font, etc.)Using Copy, Cut, Paste, and Format Painter to quickly copy cell formattingPaste Value using Paste SpecialWrap text in a cellFormatting numbers using dollar sign, percentage, decimalsConditional formatting to add colors to make sense of cell dataUsing charts (pie charts, column charts, etc.)Sorting numbersFiltering numbersUsing Freeze Panes to see columns and row headingsPrint Preview options to nicely print your Excel sheetUsing Sumif function to add cells based on criteriaUsing VLookup function to quickly find data in a table vertically Using HLookup function to quickly find data in a table horizontally Using If function to test criteriaUsing Left and Right functions to extract data from a cellRemoving duplicates in a range of dataShortcut keys to quickly select a range of cellsFinding absolute value of positive and negative numbersPivot Tables to summarize your dataAnd much more!WHY THIS COURSE?Taught by a CPA, CA, MBA – Calvin K. LeeCalvin is a top-rated instructor at Schulich School of Business at York UniversityOver 52,000+ students from 172 countries enrolled in his coursesLifetime access to this course, and you receive new lessons and updates for FREE.He has 15 years of experience in bookkeeping  accountingHe has worked in a Big 4 accounting firm (Ernst  Young)Subtitles (captions) available in English, French, Hindi, Simplified Chinese, and SpanishCertificate of Completion availableI guarantee you will learn Excel. If you aren’t absolutely satisfied, I’ll refund your money with a 30-day money-back guaranteeREGISTER FOR THIS COURSE NOW!Who this course is for:Beginner bookkeeping accounting studentsPeople who need to use Excel in their work or life