- Other Locations: Dubai Abu Dhabi - United Arab Emirates As Sahifah - Jeddah Riyadh Al Ghubrah South - Muscat Qudaibiya - Manama Kuwait City Doha - Qatar
- Duration: Upto 16 Hours
- Timings: Part Time, Flexible
Course details
Participants will learn to use advanced functions of Excel to improve Productivity, enhance Spreadsheets with Advance Level Formulas, Dynamic Charts, Visualize Data with use Powerful Graphics, Dashboards and Streamline their Operational Work.Participants will also learn how to automate common Tasks, apply Advanced Analysis Techniques to more Complex Data Sets, Collaborate on Worksheets with others, and Leverage on Excel's Advanced Functionality to Simplify and Streamline their day-to-day Work.
Workbooks (File) & Worksheet Handling
- Excel Limitation.
- Excel Shortcut use and Benefits.
- Excel Setting and Custom List Creation.
- Excel Tamplate and File Location System.
- Advanced Paste Special.
- Calulation with Paste Special.
- Link Data Range as Picture Link.
- Formatting Triks.
- Date & Time Format.
- Advanced Custom Formating (Number Format using Code).
- Condtional Formatting.
- Advanced Conditional Formatting using Formulas.
- Files, Sheets or Cells Protection Method.
- Data Fill and Selection Method.
- Advanced Sorting and Filter.
- Data Summarization with Pivot Table.
- Calculation with Pivot Table.
- External Data Pivot Table.
- Timeline and Slicer in Pivot Table.
- Power Pivot in Excel 2016.
- Formula Basics for Advance Level Formulas.
- Logical Formulas (IF, AND, OR, IF Error Formulas).
- Nested IF Formulas ( Multi Condition in IF, AND, OR ).
- Text and Advanced Text Formulas.
- Date and Time Calculation using Data Time Formulas.
- Ref# Formulas and V Lookup.
- Lookup Method(V Lookup, H Lookup, Match, Index, Offset).
- Advanced V Lookup and V Lookup Listing.
- Math & Trigno Formulas.
- Data Summarization Formulas.
- AVERAGE IF, AVERAGE IFS, COUNT IF, COUNT IFS, LARGE, SMALL.
- Database and List Management Formulas.
- Information Formulas.
- Financial Formulas.
- Advanced Array Formulas.
- Complicated Large Formulas Creation.
- Advanced Naming Method with Formulas.
- Report Automation with Formulas.
- Chart Creation.
- Chart Tricks.
- Dynamic Chart with Offset Formulas.
- Dashboard Example.
Updated on 15 March, 2021
Eligibility / Requirements
Any one can do this course
Job roles this course is suitable for:
Secretary , Sales Team Leader , Human Resources , Senior Manager , Finanical Anaylst , Finance Manager , Senior Equity Analyst , Senior Business Analyst , Director , Business AnalysisCourse Location
About Delphi Star Training Centre
The Delphi Star Training Institute is a premium corporate training provider established with the motto to provide unique, innovative and effective training opportunities for people aspiring to enhance their skills, not only to meet manpower requirements, but also to cope with market trends. The Delphi Star Training Institute is committed to impart the highest quality of education and exposure to help develop the next generation of business leaders with global outlook and capability of adapting to the fast changing business environment of the world. By introducing new specialization courses and adopting an innovative online interactive technique, the institute has been constantly working to develop professionals with vision, courage and dedication to initiate and manage the change.
In today’s world, distinguishing yourself from the competition in the cut throat global job market requires professional certifications, which is where we, at Delphi Star Training are equipped to fast track your career and personal growth. Regardless of your industry and career path, the various courses offered by us are sure to match yours and your organization’s requirement.
We are the leading Professional Training institute in Middle East providing training for Project Management, HR Trainings, Accounting & Auditing, Information Technology, Finance, Quality Management, Digital Marketing and many more. Delphi is a unique platform for professionals, academic to get outstanding knowledge, quality exposure, and immaculate scope to reach to their target position.
At Delphi the faculty members are vision driven and are inspired with a passion for teaching – a drive that makes them prestigious and outstanding. The faculty members at Delphi functions as mentors and facilitators, making learning interactive experience and more enhancing. The Institute also invites people from the corporate sector and academic field as visiting and guest faculty to share their experiences with the students.
“Education is not preparation for life; education is life itself” ~ John Dewey
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel : VLOOKUP Formula Course LineOMR 9
OMR 185Duration: Upto 2 Hours - OMR 4Duration: Upto 8 Hours