Name: How to use Formulas and Functions in Microsoft Excel @TeachersTech
Uploaded: 2026-09-22T08:17:00-05:00
Duration: 8 min 17 s
Description: How to use Formulas and Functions in Microsoft Excel

How to use Formulas and Functions in Microsoft Excel

Teachers Tech 2026-09-22 | How to use Formulas and Functions in Microsoft Excel

How to Calculate Ratios in Microsoft Excel

Teachers Tech 2023-08-14 | In this video, I will show you how to calculate ratios in Microsoft Excel. Learn how to leverage Excel's versatile range of functions and formulas to compute ratios effortlessly. Whether you're comparing student performance, financial metrics, or any other dataset, understanding ratios is a game-changer. I will show you two different methods of calculating ratios in Excel. The first one is using the GCD function and then I will show you how to use the TEXT and SUBSTITUTE functions to get the same results.

0:00 Introduction
0:36 Using the GCD function to calculate a ratio
2:55 How to use the TEXT and SUBSTITUTE Functions for creating ratios

CapCut Crash Course: A Beginners Guide to Mastering the Free Desktop Video Editor

Teachers Tech 2023-07-31 | Welcome to this beginner-friendly CapCut crash course! In this easy-to-follow video tutorial, I'll show you how to use CapCut's free desktop video editor.

Whether you're new to video editing or want to improve your skills, this guide is perfect for you. I'll take you through each step, from downloading CapCut to creating stunning videos.

Download Capcut for Desktop here: capcut.com/tools/desktop-video-editor

Here's what you'll learn:

0:00 Getting Started: I'll help you set up CapCut on your computer and show you around the simple interface.
4:13 Importing and Organizing: Learn how to bring your videos into CapCut and arrange them in the timeline.
6:52 Editing Made Easy: Discover how to cut, trim, and join clips to create a seamless video.
22:11 Adding Audio: Find out how to adjust volume, add music, and use sound effects to enhance your video's sound.
24:23 Text and Transitions: Elevate your videos with stylish captions and transitions.
28:22 Filters and Effects: Make your videos look professional by applying filters and effects.
31:06 Exporting Your Video: Learn how to save and share your finished masterpiece with others.

By the end of this tutorial, you'll have the skills to edit videos like a pro using CapCut. Let's get started on your video editing journey!

From Paper to Digital: Converting Forms to Fillable PDFs with Acrobat Pro

Teachers Tech 2023-07-24 | In this video, I will explore the powerful capabilities of Acrobat Pro in converting forms to fillable PDFs. Converting paper forms to fillable PDFs has never been easier. I'll guide you through the step-by-step process, showcasing the seamless transition from physical documents to interactive digital forms. With Acrobat Pro's intuitive interface and robust features, you'll discover how to transform your paper forms into dynamic PDFs that can be easily filled out and submitted electronically. I'll cover various aspects of the conversion process, including starting from a Microsoft Word file or an image.

I'll cover various aspects of the conversion process. You'll learn how to create form fields, such as text boxes, checkboxes, drop-down menus, and more, ensuring a user-friendly experience for form fillers. I'll demonstrate how to add validation rules, calculations, and formatting options to enhance the functionality and accuracy of your digital forms.

Learn more about Adobe Acrobat Pro here: youtu.be/wdENhL-FxOs

0:00 Introduction
1:03 Opening Adobe Acrobat Pro
2:07 Fillable Form tool
2:33 Preview form
3:36 Editing form fields properties
7:30 Deleting fields and adding checkboxes
9:25 Copy and paste fields
11:00 Testing the form
12:05 Adding a drop-down list
13:30 Saving your form
15:00 Create a from from a Word file or an image

Try Adobe Acrobat Free trial here: adobe.com/ca/acrobat/complete-pdf-solution.html?mv=search&ttid=annual-pro&ef_id=CjwKCAjwtuOlBhBREiwA7agf1ohNe1ioCuyA9XU4NEQvcVMEpCFODCcFK2WLCkUkPT1wls-aV4V8cRoCITgQAvD_BwE:G:s&s_kwcid=AL!3085!3!495139191296!e!!g!!adobe%20acrobat!12198070712!122681202608&gad=1&gclid=CjwKCAjwtuOlBhBREiwA7agf1ohNe1ioCuyA9XU4NEQvcVMEpCFODCcFK2WLCkUkPT1wls-aV4V8cRoCITgQAvD_BwE

Discover the Game-Changing Power of the Insta360 Link Webcam

Teachers Tech 2023-06-24 | I'm excited to show you the game-changing Insta360 Webcam. This cutting-edge camera will elevate your video conferencing and live streaming experiences to new heights. I think this is the best Webcam in 2023.

The Insta360 Webcam is designed with the modern professional in mind. Its sleek and compact design makes it easy to set up and transport, ensuring you're always ready for high-quality video calls, virtual meetings, and content creation on the go.

Check out the Insta360 Link here: insta360.com/sal/link?insrc=INROOH6

With its wide field of view, the Insta360 Webcam captures every detail of your surroundings, providing a stunningly immersive experience for your audience. Whether you're hosting a webinar, collaborating with remote teams, or live streaming your gaming sessions, the Insta360 Webcam delivers crystal-clear video at resolutions up to [insert specific resolution options here].

But it doesn't stop there! The Insta360 Webcam's powerful software takes your video quality to the next level. Customize and fine-tune your visuals with real-time image adjustments, including exposure, color correction, and more. Engage your viewers with virtual camera effects and background removal options, allowing you to choose the perfect backdrop for your video calls or live streams.

Check out the Insta360 Link here: insta360.com/sal/link?insrc=INROOH6

I use Camtasia to record and edit my videos:

Camtasia purchase with 10% OFF code applied:
Use this coupon code: TEACHCAM10
techsmith.z6rjha.net/c/1264585/701976/5161
Camtasia EDU 10% OFF with code applied: techsmith.z6rjha.net/c/1264585/704928/5161

Download Free Trial
Camtasia Download page: techsmith.z6rjha.net/c/1264585/489271/5161

DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for the support!

0:00 Introduction
1:30 Insta360 Link Setup
3:06 Using Insta360 Software
8:19 Using the AI zoom
9:22 Using hand gestures to control the Insta360 Link

How to Add Background Music to your PowerPoint Slides

Teachers Tech 2023-04-03 | In this tutorial, you'll learn how to add background music to your PowerPoint presentation. Adding background music to your PowerPoint presentation can enhance your message and create a more engaging experience for your audience. With just a few simple steps, you can add music that will play continuously throughout your presentation.

First, you'll need to choose the music you want to use. You can select a track from your personal library or download music from a royalty-free site. Once you have your music, you'll need to import it into your PowerPoint presentation.

Next, you'll need to determine which slide you want the music to begin playing on. You can choose to have it start playing on the first slide, or you can set it to start playing on a specific slide.

After that, you'll need to adjust the settings to make sure your music plays continuously throughout your presentation. You can adjust the timing and the volume of the music to fit your presentation.

Finally, you'll want to test your presentation to make sure the music is working properly. You can preview your presentation to ensure the music plays throughout the entire presentation.

In this tutorial, we'll walk you through each step of adding background music to your PowerPoint presentation. By the end of this video, you'll be able to add music to your PowerPoint presentation and take your presentation to the next level.

0:00 Introduction
1:11 Add music to PowerPoint
3:10 Adjusting Audio format
4:02 Adjusting Playback options
4:11 Quickly use the Play in Background button
5:13 Customizing audio options
7:38 Adding bookmarks to your music in PowerPoint
8:25 Editing your music in PowerPoint (trim and fade in/out)

5 Powerful yet Underused Charts in Microsoft Excel for Data Visualization

