Know About Your Trainer -&nbsp;This live Google Sheets course is designed and led by Ms. Tanu Singhal, a highly skilled data professional with over 3 years of corporate experience as a Senior Data Analyst. In addition to her industry expertise, she has successfully trained more than 5,000 students as a freelance instructor, helping them master data tools and techniques used in real-world business environments. 
Module 1: Getting Started &ndash; The Basics
<ul>
	<li class="MsoListBulletCxSpFirst">&bull; What is Google Sheets? (Difference from Excel)</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Understanding the interface</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Creating, renaming, saving sheets</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Rows, Columns, and Cells &ndash; how they work</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Entering data and basic formatting (bold, color, alignment)</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Freezing rows/columns</li>
	<li class="MsoListBulletCxSpLast" style="margin-bottom:13px">&bull; Basic formulas: SUM, AVERAGE, COUNT, MAX, MIN</li>
</ul>
<h2 style="margin-top:13px">Module 2: Smarter Work &ndash; Functions &amp; Formatting</h2>
<ul>
	<li class="MsoListBulletCxSpFirst">&bull; Text Functions: LEFT, RIGHT, SPLIT, LEN</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Date Functions: TODAY, NOW, DATEDIF</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Logical Functions: IF, AND, OR</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Lookup Functions: VLOOKUP, INDEX, MATCH</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Conditional Formatting (change colors based on conditions)</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Dropdown lists using Data Validation</li>
	<li class="MsoListBulletCxSpLast" style="margin-bottom:13px">&bull; Adding Checkboxes</li>
</ul>
<h2 style="margin-top:13px">Module 3: Mastering the QUERY Function</h2>
<ul>
	<li class="MsoListBulletCxSpFirst">&bull; What is QUERY and why is it powerful?</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Simple SELECT and WHERE conditions</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Filtering data by text, number, and date</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Sorting data using ORDER BY</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Aggregating with SUM, COUNT, AVG</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Using GROUP BY in QUERY</li>
	<li class="MsoListBulletCxSpLast" style="margin-bottom:13px">&bull; QUERY across different sheets using IMPORTRANGE</li>
</ul>
<h2 style="margin-top:13px">Module 4: Dashboards in Google Sheets</h2>
<ul>
	<li class="MsoListBulletCxSpFirst">&bull; What is a Dashboard? Why use it?</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Creating simple charts: Bar, Pie, Line</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Creating KPI cards using formulas</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Adding Slicers (Dropdown filters)</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Connecting QUERY results to charts</li>
	<li class="MsoListBulletCxSpLast" style="margin-bottom:13px">&bull; Clean layout design for reports</li>
</ul>
<h2 style="margin-top:13px">Module 5: Sharing &amp; Collaboration</h2>
<ul>
	<li class="MsoListBulletCxSpFirst">&bull; Share settings: View, Edit, Comment</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Protecting cells or ranges</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Adding comments &amp; notes</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Version history &amp; restoring changes</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Publishing Sheets as a website</li>
	<li class="MsoListBulletCxSpLast" style="margin-bottom:13px">&bull; Sending sheets via email (PDF or Excel)</li>
</ul>
<h2 style="margin-top:13px">Module 6: Final Projects</h2>
<ul>
	<li class="MsoListBulletCxSpFirst">&bull; Sales Report Dashboard &ndash; With charts and filters</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Attendance Tracker &ndash; With checkboxes and summary</li>
	<li class="MsoListBulletCxSpMiddle">&bull; Expense Tracker &ndash; With category-wise breakdown using QUERY</li>
	<li class="MsoListBulletCxSpLast" style="margin-bottom:13px">&bull; Live Google Form Dashboard &ndash; Auto-updating data view</li>
</ul>

Google Sheets Live Course: From Beginner to Expert

Accounts Expert

