MOF 004 – Microsoft Excel (Intermediate and Advanced)

MOF 004 – Microsoft Excel (Intermediate and Advanced)

Teachers
Mrs. Surya
Category:
In-House Programs/ Information Technology/ Microsoft Office/
5 Reviews
Microsoft Excel (Beginner to Intermediate)

Duration: 2 Days
Lectures: InHouse
Certificate of Completion

Introduction

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision-makers is at the foundation of a successful organization that is able to compete at a high level.

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

Objective

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and Pivot Charts.
  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create spark lines and map data.
  • Forecast data.

Target Audience

  • Anyone who has never used Microsoft Excel before (or any other spreadsheet package) or has some experience but is unfamiliar with using the software to perform calculations and create charts

Methodology

  • Hands-on,
  • Exercise,
  • Case study,
  • Test,
  • Brain-storming session

2 Days Training Modules

This content is restricted to members only. Please log in to view more details

Day One

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Timelines and Slicers

Day Two

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

  • Create Sparklines
  • Map Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

About Instructors

Mrs. Surya
Microsoft Office Microsoft Project Microsoft Visio Microsoft Publisher Microsoft Outlook AutoCAD Adobe Photoshop Adobe Illustrator Adobe Flash Adobe Dreamweaver