Microsoft Excel 2016 Training

excel

Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of desktop applications and services. Spreadsheets introduce tables of values arranged in rows and columns that can be used mathematically using both basic and complex arithmetic operations and functions. This software spreadsheet is used to create budgets, produce graphs – 

 and charts, and for storing and sorting data. Business uses spreadsheet software to forecast future performance, calculate tax, completing basic payroll, producing charts and calculating revenues.

Pre-requisites

  • Anyone with basic computer skills and  little knowledge in typing.

Who should do the course

  • SHS graduate
  • JHS graduate
  • Those willing to learn and build their career in software development.
  • Anyone who wants to brush up their skills

Objectives

  • Learn the basic operations of Excel 2016
  • Learn Quick Analysis
  • Learn to use templates for creating a workbook
  • Create different variations of charts and graphs
  • Manipulate data to gather useful action-oriented information
  • Analyze and sort/filter data and captivating pivot tables
  • Implement formulas, functions and calculation

Course Content

  • Excel User Interface
  • Auto Series
  • Addition and Subtraction
  • Multiply and Divide
  • Conditional Formula – IF
  • Complex Conditional Formula IF
  • AND OR Function
  • Fix Reference
  • Working with Date
  • Working with Time
  • Cell Formats
  • Conditional Formatting
  • Paste Special
  • Charts and Graphs
  • Filter and Sorting
  • Pivot Table
  • Slicer and Timeline
  • Filters
  • Sparklines
  • Power View
  • Freeze Pane
  • Protecting Sheets

Microsoft Excel Training Duration

If you’re interested in this course.

Call us on +233 544774045/ 0201003139
or complete the form below and a member of
our team will get back to you as soon as possible