Excel Newsletter: Pastel and Excel working together, South African Tax Tables

In this issue:

• South African Tax Tables for 2014/ 2015
• Excel less than or equal to
• Waterfall Chart creation
• Export to Pastel problems
• Remove Page Breaks
• Budgeting and Forecasting with Excel
• Format numbers in thousands
• Excel for HR
• Finance for non-financial people
• Part Time Excel courses
• Excel and Hyperion
• Excel for sales and marketing teams
• Excel for teachers and school management

Waterfall Chart Creation in Excel

We have developed an easy way to create a waterfall chart (also known as a bridge or McKinsey chart) in Excel. With this template you will be able to explain movements in key numbers like budgets and it includes the added benefit of being able to categorise the reasons. See more

Budgeting with Excel

Best ways to use Excel for your budgeting and forecasting needs. Learn how to consolidate multiple budget and compare actuals to forecasts Read more

Excel for HR

Custom built courses for particular areas e.g. HR. Learn how to better manage your HR and Payroll issues. Read more

Part Time Excel Courses

Via the online training courses you can learn all about Excel in the comfort of your own home, at any time convenient to you! Read more

South African Tax Calculator 2014/ 2015

A free download that allows you to capture salary details to see what the taxes will be for next year.

You are also able to compare to last year’s tax tables to see if you are better or worse off. Read more

This Month’s New Tips and Tricks

• Export to Pastel problems
  • Addressing some problems with exporting from Pastel to Excel
• Excel less than or equal to
  • How to represent less than or equal to (or greater than or equal to)
• Remove Page Breaks
  • How to remove page breaks in Excel
• Format numbers in thousands
  • How to format numbers in thousands

Free Skills Assessment

If you know of anyone who wants to improve their Excel skills, please tell them that we have created an online version of the Excel Skills questionnaire where you can get an indicative score with only 5 questions.

Next Excel Courses

• Advanced Excel course (7^th– 9^th April 2014)
• Excel for HR (15^th May 2014)
• Excel Beginner Course (3^rd April 2014)
• Excel Budgets and Forecasts (15^th– 16^th  May 2014)

Email us if you need more details or visit the calendar page

Convert a PDF into Excel

A common problem is how to convert a document in pdf format into a workable Excel file.

Spreadsheet Auditing

A tool to easily review and audit spreadsheets.

Management Dashboards

See the products we offer on creating meaningful dashboards and management accounts

Please follow and Like us on Facebook, Twitter , Google + or LinkedIn