Spreadsheet ApplicationsCurated Directory — Courses, Videos, Books & Websites

Microsoft Excel - Creating Dynamic Dashboards

" Are you interested in how Excel can be used to present data in a functional, visually attractive, and user-friendly ways? This tightly focused course will show you how to create dynamic dashboards to present complex data using a variety of techniques. A basic knowledge of Excel is required. You will start by learning how to prepare the data, then jump into building the dashboard. Throughout the course, you will be working to create a dashboard that provides a summary of a person's health information. Erin will teach you how to optimize Excel data for use in dashboards, create visual dashboard components, and add interactivity to customize them for each user. This video tutorial also covers how to create a distribution histogram, use a waffle chart to show progress, and add actions to buttons. Finally, you will learn how to generate dashboards as outputs, produce them as PDFs, and utilize them within PowerPoint or share via OneDrive. Once you have completed the course, you'll be able to create your own custom dynamic dashboards in Excel with ease. Working files are included, allowing you to follow along with the author throughout the lessons. "

The Beginner's Guide to Excel - Excel Basics Tutorial

Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look ...

How To Use Google Sheets

0:00 Intro 0:10 Launching Google Sheets 0:43 Creating a spreadsheet 2:06 Importing files 3:13 Columns, rows, and cells 4:43 ...

Spreadsheets #1: Introduction

The basics of creating a spreadsheet in OpenOffice Calc, LibreOffice Calc or Microsoft Excel, including how to format data, create ...

Excel How-To: Starting a Basic Spreadsheet

How-to/tutorial video demonstrating how to create a basic Excel spreadsheet. Spreadsheet features, navigations and terminology ...

Google Sheets Tutorial for Beginners

In this step-by-step tutorial, learn how to use Google Sheets. Google Sheets is completely free to use, and you can use it to get ...

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

Learn how to use VLOOKUP in Excel to quickly and efficiently find values in large datasets. In this video, we cover how to master ...

How to calculate PERCENTAGE in excel? | Percentage Formula #shorts #excel

Learn how to calculate PERCENTAGE in excel? | Percentage Formula #shorts #excel Watch more Excel Videos: ...

Excel Formulas and Functions | Full Course

Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step Microsoft Excel tutorial, learn how to use ...

How to Use Copilot in Excel for Data Analysis

Join 6000+ Busy professionals learning Microsoft 365 Copilot➡️https://learncopilot.ai/masterclass ...

Excel for Beginners - The Complete Course

This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching ...

Excel Tutorial for Beginners | How to Use Excel

Join our bestselling Excel Essentials for the Real World course: ...

How to create a spreadsheet in excel in 5 minutes | excel for beginners

In this video, we'll guide you through creating a simple and effective Excel table from scratch. Learn how to set up your data, insert ...

Excel Tutorial for Beginners

Learn Excel in just 2 hours: https://excel.kevinstratvert.com Are you looking to upskill your Excel game? Look no farther than this ...

Shortcut keys (to select column & row)

Excel vs Google Sheets

They're pretty similar but it feels like this sometimes. If I had to pick one, I'd start with Excel -- it's more universally used, and many ...

Excel Multiplication formula tricks | How to multiply 2 values in Excel #excel #microsoftexcel

Excel Multiplication formula tricks | How to multiply 2 values in Excel #excel #microsoftexcel.

Excel for Beginners - The Complete Course

This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching ...

Excel tricks | #computer #typing #keyboard #asmr #tricks #fasttypingkeyboard

Welcome to GigaTips – your ultimate destination for mastering computer tricks, hacks, and techniques in just a few seconds!

Microsoft Excel Tutorial for Beginners - Full Course

Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google ...

Excel Tutorial for Beginners

Learn Excel in just 2 hours: https://excel.kevinstratvert.com Are you looking to upskill your Excel game? Look no farther than this ...

Excel Formula Hacks | Microsoft excel for beginners

Excel Formulas hack | Microsoft excel for beginners Search keys: excel interview questions excel shortcut keys excel interview ...

Excel Formulas and Functions Tutorial

Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: https://kevinstratvert.thinkific.com ...

Don't Use Vlookup in Excel‼️Instead Use Amazing Function #exceltips #exceltricks #shorts #excel

In this video, you will learn how to use Advance Vlookup in Excel. Wants to Learn EXCEL + AI and Advanced Excel Formulas‼️