Advanced Microsoft Excel Training

Advanced Microsoft Excel Training

Lesson 1: Custom & Conditional Formats

  • Creating a Custom Format
  • Create a custom number format
  • Conditional Formatting
  • Creating Conditional Formatting
  • Editing Conditional Formatting
  • Adding Conditional Formatting
  • Deleting Conditional Formatting from the Selected Range

Lesson 2: Using Formulas & Functions

  • Relative Cell Reference
  • Absolute Cell Reference
  • Using Text Functions
  • Left Function
  • Upper Function
  • Concatenating the text values
  • Date Functions
  • Using Today Function
  • Calculating using Date Function
  • Using Sum Functions
  • Using CountA Functions

Lesson 3: Working with Range Names

  • Using Range Names
  • Creating Range Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Deleting Range Names
  • Creating 3-D Range Names

Lesson 4: Using Advanced Functions

  • Using If Functions
  • Using Nested If Functions
  • Using Sum If Functions
  • Using Count If Functions
  • Using Vlookup Functions
  • Using HLOOKUP Functions

Lesson 5: Managing Tables

  • Creating Tables
  • Naming the Table
  • Changing the Table Style
  • Creating a Total Row
  • Creating a calculated column
  • Using Filtering in Table
  • Removing the Duplicate Record

Lesson 6: Using Auto Filter

  • Sorting Data
  • Using AutoFilter
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Database Functions

Lesson 7: Getting Most from your Data

  • Creating Subtotal
  • Using Automatic Outline
  • Grouping Data Manually
  • Using Data Validation

Lesson 8: Working with Charts

  • Creating a Chart
  • Formatting the Chart
  • Adding Labels
  • Changing the Chart Type, Data Source

Lesson 9: Working with Pivot Tables

  • Creating Pivot Tables
  • Adding Pivot Table Report Fields
  • Refreshing Pivot Table Report
  • Changing the summary function
  • Creating report filter pages
  • Creating Pivot Chart

Lesson 10: Using Shared Workbooks

  • Sharing a Workbook
  • Opening and Editing a Shared Workbook
  • Tracking Changes
  • Resolving Conflicts in a Shared Workbook

Lesson 11: Worksheet Protection

  • Protecting your Worksheets
  • Protecting range with password
  • Protecting your Workbook & Excel Files

Lesson 12: Multiple Workbooks

  • Linking Workbooks
  • Editing the Link
  • Consolidating Workbooks

Lesson 13: Working with Macros

  • Display the Developers Tab
  • Changing Macro Security Settings
  • Recording & Running a Macro

Advanced Microsoft Excel Training |T. Nagar|Chennai|India|Online

Related Training Courses:

  1. Microsoft SharePoint Training
  2. Microsoft Exchange Server Training