Excel Fundamentals

ActionPoint is delighted to bring Excel Fundamentals training to our Virtual Academy.

Microsoft Excel allows the user to create digital spreadsheets which enables information to be stored, organised and manipulated with powerful data visualisation and analysis tools.

Time-frame: Half day or full day course

Suitable for: This course can be adapted from beginner to intermediate level, depending on the needs of the user.

Course Objectives

On completion of this course you will have covered a wide range of functionalities and uses of Excel such as;

• Become proficient in creating and navigating workbooks
• Understand formatting and modifying a worksheet
• Gain an understanding of basic formulas and using key features of Excel

Course Outline

Topic 1: Getting Started

• Creating, Navigating and Saving a Spreadsheet and Workbook
• Working with Cells and Entering Cell Data
• Use Excel Commands and Excel Help

Topic 2: Formulas and Functions

• Entering Basic Formula and Functions
• Reuse Formulas and Functions
• Auto filling Rules
• Using Page Setup
• Sorting Data

3: Modifying Worksheets

• Add and Edit Borders
• Cut, Copy and Paste
• Insert and Delete
• Adjust Cells, Columns, and Rows
• Find and Replace Data
• Undo and Redo

4: Formatting Worksheets

• Format Text
• Format Numbers, Values, Columns and Rows
• Align Cell Contents
• Apply Styles and Themes
• Basic Conditional Formatting

5: Printing Workbooks

• Print and Preview a Workbook
• Page Set Up and Layout
• Headers and Footers

To choose a time or date that suits your team or to discuss your tailored training needs, please email academy@actionpoint.ie.