- Duration: 20 Hours
- Timings: Part Time, Flexible
Course details
Working with Microsoft Excel can be extremely time-consuming if you don't know how to use it efficiently and effectively. Stop wasting your precious time on how to take control of spreadsheets! Come & Learn from the Masters!Advanced Excel Course from Edoxi Training Institute is a complete package of all the various tools and techniques which you may require in your profession and also to excel in MS Excel. Our Trainer for Advanced Excel is well known for his teaching and knowledge skills. You shall go through the Google reviews given by our students. Get the best Advanced Excel Training from Edoxi / Time Training Institute.
Edoxi Training Institute Dubai is an extended operation of Time Training Center Abu Dhabi. Time Training Center has 24 years of excellence in education field with ten thousands of professional certified students
Course Duration
Course Duration is 20 Hours, which can be completed by Two Weeks. Fast track coaching for Advanced Excel Course also available
Course Outline
- Dashboard Preparation
- Functions Used for HR & Admin Operation
- Automatic Delivery Order, Invoice & LPO Preparation
- BRS Preparation
- P&L Account Preparation
- Preparation of Gratuity
- Budgeting & Analyzing Functions
- Timeline, Slicer & Scenario Manager Application
- Offset Function
- Aggregate Functions
- Indirect Functions
- Dynamic Dropdown List
- Index Match Function
- Pivot Table, Pivot Chart-Advanced Level
- Audit Functions
- Database Functions and Logical Functions
- Look Up Functions (Lookup, Vlookup & Hlookup)
- Advanced Level use of Charts
- Protecting a Worksheet and Setting Permissions
- Data Management and Analysis Tools
- Working with Dates and Times
- Creating Formulas for Financial Applications
- Getting Data from Other Programs
- Automating Activities by Using Macros .
- Key Board Shortcut Practice
About Edoxi Training Institute
Edoxi Training Institute is the most excellent educational training center in Dubai who has the zeal to be on top by providing unique coaching for individuals. Being the finest training institute, we are the pioneers in offering career-orientated courses to the aspirant professionals. In our institute, we have been training several members and all those are now well settled with a bright career path.
As we also offer training for corporate companies, your employees can learn better courses and master them to increase productivity significantly in your company. This also helps in customer profitability for your business and boost return on investment. Moreover, our Edoxi Training Institute is a part of the Time Training Center, which has an experience of 24+ years in training students in Abu Dubai location. It has also shown its mark as being the leading institute in Abu Dhabi both in corporate training and individual training too.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Complete Guide A-Z Course CentralUSD 26
USD 250Duration: Upto 13 Hours - Microsoft Excel Bundle Study 365USD 94
USD 673Duration: Upto 18 Hours
