Advanced Excel

Advanced Excel Training Course – Master Formulas, Pivot Tables & Data Analysis

Advanced Excel Course in Nepal

21 days. NPR 1,999. 84% off. Master the skill every Nepal employer asks about first.

If you're searching for the best Advanced Excel course in Nepal, this is it. Code IT's 21-day training covers everything from essential formulas and data validation to Pivot Tables, Power Query, dynamic dashboards, VLOOKUP, XLOOKUP, INDEX & MATCH, SUMIFS, macros, and professional data cleaning — skills that banks, finance companies, corporates, and NGOs in Nepal hire for immediately.

Excel proficiency is no longer optional in Nepal's job market. Whether you're applying for a finance, data analyst, admin, or business operations role — employers ask about Excel in every interview. This course makes sure your answer is "very well" — and you can prove it with a portfolio of real dashboards and reports.

Your instructor, Sita Katuwal, has 5+ years of dedicated Excel training experience — every shortcut, trick, and formula you'll learn is drawn directly from real workplace practice in Nepal.

Live classes run from 7:00 PM to 8:00 PM via Google Meet, accessible from Kathmandu, Pokhara, Biratnagar, Butwal, Chitwan, Birgunj, or anywhere in Nepal. Classroom sessions available in Dharan. Only basic computer knowledge required.

Every student receives lifetime video access and an industry-recognized certificate from Code IT.

Prerequisites

Basic computer knowledge is required.
Advanced Excel

Advanced Excel

Next batch starting soon

Mode: Online (Google Meet) Google Meet
Duration: 21 Days
Rs.1,999/-
Rs.12,500 Save 84%
Enquiry

Have any Question?

WhatsApp: 9862130505
Telephone: 025-575163

Everything You Receive

All-inclusive support — from training to real-world experience

Live Classes

Google Meet
8:00 PM - 9:30 PM

Lifetime Videos

Re-watch anytime

Certification

Industry recognized

Internship

No internships are available right now.

Course Curriculum

Everything you'll learn — from fundamentals to advanced concepts

What you will learn

  • Advanced Formulas & Functions

  • Data Analysis & Pivot Tables

  • Data Visualization & Charts

  • Data Management & Automation

  • Advanced Projects & Real-World Applications

01 Data entry and Formatting
Data entry work
Data transpose
Fill series
Keyboard navigation
Data entry Trick
Data entry form
Data validation
Flash fill
Gridline, formula bar, heading…hide/show
02 Number, Editing
Across worksheet
Cell format &style(pcs, Rs,..)
Clear format & input data
List show trick(alt+pgdn)
Blank cell find and auto fill
Blank row find and delete
Remove duplicate
Convert number into Roman number
Find Square
Find Cube
Find Square Root
03 Basic Formulas and Functions
Arithmetic Operations
Using Sum, Average, Min, Max function
Cell References (relative and absolute)
Percentage
Decrease & increase Decimal
Count Number
Trace Presidents
Trace Dependents
Freeze pane
Data selection trick
Clear data
04 Perform Calculations with Functions
How to Apply Formula
SUM
Subtraction
Multiplication
Percentage
Count
Counta
Countblank
Countif
Rank
Logical Functions (If, and, or, if or)
Rank
05 Logical Function
Logical functions: IF, AND, OR.
Nested formulas.
Text Function: CONCATENATE, LEFT, RIGHT.....
06 Lookup Function
Using LOOKUP, VLOOKUP and HLOOKUP.
Introduction to XLOOKUP
Using INDEX and MATCH for advanced lookups.
07 Types of Error
#### error
#NAME? ERROR
#VALUE! ERROR
#DIV/0! Error
#NULL! ERROR
#REF! ERROR
#N/A ERROR
#NUM! ERROR
08 Data Analysis
Sort
Filter
Conditional formatting
Highlight Cell Rules
Top Bottom Rules
Data Bars
Colors Scales
Icon Sets
Manages Rules
Quick Analysis
Data Analysis
09 Working with Tables
Creating and formatting tables
Using table features like filters
Total row and structured references
Convert table to Range
10 Date Formulas
Day, Month, Year
Date
Text
Eomonth
datedif
Networkdays.Intl
Workday.Intl
Edate
Weeknum
Number to month
AD2BD
BD2AD
Convert Date Format
Number to word
11 Data cleaning and Preparation
Remove Duplicates
Remove Blanks Rows
Remove blank Space
Change case using formula
Proper, upper,lower,
Fix negative stock values
Split data
12 Chart
Creating basic Charts
Formatting chart elements
Using different chart types
13 Pivot Table
Pivot table
Pivot chart
Slicer and slicer settings
Timeline
Grouping, custom grouping
Pivot table option setting
Show value as
Calculated field
Filters and filter report pages
Dynamic pivot table
Pivot table on multiple sheets
Getpivot data formula
Auto refresh pivot table
Creating Dashboard Using pivot table
14 Power Query
Split column in power query
Group by Power Query
Unpivot Column
Append Query
Merge Query
Append Multiple Table using Power Query
Date function in power query
Time Difference in power query
Add Column in Power Query
15 Statistical Formula
Sumif/Sumifs
Countif/Countifs
Averageif/ Averageifs
Maxif/Maxifs
Minif/Minifs
16 Advanced Features
Protecting worksheets and workbooks
Macros basics
Automatic data enytry form
17 Page Setup
Paste Special
Page Setup
Print titles
Heading
Header & Footer
Page num, time,date,file path,picture
Print area set
How to print

Earn Your Certification

After completing the course, you will receive a professional certificate from Code IT, verified by industry leaders in Nepal.

Share your achievement with pride on LinkedIn.
Certificate

Course Mentors

Learn directly from industry experts with years of hands‑on experience

Sita Katuwal

Sita Katuwal

Ms office package & Tally Instructor

CodeIT, Nepal 5+ Years of Experience
Get in Touch

Need More Information?

Our team will respond within a few hours

Why Enquire?

Payment plans & installment options
Certificate & accreditation details
Course level & suitability check
Flexible batch timings
Career guidance & job support

Join 100k+ successful graduates

We'll respond within 2-3 hours during business hours

Watch Demo Video

Advanced Excel

Open on YouTube ↗