Category Archives: Excel How To Videos

Simple and easy to follow excel how to videos.

Master Excel Like a Pro: Genius Shortcut Keys to Add Borders—No Mouse Needed!

Click here to view our video tutorial. Click here to download our PDF tutorial. Enhancing your Excel 365 proficiency by mastering keyboard shortcuts for adding borders can significantly boost your efficiency, especially if you prefer or require a mouse-free workflow. … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , , , | Leave a comment

Open the Format Cells Dialog Box in Excel with Shortcuts

Click here to view our video tutorial. Click here to download our PDF tutorial. Enhance your Excel efficiency by mastering the use of keyboard shortcuts to access the Format Cells dialog box. This powerful feature allows you to customize cell … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , | Leave a comment

Select the Entire Worksheet in Excel Using ONLY Shortcut Keys

Click here to view our video tutorial. Click here to download our PDF tutorial. Today, we are going to show you how to select the entire worksheet using only shortcut keys in Excel 365. Let’s get started. For most people, … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Turn Any Excel Data into a Stunning Chart—Fast & Easy with Just Shortcut Keys! (Excel 365)

Click here to view our video tutorial. Click here to download our PDF tutorial. Today we are going to show you how to create a chart from data using only shortcut keys in Excel 365. Let’s get started. Here, we … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

How To Expand All Columns Using Only Shortcut Keys In Excel 365

Click here to view our video tutorial. Click here to download our PDF tutorial. Working with Excel can be a time-consuming task, especially when formatting large datasets. A common problem faced by many users is adjusting column widths to fit … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

How to Lock Cells in Excel | Step-by-Step Guide

Locking cells in Excel is a fundamental skill that ensures the integrity of your data by preventing unintended modifications. By default, all cells in an Excel worksheet are locked, but this setting only takes effect when the worksheet is protected. … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Create A Colorful Weekly Lesson Planner In Excel 365

Welcome to Mark’s Excel Tips. Today, we are going to show you how to create a colorful weekly lesson planner In Excel 365. Let’s get started. Click here to view our video tutorial. Click here to download our PDF tutorial. … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

How to Create A Schedule Template in Excel 365

Click here to view our video tutorial. Click here to download our PDF tutorial. Today, we are going to show you how to create Schedule Templates, in Excel 365. Let’s get started. To start, click on File. On the right … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , | Leave a comment

How to Create an Any Year Calendar in Excel 365 | Easy Tutorial

Today, we are going to show you how to create an Excel calendar template for any year, in Excel 365. Let’s get started. Click here to view our video tutorial. Click here to download our PDF tutorial. To start, click … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

How to Create a Balance Sheet Template in Excel 365 | Step-by-Step Guide

Hello, and welcome to Mark’s Excel Tips. Today, I will show you how to create a Balance Sheet Template, in Excel 365. Let’s get started. Click here to view our video tutorial. Click here to download our PDF tutorial. To … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , | Leave a comment