Advance Excel Using Office 365

Working with thousands of business companies around the world for Ideas

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.

Advanced Conditional formatting

  • Highlight data on basis of cretin condition
  • Add data bar
  • Trend lines
  • Color Scales
  • Use Icon Sets for quick visual indicators

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

Logical Functions

  • IFs and Nested IF Functions
  • Using AND/OR/NOT Functions
  • Combining logical functions
  • SWITCH function

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
  • HLOOKUP
  • XLOOKUP

Validations

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

Date/Time Functions

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

Zenoxx Training Credentials

We at Zenoxx are a dynamic organization built by like – minded leaders belonging to various industry segments. We have a strong network of most preferred trainers of the industry country wide. 

  • Experienced, time tested & Certified trainers
  • Strong R&D Team to keep abreast with upcoming technologies
  • Cost effective professional solutions ensuring good ROI
  • Bespoke Solutions
  • Local Expertise to complement our Global perspective
  • Design and delivery based on organization’s vision that meet its unique needs
  • All Program Content is duly vetted by our Business Leaders/Think Tank Mentors
  • Lucid Delivery Styles and Experiential Learning Processes that measure the Sustainability of Learning

Why Zenoxx is Best?

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.

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

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

Soft Copy of Training Material

Participation Certificate

Training Fee – Rs 16,000 (INR) + 18% GST Per Person

210 (USD) – Per Person

blog39

Need Any Help!

Hotline
+91-9560809008