Scribd
Upload
11 views1 page

Schedule Excel

Uploaded by

Bikash Chapagain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views1 page

Schedule Excel

Uploaded by

Bikash Chapagain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Nepal Electricity Authority

Training Center , Kharipati Bhaktapur


Training Programme on Advance Excel

Days Date/Day 10:00 AM- 11:30AM 11:35AM - 1:25PM 02:00PM- 3:30PM 03:35PM - 5:00PM

Logical Operators,If Fuctions, Nested if,


Indroduction, Customize Quick Access Use of Named Cell, Named Range in
use of AND, OR funstions, working with
ToolBar, Creating Formulas, Cell functions and data validation, Paste
1st 6/30/2024 Opening dates and times, age
Referencing, Connection and Links Special function
calculation
(T) SB (P) SB
(T) SB

Working With text and Numbers


(Left, Right, Mid, Value, Len, trim, Lookup function, Match, Index, Conditional Calulations Practice work: Working with real
2nd 7/1/2024 concatenate, find, Round, Ceiling Indirect Sumifs,Countifs,Average,Countif applications
floor, Trunc ) (P) SB/RK (P) SB/RK (P) SB/RK
(P) SB/RK

Working with
Array(Mmult,minv,maxif, Making Table, Subtotal, Pivot Table and
sumproduct), Excel functions Conditional formatting Sorting, Autofiltering, Advance Filtering Pivot Chart, Making Charts and
3rd 7/2/2024
( Isnumber, Isblank, Istext,T, Iserror, (P) SB/RK (P) SB/RK Diagrams
iferror) (P) SB/RK
(P) SB/RK

Introduction to Excel Macro


Importing file, Remove duplicates, Recording Macro, Using Recorded
Practice work: Working with form and
Text to column, Goal Seek, Solver, macro to perform repeating actions, Introduction to Excel VBA
4th 7/3/2024 coding real problem
Analysis toolpack Assigning macro, Create buttons, (T) RK
(P) SB/RK
(P) SB/RK Assigining macro to buttons
(P) SB/RK

VBA programming (Concept on


VBA programming (Conditional Variables/ Constants,Operators & Practice work: Working with form and
5th 7/4/2024 Statements & loop, Certain functions) Built-In functions (range, address, cell, coding real problem Closing
(P) SB/RK worksheet, workbook, etc (P) SB/RK
(P) SB/RK

Instructor : (S.B )Showet Basnet


Instructor : (R.K) Rebika Koju

You might also like