Microsoft Excel

Trainings offered from Basic to Advanced levels.

MICROSOFT EXCEL

Trainings offered from Basic to Advanced levels.

Microsoft Excel Training Module

Protocol brings to you a one stop Personality Development training program. This program is developed by highly skilled and experienced trainers in the industry.

Join this unique Personality development training program, Learn the right skills that will help you climb the corporate ladder and excel in your career. 

Microsoft Excel Training Module

Microsoft Excel is a powerful spreadsheet and data analysis program with wide-ranging capabilities. Attending a live Excel course is a good way to quickly and efficiently learn Excel. There are four primary reasons why you should learn Excel and how learning Excel is helpful for your career.

Learning Excel increases your value in the job market. Excel skills are highly valued by employers because of the variety of ways it can be leveraged. By attending Excel courses, you will learn more advanced ways to use Excel that will help you stand out in the job market. Excel can be used in a variety of contexts, including:

  • Creating staff schedules.
  • Managing budgets.
  • Tracking revenues and expenses.
  • Managing inventory.
  • Creating charts, visualizations, and dashboards to represent data.
  • Excel training makes you more efficient

Why Join Protocol?

Why Join Protocol?

Certified Trainers

Be trained by highly skilled and certified trainers.

Improv Learning

Activiti Based Learning which will contribute to Holistic development of your personality.

Get ISO Certified

Get ISO attested certificate after completion of training program.

Certified Trainers

Hands On Learning

ISO Certified

Course Details

Course Details

Basic Excel

 

  • Introduction to Excel
  • Understanding Microsoft Excel
  • Excel Workbook windows
  • Spreadsheet Skills
  • Excel Help System
  • Opening and Closing Workbooks
  • Understanding Workbook file formats
  • Creating New Workbook
  • Selecting Cells
  • Auto Sum and Auto Fill Function
  • Cell Refrencing and request
  • Formatting Cells
  • Formatting Numbers
  • Basic Cell Allignment
  • Cell, Rows, Columns
  • Understanding Worksheers
  • Editing, Copying and Moving Cells
  • Page Layouts in Excel
  • Proofing Workbooks
  • Basic Options, Ribbons and Tool Bar
  • Introduction to Charts
  • Introduction to Tables
  • Introduction to Pivot Table

Intermediate Excel

 

  • Introduction to Excel Spreadsheet – Intermediate level
  • Defining Names in Excel
  • Sorting Data
  • Using Excel Tables
  • Filtering Data in Excel
  • Understanding Charts
  • Chart Design options and Tools
  • Chart Format Tools
  • Combo Charts
  • Functions within Excel
  • Understanding Date Function
  • Information Functions
  • Logical Functions
  • Financial Functions
  • Find and Replace
  • Headers and Footers
  • Adding Comments
  • Conditional Formatting

Advanced Excel

 

  • Introduction to Excel Advanced
  • Using texts to Columns
  • The Paste Special Function
  • Data Validation
  • Sub totals and Grouping
  • Consolidating Data
  • Scenario Analysis
  • Data Tables in Scenario Analysis
  • What-If Analysis
  • Mats and Trig Functions
  • Text Functions in Excel
  • Using Lookup Functions
  • Vlookups
  • HLookups
  • Using Statistical Functions
  • Database Functions
  • Formula Auditing and Error Tracing
  • Hyperlinks in Excel
  • Linking Data
  • Understanding Pivot Tables
  • Using Pivot Charts
  • Workbook Properties
  • Protecting and Sharing Worksheets
  • Data Encrypting and Finalizing Workbooks
  • Understanding to Macros
  • Custom Number Formats in Excel
  • Using Custom Lists
  • Working with Templates
  • Tracking Changes in Excel
  • Merging and Compare Excel Workbooks.

Course Structure

Course Structure

Course Duration: 1 MONTH

Saturday – Sunday

Weekend 1 – Saturday – Basic Excel

Weekend 2 – Saturday – Intermediate Excel

Weekend 3 – Saturday – Advanced Excel

Weekend 4 – Sunday   – Advanced Excel

 

 

 

Timings

Saturday – Sunday

Weekend 1 – Saturday – 10am to 4pm

Weekend 2 – Saturday – 10am to 4pm

Weekend 3 – Saturday – 10am to 4pm

Weekend 4 – Sunday   – 10am to 4pm

 

 

 

Learning made Easy and Simple with this strategically designed Program

Learning made Easy and Simple with this strategically designed Program

Candidate Experiences!

Candidate Experiences!

Lakshmi Vipin

I had attended for communication and personality development classes…Iam very much impressed in them. Their way of training is amazing..kauser Mam and Usman sir were polite and very supportive from the beginning.Had a very pleasant experience with two wonderful trainer’s (Soumya Mam and Jasmine Mam).I would recommend this institution for all the people who would like to enhance their skills in communication and personality development..

Vidhya Suresh

I had joined protocol for the personality development and communication classes for 1 month.The classes were excellent.The classes taken by Jasmine Ma’am and Sowmya Ma’am were really helpful.The classes helped me improve my interpersonal skills,presentation skills and had an overall development.

Anutha Arjun

Protocol is a great place of learning. I have undergone TTT program from here. I am super confident and impressed with training techniques of Kauser.

Madhavan

Personality development was really useful and I really liked Jasmine mam’s teaching, at first I wasn’t really interested in joining the session but because of Jasmine man’s teaching and attitude I got an interest to attend the sessions and she encouraged me to express myself and was very friendly. These online classes were really great and if you’re thinking to join Protocol,i suggest you to actually join it without any hesitation,it’ll really make a big difference in your life and will be useful for you too.

What are you waiting for?

Enroll Now and be the best version of yourself!

What are you waiting for?

Enroll Now and be the best version of yourself!