MICROSOFT EXCEL FOR ACCOUNTING
Microsoft Excel Expert Certification
The Microsoft Office Specialist: Excel Expert Certification demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.
An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry expert-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel at an expert-level and can complete tasks independently.
Purpose
Competency in Microsoft Excel Advanced will help individuals:
• Understand Excel tools and functions used in accounting.
• Create and manage professional accounting spreadsheets.
• Use formulas for calculations, budgeting, and financial analysis.
• Prepare invoices, expense sheets, payroll, and financial reports.
• Apply functions such as IF, SUMIF, COUNTIF, VLOOKUP/XLOOKUP and more.
• Analyse financial data using PivotTables, charts, and dashboards.
• Automate repetitive accounting tasks and improve accuracy.
• Build practical Excel skills for accounting and finance professionals.
This Course is:
MQA Accredited
HRDC Refundable
MQA Reference: MQA -NAW 688
Course Duration: 9 Hours