Teachers Tech 2023-03-13 | In this video, I'll explore five underused but powerful charts in Microsoft Excel that can help you analyze and visualize data in new and insightful ways. I'll start with Sparklines, which are small, data-dense charts that can be easily integrated into the text, tables, or other visualizations. I'll show you how to create Sparklines and use them to identify trends and patterns in data sets. Next, I'll look at Heatmaps, which are visual representations of data that use color coding to highlight patterns and trends. I'll show you how to create Heatmaps and use them to analyze large data sets and identify areas of focus. Then, we'll explore Gauge charts, which are ideal for displaying a single metric and comparing it to a target or benchmark. I'll show you how to create Gauge charts and use them to track progress toward business goals. After that, I'll dive into Waterfall charts, which are great for showing how different factors contribute to a total value. I'll show you how to create Waterfall charts and use them to analyze financial data, sales figures, and other complex data sets. Finally, we'll wrap up with Funnel charts, which are useful for tracking the progress of a process, such as a sales funnel or a marketing campaign. I'll show you how to create Funnel charts and use them to identify areas where you can improve efficiency and increase conversions. By the end of this video, you'll better understand these five powerful charts in Microsoft Excel and how you can use them to analyze and visualize data in new and insightful ways.

0:00 Introduction
0:42 How to use Sparklines in Excel
3:01 How to make a heatmap in Excel
5:36 How to make a gauge chart (speedometer) in excel
13:23 How to use the waterfall chart
14:51 How to use the funnel chart in Microsoft Excel

Download the practice worksheet: bit.ly/powerfulcharts

How to Reduce Video File Size with Without Compromising Video Quality: Handbrake Tutorial

Teachers Tech 2023-03-06 | Are you tired of dealing with huge video files that take up too much space on your computer or device? Look no further! In this tutorial, I'll show you how to reduce video file size with Handbrake without compromising video quality.

Handbrake is a free, open-source video transcoding tool that allows you to compress your videos without sacrificing quality. With a few simple steps, you can significantly reduce the file size of your videos while maintaining their clarity and crispness.

I'll walk you through the entire process, from downloading and installing Handbrake to adjusting the video settings and optimizing the compression. You'll learn how to tweak the bitrate, resolution, and other settings to get the best balance of size and quality for your needs.

Whether you're a content creator looking to upload videos faster or just someone looking to save storage space on your device, this tutorial will give you the skills to reduce video file size with Handbrake like a pro. Don't miss out on this essential tool for video compression – watch now and start shrinking those files!

0:00 Introduction
0:32 Download and install Handbrake
1:20 Select a source for Handbrake to compress
3:35 Select a preset for compression
5:50 Preview a quick clip of your compressed video
6:20 Make modifications to your settings
10:45 Start encoding
11:45 Save your modifications as a preset

📝Best Free PDF Editors: Edit Text and More Without Breaking the Bank 🏦

Teachers Tech 2023-02-27 | Are you tired of expensive PDF editing software that drains your wallet? Look no further than these FREE PDF editors that can help you edit text, images, and more without spending a penny.

In this video, I'll explore some options for PDF editors and show you how to use them for various editing tasks. These FREE pdf editors can do text editing to more advanced functions like form filling, annotation, and document merging. Whether you're a student, professional, or simply someone who needs to edit PDFs from time to time, you'll find something useful in this video.

So sit back, grab a cup of coffee, and learn about these amazing free PDF editors that can help you get the job done without breaking the bank. Don't forget to like and subscribe for more tech tutorials, and let us know in the comments which editor is your favorite!

Check out these videos on how to edit PDFs.

Microsoft Word to edit Pdfs: youtu.be/3FSy7ydccfY
Adobe Acrobat Pro: youtu.be/wdENhL-FxOs

0:00 Intro
0:31 Adobe Express to edit PDFs for FREE- adobe.com/express
3:16 Canva to edit PDFS for FREE - canva.com
4:45 Sedja FREE Online PDF Editor sejda.com/pdf-editor
6:21 Libre Draw to edit PDFs for Free libreoffice.org

How to Create AI Generated Images from Text with MidJourney - Beginners Tutorial

Teachers Tech 2023-02-20 | Learn how to easily create images from text using MidJourney with this beginner-friendly video tutorial. With MidJourney, you can turn your ideas into visuals in just a few simple steps. By typing in a description, you can generate up to four images that accurately represent the text.

In this tutorial, you'll be guided through seven easy steps to get started with MidJourney and create stunning visuals from text descriptions. So, whether you're a student, researcher, or creative professional, this tutorial will show you how to leverage the power of MidJourney to create beautiful and meaningful images in no time.

Check out my ChatGPT beginners tutorial: youtu.be/Y6cp89S6W8M

0:00 Intro
1:04 Step 1 Join the MidJourney Discord
2:58 Step 2 Find the Newbies Channel
3:28 Step 3 Use the /imagine Command
4:03 Step 4 Process the job
4:40 Step 5 Find your AI-generated image and Upscale or Make a slight variation
6:17 Step 6 Make variations, view on the web, rate
6:48 Step 7 - Save your image

Community Guidelines for Midjourney docs.midjourney.com/docs/community-guidelines

ChatGPT 101 for Teachers: A Beginners Tutorial

Teachers Tech 2023-02-12 | In this video, we will take you through the basics of ChatGPT, the powerful AI language model developed by OpenAI. If you are a teacher looking to bring the latest technology into your classroom or want to know how your students might be already using ChatGPT, this beginner's tutorial is for you! We'll show you how to get started with ChatGPT, how to use it to engage and educate your students, and give you tips and tricks to help you make the most of this amazing tool. From understanding the basics of natural language processing to exploring the endless possibilities of ChatGPT, this video is your one-stop shop for all things ChatGPT. Whether you're a seasoned tech-savvy teacher or just starting to explore the world of AI, this video is the perfect starting point. So sit back, relax, and let's dive into the exciting world of ChatGPT!

OpenAI Link: openai.com
How to create AI-Generated Images form Text with MidJourney: youtu.be/6ezYNvSnQLM

0:00 Intro
0:50 Creating your ChatGPT account
2:50 How to use ChatGPT to write an essay
3:36 Change the tone and add citations to your essay
5:00 Write a children's story with ChatGPT
5:55 Rewrite a story as a nursery rhyme, then change the language
7:02 Examples of how to use ChatGPT
9:00 More complex examples of ChatGPT
12:10 Get ChatGPT to write code
12:36 ChatGPT (AI) detectors
14:00 How to beat AI detectors
16:45 Another AI detector to test

AI Detectors Websites:
GPTZERO: gptzero.me
Hive Moderatio: hivemoderation.com/ai-generated-content-detection

I made reference to these videos
Success with AI: youtube.com/watch?v=Xgc-d7SO4OQ
Dr. Alex Young: youtube.com/watch?v=HGDxu3kPErs

Prompt to use to try and beat AI detectors:

Step 1

I will give you some information before asking you to write an article. Do you understand?

Step 2

When it comes to writing content, two factors are crucial, "perplexity" and "burstiness." Perplexity measures the complexity of the text. Separately, burstiness compares the variations of sentences. Humans tend to write with greater burstiness, for example, with some longer or more complex sentences alongside shorter ones. AI sentences tend to be more uniform. Therefore, when writing the following content I am going to ask you to create, I need it to have a good amount of perplexity and burstiness. Do you understand?

Step 3

Using the concepts written previously, rewrite this article with a high degree of perplexity and burstiness

Make Teaching Easier in 2023: Find out the Top Productivity Apps!

