MS Excel® Course Advance Level

Upcoming Training


Course 
  • Organizations rely on the information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2019 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

The 2-days Advance MS Excel® training will include the following topics:
Working with Functions
  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
Using PivotTables and Pivot Charts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks
  • Use 3-D References
  • Consolidate Data
  • Using Lookup Functions and Formula Auditing
Using Lookup Functions and Formula Auditing
  • Trace Cells
  • Use Lookup Functions
  • Watch and Evaluate Formulas
  • Sharing and Protecting Workbooks
Sharing and Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
Automating Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
Creating Sparklines and Mapping Data
  • Create Sparklines
  • Map Data
Forecasting Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends
77-727 : Microsoft Office Excel 2016 Exam
77-728 : Microsoft Excel 2016 Expert: Interpreting Data for Insights

Location Date Duration Delivery Price
Sat 31st Aug, 19 2 Day(s) Live Online Instructor Led $1399  $799

Why Train With Us?

At ITIC System, our industry experts and professional trainers, deliver the best courses to help you get the knowledge and also get the certification in the least cost and time. Accredited as a registered education provider of Project Management Institute, US (REP ID 4562) ITIC System provides quality training to help you boost your career.

Highest Value

We price our courses lower than others offering best value for the investment you are making in your career.

Flexible Delivery Modes

We know that your time is precious, so we offer multiple modes of delivery methods to suit your availability and schedule.

Complete Courseware

Our courses come with a comprehensive course ware and everything you need to learn to get the certification you are looking for.

Customer Support

We provide customer support service in case if you need more information while enrolling a course, we are available any time to help you.

Related Courses