DATA ANALYSIS WITH EXCEL TRAINING (PHYSICAL & VIRTUAL)

Data Analysis with Excel Training in Lagos, Nigeria

Megatek ICT Academy Training is Fun, Beneficial, Project based and Practical Oriented

10 + 14 =

Hello! Welcome to Megatek ICT Academy, where we train students on IT related courses, we move our students from Amateur to Professional within a short period of time.

PROJECTS TO BE DONE

PROJECT 1

Dashboard

PROJECT 2

Financial Dashboard

PROJECT 3

HR Dashboards

PAST STUDENTS WORK

STUDENT 1

STUDENT 2

STUDENT 3

Course Detail

Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the huge amount of data, performing data analysis, better representation of data, etc.

 

This course is designed for students who already have foundational knowledge, skills and experience working with Excel. The student will now begin taking advantage of some of the higher-level functionality in Excel such as creating macros, working with shared documents, analyzing data, and auditing worksheets

 

At the end of the course  students will build upon the foundational Microsoft Excel knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering. In addition, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analysing data, and using Excel data in other applications.

Course Outline

  • Customizing the Excel Environment
  • Creating Advanced Formulas
  • Analyzing Data with Functions and Conditional Formatting
  • Organizing and Analyzing Datasets and Tables
  • Visualizing Data with Basic Charts
  • Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Working with Multiple Worksheets and Workbooks Simultaneously
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Applying Conditional Logic
  • Auditing Worksheets
  • Using Automated Analysis Tools
  • Presenting Your Data Visually

Benefits

Customer Acquisition and Retention

Focused and Targeted Promotions

Potential Risks Identification

Innovate

Complex Supplier Networks

Cost optimization

Improve Efficiency

Fee

Duration: 2 Weeks

Price: 65,000

FAQ

Who is this course designed for?

This course is designed for anyone interested in Learning Data Analysis, including professionals, students and entrepreneurs.

Do I need Prior Experience

No experience is needed, all you need to know is how to operate the system.

Will I have access to resources and software?

Yes! All the resources needed for the duration of the class will be given to you