Excel for Accounting

Gain the essential Excel skills you need for accounting and financial analysis with the GoSkills Excel for Accounting course.

In 34 short lessons you will learn how to use Excel for accounting like a pro, including how to import and clean your data, validate data to ensure it is free of errors, master specific Excel formulas for accounting and finance, create your own tax and debt calculators, and so much more.

The course also includes free downloadable Excel accounting templates and exercises to help you get up and running quickly. By the end of the course, you will be able to leverage Microsoft Excel to boost your performance in your day to day accounting, bookkeeping, and financial analysis tasks.

• Import and clean data in Excel
• Master conditional formatting and its formulas
• Validate your data to ensure your information is error free
• Use auto filters to display data that meet a certain criterion
• Group and ungroup data
• Master text, data, time, logic, and IF functions
• Use conditional math to calculate data based on different criteria
• Look up exact and approximate data with VLOOKUP, HLOOKUP, XLOOKUP
• Extract, combine, and report data
• Convert data into a table
• Analyze data efficiently using PivotTables
• Present your data using charts
• Create your own calculators for tax and debt

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.