Teachers Tech 2023-02-05 | In this video, we'll be exploring the top productivity apps for teachers. With the ever-increasing demands on teachers' time and attention, having the right tools can make a big difference in staying organized and efficient. From task management to lesson planning and communication, we'll be showcasing the most popular and highly rated apps to help streamline a teacher's workload. Whether you're a seasoned educator or new to the profession, you won't want to miss this rundown of the best productivity apps for teachers.

Francesco from Keep Productive has put together a great list of tools for teachers to use! Check out his channel.
Keep Productive YouTube Channel: youtube.com/@keepproductive

5 Amazing Google Docs Hacks!

Teachers Tech 2023-02-01 | In this Google Docs video, I want to show unknown or underused tips and tricks. These advanced tips will help you get more out of Google Docs.

0:00 Intro
0:10 Separate images from text
1:24 Force a copy of a document
2:46 Edit a PDF in Google Docs
3:46 Voice typing and all of the commands
6:27 Don't forget to add headings!

I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN
10% off - Apply this coupon code at checkout as the promo code: TEACHCAM10

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. I appreciate your support!

How to Record your Computer Screen for FREE

Teachers Tech 2023-01-23 | Looking for a reliable and free screen recorder? Look no further! In this video, we will be discussing the top 5 screen recorders that won't cost you a cent. These screen recorders will get the job done if you need to create a tutorial, record a presentation, or capture gameplay.

First on the list is Apowersoft Free Online Screen Recorder, a web-based screen recorder that requires no installation and allows you to record your screen with just a few clicks.

Next up is Loom, a user-friendly screen recorder that allows you to capture and share your screen with just a few clicks.

We'll also be discussing ShareX, a screen recording tool that offers a range of features, including screen recording, screenshot capture, and file sharing.

In addition, we'll cover Clipchamp, a web-based screen recorder that allows you to record your screen and webcam simultaneously and offers editing features like trimming and cropping.

Last but not least, we'll be discussing OBS Studio, a powerful open-source software that offers live streaming and video recording capabilities.

Whether you're a content creator, educator, or gamer, these top 5 screen recorders have got you covered. So, sit back, relax, and discover the best free screen recorders available!

0:00 Intro
1:26 Apowersoft apowersoft.com/free-online-screen-recorder
5:05 Loom loom.com
8:14 ShareX getsharex.com
11:39 Microsoft Clipchamp clipchamp.com
14:53 OBS Studio obsproject.com

How to use Clipchamp as a Screen Recorder: youtu.be/22ZUGZ5tbmA
How to use Clipchamp video editor: youtu.be/Kf_14bvASxY
How to record our computer screen with OBS Studio: youtu.be/gdqOXl6lFB0

I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN
10% off - Apply this coupon code at checkout as the promo code: TEACHCAM10

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. I appreciate your support!

How to Record Your Computer Screen and Make AMAZING Videos with Microsofts Clipchamp

Teachers Tech 2022-12-21 | In this video tutorial, I will show you how to record your screen and webcam for free with Microsoft's Clipchamp. If you are on Windows 10 or Windows 11, you can install Clipchamp, but you can also use it online. Not only record, but you can also edit your videos. Quickly make changes by dragging and dropping filters such as green screen.

How to use Clipchamp for beginners: youtu.be/Kf_14bvASxY

0:00 Introduction
1:40 Record your screen (setup)
4:44 Edit your recordings in Clipchamp
5:41 Transform your recordings clips (size & crop)
6:32 Add the green screen effect
8:47 Add captions to your videos
9:45 Export your finished video

I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. I appreciate your support!

How to use Microsofts FREE Video Editor - Clipchamp Beginners Tutorial

Teachers Tech 2022-12-19 | In this video, I will show you how to use Microsoft’s free video editor Clipchamp. Are you looking for a user-friendly video editing platform that allows you to create and edit videos online? Look no further than Clipchamp! Owned by Microsoft, Clipchamp is a free video editing platform that you can use without a watermark. You can download it from the Microsoft Store, use it on Windows 10 or 11, or use it online.

In this tutorial, we'll show you how to use Clipchamp to create and edit videos like a pro, even if you're a beginner.

We'll start by walking you through the basics of the Clipchamp interface, including how to create a new project, import your video footage, and use the editing tools to trim, cut, crop, and adjust your clips. You'll also learn how to add text, filters, and effects to your videos to make them more engaging and professional-looking.

Next, we'll cover more advanced features, such as adding music and sound effects to your videos and using Clipchamp's built-in templates and stock footage to speed up your video creation process. We'll also show you how to export your finished videos in various formats, so you can easily share them on social media or your website.

Whether you're a content creator, marketer, or just someone who wants to make fun and engaging videos, Clipchamp has everything you need to bring your ideas to life. So why wait? Join us in this tutorial and start creating amazing videos with Clipchamp today!

Record and Create Amazing Videos with Clipchamp: youtu.be/22ZUGZ5tbmA

0:00 Introduction
1:00 Installing Clipchamp on your Windows computer
1:30 Using Clipchamp online
2:15 Create a new video
3:20 Import media (Videos, Images, Audio)
7:00 Clipchamp layout
8:16 Set aspect ratio
9:33 Bringing media to the timeline
12:59 Editing a video, image or audio clip clip in Clipchamp
16:04 Add text to your video
17:30 Add transitions to your video
18:10 Adding graphics
19:10 Adding effects ( Filters, Color Adjustments, Speed)
22:27 Transforming Video Clips in Clipchamp
25:50 Using the green screen effect
28:20 Exporting your finished video

Download free videos at Pixabay: pixabay.com

I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. I appreciate your support!

How to use Microsoft Edge as a PDF editor

Teachers Tech 2022-12-15 | Did you know you could use Microsoft Edge as a FREE basic PDF editor? It may be basic, but it's a nice free option to markup PDFs. In this short video, I will show you how quickly you can start editing PDFs with Microsoft Edge. Use Microsoft Edge to read aloud the pdf, add text, draw, highlight, and more.

How to use Adobe Acrobat Pro - Beginners Tutorial

Teachers Tech 2022-12-12 | Are you new to Adobe Acrobat DC Pro? In this tutorial, I'll guide you through the process of editing, creating, signing, and sharing PDFs using Adobe Acrobat Pro. With the power of Adobe Acrobat Pro, you can easily convert photos into editable PDFs, edit text and images, add new content, and sign documents using your e-signature.

Whether you want to delete a blank page, change the order of pages, or combine PDF files into one, Adobe Acrobat Pro has got you covered. With its user-friendly interface, you can easily perform these tasks in a snap.

So, if you want to take your PDF editing game to the next level, be sure to watch this beginner's guide to Adobe Acrobat DC Pro. Don't forget to hit the like and subscribe button for more useful tutorials!

Learn how to make a fillable form with Adobe Acrobat Pro: youtu.be/xyZgA5yu2ok

0:00 Introduction
1:07 Sign in to Adobe Acrobat
1:32 Layout
2:19 Create a PDF from an image
3:18 Editing images in Adobe Acrobat Pro
7:17 Load and edit a scanned PDF from your phone
8:51 Change page display
9:43 How to edit the text in Adobe Acrobat Pro
10:26 How to add text to a pdf document
10:52 How to add an image to a pdf document
12:15 Edit images in a pdf document
12:52 Add links to your pdf document
14:24 How to add a watermark to your document
15:22 Organize or combine pdfs in Adobe Acrobat Pro
18:30 Export your pdf as a Word document, Spreadsheet, Image, or more
18:49 Share or work with others in Adobe Acrobat Pro
19:45 How to fill and sign in Adobe Acrobat Pro
20:47 Create and save your e-signature

Adobe Acrobat Website: adobe.com/ca/acrobat/acrobat-pro.html

How to use Power Pivot in Excel - Intermediate Microsoft Excel Tutorial

