Excel Courses

Microsoft Excel Courses Available

  • Course Description:
    The course introduces Excel at an elementary level, introducing the first time user to Excel. Features covered: using the Excel screen; navigation between cells, sheets and workbooks and how to enter data; basic calculations and formulae; saving of data, and finding saved documents; editing and printing spreadsheet information. The course covers MICT Unit Standard: 116937

    Duration: 1 day

    Target Group:
    This course is intended for a first time Excel User, or delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification.

    Prerequisites:
    The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills.

    Method of training:
    Instructor led, hands-on exercises using a computer.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic1 The MS Excel Screen Using the Ribbon, Tabs and Groups
    Managing Excel Workbooks
    Using Help
    What is an Excel workbook?
    Saving Workbooks, Opening Saved Documents
    Topic 2 Mouse Pointers In Ms Excel Shortcuts and Using the Go To option.
    Topic 3 Scrolling In A Worksheet Select, move Or copy, the Auto fill Handle
    Topic 4 Working In an Excel Workbook Adjusting Columns Widths
    Changing The Names Of Sheet Tabs
    Changing The Colour Of Sheet Tabs
    Moving Between Multiple Workbook Sheets
    Topic 5 Entering Data Entering Text
    Entering Numbers
    Entering Date and Time
    Topic 6 Find And Replace Data Using Undo And Redo
    Topic 7 Checking Spelling Checking Spelling
    Topic 8 Formulas Operators For Formulas
    Order Of Operations
    Sum, Average, Max, Min, Count
    Quick Calculations
    Editing Formulas/Functions
    Topic 10 Rearranging A Worksheet Insert/Delete Columns/Rows In A Worksheet
    Topic 11 Formatting A Worksheet Formatting Numbers
    Formatting Text
    Orientation Of Data Within A Cells, i.e. Vertical Headings
    Wrap Text in a cell
    Centre across selection
    Using Borders and shading
    Clear Formats
    Topic 12 Page Setup Changing The Page Orientation Ð Landscape/Portrait
    Setting paper size
    Inserting Headers And Footers
    Changing The Margins
    Topic 13 Printing Options Setting A Print Area
    Page Break View and adding additional page breaks
    Printing Column Or Row Headings
    Topic 14 Saving Excel Files In Different File Formats Saving Excel Files In Different File Formats
    Topic 15 Introduction To Charts (Optional) Terminology
    Using the F11 shortcut to create a chart
    Using Sparklines to show trends
  • Course Description
    Using an Excel spreadsheet to solve a specific outcome, using formulae and functions and using features like charts to enhance a spreadsheet. This course concentrates on formatting of data and displaying information in a professional manner. The course covers MICT Unit Standards: 116937, 116940 and 116943

    Duration: 1 day

    Target Group:
    This course is intended for a delegate who already knows how to enter data into a spreadsheet and knows the basic concepts of a spreadsheet. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification could also attend this course.

    Prerequisites:
    The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills. The delegates must also know the basics of an Excel spreadsheet, e.g., navigating, inserting/deleting columns and rows and basic formatting.

    Method of training:
    Instructor led, hands-on exercises using a computer.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic 1 Using Templates Using Templates
    Topic 2 Working In The MS Excel Window The Menu Ribbon
    Customizing The Quick Access Toolbar
    Topic 3 Saving Options for documents Workbook Properties
    Topic 4 Workbooks And Handling Large Spreadsheets Swapping Columns Or Rows
    View more than one document at the same time
    View more than one worksheet at the same time
    Topic 5 Naming/Moving/Deleting/Copying sheets in a workbook Copy/Move sheets to another workbook or within a current workbook
    Hiding/Unhiding Worksheets
    Topic 6 Organising Large Projects Splitting the Screen
    Freezing/Unfreezing Titles
    Hiding/Unhiding Columns/Rows
    Inserting/Removing manual Page breaks
    Printing Row and Column Titles
    Topic 7 Using Autocorrect and Customised Lists Creating A Linear Series
    Topic 8 Formatting (More advanced features) Formatting Numbers
    Change Letters to Superscript or Subscript
    Borders And Shading/Patterns
    Use the Format Paintbrush
    Text Alignment and wrapping of headings Ð Vertical Headings
    Topic 9 Functions And Formulae Using various formulae and Using The Function Wizard
    Error Messages And Their Meaning
    Using Auto Calculate (Quick Calculations)
    Topic 10 Working with Dates And Time and using the Date and Time formulae Format Dates
    Custom formats on dates
    Topic 11 The IF Statement SumIF,AverageIF
    Topic 12 Relative And Absolute Cell Addresses Relative And Absolute Cell Addresses
    Topic 13 Using Comments Using Comments
    Topic 14 Sorting and filtering In Excel Sorting by colour
    Custom filters
    Topic 15 Charts Terminology
    Different Types Of Charts And What They Are Used For
    Plotting A Chart With Non-Adjacent Data
    Change Chart Options
    To Change The Scale On A Chart
    Adding a New Series to a Chart on the Same Sheet
    Creating a mixed chart (Combination Charts)
    Inserting Data Labels on a Chart
    Adding A Trend Line To A Chart
    Topic 16 Page Setup (Overview) Headers And Footers
    Changing The Margins
    Centering Data Vertically And Horizontally On A Page
    Topic 17 Printing Options (Overview) Setting A Print Area
    Page Break Preview
    Printing Column Or Row Headings
    Topic 18 Evaluate Spreadsheets Using tracing
    Topic 19 Importing Files From Other Applications Importing Files From Other Applications
    Topic 20 Inserting SmartArt and shapes i.e. Organograms Inserting SmartArt and shapes i.e. Organograms
  • Course Description
    This course focuses on customizing and automating repetitive actions. Advanced Formulae and functions are enforced by numerous exercises. The course covers MICT Unit Standard: 116940.

    Duration:
    1-2 days depending on level.

    Target Group:
    This course is intended for a delegate who needs more advanced features in Excel to automate tasks and to use formulae and functions more effectively. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification could also attend this course.

    Prerequisites:
    The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills. The delegates must also know the basics of an Excel spreadsheet, e.g., navigating, inserting/deleting columns and rows and basic formatting.

    Method of training:
    Instructor led, hands-on exercises using a computer.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic 1 Using the Quick Access Toolbar to add buttons to specific workbooks and to customise Using the Quick Access Toolbar to add buttons to specific workbooks and to customise
    Topic 2 Error Messages and their meanings Error Messages and their meanings
    Topic 3 Workbooks and Worksheet Protection WORKSHEET Protection
    WORKBOOK Protection
    Saving a Workbook with a Password
    Topic 4 Conditional Formatting Conditional Formatting
    Topic 5 Data Validation Create a List with specific values to choose from using data validation
    Using Data Validation to trace errors on a Spreadsheet
    Topic 6 Templates Tempaltes
    Topic 7 The Paste Special Command Transposing Data
    Pasting data with a link
    Topic 8 Go To (F5) - Special Features Filling Blank Cells with the same Data as in the Cell Above
    Topic 9 Relative and Absolute Cell Addresses and using Mixed Cell Addresses Mixed Cell Addressing
    Topic 10 Useful Spreadsheet Functions UPPER, LOWER, PROPER, CONCATENATE,LEN, MID, LEFT,RIGHT, FIND, SEARCH
    TRIM, SUBSTITUTE, TEXT, ABS, ROUND, INT, TRUNC, RAND, RANDBETWEEN, VALUE
    Lookup Functions
    VLOOKUP and HLOOKUP
    If Statements
    IF(Condition,True,False) - Overview
    The NESTED IF
    IF Statement: Using AND, OR or NOT
    SUMIF, COUNTIF
    Date and Time Functions
    NOW(), TODAY(), MONTH(), DAY(), YEAR(), DATE(year,month,day)
    Topic 11 Group and Outline Creating manual and automatic outlines
    Topic 12 Using Range Names In Workbooks Using Range Names in Formulas
    Topic 13 Copying Worksheets from different Files Grouping and Linking Worksheets
    Topic 14 Consolidation (totals) a group of Sheets/Workbooks Linking different files
    Changing the file reference in a linked file
    Breaking a link to a source file
    Saving a tiled arrangement (Workspace)
    Viewing more than one worksheet in the same Workbook
    Topic 15 Using the List/Database Features in Excel Sorting Data in a Database/list
    Topic 16 Subtotals Nested Subtotals
    Topic 17 Filtering Data Using the Advanced Filter options
    Topic 18 Pivot Table Reports Adding a Page Field to a Pivot table
    Monthly reports - Grouping Data in a Pivot Table
    Using Calculations in a Pivot Table
    Using Multiple Consolidation Ranges in a Pivot Table
    Creating a PivotChart Report from an Existing Pivot Table
    Using Slicers to filter data in Pivot tables.
    Link slicers to more than one pivot table
    Topic 19 Introduction to Macros To record a macro (Absolute/Relative)
    Topic 20 Data Analysis (What IF scenarios) Using Goal Seek, Using Solver, Creating Scenarios
Microsoft Excel

Our Courses

Microsoft Excel Course

Read More

Microsoft Word Course

Read More

Microsoft PowerPoint Course

Read More

Microsoft Access Course

Read More

Microsoft Oulook Course

Read More

Microsoft Excel Dashboard Reporting

Read More

VBA for Excel or VBA for Access

Read More

Microsoft Projects

Read More
Top