Excel Tutorial Videos

Excel Camera Tool

This tutorial shows you how to add the secret Excel Camera Tool to your Quick Access Toolbar or Ribbon. Combine text, charts, graphics, WordArt, SmartArt, data, etc. to create a picture that you can use in your presentations, videos, slide shows, other programs and so on.

Excel Goal Seek

Use Excel's Goal Seek to solve for any unknown value by specifying a desired outcome. With Goal Seek, you can determine the input needed to achieve a specific result. Whether it's finding the necessary sales figure to reach a target profit or determining the interest rate required to pay off a loan within a certain period, Goal Seek can help solve these problems quickly and efficiently. It can also solve Algebra problems.

Excel Structured References

How to use Excel Structured References both in tables and out of tables. Use Structured Reference to perform math functions on multiple tables. Use Excel Structures to copy all or part of a table. Learn how to use Structured References to copy a portion of a table such as a row, column, headers, totals, etc.

Generate Random Numbers in Excel

Create random values in Excel with three different functions. Learn how to handle duplicate values and use random values to select items from a list. Invaluable for saving substantial time during the testing of Excel features and functions, allowing for the swift creation of sample data. Get the benefit of creating arbitrary selections of items or individuals. Use it to randomly select employees for drug testing or items from the production line for quality assurance testing.

Add Pictures to Excel: No Cell Adjusting Needed

Ultimate Guide to Adding Pictures to Excel.
Learn the amazing unknown way to add pictures to Excel without the hassle of adjusting cells. Insert pictures into Notes. With this quick and easy method, you can hide and show pictures whenever you want, without taking up any cell space. Say goodbye to the impracticality of Excel's built-in image feature and embrace this more practical solution.

Excel Navigation Pane

Unlock the full potential of Microsoft Excel with our in-depth tutorial on using the Navigation Pane! See what elements exist within the workbook such as tables, charts, PivotTables, pictures ranges, slicers, grouped elements, etc. and navigate directly to those elements. You can select any object in the workbook by just clicking on it in the pane. Show hidden worksheets. Learn how to quickly navigate between different sections of your workbook, how to quickly access specific elements by applying filters and group and ungroup elements. The Navigation pane also makes it easier for those with visual impairments to access all parts of the workbook.

7 Advantage of Using Excel Advanced Filtering

Everything you need to know about Excel Advanced Filtering in this Everything you need to know about Excel Advanced Filtering in this comprehensive tutorial. In this Mastery series we will dive deep into one of the most powerful yet underutilized features in Excel. You will learn how to filter complex criteria, display only unique records, copy filtered data, dynamically adjust filters based on your needs and much more. Become a filter and data analysis expert.

How to use Geography Data Type in Excel

Learn how to enhance your stock analysis using Excel. This tutorial covers stock data types, current data, historical data, and more for in-depth analysis. How to use stock history function in Excel.

How to use Stock Data Type for Stock Analysis

Learn how to enhance your stock analysis using Excel. This tutorial covers stock data types, current data, historical data, and more for in-depth analysis. How to use stock history function in Excel.

How to Create Macros in Excel

Learn how to delete macros, change shortcut keys, and even attach macros to the Quick Access Toolbar or shapes and icons for fast access. Unlock the power of automation in Excel with this step-by-step tutorial on how to build your first macro! Whether for work or personal projects, this guide will teach you how to create macros in Excel, save workbooks with macros, and manage your personal workbook macros.