Tuesday 20 August 2019

Excel Webinar / Full Series

REMINDER to Register for below series – SESSION 1 ON WEDNESDAY 21 AUGUST
Excel Webinar / Full Series
SESSION 1
Wednesday -
21 August

SESSION 2
Tuesday -
27 August

SESSION 3
Wednesday -
4 September

SESSION 4
Wednesday -
11 September


TIME
1pm - 3pm


COST
R850 PER SESSION

OR

R2 500 PACKAGE DEAL FOR ALL 4 SESSIONS

INCLUDED
  • Full Comprehensive course notes
  • Recording of the webinar
  • Certification for CPD points


WHO MUST ATTEND?

All individuals who make use of Excel as part of their daily work duties in the capacity of receptionist or in other administrative areas, those involved in various finance fields including auditing, accounting, taxation and financial management as well as individuals who prepare reports and need to be able to edit text and numbers. All will benefit from attending one or more of these sessions.



NEED TO FULLY UNDERSTAND EXCEL?
Are you new to Excel or have very little or no knowledge of how to even begin?

Do your staff struggle with spreadsheets, formulas and sorting data?

Then join us for these 4 two-hour webinars where we introduce delegates to Excel.


SESSION 1 - INTRODUCTION TO EXCEL/FIRST TIME USER - 21 August
The objective of SESSION 1 is to enable delegates to open and create Excel workbook files, use the 2016 interface, format worksheets and data, and become comfortable with the Excel interface.

  • Introduction
    • Terminology
    • Layout and interface
    • Move or copy sheets
    • Status Bar
    • Print Preview and set print area o Formatting data (changing appearance) and format Painter
    • Various ways to Paste data
    • How Windows Regional Settings may affect your Excel
  • Recovering Lost Documents and using the auto-save function
  • Built-in Templates - Exploring pre-created templates, e.g.
    • Budgets
    • Expense tracker
    • Invoices
  • Navigating Seamlessly
    • Freeze panes
    • Quick access toolbar
    • How to navigate without a mouse
    • Line breaks.


SESSION 2 - EXPLORING AND CREATING FORMULAS- 27 August
Excel has powerful formula functionality. The goal of formulas is to automate processes that would require manual execution. Formulas are used to save you time and give you the edge when completing daily tasks. Join us as explore basic formulas and attempt to increase your efficiency with helpful formulas that you will need daily in an office space.

The objective of SESSION 2 is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment.

  • Building formulas
    • Exploring available library of formulae within Excel
    • Cell referencing within formulas i.e. relative and absolute references
    • Mathematical operators within Excel
    • Duplicating (dragging) formulas without retyping
  • Reviewing formulas
  • Flash fill (Excel 2013 and later only)
  • Financial formulas i.e. SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV.



SESSION 3 - DATA FILTERING, SORTING, SEARCHING EDITING AND EXTRACTION - 4 September
Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulas, filtering functionality, data searching and extraction tools.

The objective of SESSION 3 is to enable delegates to become comfortable with working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information.
  • Data Editing
    • Sorting
    • Filtering
    • Conditional formatting
    • Data validation
    • Subtotal formula
    • Find and replace
  • Data Searching
    • Searching within filter
    • Searching within sheet
    • VLookUps
    • CountIf formula
    • If statements
    • Basic Data Extraction
    • Flash fill
    • Text-to-Columns
    • Concatenate



SESSION 4 - PIVOT TABLES, TABLES, GRAPHS AND CREATING VISUAL REPORTS - 11 September
Sometimes it is easier to understand something when it is represented in pictures or some other visual medium. This also helps when making decisions, analysing trends and reviewing results. Excel is bursting at its seams with all kinds of techniques to visually represent data in a way that is organised and easier to digest. Numbers can be a bit overwhelming sometimes, so join us as we explore various ways numbers/data can be organised and simplified by converting them into graphs, tables and other visual reports to help with decisions.

The objective of SESSION 4 is to enable delegates to become comfortable with using visual aids within Excel and turn copious amounts of data into a visual expression, to perform better decision making.
  • Tables and Graphs
    • Quick analysis
    • Pivot tables
    • Charts
OTHER TRAINING OPTIONS

LIVE WORKSHOPS

We provide easy to understand comprehensive Accounting and Taxation training workshops to benefit individuals, business owners, financial managers, business and corporate staff!

