EXCEL

What You Didn’t Know You Didn’t Know

Introducing “What You Didn’t Know You Didn’t Know,” a series of bite-sized Excel tutorials crafted to reveal the vast possibilities that Excel offers—possibilities you may not have even realized existed. This series is designed to show you just how powerful Excel can be in making your work more efficient and your data management more effective, uncovering lesser-known features and shortcuts that can fundamentally transform your Excel experience. Join us in these quick tutorials to discover the full potential of Excel and learn to utilize its capabilities in ways you never imagined. Welcome to a journey of discovery, where you’ll not only learn to use Excel but to master it in ways you didn’t know you didn’t know.

Jump to:

Beginner

Basics in Excel: Part 1

Learn how to open a file, navigate through multiple sheets within your workbook, and familiarize yourself with the ribbon menu, including the “Home” and “Insert” tabs. We’ll also delve into submenus like font, alignment, and numbers.

Excel: Formatting

Discover key aspects of making your data visually appealing and reader-friendly. Discover how to apply formats to enhance readability, highlight important information, and present your data with professional polish, setting the stage for effective communication and analysis.

Excel: Filtering

This video introduces the fundamentals of using filters to efficiently navigate and manage data. Learn to apply and customize filters, enhancing your data analysis and organization skills in just a few clicks.

Basics in Excel: Part 2

This video emphasizes the critical step of saving your work and explores various saving options. Discover how to use “Save,” “Save As,” and how to save your documents in different file formats, ensuring your data is securely stored and accessible in the format you need.

Charts in Excel

This video equips you with the knowledge to leverage Excel charts with ease. Learn to quickly transform data into clear, impactful visuals, making your analyses and reports more accessible and engaging. This guide is your shortcut to mastering the essentials of Excel charts with ease.

How to Freeze Your Header Rows

Learn how to freeze header rows, ensuring your column titles remain visible as you scroll through your data, making it easier to track and analyze your information without losing context.

Basics in Excel: Part 3

This tutorial delves into navigating and managing columns and rows, utilizing the address bar, and mastering the formula bar. Learn to insert a carriage return within a cell and expand the formula bar for better visibility, enhancing your efficiency and ease of use in Excel.

Formulas in Excel (Part 1)

This video introduces the basics of Excel formulas, perfect for beginners, it introduces you through the steps to start using formulas for simple calculations and data analysis. Learn to automate tasks and efficiently manage your data with Excel. Start your journey to mastering Excel formulas with us!

Excel: Sorting

This video explores the essential techniques for organizing your data through sorting. Discover how to effortlessly arrange information by values, dates, or text, streamlining your data analysis and reporting processes.

Basics in Excel: Part 4

This video guides you through using the Insert Function builder and demonstrates the basic Sum formula. Explore different “View” options to preview how your spreadsheets will look when printed and learn how to adjust the print view, ensuring your documents are perfectly prepared for presentation or sharing.

Formulas in Excel (Part 2)

This video continues your journey into the basics of Excel formulas. Building on the foundation laid in Part 1, this video dives deeper into slightly more complex calculations and introduces additional functions to enhance your data analysis and task automation.

Customize the Menus

This video offers insights into personalizing your Excel workspace. Discover how to modify the ribbon and quick access toolbar, tailoring Excel’s interface to fit your specific workflow needs. This guide empowers you to streamline your tasks and access your most-used tools and functions with simplicity.

Intermediate

Making Drop-Down Menus in Excel

This video shows you how to make drop-down menus in Excel. This is very useful for data-entry. It makes it easier for the person entering the data, and it makes your data cleaner (because data won’t be spelled 20 different ways, etc.)

Excel: Merging Data

This tutorial teaches you efficient techniques for merging data, ensuring consistency and accuracy across your spreadsheets. Discover how to seamlessly integrate information, enhancing your data analysis and reporting capabilities.

Dynamic Images in Excel

This video provides a comprehensive guide on creating dynamic images in Excel that update based on your selections from a pull-down menu. Discover the steps to link images and selections, enabling your spreadsheets to visually reflect changes and choices in real-time, enhancing interactivity and user engagement.

Conditional Formatting in Excel

Conditional formatting in Excel is a feature that allows you to apply specific formatting (such as colors, icons, or data bars) to cells that meet certain criteria. This enables you to visually analyze and interpret data more efficiently, identify exceptions, and make data-driven decisions quickly.

Excel: Mark All That Apply is in One Column, Help!

Some survey forms put the results for a “Mark all that apply” (checkbox) question all in one column with commas between them. This video shows how to separate the data into separate columns and put each answer where you want it.

Making a Dynamic Info-graphic Chart in Excel

This video guides you through creating a simple, dynamic infographic chart in Excel. It breaks down the process into easy-to-follow steps, showing you how to transform your data into an engaging and visually appealing infographic.

How to Use a Form for Data Entry

Learn how to customzie your Excel menu to include the Form-Maker tool, followed by a practical guide on utilizing forms for efficient data entry. This tutorial simplifies data collection and entry, showcasing how forms can streamline your workflow, enhancing data accuracy and organization.

Analyzing Survey Data: Step 1 Get Data Ready

This video uses a sample data set to show how to analyze survey data to get much more useful, interesting, and professional data. This video is the first step. The dataset used in this is from https://astralcodexten.substack.com/p/acx-survey-results-2022.

Excel: Preparing and Cleaning Data

This short tutorial demystifies the process of refining your datasets for analysis. Learn practical techniques for eliminating errors, standardizing formats, and ensuring your data is accurate and ready for use, paving the way for insightful analysis and decision-making.

Excel: Intro to XLOOKUP

This video shows you how to use xlookup instead of vlookup. One advantage to xlookup is that you can return data from any column instead of only from those to the right of the matching column.

Advanced

How to Recode Data in Excel

his tutorial demonstrates how to recode data in Excel using the “switch” function. For those specifically interested in the formula application, skip ahead to the 2-minute mark.

Easy Excel Data Dashboard (Part 1)

This video is a step-by-step guide on the fundamentals of building an Excel dashboard, showcasing how to effectively use pivot tables and slicers. Learn how to combine these powerful tools to create dynamic, interactive visualizations that can transform your raw data into a compelling and easily understandable dashboard.

How to Explore Data Using Slicers in Excel

This video introduces the powerful feature of slicers in Excel, a dynamic tool designed for filtering data in pivot tables and charts. This video tutorial guides you on how to use slicers to visually segment and refine your data, making it easier to explore and analyze patterns, trends, and insights.

Easy Excel Dashboards (Part 2)

This part 2 video elevates your dashboard design skills by teaching you how to incorporate elements of infographics into your Excel dashboards. 

How to Use a Slicer in a Pivot Table

This video shows how to use a slicer in a pivot table. It also shows you how to right click in a pivot table to change the order of the header row to something other than the automatic abc-order it defaults to.

Excel: Introduction to Power Query

This video is for people who use Excel on a regular basis, and are not familiar with the Power Query features. This will introduce you to what Power Query is and how it works.