Dear All, in case anybody wants to take training on advanced excel, please note the details;

Advanced Excel - 16 HOURS
  • Microsoft Excel and its applications
  • GUI Layout
  • Customizing toolbars
  • Working smartly with office ribbon and mini toolbar
  • Working with quick access toolbar
  • Contextual tabs
  • Data creation : Working with cells, rows, columns,
  • Worksheets, workbook effectively ; shortcuts
  • Data preparation Using "format as table" effectively
  • Using paste special and format painter brush
  • Custom settings: number, text, date, currency
  • Format Painter
  • Auto fill, auto complete, auto correct functions
  • Data analysis Subtotal function
  • Grouping and ungrouping
  • Text to columns
  • Data validation
  • Single Sort, multiple sort, filter, custom filter
  • Advanced filter
  • Conditional formatting
  • Goal seek, data table
  • Solver
  • Pivot table, pivot chart
  • Scenario
  • Hyperlinking
  • Reviewing Inserting and deleting comments
  • Sending files for review, managing track Changes
  • Proofing Thesaurus, spelling and grammar
  • Auto correct option
  • Formulas : Sum, average, count, min, max, autosum, counta, maxa, mina, averagea, Upper, lower, proper vlookup, hlookup
  • If, absolute and relative referencing
  • Sumif, countif, date and time functions
  • And, or, not and other regularly used advanced formulaes
  • Graphs How to create charts: pie charts, column charts, bar charts
  • Viewing data Normal view, page layout, page break preview, custom view, full screen view
  • Name manager
  • Data printing Print area, page setup, printing do's and doníts
  • Security Protecting excel workbooks with password
  • Visual Basic for Applications Introducing VBA macros, macro recorder
  • Settings and Excel options

You can send queries to learn more

From India, Pune

Preparation for the global SHRM certification exams: SHRM CP and SHRM SCP →
Promoted: XLRI Executive Development Program In Human Resource Management
dear sir , wanted to learn vlookup & hlookup if got ur help its excellent tyvm
From India, Mumbai
Greetings of the day! I introduce myself as Ambarish Tarte, a Microsoft Certified Trainer & Microsoft Office Specialist based out of Mumbai who conducts corporate training workshops for various corporate giants/multinational companies across the globe. I operate independently as a Corporate Training Consultant with M.S Office being my forte.
Looking forward to associate myself with your organization for all training requirements on M.S Office.

From India, Mumbai

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server