Excel: Core Data Analysis, and Workbook Customization

Welcome to Excel: Core Data Analysis, and Workbook Customization on Udemy.com

Use copies of the attached workbook for exercises in thisExcel: Time Saving Tips That Will Boost Your ProductivityUdemy.com course

Customize Excel's Ribbon. Create your own tab(s) on the Ribbon to find what you need most, when you need it.

Even share the customizations with others.

Find the Excel tools you need fast with the Quick Access Toolbar

Learn the quick ways to select cells and ranges of cells in your Excel workbooks

Use your mouse and the CTRL key in this quick tip on moving and copying cells in Excel

You are not limited to only copying one item onto the Clipboard. Learn the power of the keyboard.

Learn to Quickly Navigate to Worksheets in your Excel workbooks

Take advantage of being able to name your cells and ranges by using those names as Navigation tools in your Excel workbooks

The Fill Series has so many uses. Learn how they can help you save time in Excel

Learn the quick tip on inserting the same data into multiple cells

Use Freeze Panes to keep your headings in place when working with long spreadsheets

Too much data in one cell? Learn how to split your data into multiple columns.

You have probably tracked changes in Microsoft Word. Did you know that you can also track changes in Excel?

You can.

When you need to add data to multiple existing Excel worksheets, watch this lecture.

This quick lecture, shows you the quick way to copy and rename your Excel worksheets

Coloring your Excel worksheet tabs is a great way to get organized

Learn the quick way to enter the Current Date and Time on your Excel Worksheets

Did you know you can turn your lists and tables into forms with just one click?
Learn to create a user-friendly form for easy data entry and searching.

Keep this printable Keyboard Shortcut document handy when working on Excel

Keep this printable Keyboard Shortcut document handy when working on Excel

Learn how the ALT key can help you quickly navigate through Excel's Ribbon commands

AutoCorrect can do a lot more than just fix your misspelled word in Excel. Find out what else AutoCorrect can do

Use Excel's Camera tool to Take a Picture of the Data You Need to Track

In Excel you are not limited to rectangular shaped comment call-outs

3D formulas allow you perform functions on values across multiple worksheets in your Excel workbooks

You copy down your formulas and functions, but something is just not right.
Are you using Absolute or Relative Reference?
What is that, and how can you tell?

Watch this lecture and find out.

Probably one of my favorite ways to use named ranges. Learn how named ranges can benefit you, and others using your Excel workbooks

This is not just a regular SUM, but a SUM based on a true condition

This is not just a regular SUM, but a SUM based on multiple true conditions

I am a visual person so I like to use the dashboard like features of the DSUM function in Excel

VLookup is a powerful and very handy tool inside of Excel. Learn how you can use it for your spreadsheets

The IfError function in Excel returns a value if a formula evaluates to an error; or it will return the result of the formula.

Use Left, Right, and Mid functions in Excel to extract only parts of a cell's value

The Find function in Excel can help you quickly locate characters in your spreadsheet

Use the Rank function in Excel to find how your values rank compared to others

Ever look at your Excel spreadsheet and wonder what formula is running behind a cell, or cells?

There is a keyboard shortcut for that.

Want an easy way to make sure users enter only the information you want them to enter into a cell or range of cells? Create a drop-down list.

Learn how to create drop down boxes that list values based off of the value in a previously selected drop down.

Limit the number of characters others can type into a cell or range of cells in Excel

Create your own custom Error Messages in Excel

If you are enjoying this Microsoft Excel Tips & Tricks course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.

Learn about special number formats in Excel, like phone numbers, social security numbers, and more

An explanation of custom number formats in Excel

An example of custom number formats in Excel

Learn how to use custom formatting to hide the data in your workbook.

Learn how conditional formatting can turn your Excel spreadsheet from drab, to fab

Quick Analysis is a new feature in Microsoft Excel. Learn how you can use it on your spreadsheets.

When using Conditional Formatting in Excel, you can hide the values, and just show the icons

It's not just Find and Replace, it's Find and Replace with Formatting.

Using tables instead of lists has big benefits in Excel. Learn what they are in this lecture

Use Slicers in Excel to create a User-Friendly dashboard to help you and other users quickly filter data

When sorting ascending or descending just won't do, create your own custom sort list in Excel

Created a table, but need the rows in the columns and the columns in the rows? Transposing your data in Excel is quick and easy

The Subtotals tool is a fast way to add subtotals to your Excel lists

Learn how to quickly create charts in Microsoft Excel

Quickly format the features of your charts in Excel

Learn how to create an exploding, 3D pie chart in Excel

Sparklines in Excel are like mini charts in a cell. See if it is a feature that would work for you.

Creating a Secondary Axis in Excel has never been easier. Watch this lecture to see how easy it is.

Need your Excel chart in a Word or PowerPoint presentation? Here is how to do it...

What are PivotTables and why would you want to use them?

Learn how to quickly analyze your Excel spreadsheets using PivotTables

PivotTables and PivotCharts go hand in hand. Learn how to quickly create PivotCharts in Excel

Just like with tables, Slicers are a great way to filter PivotTable data

Use Timelines in Excel to filter by dates

Ever notice that when you print a spreadsheet in Excel, the heading only show on the first page by default?
Learn how to change that so your headings appear on every printed page.

When you only want a few cells or range of cells to print you can set the print area.

Whether it's one column or many rows, learn how to fit all of your records on one page in Excel

Learn how to set your own Page Breaks in Excel

You can hide your #N/As, #DIV0s, and other errors when printing your Excel spreadsheets

Add a watermark to your Excel spreadsheets