Microsoft Excel - Beginner to Advanced (Recorded)

<p><strong>Learn Excel step by step, from the basics to formulas, pivots, charts and dashboards.</strong></p> <p>This is the Excel course we have taught in our classrooms since 2016, now recorded so you can learn at home.</p> <p>You start with the basics: how Excel works, formatting, references and dropdowns. Then you learn the functions every office uses (date, logical, maths, lookup and text) and finish with charts, pivot tables, data tools and a complete dashboard built on a real-world scenario.</p> <p>Every topic is shown live in Excel. Pause, practise along, and replay anything you need.</p> <h3>What you&#39;ll learn</h3> <ul> <li>Excel basics: structure, formatting, cell references across sheets and workbooks</li> <li>Named ranges, dropdowns and dependent (hierarchy) dropdowns</li> <li>Date functions: DATEDIF, NETWORKDAYS, WORKDAY, EDATE, EOMONTH and more</li> <li>Logical functions: IF, IFS, AND, OR, IFERROR and nested formulas</li> <li>SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, SUMPRODUCT, RANK and SUBTOTAL</li> <li>VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, INDIRECT and OFFSET</li> <li>Text functions: LEFT, RIGHT, MID, FIND, TRIM, SUBSTITUTE, TEXT and more</li> <li>Static and dynamic charts, pivot tables, conditional formatting and sparklines</li> <li>Protect sheets and workbooks, track changes, Goal Seek, Scenario Manager, Data Table</li> <li>Build a dashboard from start to finish</li> </ul> <h3>Who this course is for</h3> <ul> <li>Beginners who want a strong Excel base</li> <li>Job seekers for MIS, data entry, accounts, HR and operations roles</li> <li>Working professionals who want to work faster in Excel</li> </ul> <h3>Requirements</h3> <ul> <li>A laptop or PC with Microsoft Excel</li> <li>No prior Excel knowledge needed</li> </ul> <h3>Curriculum</h3> <p><strong>Section 1 - Excel Basics</strong><br /> Structure of Excel; formatting (borders, colours, fonts); Excel versions; references across sheets, workbooks and closed workbooks; Define Name; dropdowns with Data Validation and combo box; hierarchy dropdowns; shortcut keys</p> <p><strong>Section 2 - Date &amp; Time Functions</strong><br /> DATEDIF, DATE, TODAY, NOW, WEEKDAY, DAY, MONTH, YEAR, NETWORKDAYS(.INTL), WORKDAY(.INTL), HOUR, MINUTE, SECOND, WEEKNUM, EDATE, EOMONTH</p> <p><strong>Section 3 - Logical Functions</strong><br /> IF, IFS, AND, OR, NOT, IFERROR, nested formulas</p> <p><strong>Section 4 - Arithmetic &amp; Statistical Functions</strong><br /> COUNT family, SUM, SUMIF(S), SUMPRODUCT, SUBTOTAL, AVERAGE family, MAX/MIN(IFS), LARGE, SMALL, RANK, MOD, RANDBETWEEN</p> <p><strong>Section 5 - Lookup &amp; Reference Functions</strong><br /> Freezing, CHOOSE, MATCH, VLOOKUP, HLOOKUP, XLOOKUP; formula combinations and array formulas; INDEX, INDIRECT, wildcards, OFFSET; activities with form controls</p> <p><strong>Section 6 - Text Functions</strong><br /> UPPER, LOWER, PROPER, LEN, LEFT, RIGHT, MID, FIND, SEARCH, TRIM, CLEAN, CHAR, CODE, CONCATENATE, SUBSTITUTE, REPLACE, REPT, VALUE, TEXT, ABS, ROUND</p> <p><strong>Section 7 - Charts</strong><br /> Chart areas, chart types, static and dynamic charts</p> <p><strong>Section 8 - Pivot Tables</strong><br /> Static pivots, formulas in pivot tables</p> <p><strong>Section 9 - Home &amp; Insert Tab</strong><br /> Format conversion, merge and wrap, conditional formatting (including formula-based), Format as Table, sparklines</p> <p><strong>Section 10 - Data, View, Page Layout &amp; Review Tabs</strong><br /> Protection, hiding formulas, track changes, comments, consolidation, Scenario Manager, Goal Seek, Data Table, grouping, trace precedents and dependents, evaluate formula, advanced sort and filter, Text to Columns, Remove Duplicates, Data Validation</p> <p><strong>Section 11 - Dashboard Project</strong><br /> A dashboard built on a real-time scenario</p> <h3>Frequently asked questions</h3> <p><strong>How long can I access the course?</strong><br /> Lifetime access. Watch as many times as you like.</p> <p><strong>Can I watch on my phone?</strong><br /> Yes. Watch on the Excel Logics app (Android/iOS) or on learn.excellogics.co from any laptop or phone.</p> <p><strong>Is this a live class?</strong><br /> No, these are recorded classes you watch at your own pace. For live classes with a trainer, WhatsApp us on 9010290253 about our morning and evening live batches.</p> <p><strong>Will I get a certificate?</strong><br /> Yes. Complete all lessons and quizzes to download your Excel Logics certificate.</p> <p><strong>Which Excel version do I need?</strong><br /> Excel 2016, 2019, 2021 or Microsoft 365.</p> <p><strong>I have a doubt. Who do I ask?</strong><br /> Post it in the course comments or WhatsApp us on 9010290253.</p> <p><strong>How do I pay?</strong><br /> UPI, debit/credit card or net banking on the secure checkout. You get access immediately after payment.</p>