Name: Microsoft Office Specialist: Microsoft Excel Advanced Expert
Availability: InStock
Rating: 0 (1,007 students reviews)

Course Title: Microsoft Office Specialist: Microsoft Excel Advanced Expert
Instructor: Dr. Alex Amoroso
Target Audience:
- Professionals in fields like finance, accounting, marketing, and data analysis
- Individuals seeking to enhance their data analysis and visualization skills
- Organizations aiming to increase productivity and profitability
Prerequisites: For a better learning experience, it is suggested to use a laptop, mobile phone, pen, and paper for taking notes, highlighting important points, and making summaries to reinforce learning.

Key Topics Covered:
- Advanced Formulas and Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Text Functions
- Data Analysis and Visualisation
  - Pivot Tables
  - Advanced Charting
  - Conditional Formatting
  - Data Tables
- Data Management and Cleaning
  - Data Validation
  - Text to Columns
  - Removing Duplicates
- Automation with Macros and VBA
- Advanced Data Import and Export
  - Using Downloaded JSON Data for Data Connections
  - Importing data
  - Data Integration with SQLite and Excel
  - Advanced Filtering and Sorting with Dynamic Arrays
Key Skills Learned:
- Performing complex calculations and analyses
- Creating dynamic reports, dashboards, and visualizations
- Automating repetitive tasks with macros and VBA
- Importing, cleaning, transforming, and validating data
- Managing and manipulating large datasets
- Extracting meaningful insights from data

Duration: 1.5 hours on-demand video
Format: Self-paced online course
Resources:
- 2 articles
- 15 downloadable resources
- Access on mobile and TV
- Certificate of completion

Limited Time Coupon Code: Check the link below for potential discounts. This course have a limited number of coupon codes available.