- Duration: 20 Hours
- Timings: Part Time,Evening, 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 Time Training Center 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 Time Training Center.
Course Duration
Course Duration is 20 Hours, which can be completed by Two Weeks. Fast track coaching for Advanced Excel Course also available
Course Content
- 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
Course Location
About Time Training Center
Time Training Center (TTC) is a leading education institute in Abu Dhabi that focuses on providing quality education and training programs.TTC is accredited to Abu Dhabi Center for Technical Vocational Education & Training (ACTVET) with specialization in Computer and Management Training programs.
TTC has been operating in Abu Dhabi for over 24 years, previously known as Aptech Computer Education. The Center has slowly but surely, established its name and brand value as a comprehensive and high quality Management and Computer Training Center in Abu Dhabi. TTC has also secured strong loyalty from corporate companies and other associations with its holistic practical teaching approach. Given its established credentials, the Center now seeks to expand its services in Abu Dhabi and serve a larger number of students with its futuristic technology and Management programs.
We are passionate about making a difference to our student’s lives. We do this by providing affordable, accessible training programs that lead to an employment outcome. Our courses are developed in conjunction with industry to ensure our students skills and knowledge that employers are looking for. All of our courses are reviewed regularly to ensure they remain current and aligned with industry demands.
The target market for the Center include; students with a high school diploma seeking to add technical and language skills to their knowledge base and professionals seeking to enhance their technical skills& Managerial competency. Time Training will continue to employ professionals with rich industry experience as guides, to train students and provide them with the necessary career enhancing tools and techniques.
See all Time Training Center courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- AED 735Duration: Upto 145 Hours
- Microsoft Excel 2013 Basic to Advanced 1TRAININGAED 179Duration: Upto 60 Hours
