DiscountONLINE Modular Package to Excel for Business and Professional Services.

*** Suitable for business owners, their staff, school leavers & job seekers ***

ONLY 1,000 UNITS WILL BE SOLD ON A FIRST COME FIRST SERVED BASIS.

NORMAL PRICE : R2,500/$199  NOW R250/$19.90 !

DEAL SUMMARY

  • Improve your future earnings by mastering this job requirement.
  • Impress your employer with eye-catching tables and graphs.
  • Produce superb budgets, control accounts, keep track of who owes you money, and when it is due.
  • Save hours in your day by using advanced filters and lookups.
  • Get that job or promotion by staying ahead of the pack with Excel.

GET ALL THE FOLLOWING WITH PURCHASE:

  • Immediate full and unfettered access to the 6 Hours of Excel lessons in online modules.
  • Progress at your own pace and enjoy a lifetime of updates.
  • Discounts for future courses. E.g. Excel II
  • Certificate of completion.

*** VIEW THE FULL COURSE AT UDEMY HERE .

You can “Preview” lesson 5 “Entering Data” for FREE

LOCK IN YOUR 90% DISCOUNT NOW.

GET IMMEDIATE ACCESS TO ONLINE MODULES

(If you pay by direct deposit into our bank account you need to “claim” your access by emailing us at admin@resultswithpeople.com).

PAYMENT OPTIONS

Cost for LIFETIME ACCESS to the Online Modules: R 250 per person and you get immediate access by using the secure Payfast online payment facility below.

Payment can be made through this portal via EFT, Debit Card or Credit Card.

Choose a payment method:

Option #1:

Pay using the secure online Payfast gateway.

Click the “Pay Now” button below to purchase for R250.

Pay

Option #2:

Pay using the secure online Paypal gateway.

Click the “Buy Now” button below to purchase for $19.90.




.

Option #3: Bank detail for direct deposits:

C.J.A. Muller – Capitec Bank Glenfair

Account number: 116 059 1111

Branch code: 470010

– With direct deposits, email proof of payment to admin@resultswithpeople.com and you will receive a link to access your online modules.

– Please address all enquiries to:

Connie at – Tel: 079 526 3896

Email: admin@resultswithpeople.com

Questions ?

Pop us a mail at : admin@resultswithpeople.com

Give us a call on: 079 526 3896

Or use the form below

Your Name (required)

Your Email (required)

Your Contact Number (required)

Your Message

g-logo

EXCEL I for Business and Professional Services is a structured modular course designed to take Excel users to an intermediate level. The lessons are engaging and have proven to be highly effective. A number of students have participated in this course with the intention of “just doing a re-cap here and there” – and have been amazed by how much they have gained from each session.

Connie currently works for a financial organization as their national sales manager and apart from the workshops, consultancy work and training that he does across a wide range of subjects and business types, he has also been giving training on spreadsheets and Excel since 1995.

Shane has deep roots in training for a number of years and is involved in a number of business types and professional services with a focus on the accounting profession.

Shane is also a Microsoft accredited trainer in Excel.
He is director of 2020 South Africa at http://www.2020sa.co.za where he offers solutions focussed on the accounting profession but he also adds value to a variety of business types.

Course Content:

1. Excel Essentials
1.1 Excel Worksheet / Workbook
– Inserting a Worksheet
– Renaming a Worksheet
– Deleting a Worksheet
– Moving or Copying a Worksheet
– Moving between Worksheets
1.2 Active Cell, Name Box, Formula Bar
1.3 Inserting Rows / Columns
– Shift Cells down / across
– Inserting a Picture / Logo
1.4 Entering Data
– Fill Series (Numbers, months, days)
1.5 Editing Contents of a Cell
1.6 Select All Button
1.7 Grouping Worksheets
1.8 Common Keyboard Shortcuts
2. Tables and Text files
2.1 Setting up a table
– Merging cells
– Sum and other calculations
2.2 Importing a Text File
– Text Import Wizard
– CSV Files
– Import example text file
– Converting Data to Numbers
– Space or comma as thousand separator
2.3 Useful Text Functions
= LEFT / RIGHT, FIND
= MID, CONCATENATE, TRIM
3. Function vs Formula
– What is the difference?
3.1 Using Insert Function
= SUM / SUMIF, COUNT, COUNTA, COUNTIF
= AVERAGE, REPT, VLOOKUP
3.2 Copying and Pasting Formulae
– Editing Formulae F2
3.3 Absolute References F4
4. Named Ranges and Paste Special
4.1 Alternative to using $
– F3
4.2 Paste Special
– All
– Formulas
– Values
– Formats, Format Painter, three semi-colons ;;;
– Column widths
– Operation
– Skip blanks
– Transpose
5. Working with Data
5.1 Freezing Row or Column Titles
5.2 Split Window
5.3 Sorting Data
– Add Levels
5.4 AutoFilter
6. Working with Data (continued)
6.1 Advanced Filter
6.2 Conditional Formatting
6.3 Remove Duplicates
6.4 Data Validation
7. Data Presentation
7.1 Tables
– Grouping
– Subtotals
7.2 Graphs
7.3 Watermarks
7.4 Save as PDF
8. View Options and Data Protection
8.1 Comparing Two Workbooks Side by Side
– Creating Multiple Views for a Workbook
8.2 Protecting Cells
– Worksheet
– Workbook
8.3 Practical tips

TO GET THE ABOVE BUNDLED WITH A SERIES OF 8 WEBINARS

AT 50% DISCOUNT >>>>

clickhere

I found the Excel course very enlightening and of practical application in my business. It made me discover features of which I was totally unaware. Shane is an excellent facilitator and clearly an expert in his field. The fact that the weekly sessions are recorded makes the course even more valuable as it provides the means to repeat the learning module and study an application more intensively. I can recommend the course wholeheartedly.
Cor Faling
This excel course was definitely worth it for me, so grateful that I have the recordings to view back on.
Candice Grobbelaar
GRAB a FREE Excel or Open Office course !
We will send you FREE access to an Excel or Open Office course. Enter your best email address and click "Request".