- Flat 106, Omran Tower, Immigration Road, Sharjah U.A.E.
- +971 65519919
- +971505376927
- info@albahith.org
Advanced Excel courses offer skills that are available at a high level of proficiency with the software program- the Microsoft Excel spreadsheet. Advanced Excel course offers users and experts the lesser-known capabilities like pivot tables, lookup tables, pivot charts, and data validation and debugging features to ensure accuracy.
• Creation of personalized templates
• Knowledge on how to work with sparklines
• Basic knowledge on how to create and manage scenarios
• Use of Goal Seek and Solver
• Creation, management, and formatting pivot tables and pivot charts
• Use of Excel mathematical functions
• Creation and writing knowledge on complex formulas
• Perform data lookups
• Creation and use IF statements
• Use of Excel’s data functions
• Creation and use data validation rules
• Application of custom and prebuilt conditional formatting
• How to work with functions to manipulate strings of text and data
• Creation and use of macros
• Troubleshoot and audit formulas
• Creation of pivot tables and pivot charts
• Use of queries to import external data
• Import and clean data
• How to link and consolidate worksheets and workbooks
• Troubleshoot errors
The course covers essential applications like MS Word, Excel, PowerPoint, Outlook, and OneDrive, along with cloud-based features and collaborative tools in Office 365.
This course is ideal for students, job seekers, working professionals, and anyone who wants to improve their computer productivity skills.
The course typically runs for 4 to 6 weeks, depending on the selected schedule (weekday or weekend classes).
Join the Program and take the first step toward confident English communication.
Al Bahith Training Centre in Sharjah offers Ministry-approved courses in English, IT, and professional certifications.
Saturday - Wednesday 10 AM - 09 PM Friday - 12AM - 08 PM | Thursday - Closed
Stay Tuned With U! . Be the first to know about our latest courses, updates, offers, and success stories. Join our learning community and never miss an opportunity to grow!