Teachers Tech 2022-12-05 | In this Intermediate Microsoft Excel tutorial, I will show you how to use Power Pivot in Microsoft Excel. In this tutorial, we'll cover the basics of Power Pivot, a powerful data analysis tool built into Microsoft Excel. We'll start with an overview of Power Pivot and its benefits, then move on to practical steps for importing and organizing data. From there, we'll cover how to create relationships between tables and use advanced calculations to manipulate and analyze your data. Finally, we'll demonstrate how to create interactive PivotTables and PivotCharts that allow you to visualize your data in powerful new ways.

Whether you're a data analyst, business owner, or just looking to improve your Excel skills, Power Pivot can help you streamline your data analysis and gain deeper insights into your information. With this beginner's guide, you'll have everything you need to get started with Power Pivot and take your data analysis to the next level.

Don't forget to like and subscribe for more Excel tutorials, and let us know in the comments if there are any other topics you'd like us to cover!

Student and School practice: bit.ly/Student_School_Practice_Files
Tuition Fees practice: bit.ly/TuitionFees_Practice_File

0:00 Introduction to Power Pivot
1:43 How to install Power Pivot in Excel
2:51 Ways to bring data into Power Pivot
9:08 How to create relationships in Power Pivot (Diagram View)
14:46 How to create column calculation in Power Pivot
20:44 Different ways to add Measure in Power Pivot (more calculations)
28:02 Build a report with a Pivot Table in Power Pivot
32:20 Add a KPI (Key Performance Indicator) to your Pivot Table
34:49 Create a Pivot Chart with your data model

Intermediate Lesson 1 (Pivot Tables and Functions): youtu.be/PqczHnsNFdM
Intermediate Lesson 2 (Power Query): youtu.be/MHIV0bYryiw

Automatically Remove all Hyperlinks in Microsoft Word with VBA

Teachers Tech 2022-11-30 | In this video tutorial, I will show you how to remove all links in a Microsoft Word document in a single click. Rather than removing the hyperlinks one by one, you will quickly use VBA to add two short lines of code to perform this. Run the macro and the links are gone. Save this Macro and add it as a shortcut to quickly run it anytime you need it.

Practice file download: bit.ly/RemoveLinks

Copy paste the following code:
Selection.WholesStory
Selection.Fields.Unlink

More word tutorials: youtube.com/playlist?list=PLmkaw6oRnRv9-nqM7qW2aWkaKU6SfersL

How to use Power Query - Intermediate Microsoft Excel Tutorial

Teachers Tech 2022-11-28 | This intermediate Microsoft Excel tutorial focuses on learning Power Query. In this step-by-step Excel Power Query tutorial, we'll show you how to use Microsoft Excel's powerful data transformation tool. Power Query can help you quickly clean, consolidate, and analyze data from multiple sources.

If you're new to Power Query, this tutorial is perfect for you. We'll start with an introduction to the Power Query interface and walk you through connecting to various data sources such as Excel files, text files, and databases. We'll then demonstrate how to use Power Query's features, such as merging, filtering, and pivoting, to transform and refine your data.

This tutorial provides easy-to-follow instructions, so you can practice using Power Query along with us. By the end of this video, you'll have a solid understanding of Power Query and how to use it to streamline your data analysis.

Watch this Excel Power Query tutorial for beginners and start taking your data analysis to the next level. Don't forget to hit the like button and subscribe to our channel for more Excel tutorials!

Power Query Practice File: bit.ly/Power_Query_Practice_Data

0:00 Introduction to Power Query in Excel
0:45 What is Power Query?
2:34 Where do you find Power Query?
3:05 How to import data from the web with Power Query
8:40 How to import data from a range or table in Power Query
9:50 Power Query Editor layout
14:25 Make changes to your headers
16:42 Examining the applied steps
17:06 How to convert data types in the Power Query Editor
18:36 Remove unwanted rows (filtering)
20:39 How to split columns in Power Query
22:45 Create a new column
24:33 Create a new column to find a value
28:33 Rounding and moving column
29:39 How to merge queries and join tables in Power Query
34:21 Add new data, then refresh your query

Intermediate Excel Lesson 1: youtu.be/PqczHnsNFdM
Learn how to use Power Query in Power BI: youtu.be/hehYMb9kobw

Look Up Values with INDEX and MATCH functions in Microsoft Excel

Teachers Tech 2022-11-22 | Looking to master Microsoft Excel's Index and Match functions? Look no further! In this lesson, I will show you how to use the INDEX and MATCH functions in Microsoft Excel.

In this video, we'll dive deep into these two powerful functions, exploring everything from their basic syntax to their more advanced capabilities. Whether you're a beginner looking to learn the ropes or a seasoned Excel pro looking to take your skills to the next level, this video is for you.

We'll start with an overview of both functions, discussing their similarities and differences and highlighting some common use cases for each. From there, we'll move into more specific examples, walking you through the steps required to use Index and Match to perform tasks like looking up values in a table, creating dynamic charts, and even performing more advanced data analysis.

Throughout the video, we'll provide clear, concise explanations and easy-to-follow demonstrations, making it simple for you to follow along and start putting these functions to work in your own spreadsheets. And as an added bonus, we'll also provide some tips and tricks for optimizing your use of Index and Match, helping you save time and improve your efficiency.

So if you're ready to take your Excel skills to the next level, click play, and let's get started!

Download Practice File: bit.ly/index_match_practice

0:00 Introduction
1:09 Create a dropdown list
2:31 How to use the MATCH function in Excel
4:47 How to use the INDEX function in Excel
6:47 How to nest the MATCH function in the INDEX function in Excel

Try out the XLOOKUP function: youtu.be/tPaXEZRh9_k
Drop-downs with XLOOIP: youtu.be/fjn4vlWwpCo

How to Create a Bell Curve In Microsoft Excel

Teachers Tech 2022-11-21 | In this lesson, I will show you how to create a bell curve using Microsoft Excel. We need to find the mean, standard deviation, and normal distribution to create the bell curve. The functions in Microsoft Excel needed to do this are AVERAGE, STDEV.P, and NORM.DIST After you have calculated all of this you are then able to insert a scatter chart to display as a bell curve.

Download the practice file: bit.ly/bellcurvedata

0:00 Intro
0:26 Sort your data
1:15 Calculate the Mean (AVERAGE)
1:57 Calculate the Standard Deviation in Microsoft Excel
2:47 Calculate the Normal Distribution in Excel
5:07 Create your Bell Curve with a Scatter Chart

Create Graphs and Charts in Excel: youtu.be/64DSXejsYbo

How to use Adobe Express - Beginners Tutorial

Teachers Tech 2022-10-31 | In this video tutorial, I will show you how to use Adobe Express. Use Adobe Express for many things such as creating professional-looking graphics, slideshows, and presentations. You can still do a lot more with Adobe Express such as edit images, videos, and PDF documents. If you need to create a QR code, no problem. In Adobe express you can create a QR code in seconds.

Adobe Express: adobe.com/express

0:00 Introduction
1:27 Adobe Express layout
3:17 Creating a poster from a template in Adobe Express
3:51 Edit and Customizing your graphic
9:43 Adding an image and removing the background in Adobe Express
11:05 How to share your graphics
11:50 Saving and accessing your projects
12:43 How to make a slideshow in Adobe Express
16:30 Adding your voice to the slideshow
19:52 Quickly make a presentation using Adobe Express
22:55 Add a Gridshow to your presentation
24:02 How to edit images, videos, and PDFs in Adobe Express
25:31 Create a QR code with Adobe Express

How to Write Without a Keyboard in Microsoft Word - Dictation and Editing with your Voice

