Let's Tute
Microsoft Excel Tutorial: Future Value Functions and Pensions
In this Microsoft Excel tutorial, we learn how to use the future value function to calculate the maturity amount of an investment. By inputting the principal amount, interest rate, and compounding period, Excel can quickly calculate the...
Curated Video
Learning Microsoft Power BI - Learning Microsoft Power BI: Course Completed
This video concludes the course. This clip is from the chapter "Report Publishing and the Power BI Service" of the series "Learning Microsoft Power BI".null
Curated Video
The Complete Excel Guide: Beginners to Advanced - Backstage View
Let's see what is the backstage view. This clip is from the chapter "Excel 2019: Introduction" of the series "The Complete Excel Guide: Beginners to Advanced".The upcoming 21 sections for Microsoft Excel 2019 are perfect for those new to...
Curated Video
How to Print The Gridlines in Microsoft Excel
Normally, when you print a sheet from Microsoft Excel, the gridlines are hidden. In this tutorial, I show you how easy it is to not only have the gridlines printed, but also the row and column headers if you want.
Curated Video
Power BI Masterclass - A Quick Introduction to Publishing Reports to the Power BI Service
In this video, let's take a quick introduction to publishing reports to the Power BI Service. This clip is from the chapter "DAX, R, and Gateways" of the series "Power BI Masterclass".In this section, we will be covering DAX, R, and...
Curated Video
Power BI Masterclass - Learning DAX: Advanced Searching in Power BI
In this video, we will be learning DAX to find out advanced searching in Power BI. This clip is from the chapter "DAX, Excel, and More" of the series "Power BI Masterclass".In this section, we will be understanding DAX table calculations...
Curated Video
Alteryx for Beginners - Fuzzy Match Tool
This video explains how to use the Fuzzy Match tool in Alteryx. This clip is from the chapter "Join Tab" of the series "Alteryx for Beginners".This section explores the Join tab.
Curated Video
Alteryx for Beginners - Tile Tool
This video explains how to use the Tile tool in Alteryx. This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.
Let's Tute
Excel Function Shortcut Keys Tutorial
This is a tutorial on function shortcut keys used in Microsoft Excel, aimed at helping users save time and become more efficient. The video covers a range of shortcuts, from opening the Excel help task pane with F1 to using F12 for the...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Font Property
The Range.Font property reveals a Font object complete with its own properties and methods. In this lesson, we explore several ways we can modify a font with VBA -- its name, its size, its bolding, and more! This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - Get Last Row of Data in Worksheet
Daily reports will often have a fluctuating number of rows. In this lesson, we introduce a convenient strategy to identify the last row of data in a sheet --- starting at the bottom of the spreadsheet and navigating upwards. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - Custom Functions
In this lesson, we explore one of VBA's coolest features -- defining public custom functions that appear directly in the Excel interface.We dive into the syntax for declaring the function, identifying its expected arguments, and...
Curated Video
Learning Microsoft Power BI - The Course Overview
This video provides an overview of the entire course. This clip is from the chapter "Project Requirements and Getting Data" of the series "Learning Microsoft Power BI".In this section, we are going to focus on report requirements and...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Order of Operations
Learn about the order of operations. This clip is from the chapter "Excel 2019 Beginner: Creating Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to create a workbook in Excel.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Goal Seeker
The aim of this video is to explore goal seeker. This clip is from the chapter "Excel 2019 Beginners: Additional Excel Features" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll uncover some...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Using Format Painter
The aim of this video is to explore how to use format painter. This clip is from the chapter "Excel 2019 Beginners: Formatting Worksheets" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll learn how...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Mouse Features
Let's explore the mouse features available in Excel. This clip is from the chapter "Excel 2019: Introduction" of the series "The Complete Excel Guide: Beginners to Advanced".The upcoming 21 sections for Microsoft Excel 2019 are perfect...
Curated Video
Calculating Averages in Excel Using Formulas and Autosum Feature
In this tutorial, the teacher demonstrates how to quickly and easily calculate the average of a group of numbers in Excel. By using the simple formula "=average" and highlighting the desired cells, students can efficiently obtain...
Curated Video
Five Ways to Fix #VALUE Errors in Microsoft Excel
In this tutorial I'll show you five different reasons why you may get #VALUE! error messages in Microsoft Excel and how to fix each of them properly.
Packt
Alteryx for Beginners - Case Study - 5
This video presents the fifth case study on appending files from a zip file. This clip is from the chapter "Case Studies" of the series "Alteryx for Beginners".null
Curated Video
Alteryx for Beginners - Filter Tool (Date Example)
This video explains with an example how to use the Filter tool for date data in Alteryx. This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.
Curated Video
Alteryx for Beginners - Getting Data from Comma Separated Value (CSV) Files
This video demonstrates how to get data from CSV files. This clip is from the chapter "In/Out Tab" of the series "Alteryx for Beginners".This section provides an introduction to the In/Out tab in Alteryx.
Curated Video
Excel VBA Programming The Complete Guide - The Parent Property on All Objects
Coming full circle, we navigate from a Range object all to the way to the top of the Excel object model (the Application object) by relying on each object's Parent property. The property returns the object enclosing the current one. This...
Curated Video
Excel VBA Programming The Complete Guide - The String Data Type
A string is a collection of characters --- in layman's terms, it's just text. In this lesson, we take a look at VBA's support for two types of strings -- variable-length and fixed-length -- as well as the advantages of both. This clip is...