Course Description

Microsoft Office Specialist Excel E-Learning

Pery Square Business College

Microsoft Office Specialist (MOS) – Excel E-Learning Course

This course is aimed at participants who wish to gain an industry qualification in the Excel environment. 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.

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

Array

Array
Limerick City

Limerick, UK

View Phone Number

Book Course

Enquire for Info

View College Details Reviews

Add to Favourite

College Name	Pery Square Business College
Course Category	Computers & IT (Information Technology), Microsoft Excel
Course Type	Online Learning
Course Qualification	Professional Qualification
Course Location	Limerick, UK
Course Start Date	30th March 2020
Course End Date	28th August 2020
Course Fee	€180
Course Duration	6 Months to Complete
Course Times	Start Anytime - Contact college
Awarding Body	Microsoft
Title of Awarding	MOS Excel
Entry Requirements	Basic Microsoft Office I.T. Skills, use of internet & Email essential.
Career Path	Any area of Business which uses Microsoft Excel Spreadsheets - more and more businesses are using this in their day to day operations and so it is essential to have this skill on your CV.