Advanced Excel Course in Nepal

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

Advanced Excel

Looking for the best Advanced Excel course in Nepal?
Join the professional Advanced Excel Training at Code IT and master data analysis, formulas, pivot tables, dashboards, and automation to enhance productivity and support business decision-making.

This hands-on Excel course is perfect for students across Nepal who want to develop job-ready spreadsheet and data analysis skills. You’ll work with real datasets, create professional reports, and automate tasks using Excel’s advanced features, gaining practical experience applicable in finance, analytics, and business roles.

Our training program offers live online classes accessible from anywhere in Nepal, along with hands-on classroom sessions in Dharan. Build practical Excel skills, work on real-world projects, and prepare for professional opportunities as a data analyst or business professional.

Enhance productivity, develop advanced Excel models, and gain the confidence to work as a professional Excel expert in Nepal’s competitive data-driven industry.

Prerequisites

Basic computer knowledge is required.
Advanced Excel
🎯 Starts in 5 Days

Advanced Excel

Starts: March 12, 2026
Mode: Online (Google Meet) Google Meet
Duration: 21 Days
Class Time: 8:00 pm - 9:30 pm
Seats available - Register now
Rs.1,999/-
Rs.12,500 Save 84%
Enroll Now
Watch Demo Video

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

Internship is not currently available.

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

Enroll Now
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 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

Similar Courses

Explore other programs that might interest you

Power BI
5.0

Power BI

Build industry-ready dashboards and analytical skills employers value

Rs. 2,499
Rs. 16,500 84% off
Curriculum →
Microsoft Office Package
5.0

Microsoft Office Package

Microsoft Office Package Course – Master Word, Excel, PowerPoint & Outlook Skills

Rs. 2,499
Rs. 9,500 73% off
Curriculum →
Tally Prime
4.0

Tally Prime

Tally Prime Course – Master Accounting & Financial Management with Tally Software

Rs. 1,499
Rs. 3,500 57% off
Curriculum →