MASTER ADVANCED EXCEL & DATA ANALYTICS: COMPREHENSIVE TRAINING FOR PROFESSIONAL EXCELLENCE

Description

Master Advanced Excel and Data Analytics

Upon completing this course, you will gain proficiency in:

• Comprehensive coverage of Advanced Excel and Data Analytics
• In-depth exploration from initial concepts to efficient data reporting
• Universal applicability across various professions
• Staying ahead with evolving
LEARNING PATH:

1. Identifying the Different Excel Programs
2. Identifying New Features of Excel
3. Working with the Ribbon
4. Customizing the Excel Program Window
5. Zooming In on a Worksheet
6. Arranging Multiple Workbook Windows
7. Adding Buttons to the Quick Access Toolbar
8. Customizing the Ribbon
9. Maximizing Usable Space in the Program Window ‘
10. Creating Workbooks
11. Modifying Workbooks
12. Modifying Worksheets
13. Inserting Rows, Columns, and Cells
14. Merging and Unrnerging Cells
15. Working with Data and Excel Tables
16. Entering and Revising Data
17. Managing Data by Using Flash Fill
18. Moving Data Within a Workbook
19. Finding and Replacing Data
20. Correcting and Expanding Upon Worksheet Data
21. Defining Excel Tables
22. Perforrning Calculations on Data
23. Naming Groups of Data
24. Creating Formulas to Calculate Values
25. Summarizing Data That Meets Specific Conditions
26. Working with Iterative Calculation Options and Automatic Workbook Calculation
27. Using Array Formulas
28. Finding and Correcting Errors in Calculations
29. Changing Workbook Appearance
30. Formatting Cells

31. Defining Styles
32. Applying Workbook Themes and Excel Table Styles
33. Making Numbers Easier to Read
34. Changing the Appearance of Data Based on Its Value
35. Adding Images to Worksheets
36. Focusing on Specific Data by Using Filters
37. Limiting Data That Appears on Your Screen
38. Filtering Excel Table Data by Using Slicers
39. Manipulating Worksheet Data
40. Selecting List Rows at Random
41. Swnmarizing Worksheets by Using Hidden and Filtered Rows
42. Finding Unique Values Within a Data Set
43. Defining Valid Sets of Values for Ranges of Cells

Lesson 02: Reordering and Summarizing Data

I. Sorting Worksheet Data
2. Sorting Data by Using Custom Lists
3. Organizing Data into Levels
4. Looking Up Information in a Worksheet
5. Combining Data from Multiple Sources
6. Using Workbooks as Templates for Other Workbooks
7. Linking to Data in Other Worksheets and Workbooks
8. Consolidating Multiple Sets of Data into a Single Workbook
9. Analyzing Data and Alternative Data Sets
10. Examining Data by Using the Quick Analysis Lens
11. Defining an A ltemative Data Set
12. Defining Multiple Alternative Data Sets
13. Analyzing Data by Using Data Tables
14. Varying Your Data to Get a Specific Result by Using Goal Seek
15. Finding Optimal Solutions by Using Solver
16. Analyzing Data by Using Descriptive Statistics
17. Creating Charts and Graphics
18. Creating Charts
19. Customizing the Appearance of Charts
20. Finding Trends in Your Data
21. Creating Dual-Axis Charts
22. Summarizing Your Data by Using Sparklines
23. Creating Diagrams by Using SmartArt
24. Creating Shapes and Mathematical Equations

Lesson 03: Using PivotTables and PivotCharts

l. Analyzing Data Dynamically by Using PivotTables
2. Filtering, Showing, and Hiding PivotTable Data
3. Editing PivotTables

4. Formatting PivotTables
5. Creating PivotTables from External Data
6. Creating Dynamic Charts by Using PivotCharts
7. Printing Worksheets and Charts
8. Adding Headers and Footers to Printed Pages
9. Preparing Worksheets for Printing
10. Previewing Worksheets Before Printing
11. Changing Page Breaks in a Worksheet
12. Changing the Page Printing Order for Worksheets
13. Printing Worksheets
14. Printing Parts of Worksheets
15. Printing Charts

Lesson 04: Most Used Formulas

I. Upper, Lower, Proper, and Trim
2. Left, Mid, and Right
3. Concatenate & (Ampersand)
4. Concatenate vs. & (Ampersand)
5. Roundup and Rounddown
6. Vlookup
7. Hlookup
8. Xlookup
9. Index
10. If
11. Nested If
12. If and And
13. Sumif
14. Error Values in Excel
15. Using Google Sheets
16. Excel Sheets vs Google Sheets
17. Integrated Google Sheets

Lesson 05: Financial Modeling and Valuation

1. Data Analysis with Pivot Tables and Power Pivot
2. Data Visualization, Charts & Graphs
3. Financial Analysis for Accounts and Finance
4. Master in Google Sheets

Lesson 06: Forecast and Trend Analysis

I. Sales, Production, and Distribution
2. Excel for Supply Chain and Logistics
3. Excel for Complete Human Resource Management
4. Creating Excel Templates for Day-to-Day Tasks