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

Limerick, Ireland
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, Ireland
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.
For information about Pery Square Business College, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Pery Square Business College



4 Pery Square, Limerick City, Limerick, Republic of Ireland

Map

Pery Square Business College
4 Pery Square, Limerick City, Limerick, Republic of Ireland