Teachers Tech 2022-10-26 | In this tutorial, I want to show you how to write without using a keyboard. Using dictate in Microsoft Word allows you to use your voice to type and format your document. There are several commands to know to get the most out of speech-to-text in Microsoft Word.

0:00 Introduction
1:26 Get your settings correct. Pick a language
2:39 Tips for voice typing
3:44 Punctuation commands
4:58 Editing your document with your voice
5:41 Formatting a word document with your voice
6:53 Add a list with your voice
7:10 Add symbols to your document with your voice
7:38 You can even add emojis with your voice

More Microsoft Word tutorials here: youtube.com/playlist?list=PLmkaw6oRnRv9-nqM7qW2aWkaKU6SfersL

How to Transform Excel Data into a Striking Visual Report with Microsoft Power BI

Teachers Tech 2022-10-24 | Welcome to this beginner's tutorial on how to use Microsoft Power BI! In this video, I will guide you through importing data from an Excel workbook into Power BI. Power BI is a powerful data visualization tool that allows you to easily create stunning, interactive reports.

First, I will walk you through how to import your Excel workbook into Power BI. We will show you how to connect to your workbook, select the data you want to import and bring it into Power BI. Once you have your data in Power BI, we will then demonstrate how to create visually appealing and interactive reports. I'll explore the different visualization options available in Power BI, including tables, charts, and graphs, and show you how to customize them to fit your needs.

I will also cover some of the essential features in Power BI, such as filtering, grouping, and sorting your data. I'll explain how to create relationships between different tables in your data, which is crucial to building accurate and useful reports.

By the end of this tutorial, you'll have a solid understanding of how to use Power BI and create reports that are visually impressive and provide valuable insights into your data. So if you're new to Power BI or just want to brush up on your skills, this tutorial is for you!

Download Power BI here: powerbi.microsoft.com/en-us/desktop
Download Excel Practice Data: bit.ly/PowerBI_practice_data

0:00 Introduction to Power BI
1:06 Get data into Power BI
2:25 Transform data
3:01 Making changes to columns in Power BI
6:30 Examining the fields in Power BI
7:00 New Measure - Write Dax Expression - Total Units Sold = SUM(financials[Units Sold])
9:10 New Table - Write Dax Expression - Calendar = CALENDAR(DATE(2020,01,01),Date(2021,12,31))
10:10 Create a relationship between two tables in Power BI
11:22 Add a title in a text box in Power BI
12:27 Add visual first visual, modify it to a line chart
14:32 Add a map chart in Power BI
16:17 Add a column chart
17:24 Filter data more by adding a slicer visual in Power BI
19:10 Customizing your report. Making it look fantastic!
27:57 Changing themes in Power BI
28:37 Sharing your Power BI report with others

Copy and paste these expressions:
Total Units Sold = SUM(financials[Units Sold])
Calendar = CALENDAR(DATE(2020,01,01),Date(2021,12,31))

How to Send Customized Bulk Emails with Mail Merge in Google Sheets and Gmail

Teachers Tech 2022-10-19 | Send personalized bulk emails using Mail Merge in Google Sheets and Gmail. I'll go through the step-by-step process of setting up Mail Merge and sending out messages from your list in Google Sheets. You create a Gmail draft template with placeholders that correspond to data in a Google Sheets spreadsheet.

Google Apps Script link: developers.google.com/apps-script/samples/automations/mail-merge

0:00 Introduction
1:00 Make of copy of Google Sheets with Mail Merge
1:38 Customize your fields (columns) in Google Sheets
4:30 Create your draft email in Gmail with field names
8:55 Initialize and Run Mail Merge from Google Sheets
12:20 Quota for Google Services

Beginner's Google Sheets Tutorial: youtu.be/G93P4DxryVE
Gmail Tutorial: youtu.be/6E2JxZ2vKPk

Beginners Google Sheets Tutorial - Lesson 1

Teachers Tech 2022-10-17 | Welcome to the first lesson in our series of Google Sheets tutorials for beginners! In this video, we'll cover the basics of using Google Sheets to create and edit spreadsheets.

We'll start by showing you how to create a new spreadsheet, including how to choose a template and customize the layout to suit your needs. Then, we'll walk you through entering and editing data in your spreadsheet, including how to format your cells and use basic formulas and functions to perform calculations.

Next, we'll cover some more advanced features, such as conditional formatting and sorting, that can help you analyze your data more effectively. We'll also show you how to collaborate with others on your spreadsheet, whether you're working with a team or sharing data with a client.

By the end of this lesson, you'll have a solid understanding of the basics of using Google Sheets. In future lessons, we'll dive deeper into more advanced features, such as pivot tables and macros, to help you take your spreadsheet skills to the next level.

So if you're new to Google Sheets and want to learn how to use it to organize your data and stay productive, this is the perfect place to start. Join us for Lesson 1, and let's get started!

Make of copy of the practice material: bit.ly/GoogleSheetsPracticeData
Learn more about Formulas and Functions: youtu.be/BTGkj9ocN40
How to use Google Drive: Creating basic formulas in Google Sheets

0:00 Introduction to Google Sheets
1:25 Opening and navigating your Google Sheets
4:30 Creating a new blank spreadsheet in Google Sheets
6:19 Google Sheet layout
7:07 Rows, columns, ranges, and sheets in Google Sheets
10:28 Adding some data to your spreadsheet
12:40 Creating and formatting column widths and row height
15:21 How to format your sheet in Google Sheets
20:13 Adding borders and colors
21:29 Formatting for currency and decimal places in Google Sheets
22:30 Creating basic formulas in Google Sheets
30:23 Freeze rows or columns in Google Sheets
31:58 Basic Google Sheet functions
35:28 How to add a chart in Google Sheets
38:53 How to print your spreadsheet in Google Sheets
40:55 Download your spreadsheet as a PDF or Excel file
41:35 Sharing your spreadsheet with other

Intermediate Microsoft Excel Tutorial - Lesson 1

Teachers Tech 2022-10-10 | Welcome to my intermediate Microsoft Excel Lesson 1 tutorial video! This video will cover some essential Excel functions and tips that will take your spreadsheet skills to the next level. I'll go over Pivot Tables and Pivot Charts, demonstrate how to use the VLOOKUP function with some useful tips and tricks, and show you how to make multiple dependent drop-down lists.

Additionally, I'll show you how to use the UNIQUE function to easily extract unique values from a dataset, add data validation to a cell to control user input, and use a nested FILTER function with the UNIQUE function to manipulate and filter data with precision.

Whether you're a student, a professional, or just someone looking to enhance your Excel skills, this video is perfect for you. With our step-by-step instructions and practical examples, you'll be able to apply these techniques to your own spreadsheets and improve your data analysis and visualization skills.

So, if you're ready to take your Excel game to the next level, be sure to watch this tutorial and learn from the best. And don't forget to like, share, and subscribe to our channel for more exciting Excel tutorials!

0:00 Introduction
1:12 How to create a PivotTable from range or table
2:16 Recommended PivotTable
3:01 PivotTable from range or table
3:55 Add PivotTable fields to report
4:50 Change PivotTable fields layout
7:20 Sort columns or rows in PivotTable
8:58 Add filter fields
9:59 Create a report on a new tab for each employee
11:51 PivotTable tips and tricks
15:43 Add a PivotChart
19:02 How to use the VLOOKUP Function in Excel
27:42 How to make multiple dependent drop-down lists in Excel
29:42 Using the UNIQUE Function
30:40 Adding data validation to a cell (drop-down list)
32:03 Using a nested FILTER function with the UNIQUE function
35:58 Using VLOOKUP to get the final result

