Overview

Become a Pro at Microsoft Excel with "The Complete Excel Training: Basic to Advanced Skills" Whether you are a complete novice or a seasoned pro, this one-stop shop course will take you from basic Excel functions to advanced data analysis and automation in Microsoft Excel.Master Microsoft Excel, use simple formulas, plot graphs, and easily handle thousands of rows of data! Learn about advanced features such as PivotTables, macros, and VBA for increased productivity.This course will equip you with Excel skills that can be used across industries, whether you are a student, job seeker, business professional, or entrepreneur.Course Features:15 hours 12 mins of on-demand video18 sections with 57 videosDownloadable practice filesFull lifetime accessExplained in English LanguageAccess on mobile and ComputerCourse Modules:Introduction - Importance of MS Excel and course details (About advanced level functions, special problem 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 & RANDBETWEENTypes 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, XLOOKUP, 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, and 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.Enroll now to become proficient in Excel and boost your career opportunities.

Skills

Reviews