This video will introduce tools to sort and filter data, teaching how to organize data in alphabetical order, reverse sort, and create custom sorts using multiple criteria. It also demonstrates how to filter records based on specific...

This video introduces the student to a variety of basic functions available in Excel, including SUM, AVERAGE, MIN, and MAX, and how to apply them to a range of cells, thereby enabling the student to perform basic statistical analyses on...

This video discusses the difference between relative and absolute cell addressing, showcasing how to create formulas using both types and their unique behaviors when copied and pasted.

This video explains how to create simple mathematical formulas, such as multiplication, and how to format cells for specific data types like currency. Additionally, it demonstrates the process of copying and pasting formulas to different...

We'll explore the powerful mathematical capabilities of Excel, showcasing how to create formulas to sum a series of cells with ease.

You'll discover how to format cells to meet your specific needs, altering text styles, changing text and background color, modifying the typeface, and adding borders around cells.

In this section, we're going to introduce you to the world of Excel's interface. Together, we'll explore the variety of tools at your disposal, located in the ribbon, tabs, and menus at the top of your screen.You'll discover how to...

Welcome to "Microsoft Excel: Minutes to Mastery" a dynamic, bite-sized course designed to transform Excel beginners into confident users.

You will learn to confidently input various types of data into Excel cells, including text, numerical data, and formulas.

In this video, Greg Martin talks about four areas of competencies needed to be effective in public health and global health. He places particular importance on management, leadership and governance.

Visualization of data is a powerful method to see trends and make decisions. Microsoft Excel trending capabilities are tools to visualize large data sets, such as financial information on company performance.

In this video Dr Greg Martin talks about the importance of management and public health. If you are working in the area of public health or global health, this video will outline some management science tools that can be applied to good...

NO BS: Microsoft Excel 2016 Data Analysis Toolpak (On Windows)

NO BS: Download Microsoft Excel 2016 Data Analysis Toolpak (On Mac)

This video is a tutorial on using logical statements and nested if functions in Microsoft Excel, demonstrated through VBA coding. The teacher explains the importance of understanding logical statements and provides examples of how to use...

Excel/Numbers: Program Average and Standard Deviation

In this video, the teacher explains how to create and edit code in Microsoft Excel using VBA. They demonstrate how to record macros for coloring data in different ways and then show the corresponding code generated by the macros. The...

Analyze Your SDS-PAGE Data IN 5 MINUTES!

In this video, the speaker, a Microsoft certified trainer, introduces the Microsoft Excel VBA editor tool. They explain the basics of VBA and macros, their functions and applications in Microsoft Excel. They also discuss the Visual Basic...

This tutorial provides an overview of the startup screen in Microsoft Excel, including the various options available such as templates, recent files, and search functions. It also highlights the benefits of using these features to save...

Excel/Numbers: Absolute Cells vs Reference Cells

NO BS: Construct a Box-and-Whisker Plot in Excel

This tutorial demonstrates how to format numbers in Microsoft Excel without using conditional formatting. It shows how to display positive numbers in black with an up arrow and negative numbers in red with a down arrow. By...

In this tutorial, the speaker demonstrates how to easily change text from uppercase to lowercase, title case, or sentence case in Microsoft Excel using simple formulas. By following the step-by-step instructions, users can efficiently...