Advanced Microsoft Excel Training For Corporate

In Chennai

Compare this course with other similar courses
See all

Important information

  • Training
  • Advanced
  • Chennai
  • 16 hours of class
  • Duration:
    2 Days
  • When:

We are Expert in Microsoft Office Training and Automation Solution for more than 15 years.

We provide Real Time Scenario's Training and Out-Of-Box Solutions for Individuals and Corporate clients across the world.

About Our Training:
We have designed and developed our material which will cover the Office Requirements. The method of training we provide at OfficeTechWorld is EXCEPTIONAL with REAL TIME SCENARIOS's. At the time of training we provide one to one attention on each Trainee where they can INVITE their MASS DOUBTS. This will help the trainee to DEVELOP and AUTOMATE their DAILY JOB.

Our well designed and continuously developed training modules, delivery methodologies, our highly effective sessions and workshops have empowered people with knowledge.

Our Services:
* Professional Advanced Excel Training
* Excel VBA and Macro Training
* Advanced PowerPoint and Presentation Skill Training
* Dynamic Dashboard Training and Automation Solution with Dropdown, Scroll Bar, Check Box, MultiSheet etc
* Email Embedded Automation, Database Programming, Data Manipulation and Conversion, Data Cleansing, Data Mining and Forecasting, Data Integration
* Automated Report Generation, Process Review Improvement and Lean, Data Audit
* Data Extraction from Web
* Outlook based Excel Tool
* Automation on Data populate in .exe program/web
* Software Automation for Billing etc

Important information Venues

Where and when

Starts Location Timetable
OfficeTechWorld, 600028, Tamil Nadu, India
See map

Frequent Asked Questions

· What are the objectives of this course?

Key Objective from our training: * Automate your process with simple Formula Tricks and Techniques * Improve your career/organisation growth * Impress your Boss/Management from creative and automated Dashboards, Presentation skill * Provide Out-Of-Box Solutions to your process * Improve your process by LEAN Techniques and many more

· Who is it intended for?

Who Can Attend Our Training: * Candidate should have basic knowledge of Microsoft Office related Excel * Anybody who want to automate their process relating to Microsoft Office related Dashboard Design, Excel Template Design, Report Automation, Data Mining, Data Cleansing, Process Improvement with simple formula and functions

· Requirements

Should have basic knowledge of Microsoft Excel

· What happens after requesting information?

Anybody who is interested for the training (Individual or Corporate) can contact us. We provide FREE DEMO. We provide both Online and Class Room Training. Call / SMS: + 91 - 8939 207070 OR 96000 15474 Email : OfficeTechWorld@Gmail.Com

What you'll learn on the course

Microsoft Office
Ms Excel
Dashboards and servicing reports
Training and Development
Excel Formula
Excel for Accounting
Excel 2003
Excel 2007

Teachers and trainers (1)

Rosy Rai
Rosy Rai
Training Coordinator

Course programme

Key Takeaways

  • Overlooked Basics and Excel Hacks
  • Key Board Shortcuts in Depth, Creating your own Shortcuts
  • Key Excel Functions in depth including Hidden Functions
  • 3 ways of doing PICTURE Lookup and 8 ways of doing VLOOKUP
  • Using MSQRY32, Advanced Filter, Database Functions, Filtering Wildcards
  • Create Graphs & Report with Dropdown, Scroll bar, Check-Box
  • Professional Dashboard Report Design with Multi Sheet Data
  • Using Excel Analytical tools: Goal Seek, Solver, Data Tables, Scenarios, Simulation & Excel Tables
  • Creating Dynamic Named Ranges that will auto update on changes and related functions
  • Hyperlinks in depth including to Applications and Hyperlink Function Magic
  • Conditional Format in Depth including using Formula and Hacks
  • Data Validation with Formula & Auto update on change of Lists
  • Protection TechniquesCell, Range, Sheet, Workbook File
  • Design Excel Templates and how they save your time
  • Playing with Pivot Tables & Charts, Slicers, Timelines, Spark lines
  • In Depth into Pivot Reports and Charts, Report Filter Pages, Auto Refresh Pivot
  • Time Saving Tips, Tricks and Techniques
  • Import & Collate Data in Seconds including use Share & Merge Workbooks
  • Print Settings and Multi Window for sheet display
  • Advanced Features and Powerful Functions in Excel and many more Hidden Tricks and Techniques
  • Using Excel File as a Database to do Mail Merge from MS word Application
  • Advanced, Complex, Multiple, Nested and Lengthy Excel Functions including Database Functions

Additional information

About Our Training: We have designed and developed our material which will cover the office requirements. The method of training we provide at OfficeTechWorld is exceptional with Real Time Scenario’s. At the time of training we provide one to one attention on each trainee where they can invite their mass doubts. This will help the trainee to develop and automate their daily job.   Our well designed and continuously developed training modules, delivery methodologies, our highly effective sessions and workshops have empowered people with knowledge.    About Our Automation: We have experienced professionals from BPO, KPO, IT Industry and other Business units who will help with your requirement to automate the process. We can develop/design Innovative and Out-of-box Solutions, Born from unimaginable perspectives, out-of-box for your Unique and Uncommon Problems. We are also experts in Audit, Investigation, Executive Services, Internal Control Design, Computers, Programming Languages, and Design & Development of Automation Solutions.   Our Customers are highly benefited with our Solutions (Eg.) Huge Cost-Saving, TAT reduced significantly, Lead Huge Productivity, Improved High Accuracy, Process Optimization, Manual Process Automated, Avoid Data Loss, Cost Effective and Customized Solution and many more.

Compare this course with other similar courses
See all