Microsoft Excel Essentials (Bookkeeping & Accounting)

In this course you’ll study the fundamentals of Microsoft Excel as shortly as doable. By the top of this course, you’ll have a stable understanding of how you can use fundamental capabilities of Microsoft Excel which you could apply to your skilled or private life.

You can use any model of Microsoft Excel to take this course, together with Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.

Each lesson is round 3-5 minutes, and you may study at your individual tempo.

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. Alvarez

YOU WILL LEARN:

• Navigating round Microsoft Excel

• Entering textual content and numbers

• Adding numbers (SUM perform), subtracting, multiplying, and dividing

• Correcting cells and transferring round cells

• Inserting columns and rows

• Adding and deleting cell format (daring, font, and many others.)

• Using Copy, Cut, Paste, and Format Painter to shortly copy cell formatting

• Paste Value utilizing Paste Special

• Wrap textual content in a cell

• Formatting numbers utilizing greenback signal, share, decimals

• Conditional formatting so as to add colours to make sense of cell information

• Using charts (pie charts, column charts, and many others.)

• Sorting numbers

• Filtering numbers

• Using Freeze Panes to see columns and row headings

• Print Preview choices to properly print your Excel sheet

• Using Sumif perform so as to add cells based mostly on standards

• Using VLookup perform to shortly discover information in a desk vertically

• Using HLookup perform to shortly discover information in a desk horizontally

• Using “If” perform to check standards

• Using “Left” and “Right” capabilities to extract information from a cell

• Removing duplicates in a spread of information

• Shortcut keys to shortly choose a spread of cells

• Finding absolute worth of constructive and destructive numbers

• Pivot Tables to summarize your information

• And far more!

WHY THIS COURSE?

• Taught by a CPA, CA, MBA – Calvin Ok. Lee

• Calvin is a top-rated teacher at Schulich School of Business at York University

• Over 52,000+ college students from 172 nations enrolled in his programs

• Lifetime entry to this course, and also you obtain new classes and updates for FREE.

• He has 15 years of expertise in bookkeeping & accounting

• He has labored in a Big 4 accounting agency (Ernst & Young)

• Subtitles (captions) accessible in English, French, Hindi, Simplified Chinese, and Spanish

• Certificate of Completion accessible

• I assure you’ll study Excel. If you are not completely glad, I’ll refund your cash with a 30-day money-back assure

REGISTER FOR THIS COURSE NOW!

Who this course is for:

• Beginner bookkeeping & accounting college students
• People who want to make use of Excel of their work or life