Advanced Excel Workshop | S-Link Cyber Solutions
November 15, 2018

Advanced Excel Workshop

We are back with one more workshop! Advanced Excel workshops provide you a hands-on environment with a systematic process, which will, help you on focusing time-saving techniques. These techniques of pretension will help you to get your work done faster by constructing graphs, charts, visuals and dashboards. This will result in making your presentation effective and easy to understand with important statistics.

WHAT YOU WILL LEARN

Take your Excel skills to the next level with our Advanced Excel course. Using these techniques you’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.

  • •  Excel Basic Overview.
  • •  How to Work with functions?
  • •  Data Validations.
  • •  Sorting & Filtering Data.
  • •  Working With Pivots & Charts.
  • •  Macros Recording.
  • •  Conditional Formatting & Many more...

WHO SHOULD ATTEND

  • •  Entrepreneurs
  • •  Top management executives
  • •  MIS Executives
  • •  BPO professionals
  • •  Finance professionals
  • •  Sales or marketing verticals
  • •  MBA Professionals
  • •  HR personnel's &
  • anyone who wants to sharpen their excel skills to enhance their productivity to the next level.

WORKSHOP OUTLINE

Module 1: Overview of the Basics

  • •  Customizing common options in Excel
  • •  Absolute and relative cells
  • •  Protecting and un-protecting worksheets and cells

Module 2: Working with Functions

  • •  Writing conditional expressions (using IF)
  • •  Logical functions (AND, OR, NOT)
  • •  Lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • •  VlookUP Functions;
    • •  Exact Match, Approximate Match
    • •  Tables, Dynamic Ranges
    • •  Reverse Function.

Module 3: Data Validations

  • By specifying,
  • •  valid range of values for a cell
  • •  a list of valid values for a cell
  • •  custom validations based on formula for a cell

Module 4: Sorting and Filtering Data

  • •  Sorting tables
  • •  Multiple-level sorting
  • •  Custom sorting
  • •  Filtering data for selected view (AutoFilter)
  • •  Advanced filter options

Module 5: Working with Reports

  • •  Creating subtotals
  • •  Multiple-level subtotals
  • •  Pivot tables
  • •  Formatting and customizing Pivot tables
  • •  Advanced options of Pivot tables
  • •  Pivot charts
  • •  Consolidating data from multiple sheets and files using Pivot tables
  • •  External data sources
  • •  Data consolidation feature to consolidate data by Creating Groups
  • •  Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  • •  Viewing Subtotal under Pivot
  • •  Creating Slicers ( Version 2010 & Above)

Module 6: More Functions

  • •  Date and time functions
  • •  Text functions
  • •  Database functions
  • •  Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Module 7: Formatting

  • •  Auto formatting option for worksheets
  • •  Conditional formatting option for rows, columns and cells
  • •  IF Formula’s & Conditional Formatting

Module 8: Macros

  • •  Recording Macro’s

Module 9: Charts

  • •  Charts
  • •  Formatting Charts
  • •  3D Graphs
  • •  Bar and Line Chart together
  • •  Secondary Axis in Graphs
  • •  Sharing Charts with PowerPoint / MS Word, Dynamically (Data Modified in Excel, Chart would automatically get updated)

WORKSHOP HIGHLIGHTS

HANDS ON PRACTICAL
100% Practical Oriented Workshop

CERTIFICATE
Awarded with Attendees Certificate

MENTORSHIP & GUIDANCE
Life-Time technical support by experts

COURSE MATERIAL
Workshop Course Material will be provided in soft copy format.

PREREQUISITE

•  Basic knowledge of Computer & Excel is required.

•  Participants need to bring a laptop with Excel installed on it.

•  Ability to grasp new technologies.

 

New workshop dates will be announced soon!

REGISTER NOW

₹ 3500 (Includes Lunch & Tea) A candidate has to pay fees online at the time of registration.

Ticket Sold Out!

Special Offer

  • 10% Group Discount (Min. 3 Candidates)

FEEDBACK & TESTIMONIAL

Vishal Kumar
Vishal Kumar
10:10 08 Jun 18
It was really an awesome training on Ethical Hacking course given by Rakesh SIR, Jai SIR and Ashwini ma'am. Really they have a great knowledge regarding this topic. They are very supportive. Their flexiblity with timings supported me to gain the knowledge in a very proper manner. Thanks a lot SIR and Ma'am.
Shubham Rathod
Shubham Rathod
12:28 25 Apr 18
Rakesh sir and Jay sir are an excellent tutor who are very knowledgeable and conveys their knowledge of complex material in a manner easily understandable. And all the staffs are good also they are knowledgeable Highly recommended.
Jay Mehta
Jay Mehta
13:13 06 May 18
I attended workshop here last month and it was great experience for me and nice to meet you Rakesh sir and Jai sir. Thank you to have awesome workshop.
Akshansh JaisWal
Akshansh JaisWal
11:38 28 Apr 18
It was a great experience ,got to know more about ethical hacking from the workshop praticals by jay and rakesh sir helped a lot in grabing the concepts more easily
priti wagh
priti wagh
13:47 05 Oct 17
Trainers provided by S-Link Cyber Solution was awesome. Trainers are expertise in Network Security Audits. training was more on practical side. Highly recommended if you want to make carrier in Information Security.
BHAVESH SUKHANI
BHAVESH SUKHANI
08:07 28 Jul 18
Best institute for learning. Best teaching! You get solution of all your problems regarding cyber world! Lucky to learn here!
Sandeep Chonde
Sandeep Chonde
08:10 28 Jul 18
very best teaching ,very best institute, jai sir ,rakesh sir and ashu mam exelent tutor ,it was great exprience.great tutor .
See All Reviews