About the Course

This program is designed for those who are already familiar with the basics of Microsoft Excel who would like to work with more advanced features of MS Excel  that help in improving their  efficiency of working with worksheets, analysing data, creating MIS reports in Excel.

About Trainer

Having more than 20 years of experience in Corporate Training. Have delivered several trainings to National & International Clients. Trained more than 35000 people in Advance Excel. She has excellent communication, interpersonal and presentation skills. She has imparted trainings to clients like Nestle India, Barclays, Bank of America, Bharat Petroleum, Walmart India, Bank of Tokyo, Citi Bank, NIIT Technologies Ltd, Adidas India and end number of Clients.

Course Coverage

Advanced Conditional formatting

  • Highlight data on basis of cretin condition
  • Add data bar
  • Trend lines

Pivot Tables

  • Creating Formatting using Simple PivotTables
  • Page Field in a PivotTable
  • Formatting a PivotTable
  • Creating/Modifying a PivotChart
  • Insert Calculated Field (formulas)

Chart Data Techniques

  • The Chart Wizard
  • Chart Types
  • Adding Title/Legends/Labels
  • Printing Charts
  • Adding Data to a Chart
  • Formatting/Renaming/Deleting Data Series
  • Changing the Order of Data Series
  • Adding Trend Line, Display data on Secondary Axis

Logical Functions

  • IFs and Nested IF Functions
  • Using AND/OR/NOT Functions

Statistical Functions

  • Using The SUMIF/COUNTIF, COUNTA, RANK Functions
  • Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Text Functions

  • Using The MID/ LEFT/ RIGHT Functions
  • Using The TRIM/ UPPER/ LOWER Functions

LOOKUP Functions

  • The VLOOKUP/HLOOKUP Functions

Validations

  • Input Messages / Error Alerts/ Drop-Down Lists
  • Conditional Formatting

Date/Time Functions

  • Using The TODAY, NOW & DATE Functions
  • Using The DATEDIF/ NETWORKDAYS Functions.

Excel Keyboard Shortcuts and Assignments

Deliverables

Soft Copy of Training Material

Participation Certificate

Training Fee

Training Fee – Rs 944 (Including 18% GST) Per Person

Contact Info

Contact Person – Sushil Gupta@ 91-9560809008
Mail – corporate@zenoxxknowledge.com

Services Offered

We offer best deployment Services.

Information Technology

Behavioural & Softskills

Open House Workshop

Manpower Consulting

150

+ COURSES

28000

+ PROFESSIONAL TRAINED

80

+ CORPORATE CLIENTS

10

+ YEARS OF EXPERIENCE

Happy Clients Say

I feel better equipped to manage after completing the course. This was my objective at the beginning. I would recommend the course as it provides good learnings on how to manage teams efficiently and gives simple yet powerful rules applicable to life. The workshop is practical and informative. Intensive, but well-paced. Very useful team-building exercises. – Developing Leadership Skills Workshop

David Mose

- Senior Leader

I would definitely recommend this azure training course to a friend or colleague. Thank you for delivering a fantastic course. The content was great and very relevant to me for my project work. I will definitely be putting this into practice now. I wish the zenoxx team all the very best. Keep doing the good job. – Azure training workshop

Nethor Doct

- Developer

Why Zenoxx is Best?

Creditability

Chosen and appreciated by our customers for providing top of the line Training solutions, coupled with creativity and out of the box thinking, translating into personal & organizational excellence.

Basic to Advance course

Zenoxx offers more than 150+ courses in IT-Mangement , Information Technology , Foreign languages , Behavioral & Mangement development and college to corporate programs.

Professional Team

Our core team consists of reputed professionals whose own experience is as rich and diverse as its portfolio of clients.

Give your organization the Zenoxx Edge

Corporate Training, Individual Training, Open House workshop , Staffing Services and much more!

Lets Connect

Our Existing Clients

client