Q.1 What is Inside the Course? 
At the basic level, you will gain complete knowledge of the program, understand various features, and get to know how things work in Excel.
&nbsp;
Q.2&nbsp; How to Apply for the Certificate?
Watch the complete video on YouTube, submit your feedback within the video, then enroll in the free course or participate in the quiz. Your certificate will be processed and sent to your email within the next 3 days.
&nbsp;
Q.3 Kya participation certificate aur course certificate same hota hai?
No, they are not the same. 
A Participation Certificate simply indicates that you actively took part in an activity or event. 
On the other hand, a Course Certificate involves live assistance from professionals, complete training based on a project-oriented approach, and upon completion, you receive an ISO-certified and QR code-based certificate that can be verified online from anywhere.
&nbsp;
Q.4 - Professional Training me Kya Kya Milta hai?
During the professional training, you get:
<ul>
	<li>
	A mentor who guides you through every feature in detail, explaining how it is used in real companies and how to execute real-world tasks with it.
	</li>
	<li>
	Project-based training, which helps you become familiar with official tools and workflows.
	</li>
	<li>
	Access to a professional community, where you can observe the work of other members, helping you enhance and sharpen your own skills.
	</li>
	<li>
	WhatsApp assistance, where you can share your queries anytime and get support.
	</li>
	<li>
	1 hour of live interactive training daily, giving you consistent hands-on learning.
	</li>
	<li>
	A total of 1.5 months of dedicated time to sharpen your skills.
	</li>
	<li>
	Training on both free and paid AI tools, making you industry-ready.
	</li>
	<li>
	Upon completing the course, you receive an ISO Certified certificate that can be verified online, which is often required for MNCs and government jobs.
	</li>
</ul>

What we&#39;ll cover in this Course -&nbsp;
1 INTRO OF COURSE 
2 ENTIRE SYLLABUS OF ADVANCED EXCEL 
3 GUI OF EXCEL 
4 FILE TAB 
5 FONT PANNEL 
6 CLIPBOARD PANNEL 
7 ALIGNMENT PANNEL 
8 NUMBERS PANNEL 
9 CONDITIONAL PANNEL 
10 FORMAT AS TABLE OPTION 
11 CELL STYLES OPTION 
12 INSERT OR DELETE 
13 FORMAT OPTIONS 
14 FILL AND CLEAR OPTION 
15 SORT AND FILTER OPTION 
16 FIND AND SELECT 
17 PIVOT TABLE 
18 PIVOT CHART 
19 PICTURE OPTION WITH DETAIL 
20 SHAPE OPTION WITH ITS MODIFICATION 
21 ICON AND 3D MODELS 
22 SMART ART AND SCREENSHOT 
23 ADD INS PANNEL 
24 3D MAP 
25 SPARKLINES PANNEL 
26 HYPERLINK OPTION 
27 TEXT PANNEL 
28 THEMES PANNEL 
29 MARGIN, ORIENTATION, AND PAGE SIZE 
30 PRINT AREA, PAGE BREAK, AND PRINT TITLES 
31 GRIDLINES, HEADING AND ARRANGE PANNEL 
32 ALL OPTIONS OF PRINT PREVIEW 
33 SPELLING, THESAURUS, AND STATISTICS 
34 SMART LOOKUP OR TRANSLATE OPTION 
35 COMMENT OPTION 
36 HOW TO SET UP THE PASSWORD ON EXCEL SHEET OR WORKBOOK 
37 WORKBOOK VIEWS 
38 ZOOM OPTIONS 
39 SHOW PANNEL IN VIEW TAB 
40 WINDOW PANEL 
41 SWITCH WINDOWS AND MACROS OPTION 
42 HOW TO IMPORT THE DATA IN EXCEL 
SR NO. TOPICS 
43 TEXT TO COLUM, FLASH FILL, AND DUPLICATE OPTIONS 
44 ADVANCE FILTER 
45 COMPLETE DATA VALIDATION OPTION 
46 CONSOLIDATE OPTION 
47 SCENARIO MANAGER 
48 GOAL SEEK AND DATA TABLE OPTION 
49 GROUP, UNGROUP AND SUBTOTAL 
50 ALL METHODS OF SUM FUNCTION 
51 DIVIDE, MULTIPLY, AND SUBTRACTION OPTION 
52 AVERAGE, COUNT, MIN, MAX 
53 ADVANCE LOOKUP FORMULA 
54 VLOOKUP ADVANCE FUNCTION 
55 HOOKUP FORMULA 
56 ROW, ROWS, COLUM,N AND COLUMNS 
57 RANDOM AND RANDOM BETWEEN FORMULA 
58 HOW TO CALCULATE EMI BY PMT FORMULA 
59 IPMT AND PPMT FORMULA 
60 AVERAGEIF AND AVERAGES 
61 COUNT, COUNT AND COUNTBLANK FORMULAS 
62 COUNTIF ANF COUNTIES 
63 UPPER, LOWER AND PROPER FORMULA 
64 LCM FORMULA 
65 POWER FORMULA 
66 TRIM AND SUBSTITUTE FORMULA 
67 IF FORMULA

Advance Excel Course for Professionals

