• English English

2024

Microsoft Excel Expert (Certification)

Code: IT

Duration: 4 Days

Location: Doha

Fee: QAR 10,500

Course Overview

By the end of the course, you'll be able to apply advanced formulas and functions, design custom visuals and formats, explore data with PivotTables, automate manual tasks with macros, collaborate with other users, and much more. We've even included several custom-built practice tests, designed to replicate the actual Excel MO-201 exam structure and prepare you for the real deal.

Course Contents

Module (01) Manage Workbook Options and Settings1.1 Manage workbooks1.1.1 Copy macros between workbooks1.1.2 Reference data in other workbooks1.1.3 Enable macros in a workbook1.1.4 Manage workbook versions1.2 Prepare workbooks for collaboration1.2.1 Restrict editing1.2.2 Protect worksheets and cell ranges1.2.3 Protect workbook structure1.2.4  Configure formula calculation options1.2.5 Manage comments1.3 Use and configure language options1.3.1 Configure editing and display languages1.3.2 Use language-specific features Module (02) Manage and Format Data 2.1 Fill cells based on existing data2.1.1 Fill cells by using Flash Fill2.1.2 Fill cells by using advanced Fill Series options2.2 Format and validate data2.2.1 Create custom number formats2.2.2  Configure data validation2.2.3 Group and ungroup data2.2.4 Calculate data by inserting subtotals and totals2.2.5 Remove duplicate records2.3 Apply advanced conditional formatting and filtering2.3.1 Create custom conditional formatting rules2.3.2 Create conditional formatting rules that use formulas2.3.4 Manage conditional formatting rules Module (03) Create Advanced Formulas and Macros3.1 Perform logical operations in formulas3.1.1 Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions3.2 Look up data by using functions3.2.1 Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions3.3 Use advanced date and time functions3.3.1 Reference date and time by using the NOW() and TODAY() functions3.3.2 Calculate dates by using the WEEKDAY() and WORKDAY() functions3.4 Perform data analysis3.4.1 Summarize data from multiple ranges by using the Consolidate feature3.4.2 Perform what-if analysis by using Goal Seek and Scenario Manager3.4.3 Forecast data by using the AND(), IF(), and NPER() functions3.4.4  Calculate financial data by using the PMT() function3.5 Troubleshoot formulas3.5.1 Trace precedence and dependence3.5.2 Monitor cells and formulas by using the Watch Window3.5.3 Validate formulas by using error checking rules3.5.4 Evaluate formulas3.6 Create and modify simple macros3.6.1 Record simple macros3.6.2 Name simple macros3.6.3 Edit simple macros Module (04) Manage Advanced Charts and Tables4.1 Create and modify advanced charts4.1.1 Create and modify dual axis charts4.1.2 Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts4.2 Create and modify PivotTables4.2.1 Create PivotTables4.2.2 Modify field selections and options4.2.3 Create slicers4.2.4 Group PivotTable data4.2.5  Add calculated fields4.2.6 Format data4.3 Create and modify PivotCharts4.3.1 Create PivotCharts4.3.2 Manipulate options in existing PivotCharts4.3.3 Apply styles to PivotCharts4.3.4 Drill down into PivotChart details

© 2024 Qatar Skills Training Centre. All Rights Reserved.