Advanced Excel Workshop

Visit Us : www.fandsindia.com

Please click here to follow us on LinkedIn

Top Trending Trainings From Fands

  • DevOps - DevOps with different tools like Docker, Jenkins, Golang, Kubernetes, Chef, Puppet, Ansible, GITHub, GitLab, Kotlin
  • Micro Services - Developing micro services using Spring Boot and Spring cloud Netflix Eureka, Zuul and Cloud Config Server etc
  • Different JavaScript libraries and frameworks - AngularJS/Angular, Mean, ExtJS, Durandal , Knockout, ReactJS, BackboneJS
  • Cloud - Cloud Primer / Essentials and advance administration and deployment on major cloud platforms namely AWS, GoogleCloud Platform, Azure, Oracle etc.
  • Big Data and Analytics - Big data & Hadoop, Pig, Hive, Sqoop, Splunk, MongoDB, R Programming, SAS
  • IOT, Machine Learning & Artificial Intelligence - Raspberry PI, Arduino, different protocol implementations for CoAP, MQTT, AMQP, Deep Learning, Business Analysis

Glimpse of Fands

  • 21 years of success in IT and ITES industry and still moving ahead.
  • Served 500+ customers pan India
  • We follow the principle ‘Think Global Act Local’.
  • Trainers with 20+ years of experience in corporate sector.
  • ‘One Stop Training Solutions’ for your training queries.
  • PAN India presence with set ups in Pune, Hyderabad, Bengaluru & Mumbai
Program Objective

By the end of the session, the participants would learn

  • To manage huge data
  • To build powerful reports and charts
  • To analyze data
Workshop Contents

Session I

  • CountA, CountBlank, Countif, Countifs, Sumifs
  • Using the IF Function to Create Conditional Formulas
  • Conditional Formats

Session II

  • Using Custom Sort & Advanced Filters
  • Validations
  • Worksheet Protection
  • Auditing Tools

Session III

  • Transpose, Range Names and Absolute References,
  • Vlookup, Hlookup, Rank, Match, Index,
  • IFError, IFNA, Error Handling in Lookups

Session IV

  • Creating/Revising Pivot Tables Using Slicer on Pivot Tables, Presenting Histogram Trends, Grouping Etc
  • Charts
  • Macros - Using, Recording & Editing

Date : 21 & 22 December 2024

Time : 9:00 AM To 1.00 PM

Last date for Registration : 17th December 2024

Fees & Registration : Rs. 4,000/- plus Tax per participant inclusive of course material.

For more details please contact
Ms. Natasha Deokule on
Mail: natasha@fandsindia.com

Offices in Pune, Mumbai, Hyderabad.
Redg. off. :- 1, "Sheshadri" 1, Rambaug Colony, Opp. Rupee Bank, Paud Rd. Pune - 411038, India.