Back to All Events

Microsoft Excel – Fundamentals

  • 5 CPD Hours Apex Building, Blackthorn Road, Sandyford Business District, D.18 (map)

If attending this course, it is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013)

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. If utilised correctly, the benefits of Microsoft Excel cannot be overstated. Due to the program’s capability of formatting data, performing calculations, analysing data and integrating information, a working knowledge of Excel is vital for most office based professionals today.

On leaving this course, you will be able to enter and edit information in a worksheet, manage workbooks and navigate worksheets and workbooks. You will be able to perform basic calculations on worksheet data, manipulate the data, format the contents of a worksheet and prepare, set up and print information. 

Prerequisites: Delegates should be familiar with PC’s/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. 

Course Content

Working with Worksheets and Workbooks

  • Start Excel
  • Get help
  • Enter information
  • Edit information in cells
  • Using Undo/Redo
  • Save, close, and re-start workbooks
  • Exit Excel

Performing Calculations

  • Use Basic Formulas
  • Use Functions
    • SUM
    • AVERAGE
    • MAX
    • MIN
    • COUNT
  • Using AutoFill
  • Understand the Order of Operations
  • Understand and create Relative, Absolute, and Mixed References
  • Linking calculations across sheets

Managing Worksheets

  • Navigate a Worksheet using the Keyboard
  • Insert/Delete Columns and Rows
  • Resize Columns and Rows
  • Hide/Unhide Columns and Rows
  • Hide/Unhide Worksheets

Managing Worksheets Contd…

  • Naming Sheets
  • Moving Sheets
  • Copying Sheets
  • Freeze Panes
  • Repeat Titles on each Page
  • Page Orientation
  • Split Screen
  • Scale to fit

Formatting Worksheet Information

  • Apply currency format
  • Apply percent style
  • Apply decimals
  • Merge and Centre
  • Copy and Paste/Transpose
  • Apply Borders and Shading
  • Deleting formatting
  • Wrap Text and Line Breaks

Checking and Printing Information

  • Check Spelling in a Worksheet
  • Preview a Worksheet,
  • Set the Page Options and Margins
  • Add Headers and Footers
  • Insert and remove Page Breaks
  • Print a Worksheet
  • Set a Print Area

Who Should Attend?

This course would be ideal for those who require a basic grounding in Microsoft Excel, this course will provide you with the knowledge to enter and edit information in a worksheet, manage and navigate worksheets, perform calculations and manipulate worksheet data, format the worksheet contents, and prepare, set up, and print information.

Certification

On completion, you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD HoursPlease note certificates are issued only at the end of the training course to participants who complete the full five hours.

Cost

This course costs €375 (Early-bird), normal rate is €425. Includes course documentation and light refreshments. While the course fee does not include lunch, we do provide freshly made sandwiches, Nespresso coffee and a range of teas and fresh juice for those who require a light lunch. Alternatively, you can avail of the local food stores and coffee shops opposite the training center for hot food or alternative lunch options.

Earlier Event: September 14
Executive Personal Assistant
Later Event: September 18
Time Management