Consulting services can provide valuable insights, strategic guidance, pecialized

+112 (789) 568 25 +112 (789) 568 25

help@gmail.com

1901 Shiloh, Hawaii 81063

Shopping cart

Subtotal $0.00

View cartCheckout

WELCOME TO NICE IT SERVICES

WELCOME TO NICE IT SERVICES

BROCHURE

WELCOME TO NICE IT SERVICES

BROCHURE
JOURNAL 4

Advance Excel

Join the program and get the opportunity to learn under the guidance of Excel specialist.

4.8 out of 5 based on 50 reviews

Advance Excel

Advanced Excel is an essential skill for professionals looking to enhance their data analysis, reporting, and decision-making capabilities. This level of Excel proficiency goes beyond basic functions and formulas, introducing powerful tools like pivot tables, advanced charting, data visualization, and complex functions such as VLOOKUP, INDEX, MATCH, and array formulas.

DOWNLOAD CURRICULAM
GET QUICK CALL BACK

Enquire Now

Contact Form Demo

Total 3 Modules ( Click For Details )

MODULE 1 : BASICS OF EXCEL (DATA ENTRY)
1. Workbook, Worksheet, Workspaces
2. Row & Column Settings
3. Calculation Basics in Excel
4. References (Relative, Absolute, Mixed)
5. Find & Replacing Data
6. Header & Footer setting
7. Auditing, Freeze Panes
8. Autofill, Autocorrect, Autoformat
9. Working with Charts
MODULE 2 : EXCEL FUNCTIONS
1. Logical Functions

if, Nested if, AND, OR, NOT, XOR, False, True etc.

2. Date and Time Functions

Date, Day, Now, Today, Month, Year, Time, Weekday etc.

3. Information Functions

Cell, Error, Isnumber, Iseven, Istext, Type, etc.

4. Data Base Functions

DSUM, DMAX, DMIN, DCOUNT, etc.

5. Math & Trignomatry Functions

Rand, Round, MOD, SUMIF, LCM etc.

6. Statistical Functions

Average, COUNTIF, MAX, MIN, Count, Countblank, etc.

MODULE 3 : DATA ANALYSIS IN EXCEL (ADVANCE EXCEL)
1. If And Analysis, What if Analysis
2. Goal Seek, Solver, Scenarios
3. Naming Cell Range (Local and Global)
4.Protecting sheet & workbook
5. Importing and Exporting Data
6.Grouping and Subtotal
7. Macro (recording tool)/EDITING
8. Customizing Sheet/Cells /Rows/Columns
9. Customizing Excel Window
10. Sorting and Filtering Data, Advance Filter
11. Data Validation
12. Pivot Table, Pivot Chart
13. Consolidation of Sheets
14. H Lookup, V Lookup, X Lookup
15. RD Calculation
16. Printing Worksheet, Custom List
17. Working with Excel CSV files
18. Making Excel to PDF file
# Live Project Work
19. Creating Reports, Marks sheet etc
20. Creating Reports, Marks sheet etc
21. ChatGPT for EXCEl (AI)

Find The Right Course For You

Testimonials

Enquire Now

Contact Form Demo
Call Now Button