Corporate Trainer

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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
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
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Coô