skecnepal@gmail.com +977-9817745587 014106547

SAI KRISHNA EDUCATION FOUNDATION

Advanced MS-Excel Training in Nepal

Enrollment Open

Course Description

The Advanced MS-Excel Training course is targeted for data analysts, business managers, accountants, research scientists, students, and other professionals for enhancing their analytical skills and strategic decision-making ability. The course aims to make trainees familiar with advanced MS-Excel features that are useful in performing complex business operations and overall management functions.

Course Highlights

  • Familiarity with advanced features and functions of MS-Excel spreadsheet.
  • Learning complex calculation and data analysis process using various MS-Excel tools.
  • Practical knowledge on using advanced MS-Excel features in business environments.
  • Understanding of conditional statements, Pivot Tables, Charts, and Macro operations.
  • Includes a final Project Work to implement learned skills.

Benefits of this Training

Career Benefits in Nepal

  • High demand for skilled data analysts.
  • Data-oriented individuals are given more attention to details.
  • The career path for data analysts is always on the rise.
  • Increased chances to work in international companies.

Why Train With Us?

  • Expert instructors with a decade of experience.
  • Availability of official Excel certifications.
  • Placement opportunities for deserving trainees.
  • Sufficient training resources and materials provided.
  • Regular practical classes for real-world application.

Detailed Course Syllabus

1
Customizing the Excel Environment
  • Customize the Quick Access Toolbar & Ribbon
  • Change default workbook settings (fonts, sheets)
  • Protect Workbook, Sheet, and set Passwords
  • Save worksheets as PDF files
2
Essential Worksheet Operations
  • Manage Worksheets (Rename, Copy, Hide/Unhide)
  • Insert/Delete Rows, Columns, and Cells
  • Freeze Panes and Split Windows for easy viewing
  • Create, Edit, and Delete Hyperlinks
  • Compare sheets side-by-side
3
Advanced Data Handling
  • Enter data with AutoFill and Flash Fill
  • Advanced Formatting for Numbers, Text, and Dates
  • Create and Manage Named Ranges
  • Use Paste Special (Operations, Transpose, Paste Link)
  • Group and Outline data for better organization
4
Formulas and Functions
  • Principles of Absolute vs. Relative References
  • Build links between cells and worksheets
  • Advanced Nested Functions (IF, VLOOKUP, etc.)
  • Techniques for combining multiple formulas
  • Auditing and Evaluating Formulas
5
Exploring Excel as a Database
  • Multi-level Sorting and Custom Sort Lists
  • Advanced Filtering (Text, Number, Date filters)
  • Using Excel Tables for structured data
  • Removing Duplicate Rows
  • Importing data from external sources
6
Data Validation & Conditional Formatting
  • Create custom data validation rules
  • Build dynamic validation lists
  • Apply formatting based on cell values or formulas
  • Use Data Bars, Color Scales, and Icon Sets
  • Manage multiple formatting rules
7
PivotTables & PivotCharts
  • Create and Modify PivotTables
  • Group, Filter, and Sort PivotTable data
  • Change summary calculations (Sum, Count, Average)
  • Apply custom styles and conditional formatting
  • Create dynamic PivotCharts from PivotTables
  • Consolidate data from multiple sources
8
What-If Analysis
  • Use Goal Seek to find desired inputs
  • Create and manage Scenarios for different outcomes
  • Build one-variable and two-variable Data Tables
  • Generate visual forecasts with Forecast Sheet
9
Advanced Charting & Graphics
  • Choose the right chart type for your data
  • Customize chart elements (axes, titles, legends)
  • Add Trendlines for data analysis
  • Save charts as templates for reuse
  • Create 3D Maps for geographical data
10
Macros & Automation
  • Understand the purpose of Macros
  • Record, Run, and Edit simple Macros
  • Assign Macros to buttons for easy access
  • Introduction to the basics of VBA
11
Collaboration and Printing
  • Add, Edit, and Manage Comments in cells
  • Set print titles and scale printed output
  • Force printing on a specific number of pages
  • Add custom Headers and Footers with images
12
Excel Tips & Tricks
  • Essential Keyboard Shortcuts for efficiency
  • Advanced Formatting Tips
  • Efficiency tips (Templates, Tables, Named Ranges)
  • Customizing the Excel interface to your needs

Ready to Master Advanced Excel?

Please reach out to us anytime via email, online forms, our social media pages, or telephone to ensure your seat for the upcoming Advance Excel training session. Our Excel instructors are excited to provide this special training to you!

Enroll Now