ProspenAfrica | Training and Consulting Services Provider

Microsoft Excel for Administration And Accounting Professionals

2 Day Training

Dates: 21 – 22 May 2024
Locations: Johannesburg, South Africa
Platform: Available In-Class / Online

Price: Available on Request

This is a Non-Accredited Course

Course Introduction

This Microsoft Excel for Administrative and Accounting Professionals masterclass programme deals with the rich functionality of Microsoft Excel to deal with the challenges of working with different accounting data sets that an accounting department must deal with. The programme deals with the core fundamental of Excel toolsets that assist administrative and accounting staff in dealing with real accounting case studies.

Course Objectives

  • Provide delegates with a professional understanding of how Excel’s deals with data |text and values|

  • Examine Microsoft’s methodology on ETL |Extract Transpose Load) data so it can be utilised in calculations.

  • Basic and advanced Data Cleaning data sets. Microsoft best practice is that users must move towards Power Query which allows for incredible transformations.

  • Examining the powerful formulas in Excel to conduct Lookup and Reference that allows for enhanced Table Development

  • Working with Tables and PivotTables to sort and filter information.

Who should attend?

Administrative Officials:

  • Administrative Assistants/Officers: Those responsible for managing data, generating reports, and organizing information within an administrative context.

  • Office Managers: Professionals overseeing office operations, task delegation, and workflow management.

  • Executive Assistants: Individuals supporting executives in organizing information, scheduling, and data analysis.

Accounting Officials:

  • Accountants: Professionals dealing with financial data, analysis, and reporting.

  • Financial Analysts: Those involved in financial planning, forecasting, and data interpretation.

  • Bookkeepers: Individuals managing financial records, transactions, and reconciliations.

Training methodology

Training Methodology

Our diverse instructional approaches ensure effective learning:

– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.

Training Outline

  1. Understanding the properties of a Data Table and how data is manipulated to summarise data into meaningful Tables.

  2. Understanding Excel’s value fields that allow for calculations

  • Accounting and numerical values

  • Date Values

  • Time Values

  • Other Values

  1. Importing Data from external sources

  2. Data Cleaning Techniques of Data Sets |from small to very large |5,000 rows plus|

  • “Utilising the standard tool in Excels to deal with small data sets:

– Data Tools (including Text to Column)

– Text functions Sort and Filter”

  • Utilising the Power Query to deal with massive data sets |plus 10,000 to millions of rows|

  • Converting PDF Documents to Tables with numerical values

  1. Converting Lists into Excel’s TABLE object that gives us advanced Sorting and Filtering capability using Slicers

  2. Introduction to Excel’s PivotTables that allows for the construction of multi-dimension Tables

  1. Application of Excel’s Formula Library

  • “Lookup and Reference functions

– VLOOKUP, Hlookup, Xlookup, Index+Match

– Filter, Sort, Unique

– WrapCols, WrapRows, ToCol, ToRow, Transpose”

  • “Date and Time

– Date, Yearfrac, Year, Month, Day, Today,

– Networkday, Weekday, Weeknum

– Hour, Minute, Seconds”

  1. Exploring Excel’s advanced formatting environment including conditional formatting

The entire day will be utilised in advanced case studies.

  1. Automating reconciliations

  2. Age Analysis of transactions

  3. Forecasting payments and receipts

  4. Development of advanced Tables with multiple dimensions

  5. Presenting information to management

Request a call back

Related Courses

Advanced Excel and Dashboards Training
Dates: 18 - 19 Apr | 18 - 19 Jun | 22 - 23 Aug 2024

A Complete Introduction To Power BI Desktop

View Course
Basic Microsoft Word
Dates: 03 May | 19 Jul 2024

Microsoft Word Basic

SAQA ID: 117924, NQF L2

View Course
Intermediate Microsoft Word: SAQA ID: 119078, NQF L3
Dates: 11 - 12 Apr | 16 - 17 May 2024

Microsoft Word Intermediate

SAQA ID: 119078, NQF L3

View Course
Basic Microsoft Word
Dates: 12 Jun | 19 Aug 2024

Microsoft Word Advanced

SAQA ID: 116942, NQF L3

View Course

Open chat
Need Help? Chat with Us
Scan the code
Powered by Prospen Africa
Welcome to Prospen Africa!
Check out our 15% Off sale when you purchase QCTO Training Material