• 5/36C Korangi 5, Karachi, near Rashid Latif Cricket Academy.
  • info@kca.com.pk
  • Follow Us On :
Accounting

Excel Expert

CERTIFICATE IN ADVANCE EXCEL: Join our advanced Excel course to propel your skills to new heights! Designed…

CERTIFICATE IN ADVANCE EXCEL:

Join our advanced Excel course to propel your skills to new heights! Designed for individuals with a fundamental understanding of excel, this program delves into advanced functions and formulas, data analysis tools like pivot tables and power query, macro automation, data visualization techniques, data validation and protection, advanced data cleaning and transformation, collaboration and sharing methods, and expert tips and tricks. Elevate your data analysis capabilities and become a proficient advanced Excel user with our comprehensive course.

What you learn:

·         Introduction to formulas

·         Professional charts building

·         Advance functions

·         Automated report building

·         Data consolidation and validation

·         Pivot table and pivot charts building

·         Data visualization and analyzation

·         Executive basic dashboard

·         Database concepts

·         Short keys

·         Advanced lookup function

Tools

  • Basic Excel
  • Advanced excel

Exit Profile

  • Accountant
  • Assistant Accountant

Course Curriculum

ADVANCE EXCEL

  • The Named Range
  • The Lookup Functions
  • The Hlookup
  • The VLOOKUP
  • More Working with Hlookup
  • Create Currency
  • Rate Calculator with VLOOKUP
  • The Lookup
  • The If Functions
  • Financial Functions
  • Data Base Concepts & Its Functions
  • Misc. Valuable Functions
  • The Sorting
  • The Filters
  • The Advance Filters
  • The Subtotals
  • The Data Validation
  • The Form
  • Charts Concept
  • Working with Chart
  • Macro
  • Running the Macros
  • Modifying the Macro
  • Macro or Procedure
  • Adding Comments
  • Converting Numeric into Text Adding Controls
  • The Conditional Formatting
  • The Grouping and Outlines
  • The Pivot Table
  • Apply Data Analysis and Pivot Table
  • Use Pivot Table Auto Format
  • Create Pivot Chart Reports
  • Manipulating A Pivot Table
  • The Solver
  • Some More Essential Tips

Final Project