Microsoft Excel

Learn Microsoft Excel

Workshop beginners to expert
Efficiency tools that will change your life.

 

Who should attend?

This programme is designed to provide both new users with the tools they need to use Excel efficiently and effectively, and for experienced users in need of a refresher, or who want to learn new tools, or new tips and tricks to hone their skills. 

How you will benefit?

At the end of this programme, you should be able to:

  • Develop and format useful spreadsheets for multiple purposes;

  • Understand, and develop excel formulae;

  • Use excel summarising and graphing tools to quickly summarise and create interactive graphical representations of data; 

  • Record or write macro's in Excel for specific needs;

  • Create advanced formulae.

Key Focus Areas:​

EXCEL: BASIC FUNCTIONALITY REVIEWED

Sessions Content

The review of the following basic concepts is purely to revisit basic concepts and to ensure that all attendees start at the same level once the intermediate section is started

  • Session Basics

    • Navigating the Excel User Interface

    • Using Excel Commands

    • Creating and Saving a Basic Workbook

    • Entering Cell Data

  • Session Performing Calculations

    • Creating Worksheet Formulas

    • Inserting Functions

    • Reusing Formulas

  • Session Modifying a Worksheet

    • Inserting, Deleting, replacing and Adjusting Cells, Columns, and Rows

    • Using Proofing and Research Tools

  • Session Formatting a Worksheet

    • Modifying Fonts

    • Adding Borders and Colours to Worksheets

    • Applying Number Formats

    • Aligning Cell Contents

    • Applying Styles and Themes

    • Applying Basic Conditional Formatting

  • Session Printing Workbooks

    • Previewing and Printing a Workbook

    • Defining the Page Layout

  • Session Managing Workbooks

    • Managing Worksheets

    • Managing Workbook and Worksheet Views

    • Managing Workbook Properties

    • 3D Management

INTERMEDIATE EXCEL SESSION

At the end of the section, students will be able to:

  • Customize the Excel environment.

  • Create advanced formulas.

  • Analyse data by using functions and conditional formatting.

  • Organize and analyse datasets and tables.

  • Visualize data by using basic charts.

  • Analyse data by using PivotTables, slicers, and PivotCharts.

 

Course Content

Session 1: Customizing the Excel Environment

  • Configuring Excel Options

  • Customizing the Ribbon and the Quick Access Toolbar

  • Enabling Excel Add-Ins

Session 2 Creating Advanced Formulas

  • Using Range Names in Formulas

  • Using Specialized Functions

  • Using Array Formulas

Session 3: Analysing Data with Functions and Conditional Formatting

  • Analysing Data by Using Text and Logical Functions

  • Applying Advanced Conditional Formatting

Session 4: Organizing and Analysing Datasets and Tables

  • Creating and Modifying Tables

  • Sorting Data

  • Filtering Data

  • Using SUBTOTAL and Database Functions

Session 5: Visualizing Data with Basic Charts

  • Creating Charts

  • Modifying and Formatting Charts

Session 6: Analysing Data with PivotTables, Slicers, and PivotCharts

  • Creating a PivotTable

  • Analysing PivotTable Data

  • Presenting Data with Pivot Charts

  • Filtering Data by Using Slicers

Fees and dates

3 day programme

R2,900 per person

 

Finance for Non-Financial Managers

 

Who should attend?

This programme is designed to provide managers in non-financial positions with a practical understanding of finance and accounting. It is assumed that delegates will have no formal accounting or finance knowledge prior to attending this programme

How you will benefit?

At the end of this programme, you should be able to:

  • Plan more effectively as to take the financial impact of your decisions into consideration;

  • Identify what causes and drives costs;

  • Gain insight into working capital management;

  • Apply key ratios and performance measures;

  • Understand growth, cash-flow and profitability considerations;

  • Implement the concept of contribution and marginal costing;

  • Calculate discounted cash-flow and capital costs; and

  • Comprehend the principles of valuation and value creation from an economic perspective.

Key Focus Areas:​

Day 1:​​​

  • Introduction to annual financial statements

  • ​Judgmental issues / notes and policies

  • ​Case studies

Day 2:

  • Recap of day 1 and introduction to costing

  • Absorption costing / cost  allocations

  • Marginal costing

  • Break-even analysis

  • Measuring performance

  • ​Working capital management

​Day 3: 

  •  
  • ​Financial planning ​​and growth  

  • ​Discounted cash flows

  • Case study

  • Capital costs

  • Valuation principles

  • ​Creating value

Fees and dates

3 day programme

R2,900 per person

TEL

+27 (0)82 415 9011
+27 (0)11 867 1013

ADDRESS

Office 3

De Marionette Center

Cnr Michelle & Blue Crane Ave

Meyersdal

Johannesburg

Gauteng

APPLY ONLINE

Interested in joining us?

Click below to express interest - no obligation, no fee...

Jan 2020 applications are now open!

CONNECT​ WITH US

  • w-facebook
  • Twitter Clean

    EMAIL

    © 2016 Institute of Accounting Science (Pty) Ltd