Practice Sheet PivotTables: bit.ly/PivotTable_data
Practice Sheet VLOOKUP: bit.ly/VLOOOKUP_data
Practice Sheet Multiple Dependant Drop-downs: bit.ly/Drop-Down_list

Intermediate Lesson 2 - How to use Power Query: youtu.be/MHIV0bYryiw
Intermediate Lesson 3 - How to use Power Pivot: youtu.be/kyGhgreDNUQ

How to use the XLOOKUP Function: youtu.be/tPaXEZRh9_k
Drop-down lists with XLOOKUP: youtu.be/fjn4vlWwpCo
Drop-down with the INDIRECT function: youtu.be/oYF162_Cmwc
Excel beginners video tutorials: youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw

Function Lessons in Excel: youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST

How to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial

Teachers Tech 2022-10-03 | This video tutorial will show you how to use XLOOKUP in Microsoft Excel. The XLOOKUP Function can replace the VLOOKUP and HLOOKUP functions in Microsoft Excel. In this tutorial, I will show you why to XLOOKUP and give you 5 examples to see it in action. From a simple exact match to nested XLOOKUPs with the SUM function.

0:00 Introduction
0:50 Why use XLOOKUP in Microsoft Excel
1:38 Find exact match with XLOOKUP
3:35 Find multiple items with XLOOKUP
6:56 Add more arguments to XLOOKUP function
9:46 Used nested XLOOKUP to perform vertical and horizontal match (replace HLOOKUP)
13:54 Use the SUM function with nested XLOOKUP

Practice Worksheets: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ETexIkRWki9MvFe5rH9BvbABnAt6JX160CzkVqeeVYq-5Q?e=bvPc9E

How to use Padlet - Beginners Tutorial

Teachers Tech 2022-09-25 | This video will guide you through the basics of using Padlet, a versatile online tool for collaboration, organization, and brainstorming. Whether you are a student, teacher, or professional, Padlet can help you create interactive and engaging digital content in a few easy steps.

First, we will show you how to create a new Padlet board, customize its appearance, and choose a layout that suits your needs. Then, we will explain how to add different types of content to your Padlet, such as text, images, videos, links, and files. You will learn how to move, resize, and delete items on your board and arrange them in a meaningful way.

Next, we will demonstrate how to collaborate with others on your Padlet board by inviting them to view or edit your content and by using features like comments, likes, and reactions. You will see how Padlet can facilitate group projects, brainstorming sessions, and feedback collection.

Finally, we will discuss some advanced features of Padlet, such as integrations with other apps, privacy settings, and sharing options. You will also get some tips and tricks to make the most out of your Padlet experience.

Whether you are a Padlet beginner or just looking to refresh your skills, this video will give you a comprehensive overview of the tool and its possibilities. Join us and start creating your own Padlet boards today!

0:00 Intro
1:35 How to sign up for Padlet
2:49 How to make a Padlet
5:55 3 Different ways to add posts to your Padlet
10:40 How to share your Padlet with others
12:38 Navigating Padlet
13:56 Using the Padlet gallery
14:47 Creating a timeline or map Padlet

Relative vs Absolute Cell Reference in Microsoft Excel - Whats the difference?

Teachers Tech 2022-09-12 | How to use absolute & relative cell references in Microsoft Excel. Ever wonder what the difference between relative and absolute cell references in Microsoft Excel is? In this video tutorial, I will show why you would want to use each of these. Also, I will show you how to use the F4 key to quickly change through the different cell references.

Link to worksheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ETnkgM0t-GFBvCbokriTG9kBvnOvjHOOg32gNYsw5Zs9Dw?e=LH5STk

How to Make Presentations and More with Microsoft Sway - Beginners Tutorial

Teachers Tech 2022-09-07 | Welcome to my comprehensive beginner's guide to Microsoft Sway! If you're looking to learn how to create engaging and visually stunning presentations, reports, and newsletters, then you've come to the right place. In this tutorial, I'll take you through the essentials of using Microsoft Sway, a digital tool that allows you to create and share interactive content.

Throughout this video, we'll cover everything from accessing Sway and customizing your design to adding different types of content, formatting, arranging your presentation, and collaborating with others. We'll also provide some essential tips and tricks to make your Sways more interactive and engaging for your audience.

As a student, educator, or business professional, Microsoft Sway can be an excellent tool to help you elevate your digital storytelling skills. With Sway's built-in design features and user-friendly interface, you can quickly and easily create presentations that captivate and engage your viewers.

By the end of this tutorial, you'll have a solid understanding of how to use Microsoft Sway and all the tips and tricks you need to create visually stunning presentations. So, whether you're a seasoned professional or just starting with Sway, let's dive in and learn together.

Access Microsoft Sway here: sway.office.com

Sway I made in the lesson: sway.office.com/XALDzka3qkDnXaNf?ref=Link

0:00 Intro
1:10 Where do you find Microsoft Sway?
2:45 Start a new blank Sway
3:15 Add a title to your Sway
4:00 Add an image to your title card
5:29 Play your Sway
5:44 Navigate back to all of your Sways
6:03 Add more content (Headings, Text & Images)
7:21 View in Design mode
7:40 Experiment with styles (Layouts, color, fonts)
8:40 Add more cards to your Microsoft Sway
9:55 Add a video to your Sway
10:59 Changing the order of your cards (content)
12:05 Add a group of images
14:08 Hitting play and other navigation
14:35 Sharing with others
15:48 Sway settings (export as a word document)
16:50 Start a Sway from a topic
17:34 Start a Sway from a document
18:30 View your Sway analytics

Combine Text and Numbers into One Cell in Excel

Teachers Tech 2022-09-05 | In this Microsoft Excel lesson, I will show you how to combine text and numbers in different cells into one cell and keep the number formatting. Using the ampersand(&) in Microsoft Excel allows you easily combine cells into one. Using the TEXT function with custom formatting in the equation allows you to add formatting to the number.

0:00 Intro
0:36 Combining cells using the ampersand sign in Microsoft Excel
1:15 Adding spaces, symbols, or more text to the combined data
3:36 Coping number format into TEXT function
5:35 Customizing number format by adding text
8:05 Copy the number format from another cell into your TEXT function

More ways to combine cells in Microsoft Excel: youtu.be/fgFzb5b7GlU
Different ways to split cells in Microsoft Excel: youtu.be/nm9z1AdudCM

Quickly Remove Blanks and Duplicates in Microsoft Excel

Teachers Tech 2022-08-29 | In this Microsoft Excel tutorial, I will show you how to remove blank rows, cells, and duplicates. This method with Go to Special and the Remove Duplicates under the Data tab in Microsoft Excel will save you a lot of time.

0:00 Introduction
0:14 Remove blank rows from an Excel spreadsheet
1:58 Replace blank cells in Excel with a numerical value or letters
3:18 Remove duplicate entries from Microsoft Excel

How to Make a Group Email in Gmail - Two Methods

Teachers Tech 2022-08-24 | In this Gmail tutorial, I will show you two ways to make a group email. Creating a group for email will save you time when sending messages to a group of people. The first way is to go to Contacts and either add new contacts or use existing contacts and add them to a label. The second way is to use Google Groups to create a new group and add members. When you create the group, a new email address is created for the group.

0:00 Intro
0:45 How to use Contacts to create a label
2:50 Sending email with contacts label (normal and Bcc)
4:35 Opening Google Groups to create an email group
6:08 Creating a new group
8:26 Adding members and editing your group
10:25 Start a conversation in Google Groups
11:29 Use the Google Groups email to send messages from Gmail

I use Camtasia to create my video tutorials:

Use this coupon code: TEACHCAM10
Camtasia purchase with 10% OFF code applied: techsmith.z6rjha.net/c/1264585/701976/5161
Camtasia EDU 10% OFF with code applied: techsmith.z6rjha.net/c/1264585/704928/5161
Camtasia Download page: techsmith.z6rjha.net/c/1264585/489271/5161

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

Create a FREE Website with Canva - The Easy Way!

Teachers Tech 2022-08-22 | In this beginner's tutorial, I will show you how to build a FREE website with Canva. By Creating a free Canva account, you will have access to many templates to start from and you can customize it with new fonts, colors, and images to get what you want.

Website: canva.com
Edit videos in Canva: youtu.be/iR2WC_pHQu8

0:00 Introduction
2:00 Choosing a website template in Canva
3:41 Preview your website in computer and mobile view
4:48 Editing and adding text to your website
6:33 Use the shortcut key / for the Magic
11:13 Edit or add images to your website
16:50 Add videos to your website
18:28 Delete, Add or duplicate sections (Pages)
19:36 Quickly change website styles (colors and fonts)
20:42 Publish your website for free
22:21 Republish your website after any updates

I use Camtasia to create my video tutorials:

Use this coupon code: TEACHCAM10
Camtasia purchase with 10% OFF code applied: techsmith.z6rjha.net/c/1264585/701976/5161
Camtasia EDU 10% OFF with code applied: techsmith.z6rjha.net/c/1264585/704928/5161
Camtasia Download page: techsmith.z6rjha.net/c/1264585/489271/5161

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

Pull Text from an Image into Microsoft Word in Seconds!

Teachers Tech 2022-08-17 | In this video, I will show you how I pull text from an image into Microsoft Word. The Office App makes it incredibly easy and fast to take a picture and bring the text into Microsoft Word so you can edit. Save yourself time! Don't worry about typing it all; quickly take a picture with the Office App, confirm it, wait a few seconds, and you have all the words and even pictures in a Word document saved to OneDrive.

Learn more about the Office App here: youtu.be/qiM-w4MYEaA

Microsoft Office App IOS: apps.apple.com/us/app/microsoft-office/id541164041
Microsoft Office App Andriod: play.google.com/store/apps/details?id=com.microsoft.office.officehubrow&hl=en_CA&gl=US

I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

Repair Documents in Microsoft Word. Make Old Look New!

Teachers Tech 2022-08-15 | In this Microsoft Word video tutorial, I will show you how to repair old documents in Microsoft Word. Take a picture of a document and insert it into Microsoft Word. In Picture Format, you can adjust the sharpness, brightness, and contrast of your document.

0:00 Intro
1:09 Insert Picture in Word
2:03 Picture format
2:28 Format picture custom
2:59 Change picture sharpness, brightness, and contrast
3:54 Crop image in Microsoft Word
4:30 Add shapes to hide markings
5:56 Add lines
7:05 Save as PDF
9:36 Auto Correctness

More Microsoft Word Tutorials: youtube.com/playlist?list=PLmkaw6oRnRv9-nqM7qW2aWkaKU6SfersL

I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

How to Print in Microsoft Excel - For Beginners

Teachers Tech 2022-08-10 | In this Microsoft Excel tutorial, I will show how to print. Microsoft Excel has quick access to printing options in Page Layout, but there are some overlooked features in Page Setup that allows you even more options when printing in Microsoft Excel.

Learn how to add page breaks to your Excel worksheet: youtu.be/eV8n10d8Swk

0:00 Intro
1:23 Using Page Layout to setup your print job
2:19 Using the print option (Quick Access Dropdowns)
3:13 Print to PDF in Excel
3:55 Print a selection in Excel
6:23 Scale your print to fit your page
7:49 Do more in Page Setup
8:30 Centre data on the page vertically or horizontally
8:57 Add page numbers or custom footer or header to your Excel print job
10:01 How to keep header when printing in excel

How to Create a Reusable Digital Signature in Microsoft Word

Teachers Tech 2022-08-07 | In this Microsoft Word tutorial, I will show you how to create a digital signature that you can save and use again and again. By selecting Quick Parts and then AutoText you can quickly create your digital signature. This is a step-by-step guide starting from taking a picture of your signature and bringing it into Microsoft word.

0:00 Introduction
0:46 Capture your signature
2:11 Creating your digital signature in Word
3:44 Add and modify the image of your signature
6:41 Adding your digital signature to Quick Parts / AutoText
7:23 Edit or delete your created signature

How to Break an Excel Worksheet into Separate Pages for Printing

Teachers Tech 2022-07-19 | In the Microsoft Excel video tutorial, I will show you how to break a worksheet into separate pages for printing. Adding page breaks in Microsoft Excel is quick and easy to do. Need to modify the page breaks? Simply try dragging them into the correct location or removing or resetting them to add some new page breaks.

Make of copy of the example worksheet here: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EUlIYlTnw_FKifJH2DupyVkB6xZFqw9xmlVKfjJ3yhmAQQ?e=UxX2Q0

Boost Productivity in Google Drive with Keyboard Shortcuts

Teachers Tech 2022-06-05 | Speed up how you use Google Drive with keyboard shortcuts. Using keyboard shortcuts in Google drive can boost your productivity. In this video, I will show you how to use the important NEW Google Drive shortcuts on your keyboard. Now you will be able to quickly make copies of files and folders or move them to a new location in a faster way.

0:00 Introduction
0:44 New shortcuts to copy and move files (and a few old)
5:20 Move files and folders with shortcuts
6:24 Open files to a new tab from Google Drive
6:56 Upload files with a shortcut
7:22 Create documents with shortcuts
8:10 Changes views and get info with shortcuts

Learn more about Google Drive here: youtu.be/G5B6ksOKlYI

Record Your Computer Screen and Create Videos with Filmora 11

Teachers Tech 2022-06-01 | In this video tutorial, I will show you how you can record your computer screen with Filmora 11 and then edit your screen recorded video. You can screen record on your Windows or Mac OS with Filmora. Filmora 11 is an easy-to-use video editor, and also allows you to screen record your desktop and webcam. Download Filmora 11 for free here: click.linksynergy.com/deeplink?

#DubbedWithAloud

0:00 Introduction
1:02 Record your PC Screen from startup
1:20 Customize your screen recorder setting
3:52 Enable your webcam to record while screen recording with Filmora 11
4:35 Start recording your computer screen
5:01 End your recording
5:25 Edit your screen recording video clip
7:05 Import other media
7:55 Record another clip and add it to your video
9:22 Add titles to your video and other effects
10:00 Export your finished video

Learn more about Filmora 11 here: youtu.be/M3cRbN_wxjw
Learn about Camtasia here: youtu.be/hNzulrauu4Y

English
This video has been dubbed into Spanish (United States) using an artificial voice via aloud.area120.google.com to increase accessibility. You can change the audio track language in the Settings menu.

Spanish
Este video ha sido doblado al español con voz artificial con aloud.area120.google.com para aumentar la accesibilidad. Puede cambiar el idioma de la pista de audio en el menú Configuración.

Portuguese
Este vídeo foi dublado para o português usando uma voz artificial via aloud.area120.google.com para melhorar sua acessibilidade. Você pode alterar o idioma do áudio no menu Configurações.

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

Create an Interactive Chart with Checkboxes in Microsoft Excel

Teachers Tech 2022-05-30 | In this Excel tutorial, I will show you how to use checkboxes to create an interactive chart. Adding checkboxes in Microsoft Excel can be done by adding the Developer tab, then you will where you can add checkboxes in Excel. After the checkboxes are added you can create a simple IF statement to make it connect to the data you want to chart.

#DubbedWithAloud

