infyni

Advance Excel Course

Advanced Excel skills are invaluable in various industries and roles, including finance, accounting, data analysis, business intelligence, project management, and research. Mastering these skills can significantly enhance productivity, decision-making, and competitiveness in the workplace.

Live Course

Live Class: Friday, 19 Apr

Duration: 9 Hours

Enrolled: 15

Offered by: infyni

Live Course
$1072 50% off

$536

Enroll Now

About Course

Advanced Excel skills involve proficiency in using Excel's features beyond the basics to efficiently manage, analyze, and visualize data. Here's a detailed description:


Advanced Formulas and Functions: Mastery of complex formulas and functions such as nested IF statements, INDEX/MATCH, SUMPRODUCT, array formulas, and functions for financial, statistical, and mathematical analysis.


PivotTables and PivotCharts: Ability to create dynamic PivotTables to summarize and analyze large datasets quickly. Proficiency in grouping data, creating calculated fields, and using PivotCharts for visual representation.


Data Analysis Tools: Knowledge of advanced data analysis tools like Goal Seek, Solver, Scenario Manager, and Data Tables to perform what-if analysis, optimization, and sensitivity analysis.


Macros and VBA Programming: Understanding of Visual Basic for Applications (VBA) to automate repetitive tasks, create custom functions, and develop user-defined solutions. Proficiency in recording and editing macros, working with VBA modules, and debugging code.


Data Visualization: Expertise in creating visually appealing and informative charts and graphs using advanced chart types, customizing chart elements, and incorporating data labels, trendlines, and error bars for better insights.


Skills You Will Gain

Data Validation Excel Add-ins and External Tools Data Analysis Tools Pivot Tables and Pivot Charts

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (1)
1 Numeric/Statistical Functions
  • SUM, SUMIF, SUMIFS AVERAGE, AVERAGEIF, AVERAGEIFS COUNT, COUNTIF, COUNTA, COUNTBLANK MAX, MIN, LARGE, SMALL
  • Understanding References Relative References Absolute References Mixed References Utilizing names for writing formulae.
  • Basic Filters Advanced Filters Column Sorting If Function AND, OR Function Nested Functions
  • Create Conditional Formatting Rule 1 to 6 Formula based C.F. TODAY, NOW DAY, MONTH, YEAR WEEKDAY
  • Creating Table Exploring Table Design Tab Slicers VLOOKUP HLOOKUP MATCH INDEX
  • Understanding a Pivot Table Data for a Pivot table Creating a Pivot table Add, copy, rearrange, and remove fields Using the Pivot table filters Changing Pivot table filters Modifying the Pivot Table placement Pivot Table options Change the Pivot Table layout Change the Pivot Table design Change the Pivot Table Tools design style options Crating Pivot Charts Insert Slicers Working With Time Line
  • Connecting Various Data Sources like PDF / Web Data Transformation or Cleaning Data Merge Query Append Query Removing Duplicate Records Splitting Columns Merge Columns

...
Jai Malhotra
About Instructor

I am a Corporate Trainer based in New Delhi and have conducted more than 500 corporate training sessions so far during a span of 8 years of training experience. My core are of expertise is Advance Excel, Power BI, SQL and Power Point.

0

Rating

0

Review

170

Students

2

Courses