Advance Excel

Lecturer
admin
Category
0 Reviews

Course Description

According to the modern report, There is no department in the industry where excel is not used. Advanced Microsoft Excel Course content coverage is huge and can become difficult to handle.

That’s why!
Shine Education Training Center has designed the Advanced Microsoft Excel Course for professional or fresher. Our course is especially for those who want to learn and become experts or brush-up their skills in Microsoft Advanced Excel. Advanced Microsoft Excel Course to persuade the best career in Data Management, MIS, Business Analysis, and Data Analysis.

Pre-Course Requirements

  • Basic Knowledge of Computer
  • Personal Laptop (if possible)
  • Positive Attitude
  • Know-How to serve on the internet
  • Self Learning Skill
  • Willing to learn Attitude

Course Objective:-

  • Explain Excel Important Functions like VLookup, HLookup, Index Match.
  • Perform tasks like Data Filtering & Sorting.
  • Apply Multiple rules using Conditional Formatting.
  • Limitations in VLookup over Index Match.
  • Create Reports using Pivot Table, Pivot Charts & Dashboards.
  • Password protect a workbook.
  • Automate Recurring Tasks using VBA.
  • Integrate Excel with Databases like SQL, Oracle.

Course Content Covered

  • Introduction
  • Using Excel lists
  • Creating a List
  • Sorting
  • To perform a Simple Sort
  • To Sort by Multiple Columns
  • Data Forms
  • Adding Data Using the Data Form
  • Finding Records Using Criteria
  • Filtering Data
  • AutoFilter
  • Advanced Filters
  • Special Features for Filtered Lists
  • Totals and Subtotals Total
  • Row
  • Subtotals
  • Manipulating data
  • Working with charts
  • Working with a pivot table
  • ‘What if’ analysis
  • Managing Windows
  • Multiple Windows
  • Splitting Windows
  • Freezing Panes
  • Linking Data
  • Macros
  • Printing Excel files
  • Managing Excel files
  • Grouping and outlining data
  • Shortcut keys and references
  • Analysis tool pack
  • Analysis by goal seek
  • Analysis by pivot tables

Reviews

0
0 Ratings
stars 5
0%
0
stars 4
0%
0
stars 3
0%
0
stars 2
0%
0
stars 1
0%
0

There are no reviews yet.

Leave a Review

Be the first to review “Advance Excel”