0:00 Introduction
1:04 Add the Developer tab
1:59 Add checkboxes in Excel
2:28 Customize the checkbox
3:35 Link cells to your checkbox
4:32 Copying checkboxes
6:00 Starting the interactive chart
6:33 Creating an IF statement to connect to checkboxes
8:24 Inserting a combo chart
9:57 Customizing the chart
12:26 Hiding the TRUE and FALSE display

Access the practice file: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQaRHKEq7xFBgQ9mJnj37W8BD9HYU4AmClW2YRWgfWSPiw?e=gbjWnA

More Microsoft Excel tutorials here: youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw

English
This video has been dubbed into Spanish (United States) using an artificial voice via aloud.area120.google.com to increase accessibility. You can change the audio track language in the Settings menu.

Spanish
Este video ha sido doblado al español con voz artificial con aloud.area120.google.com para aumentar la accesibilidad. Puede cambiar el idioma de la pista de audio en el menú Configuración.

Portuguese
Este vídeo foi dublado para o português usando uma voz artificial via aloud.area120.google.com para melhorar sua acessibilidade. Você pode alterar o idioma do áudio no menu Configurações.

How to use Google Earth Pro - Beginners Tutorial

Teachers Tech 2022-04-26 | In this beginner’s tutorial, I will show you how to use Google Earth Pro. Google Earth Pro. Search for locations, measure distances and area, go back in time, and visit the Moon and Mars are some of the things you can do with Google Earth Pro

Download Google Earth Pro here: google.com/earth/versions

0:00 Introduction
0:49 Where to download Google Earth Pro
1:56 Navigating in Google Earth Pro
5:55 Searching for locations in Google Pro
7:26 Applying layers in Google Earth Pro
11:29 How to use Street View
13:50 Getting directions in Google Earth
15:12 Using the coordinates (longitude and latitude)
17:05 Measuring distance with the ruler
19:23 Finding the area of a location
20:33 Go back in time in Google Earth Pro (historical imagery)
21:46 Exploring the sky, the Moon, and Mars
23:35 Track sunlight
24:13 Record a tour in Google Earth Pro
25:03 Save high-resolution images of a location on Google Earth

Sign Your PDF or Word Documents on Your Phone

Teachers Tech 2022-04-24 | Use your iPhone or Andriod device to add a signature to your Microsoft Word or PDF documents. With the Office app you can quickly make a quality signature on your digital documents. Move your files from your computer to OneDrive to easily access them on the Office app to sign.

0:00 Introduction
1:23 Saving Word documents and Pdfs to OneDrive
2:49 How to sign a PDF with the Office app
5:45 Signing a Word document in the Office app

Learn more about the Office app here: youtu.be/qiM-w4MYEaA
Learn more about Microsoft OneDrive here: youtu.be/rmqZW8fdolE

Microsoft Office App for iPhone or iPad: apps.apple.com/us/app/microsoft-office/id541164041

For Android: microsoft.com/en-ca/microsoft-365/mobile/microsoft-365-mobile-apps-for-android

Quickly Make QR Codes in Microsoft Word, PowerPoint or Excel

Teachers Tech 2022-04-21 | Easily create QR Codes in Microsoft PowerPoint, Word, and Excel. Simply go to Add-ins to install a QR generator for FREE. With this QR creator, you can quickly send people to websites, documents, presentations, email addresses, phone numbers, or SMS using QR codes.

0:00 Introduction
0:38 Installing the QR creator in Word, PowerPoint, and Excel
2:17 Creating different destinations for QR codes.
6:49 Testing out the QR codes

How to Create Charts and Graphs in Microsoft Excel - Quick and Simple

Teachers Tech 2022-04-11 | In this video tutorial for beginners, I will show you how to make charts and graphs in Microsoft Excel. Using data, I will show you how you can quickly and simply create a chart and customize it the way you would like.

0:00 Introduction
1:00 Quick ways to create a chart in Excel
3:23 Selecting your data series to graph
4:01 Selecting multiple data series to graph
4:32 Adding your first data series to a chart
5:15 Selecting your chart elements
5:35 Labeling your axis titles
5:55 Adding a legend to your graph
10:12 Adding more data to your chart
12:51 Formatting data series
15:34 Deleting a data series from a chart
16:27 Change chart type
17:42 Add images to your chart
18:59 Change your chart area
20:12 Save your chart as a picture

Practice File: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EWmsy_Gx2q1NsnaQN93BQkgBKGI1mtqMz8WdKx2c6VCjYA?e=njBdEa

Insert Microsoft Excel Data and Charts into Microsoft Word and PowerPoint: youtu.be/3BaabgKWnbc
How to Make a Line Graph in Excel - From Simple to Scientific: youtu.be/0jdX22qM8JA

More Excel tutorials here: youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw

How to Edit Videos with Filmora 11 - Beginners Class

Teachers Tech 2022-03-28 | This video tutorial will show you how to use Filmora 11. Filmora 11 is one of the easiest video editors to use and it comes packed with powerful features like split-screen, green screen, color match, motion tracking, video effects, and audio ducking. Free Download for Filmora 11: click.linksynergy.com/deeplink?id=05F1zWCeG70&mid=37160&murl=https%3A%2F%2Fwww.wondershare.com%2F

Filmora 11 is a perfect video editor for editing videos for YouTube. This beginners class will go over the basics of using Filmora 11.

0:00 Introduction
1:38 Create a new project in Filmora 11
3:09 Import Video clips, images, or audio into Filmora
5:00 Saving, preview your media, adjust settings, take a snapshot
7:30 Add video and images to a track
8:42 Zooming in on your tracks
9:44 Moving clips and images in the track
11:06 Adjusting audio on video clip
12:22 Trimming and splitting video clips in Filmora 11
15:20 Adjusting image duration
16:13 Bringing audio to the audio track (trimming and splitting audio)
17:58 Creating a video and images sequence with audio.
19:38 Adding fade in or fade out to audio clips
21:16 Adding and adjusting transitions in Filmora
23:50 Scale pictures and videos (remove black bars)
25:31 Adding titles and text to your video
27:45 Stock media (Pixabay) and Audio
29:02 Cropping a video clip
30:24 Change the speed of a video clip (speed up or slow down)
31:52 Create a picture in picture
33:22 Change the opacity of a video clip
34:25 Add effects in Filmora 11
34:54 Masking a video clip
36:16 Adding Elements
37:10 How to create a split-screen in Filmora 11
39:45 Exporting your finished video

Filmora 11 Tips and Tutorials playlist: youtube.com/playlist?list=PLmkaw6oRnRv9mlNYJETKdn6eHO0vrM5i8

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

7 Reasons Why you Should use Excel Tables

Teachers Tech 2022-03-21 | In this video, I will go over 7 different reasons to use tables in Microsoft Excel. When you turn your data range into an Excel table you are unlocking more properties. Benefit from using tables in Excel.

0:00 Introduction
0:32 Creating a table in Microsoft Excel
2:05 Easy formatting with a table (banded rows, add a total)
3:27 Table headers remain visible even when you scroll down
3:44 Tables automatically create filters for each column
4:50 Tables automatically expand when you add new rows or columns
5:35 Tables automatically name ranges (can be used in formulas)
6:30 You can add totals to tables automatically
7:05 Add slicers to your table
8:05 You can create dynamic charts from Excel tables

Learn more about mentioned excel topics below:
Create forms to enter data in your tables: youtu.be/dV90KPArP5Q
More about slicers in this tutorial: youtu.be/c8qePWuYleg
More about tables in this tutorial: youtu.be/dV90KPArP5Q
More about pivot tables: youtu.be/igSovq_H24A

Practice File: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQKwmxoi8yJFrrYnyk8KUYUBsQW4XelB_jkA0JwQgbiT3A?e=n8Mu0q