Excel Macro VBA Tip 22 – Open Workbooks with Excel Macros

About this tutorial: Video duration: 5:28 Visit for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to create or write a macro that will open another workbook on your computer. You will learn how to use this macro to open a single workbook on your computer as well as […]

How to chang the color scheme of excel 2007

About this tutorial: Video duration: 2:5 How to change the color scheme of excel 2007 Today in this video we will lear how to change microsoft office color scheme this is really very to change color schemes in microsoft excel you just need to visit the excel options where you can get the option to […]

Excel Tips 14 – Links in Excel to Quickly Navigate Between Worksheets with Buttons

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to create links between worksheets in Microsoft Excel 2007. Also learn how to navigate workbooks using buttons in Excel. This is a great tutorial to view to learn how to quickly navigate and move through a very large or complicated workbook in Excel. […]

Excel Tips 24 – Quickly Add Buttons to and Customize the Quick Access Toolbar in Excel 2007

About this tutorial: Video duration: 4:23 Visit for more, including Excel Consulting, Macros, and Tutorials. Learn how to use and customize the Quick Access Toolbar in Excel 2007. This tutorial shows you a cool way to very quickly and easily add buttons from the Ribbon Menu into the Quick Access Toolbar. Also, you will learn […]

Excel Lookup/Search Tip 6 – Vlookup with a Drop Down Menu and Data Validation

About this tutorial: Video duration: 5:49 Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use the VLOOKUP function in Excel in conjunction with a data validation drop down menu in order to create more logical and easy to use Excel spreadsheets. This allows you to use a drop down menu […]

Data Analysis in Excel 7 – Quickly Import XML Files and Data into Excel

About this tutorial: Video duration: 6:27 Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to import XML files and data into Excel. You will learn how to import XML data formatted in the new Excel 2007 Table format as well as just formatted as plain text. […]

Excel Formatting Tip 10 – Quickly Add Professional Formating to Spreadsheets and Cells in Excel

About this tutorial: Video duration: 5:8 Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to quickly and professionally format your spreadsheets in Excel. You will learn how to add cell styles using some of Excel 2007’s new features in order to quickly change the appearance of […]

Excel Tips 21 – Automatically Display the Current Date in Excel

About this tutorial: Video duration: 3:5 Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to Automatically display the current date every day in Excel. This tutorial shows you a useful formula which will update the spreadsheet every day to show the current day of the week, day, month, and year. You […]

Excel Tips 22 – Keyboard Shortcuts for Excel 2007 The Easy Way to Learn Them

About this tutorial: Video duration: 4:46 Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This tutorial shows you how you can quickly accustom yourself to the new keyboard shortcut system in Excel 2007. You will learn how to use the new keyboard shortcuts in Excel 2007 as well as how to figure out […]

Excel Tips 22 – Keyboard Shortcuts for Excel 2007 The Easy Way to Learn Them

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This tutorial shows you how you can quickly accustom yourself to the new keyboard shortcut system in Excel 2007. You will learn how to use the new keyboard shortcuts in Excel 2007 as well as how to figure out what keyboard shortcut goes with what […]

Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet

About this tutorial: Video duration: 5:27 Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn to consolidate large amounts of data in order to get rid of duplicates using Microsoft Excel 2007. This video tutorial specifically shows you how to take a list of customer purchases, where the same customer has purchased from […]

Excel Tips 19 – Hide and Unhide Worksheets in Excel

About this tutorial: Video duration: 2:33 Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Quickly hide and unhide worksheets in Microsoft Excel 2007. This allows you to clean up the appearance of your workbooks in Excel and to hide raw data. This technique also allows you to reference the data on the hidden […]

Excel Macro VBA Tip 9 – Enter Formulas in Excel with a Macro

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn to enter formulas and values into Microsoft Excel with a macro. This tutorial teaches you how to enter a single formula into one cell as well as how to enter a formula into many cells and ranges of cells at once. You will also […]

Excel Formatting Tip 7 – Angle Cells Diagonally in Excel Make Better Looking Reports and Tables

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This tutorial teaches you how to make tables and reports look better and take up less room by making the table headings diagonally angled. This shows you how to angle cells diagonally so that they take up less room in the spreadsheet as well as […]

Formulas in Excel 1 – Round Numbers in Excel with Round Function to the Nearest Decimal or Integer

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Round numbers in Excel using the Round Function. You will learn how to round a number to the nearest integer, to a specified number of decimals, as well as to a specified number of integers. This is a great tutorial to view to learn how […]

Excel Tips 18 – Quickly Sort Data Alphabetically and Numerically in Excel 2007

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Quickly sort data Alphabetically and Numerically in Excel 2007. This tutorial shows you how to very quickly sort large lists of data to better view and understand that data. In this example, you will see how to order an employee sick-day list to see who […]

Excel Tips 15 – Add Comments, Remove Comments, Find Comments, and Edit Comments in Excel 2007

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to add comments, remove comments, view comments, find comments, and delete comments in Microsoft Excel 2007. This tutorial shows you how to add tips and reminders to any Excel spreadsheet and worksheet. You will also learn how to find any potentially out of […]

Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn to consolidate large amounts of data in order to get rid of duplicates using Microsoft Excel 2007. This video tutorial specifically shows you how to take a list of customer purchases, where the same customer has purchased from the store multiple times, and add […]

Excel Tips – Quickly Fill Series of Numbers in a Few Seconds Fill Command

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn to quickly fill a large series of number in Microsoft Excel 2007. This tutorial shows you how to put 100,000 numbers in column A in just a few seconds. This is a great way to save time when numbering large sets of data in […]

Excel Tip – Speed up Slow Workbooks Turn Off Automatic Formula Calculation

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to turn off automatic workbook calculation in Microsoft Excel 2007. This is a great Excel tip/trick to use to speed up workbook performance when you have a large number of formulas, functions, and links in any one workbook. You will learn how to […]