WEBINARS

Access our webinars anywhere from your PC or tablet. Questions during or after the webinar session. Recording of the webinar available when session has ended.

CD SELF-STUDY COURSES

Study in your own time with our various CD self-study courses available. Course notes and online access included. Training certificate issued upon completion of course.

ONLINE COURSES

Get full access to our video portal when purchasing any of our online courses. Access available at any time with downloadable, easy to understand course notes available for you to study in your own time.

THE PRESENTER

YVONNE ROSSOUW



Yvonne is a seasoned and experienced facilitator in the accounting and auditing profession. From 2015 she has been providing training and consulting services to audit, accounting and tax firms. With over eight years' experience she strives to share her knowledge obtained to others for understanding of business requirements. With extensive knowledge of auditing, accounting, tax, labour laws, companies legislation and money laundering legislation, she provides training on a wide range of topics. She also provides training sessions on excel, from beginner to advanced, with practical insights into how excel can be used more efficiently in the financial and business arena.

In Association With



OUR COMPANY DETAILS

Biz Facility (Pty) Ltd
Tyger Chambers 2
Bellville
7530
021 300 1230
www.bizfacility.com
info@bizfacility.co.za
In Association With:
If you wish to unsubscribe from our newsletter, click here

Monday 19 August 2019

Chcek website

Book now & save!
View this email in your browser
A WINNING DEAL TO CELEBRATE
OUR RUGBY CHAMPIONSHIP HEROES!
Our Springboks have kicked this rugby season off with a bang by winning the Rugby Championship/Tri-Nations for the first time in 10 years! And, with a final score of 46-13, it was not just a win, but a hiding! Shout out to Handre Pollard who was responsible for 31 of our 46 points—he was a superstar out on that field.

To celebrate: 35 seats on each of the 5 flights below will be just R299*. How’s that for a winning deal!
Visit our website at www.flysafair.co.za 
T's and C's apply
Sale Terms & Conditions: 
  • This sale takes place today, Monday 29 July 2019.
  • The offer is only applicable on the above flights. 
  • This offer is only available through our website at www.flysafair.co.za. It is not available through our call centre.
  • This offer excludes group bookings of 15 or more people.
  • Remember that all standard terms and conditions of booking and carriage will apply to these seats. 
  • All sales are final, and successful booking is guaranteed once payment has been completed.
  • When various people are viewing the same flight online at the same time, the first person to successfully complete their payment will be allocated that fare. This could result in the runner up being required to start booking again at a now potentially higher fare.
Copyright © 2019 FlySafair, All rights reserved.
You subscribed to our email list on our website

Our mailing address is:
FlySafair
Northern Perimeter Rd
Bonaero Park
JohannesburgGauteng 1619
South Africa

Add us to your address book


Want to change how you receive these emails?
You can update your preferences or unsubscribe

Sunday 18 August 2019

Each custom order is made unique for You!













Each custom order is made unique for You!








Except Stock Lace wigs & Hair extensions, Customed Units are acceptable in the factory as well. Making every customer feel special and be able to design their own look are our goal, we use the finest virgin hair, ensure the wig can be re-styled, colored, and lasting for 2-3 years.


Please check some custom wigs gallery as bellow:






































Get a different looking for your clients? Please contact with US Now!

















sales@Miuhair.com|whatsapp: 008613864858950


Copyright © 2019 -MIUHAIR INC|UNSUBSCRIBE




Casen Jia, No.18 shuangyuan road, qingdao, shandong, 266316, China

Image Each custom order is made unique for You!


Image
 
Each custom order is made unique for You!
 
Except Stock Lace wigs & Hair extensions, Customed Units are acceptable in the factory as well. Making every customer feel special and be able to design their own look are our goal, we use the finest virgin hair, ensure the wig can be re-styled, colored, and lasting for 2-3 years.
Please check some custom wigs gallery as bellow:
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
 
Image
 
Get a different looking for your clients? Please contact with US Now!
 
 
Instagram
 
sales@Miuhair.com|whatsapp: 008613864858950
Copyright © 2019 -MIUHAIR INC|UNSUBSCRIBE

Casen Jia, No.18 shuangyuan road, qingdao, shandong, 266316, China

Whatsapp: +256782856472

Sponsored by ZEEK GOLDMITH

Popular Posts