Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories
Start DateEnd DateClass Times (EST)Delivery/Location ?StatusPriceEnroll Now
5/29/20255/29/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
6/5/20256/5/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
6/12/20256/12/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
6/25/20256/25/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
7/1/20257/1/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
7/10/20257/10/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
7/23/20257/23/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
8/4/20258/4/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
8/8/20258/8/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
8/21/20258/21/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
9/2/20259/2/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
9/15/20259/15/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
9/22/20259/22/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
9/26/20259/26/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
10/3/202510/3/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
10/10/202510/10/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
10/22/202510/22/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
10/29/202510/29/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
11/5/202511/5/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
11/18/202511/18/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
12/8/202512/8/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
12/19/202512/19/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
12/31/202512/31/20259:00 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$266.00
5/29/2025 - 5/29/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
6/5/2025 - 6/5/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
6/12/2025 - 6/12/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
6/25/2025 - 6/25/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
7/1/2025 - 7/1/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
7/10/2025 - 7/10/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
7/23/2025 - 7/23/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
8/4/2025 - 8/4/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
8/8/2025 - 8/8/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
8/21/2025 - 8/21/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
9/2/2025 - 9/2/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
9/15/2025 - 9/15/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
9/22/2025 - 9/22/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
9/26/2025 - 9/26/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
10/3/2025 - 10/3/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
10/10/2025 - 10/10/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
10/22/2025 - 10/22/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
10/29/2025 - 10/29/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
11/5/2025 - 11/5/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
11/18/2025 - 11/18/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
12/8/2025 - 12/8/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
12/19/2025 - 12/19/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00
12/31/2025 - 12/31/2025
9:00 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$266.00

Train your entire team with our Private Group Training solutions. AstraTech specializes in creating customized training programs to fit your organization’s unique learning needs and business objectives. Take advantage of multiple student discounts, customized curriculum and flexible scheduling with Private Group Training from AstraTech!

    On-Demand Learning (ODL) is a self-paced training solution designed to work around your individual schedule, budget, and learning needs. Our ODL courses provide you with exclusive access to interactive platforms combining high-quality instructor videos from subject matter experts, official courseware and study materials, hands-on labs, practice exercises, skill assessments and knowledge checks. The modular, self-paced ODL course structure adapts to your unique learning needs and style, providing an optimal training experience.

    Train your entire team with our Private Group Training solutions. AstraTech specializes in creating customized training programs to fit your organization’s unique learning needs and business objectives. Take advantage of multiple student discounts, customized curriculum and flexible scheduling with Private Group Training from AstraTech!

    Excel – Part 3

    $295 | 1 day

    Upgrade your tech skills with this , training course. Launch your career to the stars with AstraTech IT Certification Training!

    Please select a Learning Method below to get started:

    • Microsoft Apps
    • Microsoft Excel

    About this Course

    SKILL LEVEL: 
    • Advanced

    Excel – Part 3 Course Outline

    Ready to take your spreadsheet skills to the next level? This Advanced Excel Training course is designed for professionals who want to work smarter?not harder?with Microsoft Excel. You?ll build upon the foundational and intermediate knowledge from Microsoft Excel ? Part 1 and Microsoft Excel ? Part 2, helping you get the most out of your Excel experience.

    Learn to collaborate more effectively with colleagues, automate complex or repetitive tasks, and use conditional logic to create powerful formulas and functions. The more you master Excel?s advanced tools, the more you can shift your focus from manual work to extracting the insights your organization needs from its vast amounts of data. From building dynamic dashboards to forecasting trends, this course unlocks the full potential of Excel at your fingertips.

    Advanced Excel Training is ideal for business professionals, analysts, project managers, accountants, and anyone who needs to perform high-level data analysis, reporting, or spreadsheet management tasks. If you already use Excel regularly and are ready to deepen your capabilities, this course is for you.

    Students should have completed Microsoft Excel ? Part 1 (Introduction) and Microsoft Excel ? Part 2 (Intermediate), or have equivalent knowledge and experience. You should be comfortable entering and formatting data, creating basic formulas, using functions like SUM and IF, and working with simple PivotTables and charts.

    In Advanced Excel Training, you?ll build the expertise needed to perform sophisticated data analysis, collaborate seamlessly on workbooks, and automate tedious tasks?boosting your efficiency and impact.

    Upon successful completion of this course, you will be able to:

    • Work with multiple worksheets and workbooks.
    • Share and protect workbooks to ensure secure collaboration.
    • Automate workbook functionality with macros and advanced tools.
    • Use Lookup functions and perform formula auditing to troubleshoot and enhance spreadsheets.
    • Forecast and analyze data trends.
    • Create Sparklines and map data for dynamic, visual reporting.

    Managing Multiple Worksheets and Workbooks

    • Create links between workbooks and use external references
    • Work with 3-D references across worksheets
    • Combine and consolidate data from multiple sources

    Collaborating and Securing Your Workbooks

    • Co-author workbooks and manage collaboration features
    • Protect worksheet content and control access permissions

    Streamlining Tasks with Automation

    • Set up data validation rules to control user input
    • Find and fix invalid data and formula errors
    • Automate repetitive actions with recorded macros

    Mastering Lookup Functions and Formula Auditing

    • Use advanced Lookup functions to retrieve data
    • Trace cell relationships and troubleshoot formulas
    • Monitor calculations with the Watch Window and Evaluate Formulas

    Predicting and Forecasting Data Trends

    • Analyze possible outcomes using data tables
    • Explore scenarios for strategic decision-making
    • Apply the Goal Seek tool to backtrack solutions
    • Build simple forecasts based on historical data

    Visualizing Data with Sparklines and Maps

    • Summarize trends with Sparklines inside cells
    • Create basic geographic maps to display data visually