Foundation diploma in Microsoft Excel

Live Online Academy

Price: N20,000 N4,000

Course Specifications

Mode of study : Online

Location :

Duration : 1 Month(s)

Date : Feb 26 - Mar 30   2018

Course Description

Microsoft Excel has got to be one of the most confusing programs ever. Who can make head or tails of all those numbers, graphs and half a million little symbols that all do something incredibly important, but you have no idea what? 

Remedy that with some help from The Shaw Academy's Microsoft Excel course, your own bonafide decoder. You'll learn all there is to know about formatting, merging scenarios, validating data, advanced filters, editing workbooks and a ton more with this easy-to-follow and comprehensive course. Maybe Excel isn't that difficult after all.

Microsoft Excel can be incredibly powerful in the right hands however often it is more than a little daunting. Knowledge of Microsoft Excel is often crucially required for gaining employment and most roles require a working knowledge. The purpose of this course is to bring the student on a journey from basic level Excel use all the way through the most advanced charts, graphs, look ups and much more

THE DEAL 
  • Accredited online Diploma in Microsoft Excel for NGN5,000
  • Get knowledgeable on the ins and outs of Excel with Shaw Academy
  • Designed by highly-qualified instructors
  • Modules presented by highly qualified instructors with decades of professional experience
  • Diploma includes over 180 course topics, delivered in video format – making it the most comprehensive Excel Programme available today 
  • Learn at your own pace - all lessons can be accessed from any device – study 24/7 anytime, anywhere at your convenience
  • Full support provided throughout and upon completion of the programme – your tutor is at hand at all times and can be reached with any question no matter how large or small
  • Practical downloadable workbooks available throughout which will refine your skills
  • Completely suitable for all levels – from complete beginner to Excel Master

Career Outcomes

Assessment is continuous throughout the programme. Assignments will be a mix of both written and practical work. The entire programme is over 8 hours in duration, with each module taking approximately 30 mins to complete including exercises. The course is delivered “on demand” which means that you can learn at your own pace!

Course Outline

Module 1:


• Introducing Microsoft Excel
• Starting Microsoft Excel
• Understanding spreadsheets
• Understanding the Excel window
• Understanding the workbook window
• Using the Ribbon
• Using the Quick Access Toolbar
• Getting help on Microsoft Excel
• Exiting Microsoft Excel
• Exercise / Solutions
• Summary

Module 2:
What are Workbooks and Worksheets? How they work and what they assist with. 
Topics covered in this module include:

• Creating and Saving Workbooks
• Creating a new workbook
• Saving a workbook
• Auto-saving your work
• Closing a workbook
• Opening a workbook
• Moving the cell pointer
• Moving around a worksheet
• Entering text 5 Entering numbers
• Entering dates and times
• Using the Zoom tool
• Exercise / Solutions
• Summary

Module 3
How to alter Workbooks and make changes to the data held within them. 
Topics covered in this module include: 

• Editing Workbooks
• Selecting ranges of cells
• Editing cell contents
• Clearing cell contents
• Copying cell contents
• Moving cell contents
• Inserting and deleting cells
• Inserting columns and rows
• Deleting columns and rows
• Copying cells with AutoFill
• Inserting cell comments
• Checking your spelling
• Finding and replacing data
• Exercise / Solutions
• Summary

Module 4
How to perform and generate different basic calculations upon data within Workbooks. 
Topics covered in this module include:

• Performing Simple Calculations
• Introducing formulae
• Totalling columns and rows
• Calculating with formulae
• Calculating averages
• Find the highest & lowest values
• Understanding cell referencing
• Using explicit values in formulae
• Exercise / Solutions
• Summary

Module 5
Printing Worksheets and changing options to find the most efficient print formats. 
Topics covered in this module include: 

• Previewing and Printing Worksheets
• Previewing the worksheet
• Preparing pages for printing
• Creating headers and footers
• Specifying the print area and titles
• Controlling page breaks
• Printing a worksheet
• Exercise / Solutions
• Summary

Module 6
How to set Validation to ensure that errors are not introduced into a Workbook. 
Topics covered in this module include: 

• Validating Data
• Using totals as visual checks
• Using formulae for automatic checks
• Using the Range Finder
• Auditing a worksheet
• Using error checking
• Watching and evaluating formulae
• Exercise / Solutions


How To Enroll

Fill in your details on the enquiry form, proceed to pay online by clicking on the orange button "Pay with your ATM card" If you wish to make an online transfer or cash deposit to the bank, please send a mail to learning@jobberman.com requesting for account details.

Price: N20,000 N4,000

Receive a free course outline

For enquiries call 08139859990, 08086660967, 08129123104 or send an email to learning@jobberman.com


You can also request a call and a consultant would reach out to you

Request a Call

Similar Courses

MS Excel - Basic & Intermediate

Autusbridge Consulting Limited

Ilupeju

Offline

Information Technology

Microsoft Project

Autusbridge Consulting Limited

Ilupeju

Offline

Information Technology