Learn Excel in 2 Weeks !!

Create & Master Common Professional Excel Projects

Microsoft Excel

Excel is the most popular business software application in the workplace. Whether you are a junior admin officer, a clerk, help-desk admin, office assistant, sales rep, loan agent, hr officer, junior/senior accountant etc or a top executive in any industry, your daily work-life revolves around excel. A lot of employers now hinges recruitment & promotion on excel skills, in addition to the role qualifications.

Excel can be used for little tasks like recording daily transnational records, doing simple calculations, automating receipts and invoices and much more.

Excel is also capable of advance tasks like data analysis, corporate budgeting, loan variables calculations and even a company's financial models development and tracking, some of which are covered in this course.

Training Schedules & Fees

  • Date April 25, 2020
  • Duration 2 Weeks
  • Days and Time Weekdays [Mon - Thurs] & Weekend [Sat. 10am-5pm]
  • Fee N40,000

    N50,000

    [20% Discount]


Course Outline

    1 - Getting started with Excel 2016

    This explains briefly about the chapter

  • General Overview of Excel - The Spreadshet application
  • The Menu
  • Quick Access Toolbar
  • Worksheet
  • Formular Bar
  • Status Bar
  • Navigation
  • 2 - Entrying Data

    This explains briefly about the chapter

  • Data Entry and Cell Navigation
  • AutoFill
  • Dates
  • Undo & Redo
  • Adding Comments and FileSave
  • 3 - Creating Formulars and Functions

    This explains briefly about the chapter

  • Simple Formulas
  • Copying Formulas
  • YTD and Percentage Increase
  • Absolute Cell Reference - $A$2
  • AutoSum & Average
  • Min,Max,Mean & More
  • 4 - Formatting Content

    This explains briefly about the chapter

  • Font Edits
  • Column Width
  • Contents Alignments
  • Borders
  • Numbers and Dates
  • Conditional Formatting
  • Tables
  • Graphics and Images
  • 5 - Adjusting Worksheets

    This explains briefly about the chapter

  • Insert/Delete New Columns
  • Hide Columns
  • Move-Copy
  • Find & Replace
  • 6 - Printing

    This explains briefly about the chapter

  • Page Layout
  • Page Breaks
  • Page Setup
  • 7 - Creating Charts and Graphs

    This explains briefly about the chapter

  • Creating Charts
  • Chart Types
  • Chart Formatting
  • Chart Elements
  • Sparklines
  • 8 - Page Splits & Freezing

    This explains briefly about the chapter

  • Section Freezing
  • Creating Splits
  • Outlines
  • 9 - Linking Workbooks

    This explains briefly about the chapter

  • Working across worksheets
  • Working across workbooks
  • 10 - IF,VLookup,VLookupExact

    This explains briefly about the chapter

  • If function
  • VLookup function
  • VLookupExact function
  • CountIf function
  • 11 - Security & Sharing

    This explains briefly about the chapter

  • Protect Worksheet
  • Protect Workbook
  • Workbook Password
  • Sharing Workbook
  • Tracking Changes
  • 12 - PivotTable

    This explains briefly about the chapter

  • PivotTable Overview
  • Creating a PivotTable
  • Manipulating and Grouping
  • Slicers
  • PivotChart

Testimonial

Catherine Akinwolere

Catherine Akinwolere

Head, Sys. Admin. Lumenave International

5 star rating

Didn't realize there are a lot of things you can do with Excel. It was down right a very explanatory session. The Course guide itself was explanatory. The Instructor was very patient in answering questions.

Anchorsoft is an institute I would recommend to anyone who is willing to know more about excel than just the basic knowledge.