Gyanshri
2

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
turkewadkar8090@gmail.com
1

dear sir , wanted to learn vlookup & hlookup if got ur help its excellent tyvm
From India, Mumbai
tarte_ambarish
5

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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.