• +256-200923322

    Get in touch with us

  • info@hcacyber.com

    Send us an e-mail

Home | Advanced Microsoft Excel

Advanced Microsoft Excel

CERTIFICATE IN ADVANCED MICROSOFT EXCEL

Learn how to enter and edit worksheet data, create formulas that LOOKUP values, create formulas that COUNT and SUM, create formulas for financial Applications, protect your work, perform worksheet what-if analysis and analyse data using goal seek and solver.

REQUIREMENTS

We advise to meet the following requirements for effective completion of the course.

  • Formatted a spreadsheet while using colors and fonts before
  • Typed in general formulas and used basic spreadsheet functions like IF, MAX, MIN among others.
  • Built a table before and done some drag and fill operations on formulas
  • Used fundamental Excel features like Sort, AutoFilter and have built charts
  • Used relational operators <, >, <=, >=, <>, =

 

  LEVEL 1

Price: 600,000 Uganda Shillings
Duration: 4 Weeks
Classes: Regular 09-11hrs, 14-16Hrs, 19-21Hrs
  Weekends 09-14Hrs

 

COURSE OUTLINE

WEEK 1 WEEK 3
Introduction to Advanced Excel Printing your work
Entering and Editing Worksheet Data Excel and the Internet(Creating/saving your work as html files)
Introduction to Advanced Formulas & Functions
Creating Formulas that LOOKUP values Introduction to Charts and Charting
Creating Formulas that COUNT & SUM Protecting your work
Creating Formulas for Financial Applications Database Features in Excel
WEEK 2 WEEK 4
Data Visualisation using Conditional Formatting Introduction to PIVOT TABLES
Introduction to Excel Tables Performing Worksheet What-If Analysis
Working with Cells and Ranges Analysing Data using Goal Seeking and Solver
Worksheet Operations and Formatting Programming Excel with VBA
  CONCLUSION
  COURSE ASSESSMENT
  AWARDS

 

 

LEVEL 2

Price: 1,200,000 Uganda Shillings
Duration: 2 Months
Classes: Regular 09-11hrs, 14-16Hrs, 19-21Hrs
  Weekends 09-14Hrs

 

COURSE OUTLINE

WEEK 1 WEEK 5  
An Introduction to Advanced Excel Level 2, A

Summary of Advanced Excel Basics

Advanced Excel Calculations with CRITERIA & FUNCTIONS: AND, BETWEEN, SUMIFS, DSUM, COUNTIFS, AVERAGEIFS, OR, DCOUNTA, IF…  
Comprehensive Excel Formulas’ order of precedence
WEEK 2 WEEK 6  
Excel Data validation (20+ Examples) ROUND  functions(ROUND, MROUND,

ROUNDUP, CEILING)

 
Conditional Formatting(Basic to Advanced – 50+ Examples)
Introduction to SumProduct  
Advanced Charts and Charting Performing Magic with Array Formulas  
WEEK 3 WEEK 7  
Defined Names and AGGREGATE functions VLOOKUP Functions indepth (20+ Examples)  
Cell References: Relative References, Absolute References, Worksheet References, Workbook References, 3D References, Table Formula Nomenclature References, Structured References Advanced Functions that LOOKUP text  
INDEX and MATCH Functions for unusual Lookups  
CHOOSE Function to lookup multiple tables  
WEEK 4 WEEK 8  
Making your Sheets Error free Recorded Macros Basics including Absolute and

Relative Refrences

 
Importing and cleaning Data
Analysing Data with PIVOT TABLES
COURSE ASSESSMENT  
COURSE REVIEW  
AWARDS  

 

 

 

LEVEL 3

Price: 2,500,000 Uganda Shillings
Duration: 2 Months
Classes: Regular 09-11hrs, 14-16Hrs, 19-21Hrs
  Weekends 09-14Hrs

 

COURSE OUTLINE

WEEK 1 WEEK 5
Introduction to DAX(Data Analysis Expressions Expanding the Data Model in Power Pivot
Working with Excel Add-Ins WEEK 6
Power BI and BI Tools Analysing Geospatial Data with Power Maps
WEEK 2 Creating and Formatting Powerview Reports
Using Power Query to get Data Creating Powerview visualisations
WEEK 3 WEEK 7
Modeling your data with Power Pivot Sharing your Data using Power BI for Office 365
WEEK 4 Creating Interactive KPI Dashboards
Enhancing Pivot Tables and Pivot CHarts with Power Pivot WEEK 8
Course Review
AssessmentAwards

 

Left Menu Icon

Assign a menu in the Right Menu options.