Microsoft Excel
Foundation
Overview
The breadth of business, educational, and organisational information in existence today is absolutely staggering. Organisations the world over rely on this information to make sound decisions regarding all manner of affairs. But with the amount of available data growing daily, the ability to make sense of all that data is becoming more and more challenging. Fortunately, the days of performing calculations and analysing data on paper are pretty much gone. Imagine, if you will, having to calculate what percentage of your organisation’s sales occurred in one small town in, say, Brazil. If your organisation operates in multiple countries and generates billions of dollars in revenue annually, it could take a lifetime to isolate the exact figures you need and then compare those to the rest of your revenues. Who has that kind of time? This is exactly where the power of Excel can help.
Course Objective
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks to work with and analyse the data that is critical to the success of your organisation.
You will:
- Familiarize with Microsoft Excel interface.
- Data key-in, formatting and modifying worksheet.
- Perform basic calculations.
- Using basic tools for create and modify table arrangement for data.
- Print workbooks.
Who Should Attend
This course is intended for students who wish to gain the foundational understanding of Microsoft Excel that is necessary to create and work with electronic spreadsheets.
Prerequisites
A willingness to learn and engage with the material is crucial for any course, especially one involving software.
Training Calendar
Intake
Duration
Program Fees
Module
Module 1 - Excel Essential
Topic A: Starting Excel
- What is a Worksheet/Workbook?
- Identifying Parts of the Screen
- The Ribbon
Topic B: Using Selection Techniques
- Selecting a Cell and Range of Cells
- Selecting Nonadjacent Cells and Ranges
- Selecting an Entire Worksheet
Topic C: Entering Data
- Identifying Types of Data
- Entering Data into a Cell and a Range
- Quickly Adjusting a Column Width
Topic D: Finishing a Workbook
- Saving a New Workbook
- Saving a Named Workbook
- Closing a Workbook and Exiting from Excel
Module 2 - Modifying a Workbook
Topic A: Opening a Workbook
- Opening an Existing Workbook
- Creating a New Workbook
- Opening a Recently Used Workbook
Topic B: Editing Data on the Worksheet
- Replacing the Data in a Cell
- Editing the Data in a Cell and Formula Bar
- Clearing the Contents from a Cell or Range
- Using Undo and Redo
Topic C: Creating Simple Formulas
- Creating a Formula by Typing and Pointing
Topic D: Using Functions
- Using the Basic Function
Module 3 - Managing the Worksheet
Topic A: Navigating in a Worksheet
- Using Special Navigation Keys
- Using the Scroll Bars and Boxes
- Moving One Screen • Using Go To
Topic B: Changing the Worksheet Structure
- Inserting Cells/Rows/Columns
- Deleting Cells/Rows/Columns
- Hide/Unhide Row/Columns
Topic C: Managing Sheet
- Grouping sheet
- Hide/Unhide Sheet
- Insert/Delete Sheet
Module 4 - Formatting the Worksheet
Topic A: Moving and Copying Data
- Moving and Copying Data
- Copying Data with AutoFill
- Creating a Series with AutoFill
- Copying Formulas
Topic B: Changing the Appearance of Data
- Changing Column Width and Row Height
- Formatting Numbers and Fonts
Topic C: Adding Enhancements
- Using Font Styles Attributes
- Aligning Data in Cells
- Merging and Centre Cells
- Rotating and Indenting Text
- Adding Borders and Shading
- Using Format Painter
Module 5 - Printing the Worksheet
Topic A: Printing a Single Worksheet
- Using the Print Dialog Box
- Using Print Preview
- Creating Headers and Footers
- Removing the Grid
Topic B: Printing a Workbook
- Printing a Whole Workbook
- Printing a Selection
- Using Print Areas
Topic C: Using Advanced Printing Techniques
- Changing Page Layout
- Aligning the Printout
- Fitting a Document onto a Desired Number of Pages
- Working with Page Breaks
- Working with Page Breaks in Normal View
- Setting Print Titles
- Removing Print Titles
Module 6 - Managing Switchboards
- Creating a Database Switchboard
- Modifying a Database Switchboard
- Setting Startup Options
FAQs
General Questions:
-
Q: What is a Microsoft Excel Foundation course?
-
A: It’s an introductory course designed to teach the fundamentals of using Microsoft Excel. It covers the basics of navigating the interface, entering and formatting data, working with formulas and functions, and creating simple spreadsheets.
-
-
Q: Who is this course for?
-
A: This course is perfect for beginners who have little to no prior experience with Excel, or those who want to refresh their basic Excel skills. It’s suitable for students, office workers, and anyone who wants to learn the essentials of spreadsheet software.
-
-
Q: What are the prerequisites for this course?
-
A: Basic computer literacy is all that’s required. You should be comfortable using a mouse and keyboard, navigating files and folders, and opening and closing programs. No prior Excel experience is assumed.
-
-
Q: What software do I need?
-
A: You will need Microsoft Excel installed on your computer. The specific version (e.g., 2013, 2016, 2019, 365) might be specified by the training provider.
-
-
Q: How is the course structured?
-
A: The course structure varies. It might involve in-person workshops, live online sessions, self-paced online modules, or a combination. Check the course details.
-
-
Q: How long is the course?
-
A: The duration varies depending on the scope and format. It can range from a few days to a few weeks. Check the course details.
-
-
Q: Will I receive a certificate upon completion?
-
A: Yes.
-
Program Content & Skills:
-
Q: What specific topics are covered in the course?
-
A: Typical topics include navigating the Excel interface, entering and formatting data, working with cells and ranges, creating basic formulas (using operators like +, -, *, /), using simple functions (SUM, AVERAGE, COUNT), working with worksheets and workbooks, printing, and saving files. Check the syllabus for a detailed list.
-
-
Q: Will I learn about advanced functions like VLOOKUP or PivotTables?
-
A: No, these are typically covered in intermediate or advanced Excel courses. A foundation course focuses on the basics.
-
-
Q: Will I learn how to create charts?
-
A: Yes, creating basic charts and graphs is usually included in a foundation course.
-
-
Q: Will I learn about macros or VBA?
-
A: No, macros and VBA are advanced topics and are not covered in a foundation course.
-
-
Q: Will I work on real-world examples and exercises?
-
A: A good foundation course will include practical exercises and examples to help you apply the concepts.
-
Submit your interest today !
