RELATED COURSES
Microsoft PowerPoint Level 1
Microsoft Word Level 1
Windows 10 Basic Computer Course
Windows 7 Basic Computer Course
Windows 8 Basic Computer Course
Details
You will create and edit basic Microsoft Office Excel Worksheets and Workbooks.
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.
Delivery Methods
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.
| Delivery Method | Duration | Price (excl. VAT) | ||
|---|---|---|---|---|
| Classroom | 1 Day | ZAR 1,895.00 | Get a Quote | |
| Live Virtual Training | 1 Day | ZAR 1,650.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
Exxaro Resources Limited
Enjoyed the course, learned a lot of new key techniques. Well demonstrated. Thank you!
Gauteng Provincial Treasury
The training was user friendly. The trainer was patient and accommodating.
Solidariteit
from the moment I arrived I was welcomed, made familiar with my surroundings and the staff went out of their way in helping me in my need of personal travel arrangements, I really appreciate their overall helpful spirits.
Bastion Group (Pty) Ltd
The trainer is very specific, he clearly explained each and every aspect such that I could understand more about Excel
World Net Logistics
I didn't know how to set up formulas and page break review now I am covered out trainer Xoli help me a lot. Know I covered many important things in this training.
Absa Bank
I enjoyed learning about the formulas and how much easier it is to use excel
Audience
This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel worksheets.
Pre-Requisites
Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.
Course Outline / Curriculum
- Lesson 1: Getting Started with Microsoft Excel
- Navigate the Excel User Interface
- Use Excel Commands
- Creating and Save a Basic Workbook
- Enter Cell Data
- Use Excel Help
- Lesson 2: Performing Calculations
- Creating Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formula
- Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert, Manipulate, and Delete Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
- Lesson 4: Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles and Themes
- Apply Basic conditional formatting
- Create and Use Templates
- Lesson 5: Printing Workbook Contents
- Preview and Print a Workbook
- Define the Page Layout
- Lesson 6: Managing Large Workbooks
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
- Manage Workbook Properties
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.
| Start Date | End Date | Branch | Status | |
|---|---|---|---|---|
| Wed 30 Oct 2024 | Wed 30 Oct 2024 | Fourways | Scheduled |