Microsoft Office Specialist Excel Training Course ( 1 Course ) See Dates/Register  

  • mos-excel-specialist-3-day-course

    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.   

MOS Excel 3 Day Course & E-Learning Jan

Course Dates: 16th, 23rd & 30th January 2019
3 Levels - Introduction, Intermediate & Advanced Excel
1 Day Courses  from 10am to 5pm
Includes E-Learning, Practice Test & Exam & Free Resit
TESG Funding May Be Available for Jobseekers
Course Date 16-01-2019 10:00 am
Individual Price €470.00
€470.00 6
Pery Square Business College & Staff Agency.
4 Pery Square, Limerick, Ireland.
Telephone: +353 (0)61 310155
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Call or Email to discuss the right course for you.
European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)