Excel in Microsoft Excel 2: Intermediate to Expert advanced

סקירה כללית

This course series has been recorded on Excel 2016 and Excel 2010 for the PC, but the content also covers Excel 2013 and 2019.

סילבוס

• Review of Basic Excel Functions
Recap of Formulas and Functions
Navigating Worksheets and Workbooks
Basic Data Formatting and Organization
• Advanced Formula and Function Techniques
Nested Functions
Array Formulas
Use of LOOKUP Functions (VLOOKUP, HLOOKUP, and XLOOKUP)
Error Handling in Formulas
• Data Management and Validation
Importing and Cleaning Data
Data Validation Techniques
Consolidating Data from Multiple Sources
Using Data Forms for Efficient Data Entry
• Advanced Charting and Visualizations
Creating Dynamic and Interactive Charts
Advanced Chart Types (Surface, Radar, Bubble)
Customizing Chart Elements
Conditional Formatting
• PivotTables and PivotCharts
Constructing and Customizing PivotTables
Using Slicers and Timelines
Designing and Analyzing PivotCharts
Calculated Fields and Items in PivotTables
• Advanced Data Analysis
Scenario Analysis and Data Tables
Goal Seek and Solver
Statistical Functions and Analysis ToolPak
Collecting and Analyzing Data in Tables
• Macros and Automation
Introduction to Macros and Recording Macros
Editing Macros with VBA Basics
Automating Tasks and Workflows
Debugging and Error Handling in Macros
• Collaboration and Workbook Security
Sharing and Merging Workbooks
Tracking Changes and Co-Authoring
Protecting Workbooks, Worksheets, and Cells
Data Encryption and Password Protection
• Integration and External Data Connectivity
Connecting to External Data Sources
Using Power Query for Data Transformation
Integrating Excel with Other Office 365 Applications
• Final Project
Applying Advanced Excel Techniques to Solve Real-World Problems
Creating Comprehensive Reports and Dashboards
Peer Review and Feedback Sessions

---

נלמד על ידי

Phillip Burton • 800,000+ students so far and I Do Data Limited

---

נושאים

Business