This course will give you the skills, knowledge and ability of advanced Excel where you will develop your ability in using Excel that goes beyond the basics Excel.
This program will give you the skills, knowledge and ability of advanced Excel where you will develop your ability in using Excel that goes beyond the basics Excel.
You will learn about creating and applying Named Ranges and practice core functions like ' IF, AND, OR, IFERROR, VLOOKUP, MATCH, and INDEX.' Additionally, you will learn about data validation, automating functions inside Excel, data merging, conditional formatting, charting, protection etc.
Outline:
- PivotTables
- Named Range
- The Seven Critical Functions (Use with Named Range)
- Dates
- Protection
- Data Validation
- Excel Collaboration
- Macros
- Conditional Formatting
- Charts
- Relevant Shortcuts
- Demonstration: Interactive Dashboards without Macros
GRCA Academy is a leading training institute that is operating Globally with a primary focus on the MENA region. It values and assists in unlocking the true potential of career-oriented professionals to achieve their goals and meet objectives.
In order to ensure that you are abreast with the current global changes, updates and technology, GRCA Academy offers several accredited programs.
We have offices in:
KHDA approved certificate will be provided to students. This is a detailed course to learn about MS Word, MS PowerPoint and MS Excel. It covers all the vital features and function of Microsoft Office Suite.
This course is designed to provide attendees with a further understanding of managing PowerPoint presentations.
This is a Microsoft Office Package training offered by Laurels Training Institute. You will be trained by richly experienced and highly qualified teachers by using comprehensive study materials. The curriculum is designed by following the bo
Microsoft Outlook training will teach you about working with MS Outlook and understanding its available features and options which are prominently used in the business world.
This course will teach you all the underlying aspects of Excel worksheet including opening existing and creating new workbooks, working with spreadsheets, learning different formulas and functions in Excel, printing functions, creating simpl
© 2024 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy