Sales & Support: 08179072163

  
 

 

 

Training » Training Courses »Microsoft EXCEL

  Microsoft EXCEL

COURSE CODE: MEX 452
DURATION: 3days (15 hours) per Stage or 2 Saturdays per Stage (Part-Time) .
REGISTRATION:N5K
TUITION: N20K Stage1 (Beginners & Intermediate)
N35K Stage 2 (Advanced)

Click here to register for this course.

Learning Outcomes

This training is a hands-on Excel training aimed to get you to any level required in the industry, prepare and arm you to become a full data analyst. At the End of the training participants will be able to do the following;

.

  • Create basic and Advanced Excel Worksheets .
  • Do Tabulated Excel Calculations
  • Work with Standard Spread Sheets.
  • Format & Modify Spread Sheets
  • Manipulate Data
  • Create Formulas and Plot Graphs
  • Perform Advanced Calculations and full Data Analysis.
  • Program Excel using Macros

Course Contents & Schedule
(Stage1 - Beginners & Intermediate )

TRAINNG DAY1
  • Accreditation of Participants: Accreditation of Participants & Installation of Excel software.
  • Introduction: Introduction to MS Excel, Applications and Workspaces. Creating and saving an Excel file. File Formats.
  • Performing Basic Calculations: Add, Subtract, Multiply , Divide , calculate averages .

TRAINING DAY2 & DAY3
  • Formatting Worksheets :Format text, Modify fonts, format numbers , format cells , adjust columns & Rows , Print Worksheets.
  • Manipulating Data: Move , Copy , Paste , Add/Delete Column , Add/Delete Rows , Employ Multiple Worksheets, Employ Auto fill , Insert/Delete Worksheets. Import data , Export Data.
  • Calculations : Create formulas across worksheets , Employ absolute references , Explian function wizard , Understand formula errors.

 


STAGE 2 (Advanced Excel)

TRAINING DAY4 &5
  • Making Data Visible : Add comments , freeze panes , Create charts, Pivot tables , Pivot charts.
  • Data Analysis: Data Extraction , Data Validation , Conditional Logic Statements ( If , CountIf, AND , NOT, OR , SumIf)
  • Financial Applications : Building financial functions into MS-Excel (FV , PV , PMT , PPMT etc ), Loan Amortization schedule
  • Excel Macros : Create Macros with Excel VBA , understand Variables , If Then Statement , loops , String Manipulation , Date & Time . Perform Automated tasks
  • ts.
  • REVIEW OF TRAINING: General review of entire training.

  • PRESENTATION OF CERTIFICATES.


  • Click here to register for this course.