Conditional Formatting Applied to Dates in Excel

Microsoft Excel | Conditional Formatting Dates

Microsoft Excel Conditional Formatting Dates. Use your Microsoft Excel Conditional Formatting to add a visual change (color) to cells that have an upcoming expiration date.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

 

Mail Merge from Excel List or Outlook Contacts to Word Labels

Mail Merge Labels

Mail Merge Microsoft Excel or Outlook List to Word Labels

Merge your Microsoft Excel address list (or Outlook Contact list) with a Word document to create a set of mailing labels.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

 

 

Microsoft Excel Data Validation Drop Down List in Excel Cells

Data Validation List

Microsoft Excel Data Validation Drop Down List in Cell

Create a drop-down list in your Microsoft Excel cells.  This is called Data Validation.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

 

 

Microsoft Excel Link Cell to Another Cell with Formula Reference

Formula References

Microsoft Excel Formula References across Worksheets | Link to Another Cell | Retrieve Number from Another Cell

Microsoft Excel Formula References across Worksheet sheets. Retrieve numbers from other worksheets in your Excel files.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

Microsoft Excel Insert Table | Table Design Tools

Table Tools Excel

Microsoft Excel Insert Table | Table Design Tools

Microsoft Excel Insert Table and Utilize Table Tools. Establish your data as a Table to take advantage of the Table Design Tools available in Microsoft Excel.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

Microsoft Excel Fix Print Problems

Excel Print Tips

Microsoft Excel Fix Print Problems | Excel Print Tips

To fix your Microsoft Excel Print Problems, Adjust Page Layout Options and Print Preview settings to get the Excel Print job exactly how you want it.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

3D References in Microsoft Excel | SUM Multiple Worksheet Cells

Excel 3D References

Microsoft Excel 3D References Across Worksheets | SUM Multiple Worksheet Cells

Microsoft Excel Create a 3D Reference Across Worksheets. Demonstration of how to create a 3-D Reference in Microsoft Excel 2016. This will allow you to include cells “thru” sheets that are in the exact same cell position on each sheet.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

 

Microsoft Excel RANDBETWEEN Function

Excel Function RANDBETWEEN

Microsoft Excel RANDBETWEEN Function

Microsoft Excel RANDBETWEEN Function. Use the RANDBETWEEN Function in Excel 2016 to generate a random number with a given bottom and top range.

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events

Record an Easy Macro in Microsoft Excel – Beginners

Excel Easy Record Macro

Microsoft Excel Record an Easy Macro Beginners

Microsoft Excel Record an Easy Macro – Beginners. Build a Macro to Quickly Format Data in Microsoft Excel. A Macro is simply a recording of the steps that you can playback at any time!

Subscribe to Dawn’s YouTube Channel

Contact Dawn Monroe for Your Custom Training Needs Today!

View Calendar of Upcoming Training Events