Excel Expert Test Preparation Course – Microsoft Excel Expert (Office 2016)

1500

Product description

Excel Expert Preparation Course – Microsoft Excel Expert (Office 2016) Certification Number: 45036 Course Overview This course is designed for those with advanced experience in Excel, and aims to: Master advanced formulas. Create and manage professional spreadsheets efficiently. Prepare for the Microsoft Professional Certification Exam Excel Expert (Office 2019). Note: The course is advanced and not suitable for beginners. Course Data Start date: June 21 Program duration: 10 days (excluding weekends) Number of hours: 30 hours Course time: 6:00 PM – 9:00 PM Material: Simplified English Explanation language: Arabic Course Topics 1. Workbook Management Manage workbook options and settings Manage workbooks Copy macros between workbooks Reference data in other workbooks Enable macros in a workbook Manage workbook versions Prepare workbooks for collaboration Restrict editing Protect worksheets and cell ranges Protect workbook structure Configure formula calculation options Manage comments Use and configure language options 2. Data Management & Formatting Fill cells using Flash Fill and advanced Fill Series Format and validate data, including custom number formats Configure data validation Group and ungroup data Calculate subtotals and totals Remove duplicate records 3. Advanced Conditional Formatting & Filtering Create custom Conditional Formatting rules Use formulas within rules Manage conditional formatting rules 4. Advanced Formulas & Macros Perform logical operations using IF, IFS, SWITCH Use functions SUMIF, COUNTIF, AVERAGEIF, and others Lookup data using VLOOKUP, HLOOKUP, INDEX, MATCH Advanced date and time functions (NOW, TODAY, WEEKDAY, WORKDAY) Record and edit simple macros 5. Data Analysis Summarize data using Consolidate Perform what-if analysis (Goal Seek & Scenario Manager) Forecast data using AND, IF, NPER Financial calculations using PMT Troubleshoot formulas, monitor cells, validate and evaluate formulas 6. Advanced Charts & PivotTables Create and modify advanced charts: Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, Waterfall Create PivotTables, add calculated fields, create Slicers Create and format Pivot Charts Control chart options and detailed data analysis Official Exam Link Microsoft Excel Expert (Office 2019) Certification Registration for the exam and fees are included in the course price. Trainer Fatima Jafari Certified trainer from the General Organization for Technical and Vocational Training in Computer and Information Technology Holder of the title of Ideal Trainer (2017) and a Certificate of Excellence in Information Technology (2013 – King Abdulaziz University) Over 8 years of training experience in Microsoft Office programs (from beginner to expert) at Noor Aamal Higher Institute for Training – Jeddah, Saudi Arabia Student Feedback “Thank you Noor Academy and a big thank you to Ms. Fatima, may God bless you and grant you success.” “The course is wonderful and I benefited a lot.” “Trainer Fatima is very distinguished in explanation and conveying information.” “A cooperative trainer, her explanation is from the heart.” Note: Please carefully read the registration and replacement policy via the link attached at the bottom of the page before completing the payment process. The institute is not responsible if these policies are not reviewed. Completing the registration process is considered explicit agreement to all terms and conditions contained therein. All our courses are accredited by the General Organization for Technical and Vocational Training, and are issued electronically from the Mnar platform after completing all course hours. Mnar Platform Link: https://mnar.sa/auth/trainee/login

Questions you might have

‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌
‌
‌‌
‌