Search
0 Log In
Search Results
    View all results
    Popular Searches
    Popular Brand and Topics
    image
    Virtual Instructor-Led Training 4 hours

    Prerequisites for Excel – Pivot Tables and Conditional Formatting Course

    Excel - Part 1 or equivalent experience.

    Excel – Pivot Tables and Conditional Formatting Course Outline

    • Tables
    • Conditional Formatting
    • Pivot Tables
    • Pivot Charts
    • Summarize PivotTable Data
    • Organize PivotTable Data
    • Filter PivotTable Data
    • Format a PivotTable
    • Refresh and Change a PivotTable

    Resources

    pexels pavel danilyuk 7658240
    1 min Read

    The Power of Workplace Relationships: Influence, Inclusion, and Impact

    Success in today’s workplace is not just about technical skills—it’s about relationships. Strong interpersonal connections enable teams to collaborate, innovate, and adapt to constant change. The Work Relationships: Influence Inclusion and Impact course focuses on building these essential skills. Why Workplace Relationships Matter Human collaboration is one of our greatest strengths. In a rapidly changing […]
    Read More
    pexels kampus 6248961
    1 min Read

    Building Strong Teams with Positive Assertiveness & Inclusive Leadership

    In modern workplaces, communication is everything. Yet many professionals struggle to express themselves effectively—either becoming too passive or overly aggressive. The solution lies in positive assertiveness. The Positive Assertiveness & Inclusive Leadership course helps individuals develop a communication style that is confident, respectful, and impactful. What is Positive Assertiveness? Positive assertiveness is the ability to: […]
    Read More
    man meeting
    2 mins Read

    Why Critical Thinking & Decision Making is a Must-Have Skill for Leaders

    In today’s fast-paced world, decision-making is constant. From the moment we wake up, we make dozens of choices—many without even realizing it. But when it comes to leadership, decisions carry weight. This is where critical thinking becomes essential. The Critical Thinking & Decision Making course is designed to help professionals strengthen their ability to analyze […]
    Read More
    Visit Learning Blog

    FAQs on Excel – Pivot Tables and Conditional Formatting

    The course covers analyzing data with tables and conditional formatting, creating PivotTables and PivotCharts, and preparing data by summarizing, organizing, filtering, formatting, and refreshing PivotTables.

    Participants should have completed Excel – Part 1 or have equivalent experience with basic Excel functions before taking this course.

    This course is ideal for Excel users who want to move beyond basic spreadsheet skills and learn to analyze and summarize data using PivotTables and conditional formatting.

    You will be able to create and format PivotTables and PivotCharts, apply conditional formatting to highlight data trends, and summarize, filter, and organize large data sets efficiently.

    This course is offered by New Horizons, a professional training provider specializing in technology and business skills courses.

    Related Courses

    Microsoft Excel

    Programming and Data Wrangling with VBA and Excel

    VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in...
    Microsoft Excel

    Excel – Data Analysis with PivotTables

    Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only...
    Microsoft Excel

    Excel – Data Analysis with Power Pivot

    Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In...
    Microsoft Excel

    Excel – Part 1

    Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you...
    Microsoft Excel

    Excel – Part 2

    Ready to go beyond the basics? Our Intermediate Excel Training course is perfect for professionals who want to turn raw...
    Microsoft Excel

    Excel – Part 3

    Ready to take your spreadsheet skills to the next level? This Advanced Excel Training course is designed for professionals who...

    Maximize Your Learning. Unlock Your Potential

    Discover career-focused courses designed to build the skills employers demand. Explore our catalog, choose
    your path, and start learning with expert-led training today.

    Explore Our Catalog