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.
Excel SUMIFS In-Depth
Master SUMIFS in Excel: The Ultimate Comprehensive Tutorial for Data Analysis! Unlock the full power of Excel's SUMIFS function with this complete, step-by-step guide designed for beginners to advanced users. Whether you're in finance, sales, marketing, or business analytics, this tutorial will transform how you analyze data.
You Won't Believe What Relative Cell Addressing Can Do in Excel
Mastering Excel Macros: Fixing Absolute Cell Referencing Issues with VBA Code. In this tutorial, we explore one of the most common problems when creating Excel macros – the use of Absolute Cell Referencing. While Excel defaults to absolute references in macros, this can cause issues when applying the macro to multiple cells. We'll show you why Relative Cell Addressing is the better option for dynamic macros, and how to easily switch between the two.