Beginner Microsoft Excel Training Course

Learn how to use MS Excel formulas effectively!

Want to learn all about MS Excel but not sure where to start? Why not start at the beginning with our Microsoft Excel Basics course?

Ranging from Data Input and Formatting, to Basic Excel Formula and Excel Graphs, this course will enable you to grasp the key components that make Excel tick, reduce your Excel frustrations and enable you to become a lot more efficient when working with Spreadsheets.

Even though no prior knowledge of Excel is required, many regular Excel users have benefitted greatly from this course as it works through Excel from the ground up, and as a result plugs those gaps that many of us self-taught Excel users have.

 

Course Cost: R1 450 (excl. VAT)

Comments from Attendees

“Very informative and will be extremely useful in my workplace. Could not have had better. Very valuable.”

- Karon, Energy Partners HVAC & R (Pty) Ltd

“Absolutely informative and recommended for anyone. Definitely going to assist me with my efficiency at work. Mark is a super star!!”

- Tumi, Resolution Circle (Pty) Ltd

"Even though I work on excel extensively every day I still found value and learnt new things on the beginner course."

 

- Roxanne, TD Administrative Services

“Well presented and prepared. I would love to attend the follow-up training. Trainer was very patient and helpful and kept to times. I learnt a lot.”

 

- Bernadette, Vendange

“Each topic was extremely useful and detailed. Very valuable information to use not just in the workplace but on a daily living/basis.”

 

- Zandile, Kerry Ingredients

What you'll learn: 1-Day Beginner MS Excel Training Course

Excel Overview

  • Workbooks & Worksheets

  • Cells, Columns & Rows

  • Name box & Formula Bar

  • Office Ribbon & Menus

 

Excel Key Essentials

  • The Active Cell

  • Keyboard Shortcuts

  • Diff bt. Highlighting, Replicating & Moving

  • Entered Values vs. Formula

  • The right-click function

Data Input

  • Entering & Editing Data

  • Improving efficiencies with the Tab, Enter & esc keys

  • Cell Navigation

  • Cut, Copy & Paste

  • Undo & Redo

  • Spell Checker

  • Default Data Formats. NB!

  • Cell comments

Excel Auto Fill

  • Quickly copying cells 

  • Generating a Series 

  • Replicating Formulas

Formatting Cells

  • Font, Fill, Borders & Alignment

  • Merging Cells and Wrapping Text

  • Format Painter and Repeat Formatter

  • Diff bt. Delete & Clear All

Number Formatting

  • Numbers, Dates, Currency and percentage

  • Formatting façades. NB!

  • Display Rounding

Formatting Worksheets

  • Adjusting Row height & Column width

  • Inserting, Deleting and Hiding Rows & Columns

  • Freeze Top Row

Excel Formulas & Functions

  • Adding, Subtracting, Multiplying & Dividing

  • Diff bt. Formulas and Functions

  • Intro to Functions with Auto-Sum

  • Average, Count, Max and Min

  • Copying & Replicating Formulas

  • Empty cells vs. Zero values. NB!

Printing

  • Printing Basics

  • Page Orientation & Margins 

  • Print Scaling

  • Print Preview vs. Page Layout

Basic Find, Sort and Filter

  • Finding Data in large spreadsheets

  • Adding and Removing Filters

  • Extracting Filtered Data

Basic Graphs

  • Simplest method of graphing Data

  • Changing Source Data and Chart Type

  • Do's & Don'ts of Excel graphs 

Excels Golden Rule

  • Intro to Excel’s Golden Rule

  • Locking cell References in Formula

  • Absolute cell references - $A$2

 

Keyboard Shortcuts 

  • Over 25 Excel Keyboard shortcuts to maximize your efficiency

Included in the course is a free Flash Drive that contains a follow along Excel Workbook with detailed notes on each Section. A comprehensive Video Files Library of “you-tube” like mp4 files will also enable you to revisit any of the content covered, plus a tear-off summary Recap Sheet will help remind you of all the key concepts. A Course Attendance Certificate will be presented on the completion of the course.

Public Courses

Johannesburg:​​​​

  • 19 Nov '19

  • 22 Jan '20

  • 11 Feb '20

Durban: ​​​

  • 12 Nov '19

  • 03 Dec '19

  • 21 Jan '20

Pietermaritzburg:​​

  • 6 Nov '19

  • 10 Mar '20

Course Cost: R1 450 (excl. VAT)

Courses Available:  

Not sure which course

to start with?

Make use of our Free 

Pre-Assessment. 

Click here to find out more.

FLEXIBLE

PUBLIC & CORPORATE ONSITE EXCEL TRAINING

18 YEARS

DATA ANALYSIS, REPORTING  & EXCEL SPECIALISTS

COMPREHENSIVE

DEMO VIDEOS & RECAP SHEETS SUPPLIED

SUPPORT

ACCESS TO WEBINAR'S

& EXCEL TIPS

RELEVANT

SOLUTIONS BASED TRAINING WITH REAL LIFE EXAMPLES

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • improve my skills on microsoft excel
  • excel training for businesses
  • excel training help in Durban
  • learn the features of excel

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

MS Office Courses

2019 | Copyright | Summit Solutions