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.

Public Course: R1 550 per person

Corporate Course: from R11 500 per day

*Prices are exclusive of VAT

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

- Karon, Energy Partners HVAC & R (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

“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

Comments from Attendees

Not sure where to start ?

Make use of our Free 

Pre-Assessment. 

Public Courses

Gauteng: 09h00 - 16h00

KwaZulu Natal: 08h30 - 15h30

Sandton

  • 20 Oct '20

Durban

  • 13 Oct '20

Pietermaritzburg

  • 06 Oct '20

Due to Covid-19, and the safety of our clients, we have postponed public training for August & September 2020, and will instead offer Online Training, with E-Classroom sessions, over this period.

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

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

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

2020 | Copyright | Summit Solutions