Microsoft Office Excel


Microsoft Office Excel

Microsoft Office Excel, part of the Microsoft Office Suite, is a spreadsheet application for making computations.

The ability of the applications to make basic computations as well as analytical, statistical and graphical tool has made it essential and popular in various professional fields.  


  1. Basic
  2. Intermediate
  3. Advance
  • Summary

    Microsoft Office Excel is a spreadsheet application used for making computations and analysis. It is very popular in industry because of its ability to make basic calculations to being used as an analytical, statistical or budgetary tool.

    This course will introduce participants to the Microsoft Office Excel environment, making basic calculations, using formulae, producing tables and charts.

    Objective

    Upon completion of the course participants will be able to:

    • Navigate the Microsoft Office Excel environment
    • Create and work with Workbooks and Worksheets
    • Add, edit, delete and format Columns, Rows and Cells
    • Input, edit and format text
    • Create simple and complex Formulae
    • Relative Referencing  Formulae
    • Create and format Tables
    • Sort, Group and Filter data
    • Work with Functions
    • Create Charts
    • Print Workbooks and Worksheets 

    Prerequisite

    • Introduction to Computing
    • Microsoft Office Word - Basic

    Target

    • This course is aimed for persons who desire to gain the basic skills and knowledge in Microsoft Office Excel to enhance their productivity in their daily tasks 

     

  • Summary

    Tasks most often than not are repetitive, as they tend to be routine. Repetitive tasks need to streamlined and spreadsheet data must be displayed in more logical and visually effective way. In this course, participants will streamline and enhance spreadsheets with templates, charts, graphics, and complex formulae.

    Objective

    Upon completion of the course participants will be able to:

    • Apply Name Ranges
    • Apply Absolute Referencing Formulae
    • Apply built-in, Custom and Conditional Formatting
    • Use the IF, COUNTIF, SUMIF functions to summarize data
    • Adding Watch Windows, tracing errors, and tracing Precedent and Dependent Cells 
    • Create custom Lists and Sort Data
    • Work with Panes and Outlines
    • Organise data into levels using Sub-totals
    • Add WordArt and graphics to Worksheets
    • Use the Lookup Functions
    • Use Excel’s built-in Templates and use Workbooks as Templates for other Workbooks
    • Consolidate data
    • Import and Export data
    • Use Forms and Queries
    • Use PivotTables and PivotCharts
    • Save Workbooks as Workspaces
    • Add Comments to Cells and Workbooks
    • Password Protect Workbooks and Worksheets

    Prerequisite

    • Microsoft Office Excel - Basic

    Target

    • Persons who desire to gain necessary skill to create templates, sort and filter data, import and export data, analyze data, and present them in a logical and attractive way.

     

  • Summary

    This is the follow-up course to Microsoft Office Excel – Intermediate. The intent of the course is to extend participants knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

    Objective

    Upon completion of the course participants will be able to:

    • Use Scenario Manager and Scenario Summary to define alternative data sets
    • Use Goal Seek to  obtain alternative results
    • Use Solver to find optimal solutions
    • Create custom views and switch between them
    • Use advanced functions such as Nested IF statements, Time, Mathematical, Logical, Text and Database Functions
    • Use the PMT Function
    • Create dynamic Worksheets using PivotTables
    • Automate repetitive tasks using Macros
    • Link and embed other Microsoft Office files
    • Create and use hyperlinks 
    • Comment on Worksheets
    • Track changes in Workbooks
    • Protect and Share Workbooks

    Prerequisite

    • Microsoft Office Excel - Intermediate

    Target

    • The course is designed for persons desiring to gain the skill necessary to automate tasks using macros, collaborate with others, audit and analyze worksheet data and incorporate multiple data sources.

     



You may also be interested in...

  • 1
  • 2
Prev Next

Microsoft Office Access

Microsoft Office Access

Microsoft Office Access is a database application used to create and manage databases. Databases allow one to store information related to specific topics in an organized way. In addition to storing...

Website Design

Website Design

Websites have become essential in recent years. Individuals and institutions seek to showcase their products and services to the world in order to gain patronage through websites. Websites are the...

Graphic Design

Graphic Design

Graphic design is an interesting field as it brings out ones ability to be creative. The student will be taken through design considerations and rules, and the by step approach...

Microsoft Office Project

Microsoft Office Project

Microsoft Office Project is a project management application. As part of the Microsoft Office Suite, it is a tool used to define, schedule, execute, monitor and report tasks of projects....

Microsoft Office Word

Microsoft Office Word

Microsoft Office Word is the first of the Microsoft Office Suite applications to be studied by the student. It is a word processing application used to create documents such as letters,...

Microsoft Office PowerPoint

Microsoft Office PowerPoint

Microsoft Office PowerPoint is a presentation application, that is part of the Microsoft Office Suite. The application incorporates a graphical approach to presentations in the form of slide shows that accompany...



Stay Connected

 contact +233 (0) 274 236 750
  +233 (0) 303 305 664
   
 email This email address is being protected from spambots. You need JavaScript enabled to view it.
   
 facebook Facebook


Locate Us

location  114 Apple Avenue, Comm. 10, Tema
   
  map