Microsoft Excel:PeopleNTech

Microsoft Excel

About The Course

At modern days, Microsoft office (Excel, Word, PowerPoint and Access) has become one of the most useful tools at colleges, corporate offices for organizing, handling and presenting data and information. Over 90% of the corporate professionals rely on Microsoft office works and that makes MS Office tools very significant in our regular lives.

 We are here for you to boost and strengthen your understanding on advanced Microsoft office tools: Excel, Word, PowerPoint and Outlook. This is an Advanced level MS-Excel Training, Which includes:

Advanced level of “Microsoft Excel 2016” a spare sheet program with which you can analyze, communicate and manage information.

Module 1: Using Formatting and Functions

  • Applying Formatting to Numbers
  • Creating Custom Number Formats
  • Applying Conditional Formats
  • Using Formulas in Conditional Formats
  • Absolute and Relative References  Naming a Range
  • Using a Named Range in a Formula
  • Using Lookup Functions
  • IF Functions

Module 2: Using Templates and Workbooks

  • Applying a Template
  • Using a Template
  • Creating a New Template
  • Editing a Template
  • Linking Between Workbooks
  • Importing Data from Text Files
  • Importing Data from Other Applications
  • Importing an HTML Table
  • Publishing Data to the Web

Module 3: Working with Data

  • What is a List?
  • Validating Data Entries
  • Sorting Data
  • Subtotaling and Outlining Data
  • Extracting Data with Filters
  • Using Advanced Filters
  • Using Query
  • Querying the Web
  • Using XML to Share Data

Module 4: Analyzing Data

  • Using PivotTable Add info about Slicers
  • Managing PivotTable Reports
  • Creating PivotChart Reports
  • Using Charts and Trendlines
  • Working with Scenarios 

Module 5: Using Macros and Auditing Tools

  • What is a Macro? 
  • Recording a Macro 
  • Running a Macro 
  • Editing a Macro 
  • Auditing Workbooks 
  • Tracing Errors

Module 6: Sharing Workbooks

  • Creating a Shared Workbooks 
  • Consolidating Data 
  • Protecting Columns 
  • Protecting Worksheets 
  • Protecting Worksheet Content 
  • Protecting Cells 
  • Assigning a Password 
  • racking Changes 
  • Adding Comments 
  • Preparing a Workbook 
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech