What You Will Learn?

• Learn advance formula
• Learn data, power query , tables and formatting
• Learn Advance Charting
• Pivot table and pivot reporting
• Tables with advance level
• Learn about Macros

Duration: 1 months Classes: 12 Hours: 24

Advance excel

enroll now

In The Advance Excel You Will learn

ADVANCE EXCEL COURSE OUTLINE

• if conditions
• lookup functions
• paste special
• pivot table & charts
• hyperlink
• files import & export
• attendance sheet
• property window
• student report
• marksheet
• sum if function
• data sorting
• basic & advance formulas

• nested formula
• database functions
• filter/ advance filter
• if analysis
• data validation
• working with scenario
• payroll statementl
• sales report
• macros
• advance macros
• charts & graphs

OTHER COURSE

C - Programing

PHOTOSHOP

ADVANCE EXCEL

java programing

web designing

php

android

asp.net

SQL Server

SEO

Graphics

Python

Wordpress

Iot

Microsoft office