CalendarMOS Excel Specialist 3 Day Course Contact Us For Dates
-
Microsoft Office Specialist - Excel
Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their skills and advance their careers.
Microsoft Excel is perhaps the most important computer software program used in the workplace today. That's why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.
This course is aimed at participants who wish to gain an industry qualification in the Excel environment.
Candidates will demonstrate the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects. -
Learning Worksheet Fundamentals
- Creating Workbooks
- Magnifying and Shrinking a Worksheet on Screen
- Understanding MS Excel Window Environment
- Hiding and Unhiding Rows & Columns
- Selecting a Range of Cells
- Freezing and Unfreezing Rows & Columns
- Entering Text/Numbers/Dates in a Worksheet
- Moving Between Worksheets in a Workbook
- Entering a Range of Data
- Adding and Deleting Worksheets in a Workbook
- Editing Cell Contents
- Creating a Three-Dimensional Formula
- Moving Between Worksheets
- Linking Workbooks
- Naming and Saving Workbooks
- Opening Workbooks
- Renaming Worksheets
- Closing Workbooks and Quitting Excel
Editing and Formatting Worksheets
- Formatting Numbers
- Creating Charts Using the Chart Wizard
- Adjusting the Size of Rows and Columns
- Moving/Resizing/Deleting Charts
- Aligning Cell Contents
- Modifying Chart Titles and Adding Axis Labels
- Creating and Applying Conditional Formats
- Moving and Formatting Chart Elements
- Finding and Replacing Cell Content
- Changing the Chart Type & Organising Source Data
- Inserting and Deleting Cells/Rows/Columns
- Updating Data and Formatting the Axes
- Cutting/Copying/Pasting/Clearing Cells
- Adding Gridlines and Arrows
- Using Additional Paste Features
Formatting Cells
- Formatting Text
- Building/Editing/Copying Formulas
- Formatting Numbers as Currency
- Using the Sum Function and AutoSum
- Using Format Painter
- Using the Formula Palette
- Adding Borders/Shading to Cells
- Using the Date Functions
- Using AutoFormat
- Using Absolute and Relative Cell References
- Creating and Applying Styles
- Using Basic Statistical Functions
- Merging Cells
Changing Print Options
- Adding Headers and Footers
- Using the PMT Function to Forecast Loan Payments
- Changing Margins and Centering a Worksheet
- Calculating Cumulative Interest
- Changing the Orientation and Scale
- Computing Investment Value
- Adding and Deleting Page Breaks
- Using the IF Function
- Setting and Clearing a Print Area
Rows/Columns/Worksheets/Workbooks
- Magnifying and Shrinking a Worksheet on Screen
- Understanding MS Excel Window Environment
- Hiding and Unhiding Rows and Columns
- Selecting a Range of Cells
- Freezing and Unfreezing Rows and Columns
- Entering Text/Numbers/Dates in a Worksheet
- Moving Between Worksheets in a Workbook
- Entering a Range of Data
- Adding and Deleting Worksheets in a Workbook
- Editing Cell Contents
- Creating a Three-Dimensional Formula
- Moving Between Worksheets
- Linking Workbooks
Working with Charts
- Creating Charts using the Chart Wizard
- Adjusting the Size of Rows and Columns
- Moving/Resizing/Deleting Charts
- Aligning Cell Contents
- Modifying Chart Titles and Adding Axis Labels
- Creating and Applying Conditional Formats
- Moving and Formatting Chart Elements
- Finding and Replacing Cell Content
- Changing the Chart Type & Organising Source Data
- Inserting and Deleting Cells/Rows/Columns
- Updating Data and Formatting the Axes
- Cutting/Copying/Pasting/Clearing Cells
- Adding Gridlines and Arrows
- Using Additional Paste Features
- Previewing and Printing a Chart
Performing Basic Calculations
- Building/Editing/Copying Formulas
- Formatting Numbers as Currency
- Using the Sum Function and AutoSum
- Using Format Painter
- Using the Formula Palette
- Adding Borders/Shading to Cells
- Using the Date Functions
- Using AutoFormat
- Using Absolute and Relative Cell References
- Creating and Applying Styles
- Using Basic Statistical Functions
- Merging Cells
- Using Numbered Series and AutoFill
Using Basic Financial and Logical Functions
- Using the PMT Function to Forecast Loan Payments
- Changing Margins and Centering a Worksheet
- Calculating Cumulative Interest
- Changing the Orientation and Scale
- Computing Investment Value
- Adding and Deleting Page Breaks
- Using the IF Function
Using Excel with the Internet
- Creating and Editing Hyperlinks
- Saving Workbooks and Worksheets as Webpages
- Sending Workbooks via E-Mail
-
This course is aimed at those who want to learn how to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs.
Microsoft Office Specialist certification gives you the tools to build a brighter future.
Achieve industry-recognized certification
Learn the computing skills companies are looking for
Boost your workforce resume
Differentiate yourself from other applicants
Gain valuable experience and confidence
Heighten your earning potential
Prepare yourself for a successful future -
Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.
You must have completed ECDL or similar training course and have good general computer skills and have working Knowledge of Excel / Spreadsheets and other Microsoft Office Software. -
Exam: You will complete an online test which must be taken at Pery Square Business College. You will have 50 minutes to complete the MOS Online test. Exams held on alternate Friday Afternoons from 2pm - Must book 1 Week in Advance.
* subject to pass mark of 70% or more
Exam results are displayed on your screen immediately after you complete an exam. Those who pass will receive (by post) an official certificate within approximately two to three weeks.
While you can view the Learning Materials on any device, you will need a Microsoft Windows PC and Microsoft Office 2016 in order to complete the practice exams.
There are no events in the selected category
