The Power BI LIVE Masterclass: Visualize, Analyze, Excel

Accounts Expert

The Advance Excel LIVE Course&nbsp;Batch Timings is 7:10pm to 8:00pm&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

₹999
₹15,000
93.34% off

₹999
₹10,999
90.92% off

Contact

Quick Links

Download App

Follow us

All Courses

₹999 ₹15,00093.34% off

₹999 ₹10,99990.92% off

Contact

Quick Links

Download App

Follow us

₹999
₹15,000
93.34% off

₹999
₹10,999
90.92% off