Advanced Excel Single Class (Online)

Registration Link

Course Title:

Advanced Excel Single Class (Online)

Course Overview:

This course is designed to equip students with the essential skills and knowledge needed to excel in Microsoft Excel. Whether you’re a beginner or looking to enhance your existing skills, this class will cover a wide range of topics to make you proficient in spreadsheet management, data analysis, and reporting.

Course Outline:

DayContentsClass TypeHour
1Getting to start with Microsoft Excel
Screen Elements and its features Customization of user Interface		Recorded1 Hour
2Formula & Functions Concept and Operators
Formatting tools and their proper use
most popular and useful functions with Examples
Download and Install add-ins for number conversions.		Live1 Hour
3Project (Data Entry Format & Inventory Management)
Some useful Functions
Cell References with Examples		Live1 Hour
4ClassworkLive1 Hour
5Home tab explains,
Excel Table and Table Design Tools
Paste Special, Conditional Formatting, Find & Select		Live1 Hour
6ClassworkLive1 Hour
7Data Summarizing Functions with Examples
Sort and Filter, Advanced Filter		Live1 Hour
8ClassworkLive1 Hour
9Insert Tab and Page Layout tab All
Setting Before Print		Live1 Hour
10Logical & Information Functions
If, Nested if and Ifs Function with lots of Examples		Live1 Hour
11Classwork – Nested If and OthersLive1 Hour
12Lookup & Reference Functions (Part -1) With ExamplesLive1 Hour
13ClassworkLive1 Hour
14Dynamic Name Range
Data Validation, Error handling
Drop-down list, dependable & searchable Drop-down list.		Live1 Hour
15Advanced Lookup and dynamic links (Project Work)Live1 Hour
16Date & Time Functions (All) With ExamplesLive1 Hour
17Backstage View, File Security, Text Functions with ExamplesLive1 Hour
18Financial FunctionsLive1 Hour
19Advanced Conditional FormattingLive1 Hour
20Excel MCQLive1 Hour
21Analyze data with PivotTableLive1 Hour
22Classwork Reports with pivot tableLive1 Hour
23Analyze data with PivotTableLive1 Hour
24Data visualization with Charts, Pivot ChartsLive1 Hour
25Creating a Dashboard using Pivot Tables, Charts, Functions, and FormulasLive1 Hour
26Elements and Controls for Interactive DashboardLive1 Hour
27Creating a Dashboard using Functions, and FormulasLive1 Hour
28ClassworkLive1 Hour
29Get & Transform Data
What & Why Power Query Editor
Interface Intro
Getting Data & basic transformation		Live1 Hour
30Combining sheets and workbooks from different resourcesLive1 Hour
31Clean, and Merge messy dataLive1 Hour
32ClassworkLive1 Hour
33What, and Why Power PivotLive1 Hour
34ClassworkLive1 Hour
35What, and Why Macro and VBALive1 Hour
36ClassworkLive1 Hour
37ExamLive1 Hour

Class Schedule:

  • 30 Days Session (+7 Days Bonus Class)
  • Per day One Hour
  • Saturday will be off

Platform:

  • The Class will be live via Google Meet

Requirements:

  • Use headphones for better audio quality.
  • Stable internet connection and a computer device (Laptop, Desktop, Mobile) with Excel installed

Q&A Sessions:

  • Participate students can ask questions during the class.

Assessment and Feedback:

  • Every day we will provide one assignment for homework.
  • We will receive feedback from students to improve our course structure, contents, and delivery for future classes.

Help and Support:

  • Sessions will be recorded for review in case of missed classes.
  • We will provide guidelines for troubleshooting common technical issues.
  • After completing the course, the instructor will be ready to help with daily life Excel problems.
  • We will provide information regularly about any updates, additional resources, or changes to the schedule.

Registration:

  • Registration Link           : The link will be provided via Email or WhatsApp

Instructor:

Name   : Sanjay Kumar Shrestha (Known as Excel with me Nepal)

Experience:

For the past 12 years, I have had the privilege of sharing my knowledge. I find immense joy in teaching and empowering individuals to navigate the world of Excel with confidence. My training sessions are designed to cater to all skill levels, from beginners looking to grasp the basics to advanced users seeking to enhance their proficiency.

Special Offers :

  • If you have a recommendation from my old student then you will get a 30 % Discount for one-to-one online classes. 

Conclusion:

Join us on a journey to master Microsoft Excel and enhance your spreadsheet skills. Whether you’re a student, professional, or someone looking to boost your Excel proficiency, this class is tailored for you. Don’t miss out on this opportunity to become an Excel expert!

Comments are closed.