The Advance Excel LIVE Course&nbsp;Batch Timings is 6:30pm to 7:30pm&nbsp;
This structured 45-day plan ensures professionals gain expertise in Advanced Excel, Data Analytics, and Dashboard Creation while also learning automation techniques using Macros and Power Query...
30-Session Advanced Excel Live Course for Professionals
Session 1-7: Advanced Formulas &amp; Functions
<ol>
	<li style="margin-bottom:11px">Session 1: Introduction to Advanced Excel, Shortcuts &amp; Efficiency Tips</li>
	<li style="margin-bottom:11px">Session 2: Logical Functions: IF, AND, OR, IFERROR, Nested IFs etc.</li>
	<li style="margin-bottom:11px">Session 3: Lookup &amp; Reference Functions: VLOOKUP, HLOOKUP, XLOOKUP etc.</li>
	<li style="margin-bottom:11px">Session 4: INDEX-MATCH vs VLOOKUP: When &amp; How to Use </li>
	<li style="margin-bottom:11px">Session 5: Text Functions: TEXT, LEN, LEFT, RIGHT, MID, TRIM etc.</li>
	<li style="margin-bottom:11px">Session 6: Date &amp; Time Functions: TODAY, NOW, DATEDIF, EOMONTH, NETWORKDAYS etc.</li>
	<li style="margin-bottom:11px">Session 7: Advanced Math &amp; Statistical Functions: SUMIFS, COUNTIFS, RANK, PERCENTILE, Filter, DSSUM, DGET etc.</li>
</ol>
Session 8-14: Data Cleaning, Validation &amp; Pivot Tables
<ol>
	<li style="margin-bottom:11px">Session 8: Data Cleaning Techniques: Remove Duplicates, Flash Fill, Power Query</li>
	<li style="margin-bottom:11px">Session 9: Data Validation: Drop-down Lists, Input Messages, Error Alerts</li>
	<li style="margin-bottom:11px">Session 10: Conditional Formatting: Advanced Rules &amp; Custom Formulas</li>
	<li style="margin-bottom:11px">Session 11: Pivot Tables: Basics &amp; Customization</li>
	<li style="margin-bottom:11px">Session 12: Pivot Charts &amp; Slicers for Dynamic Reports</li>
	<li style="margin-bottom:11px">Session 13: Working with Large Data Sets: Filters, Sorting, Subtotals</li>
	<li style="margin-bottom:11px">Session 14: Hands-on Practice: Real-World Data Cleaning Challenges</li>
</ol>
Session 15-21: Data Analytics &amp; Dashboard Creation
<ol>
	<li style="margin-bottom:11px">Session 15: Introduction to Data Analytics in Excel</li>
	<li style="margin-bottom:11px">Session 16: Report Generation</li>
	<li style="margin-bottom:11px">Session 17: Power Query for Data Extraction &amp; Transformation</li>
	<li style="margin-bottom:11px">Session 18: Power Pivot: Data Modeling &amp; Creating Relationships</li>
	<li style="margin-bottom:11px">Session 19: Creating Interactive Dashboards &ndash; Layout &amp; Design Principles</li>
	<li style="margin-bottom:11px">Session 20: Connecting Charts &amp; Pivot Tables in Dashboards</li>
	<li style="margin-bottom:11px">Session 21: Hands-on Practice: Building a Live Dashboard</li>
</ol>
Session 22-28: Automation, Macros &amp; Final Projects
<ol>
	<li style="margin-bottom:11px">Session 22: Introduction to Macros &amp; VBA: Basics &amp; Recording Macros</li>
	<li style="margin-bottom:11px">Session 23: Writing Simple VBA Codes for Automation</li>
	<li style="margin-bottom:11px">Session 24: Data Entry Form creation with the help of Macros </li>
	<li style="margin-bottom:11px">Session 25: Invoice Creation with the help of VBA &amp; CHAT GPT</li>
	<li style="margin-bottom:11px">Session 26: Finalizing Dashboards &amp; Advanced Reporting Techniques</li>
	<li style="margin-bottom:11px">Session 27: A.I Tools &amp; Add-Ins in Excel</li>
	<li style="margin-bottom:11px">Session 28: Hands-on Project: Real-World Data Analytics &amp; Reporting</li>
</ol>
Session 29-30: Final Q&amp;A &amp; Certification
<ol>
	<li style="margin-bottom:11px">Session 29: Q&amp;A, Troubleshooting, and Best Practices Discussion</li>
	<li style="margin-bottom:11px">Session 30: Certification, Project Review, and Closing Session</li>
</ol>

All Courses

$12.97
$98.79
86.87% off

₹499
₹2,500
80.04% off

₹999
₹10,999
90.92% off

Contact

Quick Links

Download App

Follow us