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>

All Courses

$12.97
$98.79
86.87% off

Contact

Quick Links

Download App

Follow us

All Courses

$12.97 $98.7986.87% off

Contact

Quick Links

Download App

Follow us

$12.97
$98.79
86.87% off