Tarte_ambarish
Corporate Trainer
Gyanshri
Http://gyanshri.webs.com/

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
dear sir , wanted to learn vlookup & hlookup if got ur help its excellent tyvm
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.
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Coô