Microsoft Excel 2020| VBA & Macro| Data Analysis & Reporting
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Get yourself equipped with knowledge in Excel and master your analytical skills. VBA and Macro is covered extensively.Description
Get yourself equipped with knowledge in Excel.
What you will become after going through this course:
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Learn the most common Excel functions used in the Office
Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, PivotTables, Data validation
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Access to a Professional Trainer with 10+ years of Excel Training- @chandrucric9@gmail.com
This course will provide learning in the below mentioned topics
Basics in Excel
Graphical representation in Excel
Analytics in Excel.
Data validation, Advanced Pivot tables, Advanced lookup operations.
Macro used to send daily report.
Writing VBA code to automate the manual tasks.
Advanced excel topics will be provided as part my advanced course.
Basics covers all the topics related to introduction, What are the options available in excel
Graphical representation covers Graphs, Tables and other presentation materials
Analytics in Excel covers all the formulas and validation that can be performed in excel.
Requirements
- Requirements
- Basic computer knowledge
Microsoft Excel 2020| VBA & Macro| Data Analysis & Reporting
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Get yourself equipped with knowledge in Excel and master your analytical skills. VBA and Macro is covered extensively. Get yourself equipped with knowledge in Excel....
