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 550 (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

  • Intro to Keyboard Shortcuts

  • Diff bt. Highlighting, Replicating & Moving

  • Entered Values vs. Formula

  • The right-click function

 

Excel Key Essentials

  • Diff bt. Text, Numbers, and Dates

  • Excel Ranges

  • (This is Key but not often taught!)

Data Input

  • Entering & Editing Data

  • Using the Tab, Enter & Esc keys

  • Cell Navigation

  • Cut, Copy & Paste

  • Undo & Redo

  • Spell Checker

Excel AutoFill

  • 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

  • Print Preview vs. Page Layout

  • Custom Headers / Footers (Page Numbers)

  • Print Scaling

  • Repeating header Rows

  • Printing gridlines

  • Print Areas and Printing Selection

 

Basic Find, Sort, and Filter

  • Finding Data in large spreadsheets

  • Adding and Removing Filters

  • Extracting Filtered Data

 

Visualizing Data

  • Creating Graphs

  • Conditional Formatting

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 Sheet with all the Keyboard Shortcuts covered. A course Attendance Certificate will be presented on the completion of the course.

Public Courses

Johannesburg

Sandton:​​​​

  • 05 May '20

  • 09 Jun '20

  • 18 Aug '20

Midrand:

  • 19 May '20

  • 14 Jul '20

  • 15 Sept '20

Durban: ​​​​​​

  • 21 Apr '20

  • 19 May '20

  • 09 Jun '20

Pietermaritzburg:​​​​

  • 12 May '20

  • 21 Jul '20

  • 01 'Sept '20

Course Cost: R1 550 (excl. VAT)

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

20 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.

2020 | Copyright | Summit Solutions