Learn Basic To Advanced Excel Including Macro!

Upgrade your Microsoft Excel skills and expertise to the next level. Gain proficiency in all-important basic and advanced excel formulas & functions, protection, management and data analysis, Macro (automation) without knowledge of coding with lots of practical examples used across different industries. This course will empower not just students but teachers as well as employees/entrepreneurs.

Course Features:

• 15 hrs 57 min on-demand video

• 18 sections with 57 videos

• Downloadable practice files

• Full lifetime access

• Explained in Hindi Language

• Access on mobile and Computer

Basic Excel

You will learn all about basic MS Excel cells, Excel rows & columns, how to speed up your work with Excel spreadsheets, and lots of basic formulas and functions.

Advanced Excel

You will also learn about advanced formulas and features, data cleaning, data analysis, chart, dashboard, and lots of functions used practically in the industry.

Macro (Automation)

In this competitive working environment, automation is the key to get success. Here you will also learn Automation (Macro) in excel without even knowledge of coding.

Course Modules:

• Introduction – Importance of MS Excel and course details (About advanced level functions, special problems solver, interactive dashboards & Macro for automation).

• Overview Of Excel Interface - Quick access toolbar, Ribbon, Name Box, Formula Bar, Cells, Sheet Tabs, Status Bar.

• Basic formatting & Editing – Insert Row, Insert Column, Merge, Wrap Text, Alignment, Border, Bold, Italic, Underline, Cut, Copy, Paste, Percentage, Currency, Comma, Decimal, Font Style, Font Size, Fill Color, Undo, Redo, Text Orientation, Naming Cell Range, Ribbon customization.

• Basic excel formula – ADD, SUBTRACT, MULTIPLY, DIVIDE, INDICES.

• Type of cell references – Relative Reference, Absolute Reference & Mixed Reference.

• Basic excel functions – ROUND, INT, SUM, SUMIF, COUNT, COUNTA, COUNTIF, AVERAGE, AVERAGEIF, MIN & MAX, RANK, MATCH, INDEX, RAND & RANDBETWEEN

• Types of Chart – Column, Bar, Pie, Line, Combo, etc.

• Essential features of excel – Paste Special, Freeze & Split Panes, Sort & Filter, Page Setup & Print Settings, Conditional Formatting, Data validation, Dependable dynamic Dropdown list.

• Sheet & Workbook Protection – Lock Cells, Hide Formulas, Protect Sheet, Protect Workbook, Allow specific access, Allow specific users to edit ranges & Password protect the excel file, Create excel file backup.

• Advanced Excel Functions – SUMIFS, COUNTIFS, AVERAGEIFS, DATE & TIME, IF, NESTED IF, IF WITH AND/OR, VLOOKUP, HLOOKUP, IFERROR, MATCH, INDEX, INDIRECT, VLOOKUP WITH MATCH, INDEX WITH MATCH, FUZZY LOOKUP, VLOOKUP WITH INDIRECT.

• Miscellaneous Text Function – LEN, LEFT, RIGHT, MID, LOWER, UPPER, PROPER, VALUE, TRIM, CONCATENATE, FIND, SEARCH, SUBSTITUTE, REPLACE.

• Formula Auditing in Excel – Show Formulas, Trace Dependents, Trace Precedents, Remove Arrows, Evaluate Formula.

• What if Analysis – Goal Seek & Solver.

• Merge Data From Multiple Workbooks – Add Compare & Merge Workbook command, Share Workbook, Merge or Combine Data from Multiple Files to Single File.

• Create Pivot Table & charts – Pivot, Chart, Formatting Chart, Types of Charts, Slicer, Timeline and Use of shapes & SmartArt Graphics in Presentation.

• Create Power Pivot Table – Create Pivot Table from multiple worksheets, Add to Data Model, Create Relationship & Manage.

• Create Interactive Dashboard -1.

• Create Interactive Dashboard -2.

• Learn Macro with VBA code – Macro Basics: Preparation, record, create button, editing, debugging, Dynamic Selection, Use relative reference, Create Macro Data Entry Form & Protect coding of Macro.