Description

Are you ready to take your Excel skills to the next level with our Excel Expert training course? 

This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.

If you are currently using Excel and want to improve your skills, you have a job role that requires a strong level of Excel expertise and you want to get up to speed quickly, you work with Excel regularly but are looking for more advanced and well-rounded skills, this is the best platform.

This course can boost your employability and career prospects whilst also being a useful tool to analyze data in everyday life, such as when managing personal finances.


What you'll learn:

1. Manage Workbook Options and Settings

1.1 Manage Workbooks 

  • Save a workbook as a template
  • Copy macros between workbooks
  • Reference data in another workbook
  • Reference data by using structured references
  • Enable macros in a workbook
  • Display hidden ribbon tabs

1.2 Manage Workbook Review

  • Restrict editing
  • Protect a worksheet
  • Configure formula calculation options
  • Protect workbook structure
  • Manage workbook versions
  • Encrypt a workbook with a password
  • Manage comments

1.3 Use and configure language options

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

2. Apply Custom Data Formats and Layouts

2.1 Apply Custom Data Formats and Validation

  • Create custom number formats
  • Populate cells by using advanced Fill Series options
  • Configure data validation
  • Fill cells by using flash fill
  • Insert subtotals
  • Remove duplicate records

2.2 Apply Advanced Conditional Formatting and Filtering

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

2.3 Create and Modify Custom Workbook Elements

  • Create custom color formats
  • Create and modify cell styles
  • Create and modify custom themes
  • Create and modify simple macros
  • Insert and configure form controls

2.4 Prepare a Workbook for Internationalization

  • Display data in multiple international formats
  • Apply international currency formats
  • Manage multiple options for +Body and +Heading fonts

3. Create Advanced Formulas

3.1 Apply Functions in Formulas

  • Perform logical operations by using AND, OR and NOT functions
  • Perform logical operations by using NESTED functions
  • Perform statistical operations by using SUMIFS
  • Perform statistical operations by using AVERAGEIFS
  • Perform statistical operations by using COUNTIFS
  • Perform statistical operations by using AVERAGEIF
  • Perform statistical operations by using MAXIFS
  • Perform statistical operations by using MINIFS

3.2 Look up Data by using Functions 

  • Look up data by using the VLOOKUP function
  • Look up data by using the HLOOKUP function
  • Look up data by using the MATCH function
  • Look up data by using the INDEX function

3.3 Apply Advanced Date and Time Functions 

  • Reference the date and time by using the now and today functions
  • Serialize numbers by using date and time functions
  • Serialize numbers by using date and Weekday functions

3.4 Perform Data Analysis and Business Intelligence

  • Import, transform, combine, display and connect to data
  • Consolidate data
  • Perform what-if analysis by using Goal Seek
  • Perform what-if analysis by using Scenario Manager
  • Calculate data by using financial functions
  • Calculate data by using NPER() functions

3.5 Troubleshoot Formulas 

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

3.6 Define Named Ranges and Objects 

  • Name cells
  • Name data ranges
  • Name tables
  • Manage named ranges and objects

4. Create Advanced Charts and Tables

4.1 Create and modify advanced charts 

  • Add trendlines to charts
  • Create dual-axis charts
  • Save a chart as a template
  • Create and modify charts including box & whisker charts
  • Create and modify funnel charts
  • Create and modify histogram
  • Create and modify map 
  • Create and modify sunburst
  • Create and modify waterfall charts

4.2 Create and Manage PivotTables 

  • Create pivot tables
  • Modify field selections and options
  • Create slicers
  • Group pivottable data
  • Reference data in a pivottable by using the getpivotdata function
  • Add calculated fields
  • Format data

4.3 Create and Manage Pivot Charts 

  • Create pivot charts
  • Manipulate options in existing pivot charts
  • Apply styles to pivot charts
  • Drill down into pivot chart details

 4.4 Create and Modify Simple Macros

  • Record Simple Macros
  • Name Simple Macros
  • Edit Simple Macros

This course Includes:

  • Textual Explanation
  • On-demand videos
  • Downloadable resources
  • Unit-wise Assessments
  • Final Assessment
  • Certificate of completion

 

Total Course Duration: 12 hours

View more View less

You may also like

Microsoft Office Specialist (MOS) - Excel Exam Voucher

Microsoft Office Specialist (MOS) - Excel Exam Voucher

Rs. 2,999.00
Microsoft Office Specialist (MOS) Word Exam Voucher

Microsoft Office Specialist (MOS) Word Exam Voucher

Rs. 2,999.00
Microsoft Office Specialist (MOS) Power Point Exam Voucher

Microsoft Office Specialist (MOS) Power Point Exam Voucher

Rs. 2,999.00
Microsoft Office Specialist (MOS) Outlook Exam Voucher

Microsoft Office Specialist (MOS) Outlook Exam Voucher

Rs. 2,999.00