Microsoft Excel Fundamentals - The Beginner's Masterclass

Excel comes with many built in templates that can be downloaded and opened so you can then edit them with your own data.

An Excel worksheet is made up of rows and columns and you can add or remove them as needed from any location on your worksheet.

An Excel workbook contains one or more individual worksheets. You can add these worksheets as needed and also rename them to help keep things organized.

Excel has options to save your workbook in many other formats besides the default XLXS type.

In this lesson, we will be showing you how to copy and move your data to other cells or worksheets.

The Clipboard History tool is a feature of Microsoft Windows that will keep a listing of text and images you have copied so you can easily paste them again as needed.

Excel has the ability to insert many different types of objects into your spreadsheet such as images, shapes, text boxes, hyperlinks, symbols, tables and charts.

If you want to protect a worksheet or your entire workbook from others opening it or modifying it, then you can do so with a few simple steps.

If you have a workbook with a lot of data, you will find that it is easier to use the search function to find your data rather than manually looking for it. You can also use this tool to replace data with other data.

Excel makes it possible to save your workbook to your OneDrive account so you can then share it with others and have multiple people work on the file at the same time

Functions are preconfigured formulas that are built into Excel and are much easier to use than creating formulas from scratch.

The formula bar is used to create and edit existing formulas that reside in a cell.

A formula is an expression that operates on values in a range of cells and enable you to perform calculations on that data.

Filters are used to hide or display specific data of your choosing so it is not shown within your spreadsheet.

Sorting is used to organize your data in a more meaningful and easy to read order.

By default, Excel does not have borders around your cells but its very useful to add them to help your worksheet look more organized.

Changing fonts and their attributes such as making them bold or underlined is a great way to make your data stand out where needed.

If you are not satisfied with the fonts you have installed on your computer, we will show you an easy way to add many additional fonts for free.

Adding cell fill colors is a great way to make your data stand out where needed.

In this lesson, we will be discussing the various ways you can align your data within your cells such as centering and left or right alignment. We will also be discussing the wrap text, shrink to fit and merge options.

If your data is not fitting in your cells, then you can easily adjust their size as needed to make things fit.

Using Excel styles and conditional formatting is another way to make your data stand out and make your spreadsheet easier to read.

Its important to have the right type of data formatting applied to your cells so your data is displayed properly.

If you need to print a spreadsheet or show one during a presentation but don't want certain data to be shown, you can quickly hide rows and columns and then unhide them when you are finished.

The Freeze Panes feature of Excel allows you to keep specific data on the screen while scrolling to help you better perform your work.

Its important to review your page setup configuration before printing your document so it will fit the page the best it can.

Page breaks are used in Excel to show you what data is on what page so you will be able to arrange things accordingly before printing your worksheets.

If you are planning on printing your worksheet, then its important to know what options you have available to you in order to make it print correctly.

Many people like to convert their documents to PDF files before sharing them with others. You can easily do the same with Excel spreadsheets.

Add-ins can be installed into Excel as apps that add additional functionality and features.

Excel has a large variety of keyboard shortcuts you can use if you would rather not take your hand off of the keyboard to use the mouse.

If you are looking for additional Excel training, you can find some helpful resources from within Excel itself.

Excel has a wide variety of options that you can configure to make the program work better for you.

If you decide to share your spreadsheets with others for collaboration purposes, you might want to use the free Microsoft OneDrive online cloud storage app.

If you want to keep an eye on specific cells to see when data within those cells have changed, you can use the Excel Watch Window to do so.

If you want to have cells that match your search results stand out after you are done searching, you can easily assign those cells a color with a few clicks of the mouse.

The "Analyze Data" button in Microsoft Excel serves as a gateway to a suite of powerful data analysis tools and features. Located within the Excel ribbon under the "Data" tab, this button provides quick access to various functionalities like sorting, filtering, and summarizing data using PivotTables and PivotCharts. Clicking on the "Analyze Data" button opens up a range of options that allow users to explore and interpret their data effectively. With features like "Quick Analysis," users can instantly generate charts, tables, and other visualizations to gain insights.

If you want an easy way to add a calendar to your spreadsheet with the year and months of your choosing, there is a very easy way to do so.

If you want an easy way to prevent someone from adding duplicate data in a range, you can use data validation to do so.

Here are the notes from the video.

=COUNTIF($X$X:$X$X,FirstCell)=1

=COUNTIF($C$2:$C$20,C2)=1

Popup messages for cells come in handy if you want to display something such as instructions for the type of data that needs to be entered into a cell.

A Microsoft Excel Circular Reference Formula Error occurs when a formula refers back to its own cell either directly or indirectly, creating an endless loop. This prevents Excel from calculating a valid result.

Be sure to check out our computer based YouTube channel for helpful tips on a variety of tech topics!

The Computers Made Easy book series is a great resource to find books on a variety or computer related subjects.

If you are looking to improve your Windows 11 skills then check out our Easily Master Microsoft Windows 11 - The Comprehensive Guide course!