Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Advanced Excel Training - 16 Hours Interested People Contact - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




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

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.