Rating 3.95 out of 5 (35 ratings in Udemy)

• Understand the Microsoft Excel from the Basic to Advanced Level
• Master the use to Microsoft Excel Tools, Commands and Functions
• Learn Microsoft Excel Defined Functions and Formulas used in calculations and Office Tasks
• Understand how to handle Large Data, Manipulate, Summarized and Generate Reports
• Understand the Power of Data Analysis using Microsoft Excel
• Master how to use PIVOT TABLE and PIVOT CHART to create Dynamic Reports and Charts
• Understand the POWER of VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, CHOOSE, INDEX & MATCH in Data and Financial Analysis
• Understand DATA VALIDATION, CONSOLIDATION and Using SUB TOTAL tool for creating Subtotals Calculation for grouped Items
• Working with Charts (Column, Pie, Bar, Line Chart and lot more. Editing Charts and working on Chart Designs
• Understanding Alignment Tools, Text and Number Formatting, and Excel Cell and Table Style Formatting
• Working Tables, Inserting Pictures and Images into Excel Worksheet, and using Text Boxes in Excel
• Working with Cell and Range Names for Data Analysis and Calculations. Managing Names, and creating Names from Selections
• Using Sparklines Column and Line Charts for Horizontal and Vertical in-cell Charts.
• Using Hyperlink Tools to create Links to Worksheets, External Files, websites and Email from Excel Worksheet
• Removing Duplicate Transactions, Text or Number from large range of data
• Working with Conditional Formatting Tools on Large Data e.g Sales Data
• Most courses ignore Basic fundamental tools, which can many task easy. This Course seeks to Address all major TOOLS in Excel
• Creating and Working with Dashboards - Slicer and Timeline Tool.
• Creating Sensitivity Analysis using the What-If-Analysis Tools (Goal Seek, Data Table, Solver and Scenarios)
• Working with Logical Functions (IF, AND & OR and NESTING the IF Functions)
• Understanding Project Evaluation Techniques using Financial Functions (PV, FV, NPV & IRR)
• Introduction to Excel Macros and VBA Automations (Macros Recording, codes, User Form creation, VBA Controls and Objects)
• As a Microsoft Excel Certified Expert, I guarantee that this Course will also help you to pass Certification Exams as it uses Examples that we help participant familiarize with Key Excel Tools.
• Enjoy access to a CERTIFIED MICROSOFT EXCEL EXPERT with over 2 Decades in Spreadsheet Analysis using MICROSOFT EXCEL