Excelling at Excel: Working Smarter, Not Harder

Join us for this mini-course and elevate your proficiency in Excel. Whether you're a beginner or seasoned user, unlock the capabilities to manipulate, analyze, and visualize data like never before.

Description

Embark on a journey to excel in data management and analysis with our Excelling at Excel mini-course. Whether you're new to Excel or looking to enhance your skills, these sessions are designed to equip you with essential tools for effective data manipulation and visualization.

Begin with "Getting Started with Microsoft Excel," where you'll learn the foundational skills of spreadsheet creation, formatting, and navigation. Gain confidence in handling data sets and organizing information efficiently.

Next, dive into "Formulas and Functions," and unlock the power of Excel's built-in functions to perform calculations, manipulate text, and analyze data dynamically. Learn to automate tasks and streamline workflows using logical, lookup, and reference functions.

Transition to "Analyzing Tables of Data," where you'll explore techniques for sorting, filtering, and summarizing large data sets effectively. Discover how to use Excel's data analysis tools to uncover trends, patterns, and insights that drive informed decision-making.

In "Pivot Tables and Pivot Charts," master the art of summarizing and visualizing data dynamically. Learn to create pivot tables to analyze complex data sets and pivot charts to present your findings visually with clarity and impact.

Similar courses

Beginner Level of Excel 2021/365

More Information

Intermediate Level Learning for Excel 2021/365

More Information

Advanced Level Learning for Excel 2021/365

More Information

Are you new (or even not-so-new) to Excel? This sessions starts with the basics of Excel with navigating, creating, sharing and printing files. Don't miss out on the tips and tricks!

More Information

Help Excel do the hard work for you by using formulas and functions. In the session we demystify those confusing formulas and functions to their "anatomy" and then apply them to totals, text, values and even dates.

More Information

Microsoft started out as a financial tool, but did you know it can also manage large data sets? In Excel, these are known as "Tables" (aka "Lists"). Come learn the magic of using tables and what they can do for you in Excel.

More Information

Do you need to take your basic worksheets to the next level? Maybe you have workbooks with a lot of worksheets? In this session we focus on how to format your data, use styles, manage your worksheets and more.

More Information

Need to create more meaningful and flexible data tables and visualizations? Let's explore Pivot Tables and Pivot Charts to see how they can help make data analysis more meaningful.

More Information