Course Details

  • Home
  • Course Details

Microsoft Excel Expert

Avinash Karnani

4.5 

  • Overview
  • Curriculum
  • Certificates

Requirements

  •   The only prerequisite is that you have access to Excel and the willingness to complete the exercises and practice tests.
  •   Please note that MOS exams are all Windows based. This course uses Excel in a Windows environment. Apple Mac users should note that there are differences between the Windows and Mac versions of Excel

What You'll Learn

  •   How to successfully pass the MO-201 Microsoft Certified Excel Expert Exam
  •   Be confident and competent in your use of Advance Excel for everyday business use
  •   Be ready to begin to study to become a certified Microsoft Office Specialist in Excel Expert 2019

Who this Course is for

  •   Students who are intermediate users in Excel who want to obtain certification in Advance Excel
  •   Existing users of Excel who want to learn how to pass the MO-201 exam and obtain official certification for their skills.
  •   Existing users of Excel who want to have access to the type of exercises which will ensure they will pass the Microsoft Office Specialist Certification in Excel Expert 2019
  •   Graduates seeking to gain professional qualifications

• Copy macros between workbooks
• Reference data in other workbooks
• Enable macros in a workbook
• Manage workbook versions

• Restrict editing
• Protect worksheets and cell ranges
• Protect workbook structure
• Configure formula calculation options
• Manage comments

• Configure editing and display languages
• Use language-specific features

• Fill cells by using Flash Fill
• Fill cells by using advanced Fill Series options

• Create custom number formats
• Configure data validation
• Group and ungroup data
• Calculate data by inserting subtotals and totals
• Remove duplicate records

• Create custom conditional formatting rules
• Create conditional formatting rules that use formulas
• Manage conditional formatting rules

• Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions

• Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions

• Reference date and time by using the NOW() and TODAY() functions
• Calculate dates by using the WEEKDAY() and WORKDAY() functions

• Summarize data from multiple ranges by using the Consolidate feature
• Perform what-if analysis by using Goal Seek and Scenario Manager
• Forecast data by using the AND(), IF(), and NPER() functions
• Calculate financial data by using the PMT() function

• Trace precedence and dependence
• Monitor cells and formulas by using the Watch Window
• Validate formulas by using error checking rules
• Evaluate formulas

• Record simple macros
• Name simple macros
• Edit simple macros

• Create and modify dual axis charts
• Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts

• Create PivotTables
• Modify field selections and options
• Create slicers
• Group PivotTable data
• Add calculated fields
• Format data

• Create Pivot Charts
• Manipulate options in existing Pivot Charts
• Apply styles to Pivot Charts
• Drill down into PivotChart details

₹2,859
  • Mentor : Avinash Karnani
  • Level : Expert
  • Category : Productivity
  • Format : Hybrid
  • Avail 25% discount before 10th Sept 2023!!!
Join Course
Share This :

Have Any Question?

  • khargym@skillspark.org