Home
Videos uploaded by user “TeachExcel”
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation
 
05:49
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt 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 to supply the lookup value to the vlookup function in Excel instead of having to type the lookup value by hand. This reduces the amount of errors when searching a database and increases efficiency in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 196032 TeachExcel
Dynamically Update a Drop Down Menu/List - Data Validation & OFFSET() Function
 
05:52
More tutorials: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt This tutorial will show you how to have a dynamically updated drop down list in excel; how to make your data validation drop down list or menu dynamic. This means that every time you add something to the list the drop down menu will automatically include that item in its list. This uses the OFFSET() function the COUNT() function and Data Validation in Microsoft Excel. To get the spreadsheet used here of for more excel video tutorials, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions. Have a great day!
Views: 320139 TeachExcel
Remove the #N/A Error from VLOOKUP in Excel
 
03:02
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt How to remove the #N/A value from cells in excel which contain vlookup formulas. To do so, you need to use and IF statement and an ISNA function. This tutorial teaches you how to do that. For more or to follow along with the spreadsheet used here, go to the website below: http://www.TeachMsOffice.com
Views: 159928 TeachExcel
Excel Tips - Quickly Fill Series of Numbers in a Few Seconds   Fill Command
 
02:55
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt 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 and it will save you a lot of time. This method is much better than just using the quick-fill handle in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 729423 TeachExcel
Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet
 
05:27
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt 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 the purchase amounts of unique customers together. This way, you can quickly see how much a single customer has spent over a given period. This is the consolidate command in excel 2007 and allows you to quickly display only the unique values in a list while adding together multiple entries of the same item. This is great for users who manage inventory lists or purchasing records. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 427345 TeachExcel
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
 
02:18
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to print an Excel worksheet or workbook with gridlines. This means that all of the boxes that you see in Excel will show up when printed. This is a good feature to use when printing in Excel if you are printing data that still needs to look like a table or grid when printed. This feature also allows you to make easy to follow printed spreadsheets without having to add borders to the spreadsheet before it is printed from Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 163338 TeachExcel
Excel Tips 14 - Links in Excel to Quickly Navigate Between Worksheets with Buttons
 
04:16
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt More tutorials: https://www.teachexcel.com 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. You will also learn how to assign links to other worksheets to buttons in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 294061 TeachExcel
Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell
 
02:21
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt More help: https://www.teachexcel.com More, including Excel Consulting, Macros, and Tutorials. Neat Excel tip for adding extra lines to cells in Excel. This allows you to have paragraph style formatting for text within a cell whereby you can enter text on lines below other text within the same cell in Excel. This allows you to have better looking and better formatting spreadsheets in Excel. You can also use this technique to insert blank lines after or before text within a cell in Excel. This method of entering text into cells allows you to avoid using the text box to enter large amounts of text in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 431070 TeachExcel
Double Vlookup in Excel - Use Multiple Vlookups Together - Nested Vlookups
 
09:07
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Go to https://www.TeachExcel.com for more. Learn how to combine two vlookups into one vlookup function in Excel. This also includes an explanation and example of when or why you would want or need to do this in Excel. Basically, this is just nesting vlookup functions within each other and it will allow you to create more robust and useful formulas in Excel. This will help you to search through multiple tables at once in Excel in order to get the data that you need. As such, this is one way of creating more useful, albeit complex, Excel spreadsheets and this will help you sift through your data in Excel.
Views: 292832 TeachExcel
Excel Macro VBA Tip 1 - How to Write Your Very First Macro in Microsoft Excel
 
06:05
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt This is a great introduction to macros and vba and Microsoft Excel macros. You will learn how to write your very first macro by hand; what the syntax is for naming your macro; how to tell if you entered the macro correctly; and how to run the macro you just created. This is the first of a long line of tutorials which aim to teach you how to write and use macros in excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachMsOffice.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 276342 TeachExcel
Printing in Excel 7 - Repeat Row & Column Titles on Every Printed Page from Excel - Page Setup
 
05:50
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt More tutorials: https://www.teachexcel.com This Excel video tutorial shows you how to repeat title rows and columns in Excel for every page that is printed. This allows you to view the same rows at the top of a column on each page so that you know what every column stands for in the printed spreadsheet. You will also see how to do this for columns when your data is organized left to right instead of up to down. This is a great tutorial to view to increase the usability of printed spreadsheets and simply to make them much easier to read and understand. This tutorial shows you how to repeat single rows and columns as well as multiple rows and columns on every page of the printed Excel spreadsheets. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 264286 TeachExcel
Do a Two Way Lookup in Excel - Match() Index() Functions
 
08:09
http://www.TeachMsOffice.com How to do a two way lookup in excel. This tutorial teaches you how to lookup a value in a table based on two separate parameters. It is similar to the Vlookup and Hlookup but this allows you to make a more versatile lookup function. This tutorial expects you to have at least a general understanding of the Match() and Index() functions. To get the spreadsheet used here and for more information including free macros, forums, and keyboard shortcuts, go to: http://www.TeachMsOffice.com
Views: 145681 TeachExcel
Make a Dynamically Updated Vlookup Table in Microsoft Excel
 
06:59
http://www.TeachMsOffice.com This tutorial will explain how you can setup your vlookup table so that it is dynamic. This means that whenever you add an entry or any data to an existing vlookup table, the vlookup formulas will automatically update to include this new data. This tutorial assumes you already know how to make and use a vlookup table and the vlookup formula. This is a really neat trick which will help save you a lot of time when working with vlookup in excel. The OFFSET() and COUNT() and VLOOKUP() formulas and functions are used in this tutorial. To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions. Have a great day!
Views: 104230 TeachExcel
Count Cells That Only Contain Text in Microsoft Excel
 
01:33
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt This Excel video tutorial shows you how to write a formula which will count the cells in a list which contain text. The problem is that, often times, you may have a list in Excel which contains text and numbers throughout; when this is the case, you can't count only the text cells without also counting the number cells. This may seem like a very straightforward thing to do, however, Microsoft Excel does not provide one function which can do just this. That means that we need to combine two separate count functions in order to count just the cells which contain text. The functions needed to do this are the COUNT() and COUNTA() functions in Excel. This is a short yet useful tutorial which will help to save you some time when you need to count cells within a list which contain text within Excel. To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions. Have a great day!
Views: 88454 TeachExcel
Excel Data Analysis 1 - Move Data from Rows to Columns - Transpose Data in Excel
 
03:15
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to change data from being displayed across rows to being displayed across columns. This tutorial teaches you how to transpose data in Microsoft Excel. This means that you move data from rows to columns and vice versa. This is a great way to make your data more presentable in Excel and simply easier to read and understand. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 69582 TeachExcel
VLOOKUP Introduction, Explanation, Example in Excel (1 of 2)
 
08:56
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt Part 1 of 2 Here, I explain what the VLOOKUP() function in excel is; what it does; and how it can be useful for you. Note, this is an introduction to the vlookup function and does not cover anything advanced. It will serve to give you a good understanding of how it works and how to use it. Follow along with the excel spreadsheet used in the tutorial by downloading it at my website. Just navigate to the tutorials section and from there the formulas section: http://www.TeachMsOffice.com
Views: 474331 TeachExcel
Finance Basics 12 - Perpetuity Calculation in Excel
 
05:11
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate a perpetuity in Microsoft Excel. You will learn the mathematical formula for calculating a perpetuity as well as how to calculate a perpetuity using the PV() or present value function in Excel. This is a must see tutorial for people studying finance or those who need to understand perpetuity payments. Basically, a perpetuity is just a series of payments that is never ending or that goes out for a very long time into the future - such as a series of payments for the rest of a person's life. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 44811 TeachExcel
IF Statement and Nested IF Statement in Excel
 
09:05
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt More tutorials: https://www.teachexcel.com How to use a basic IF statement in Excel and also how to use a nested IF statement in Excel. This is a good tutorial for a beginner and also someone looking to understand nested IF statements.
Views: 199977 TeachExcel
Excel Tips 30 - Install Add-Ins to Excel - Analysis Toolpak - Solver - Etc..avi
 
04:25
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to install add-ins in this Excel video tutorial. You will learn how to install add-ins such as the Analysis Toolpak and Solver in Excel. This is a very good tutorial to learn if you just upgraded to Excel 2007 or just need to find out where to install add-ins in Excel. Installing the Analysis toolpak will allow you to perform regression analysis and t-stat and anova analysis in Excel in a much more efficient fashion than just using functions such as LINEST(). For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 80972 TeachExcel
FIND() LEN() LEFT() RIGHT() Functions Extract Text From Cells in Excel Advanced P.1
 
08:22
More tutorials: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt PART 1 This tutorial shows you how to pull text from cells and separate them into multiple columns. This is an advanced tutorial that gives a detailed explanation of how to use the LEN() and FIND() Functions and Formulas in excel.
Views: 304072 TeachExcel
Excel Lookup/Search Tip 5 - Vlookup - Assign Values Instead of Errors to a  Vlookup with IFERROR
 
05:18
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() function in order to never have to see another error displayed in Excel. The IFERROR() function allows you to display whatever default value you want in a cell if the original formula returns an error. This is an example of a nested function or formula since the Vlookup function is actually placed inside of the Iferror function. The IFERROR function is a great addition to Excel 2007 and should be learned by everyone who uses Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 30311 TeachExcel
Arrays in Excel - Introduction and How-to Guide
 
03:35
http://www.TeachMsOffice.com Basic introduction to arrays, what they are, how they save you time, and a simple example. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website: www.ExcelisHell.com
Views: 22423 TeachExcel
Excel Tips 18 - Quickly Sort Data Alphabetically and Numerically in Excel 2007
 
01:57
More tutorials: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt 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 was sick the most and least. This quick tip shows you how to order your data in only a few seconds and is invaluable to those who work with large amounts of data daily. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 187492 TeachExcel
Excel - AutoFill Thousands of Rows at Once in Excel
 
03:46
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt This tutorial shows you how to fill thousands of rows or columns with incremental numbers or dates with the click of a button. You will learn multiple ways to quickly fill-in the data, but, you will also learn the quickest way to do so. For instance, this Excel tutorial will show you the easiest way to fill-in 10,000 (or even a million) rows with numbers starting from one; the method illustrated is much faster than the alternatives outside of VBA.
Views: 102994 TeachExcel
Excel - Link Data Between Worksheets in a Workbook in Excel
 
03:44
More tutorials: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Here, you will learn how to link data between worksheets within a workbook in Microsoft Excel. This will allow you to keep a tab of raw data and to reuse that data throughout the entire workbook without having to re-type it. This will help with keeping your data consistent and up-to-date. This is a basic skill that everyone should learn when using Excel.
Views: 258912 TeachExcel
Excel Tips 28 - Display The Current Time in Excel Down to the Second
 
04:06
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. How to display the current time in Excel using a function. Use the NOW() function in Excel to display the current date and time. You will also learn how to change the format of the cells so that you only view the current time, time with AM/PM, as well as the seconds (hh:mmmm:ss). You will also learn how to further change the formatting to get what you need from this function. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 47001 TeachExcel
Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.
 
05:27
http://www.TeachMsOffice.com This tutorial shows you how to create a list in Microsoft Excel which only contains unique values. This means that a user cannot enter a duplicate value or word or phrase in a list. The words or numbers or characters must be exactly the same to be considered a duplicate entry. This method used the Data Validation technique in excel. The formula/function used here is COUNTIF(). To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions. Have a great day!
Views: 35498 TeachExcel
Get the Net Present Value of a Project Calculation - Finance in Excel - NPV()
 
04:11
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt This tutorial shows you how to get the Net Present Value of a project or business venture in the future using excel. You can do this very easily in excel spreadsheets and this will teach you how to do that using the estimated cash flows of a project. The NPV() function is used for the calculations. This is also a basic discounted cash flows example. This includes discount rate and number of periods in order to use the npv function. To follow along with the spreadsheet used in the video and also to get free excel macros, tips, and more video tutorials, go to the site: http://www.TeachMsOffice.com
Views: 261628 TeachExcel
Excel Data Analysis 2 - Import CSV Files into Excel
 
05:28
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to import CSV files into Microsoft Excel. This tutorial shows you how to use the import wizard in Excel 2007 to import text and CSV files into Excel. You will learn what delimiters are and how to use them as well as where to go for the properties to edit how the data imports into Excel. This is a great tutorial for everyone who needs to import data and text files into Microsoft Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 55426 TeachExcel
Data Validation 2 - Create Drop Down Menus From Source Data on Separate Tabs in Excel
 
04:58
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Create drop down menus in Excel with source (list) data from separate tabs within Excel. This Excel video tutorial shows you how to create a drop down menu that uses data from separate worksheets within Excel. This is a great tutorial to view because of the fact that you can just point to a range in a separate worksheet in Excel through data validation. Instead, you have to use named ranges with data validation in order to reference data that is not on the same worksheet as the drop down menu that you want to create. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 47373 TeachExcel
Data Analysis in Excel 8 - Import XML Maps and Pull Selected Columns Values into Excel
 
05:47
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to import an XML Map into Excel and then how to display selected information from that map within the spreadsheet or worksheet in Excel. This is a great tutorial for people who need to import XML files and data into Excel. Also, you will learn a simply good and useful technique for viewing the contents of an XML file within Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 43006 TeachExcel
Excel Macro VBA Tip 12 - Clear Data & Cell Contents with an Excel Macro
 
04:48
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to properly clear data and cell contents in Excel spreadsheets using a macro. This tutorial shows you how to use the clearcontents part of excel vba to write a macro that will delete all of the contents of cells in the spreadsheets. This is the best method or way to delete everything from a cell or a range of cells in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 86102 TeachExcel
VLOOKUP Between Separate Workbooks and Worksheets in Excel
 
06:23
More tutorials: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel. You will learn how to use the vlookup to search through lists in closed workbooks and in separate excel files. To follow along with the excel spreadsheet seen here and to find more excel stuff including free macros, keyboard shortcuts, and a forum, go to: TeachExcel.com
Views: 538467 TeachExcel
Formulas in Excel 2 - Round Numbers to Next Lowest Integer in Excel Using the INT Function
 
02:15
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Use the INT() function in Excel to quickly round any number to the next lowest integer. This is a great little function in Excel to quickly change decimals to integers or numbers with decimals to only integers. Note though that this function will only round the the next lowest integer and it will not round up. View the ROUND() function tutorial to see how to round to the nearest integer going up as well as down. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 29189 TeachExcel
Make a  Dynamic Gantt Chart in Excel- Dates Update Daily (Part 2 of 2)
 
07:50
http://www.TeachMsOffice.com Tutorial showing you how to make a Dynamic Gantt Chart and Frequency Distribution Chart which will update every day. Each day, the bars on the chart will change in size and color to show how many days left you have for a task or project. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website: http://www.TeachMsOffice.com
Views: 38788 TeachExcel
Excel Lookup/Search Tip 4 - Vlookup Explanation 3 - Vlookup to Assign Grades to Students
 
07:20
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Traditional VLOOKUP() function example in Excel. This tutorial teaches you how to assign grades to students using the Vlookup function in Excel. You will learn how to use the approximate setting of the range lookup for the vlookup. This is the last classic example of a basic use for the Vlookup function in Excel and is a walkthrough example of how to use Vlookup. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 22466 TeachExcel
Excel Macro Class 1 - Getting Started Programming Macros
 
15:47
Excel File: https://www.teachexcel.com/excel-tutorial/2059/excel-macros-class-1-getting-started-programming-macros?nav=yt Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt This is a practical class that gets you started with actually using and creating a macro on your own instead of focusing on the mundane details of things that won't help you right now. This is a hands-on tutorial and I invite you to download the sample file and work along so you can better learn how to do everything. After viewing this tutorial, you will be able to create your own very basic macro. TeachExcel.com
Views: 17793 TeachExcel
Quickly Resize Multiple Columns and Rows Quickly in Excel
 
05:06
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Visit https://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel video tutorial shows you how to automatically and quickly resize multiple columns and rows at once in Microsoft Excel. This includes resizing many columns and rows at once as well and automatically resizing an entire worksheet of columns and rows at once. This is a great tutorial for learning how to professionally and quickly format your Excel spreadsheets and worksheets. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 233811 TeachExcel
Create a Drop Down Menu with Data Validation in Microsoft Excel
 
05:34
http://www.TeachMsOffice.com This tutorial shows you how to create a drop down menu in excel. You will learn how to create a drop down menu whose contents comes from a list on the same tab or worksheet and also a drop down menu whose contents come from a list on a separate tab or worksheet in excel. This tutorial uses the data validation feature in excel as well as named ranges. This is a helpful introduction with tips on making drop-down menus in excel. To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions. Have a great day!
Views: 123594 TeachExcel
Data Analysis in Excel 7 - Quickly Import XML Files and Data into Excel
 
06:27
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt 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. This is a quick tutorial showing you how to import XML files into Excel but later tutorials will show you more tricks and tips for importing XML file data into Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 134036 TeachExcel
How to link two (multiple) workbooks and cells in Excel
 
08:11
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt More help: https://www.teachexcel.com How to link two or more workbooks and cells in Excel. Basically just cell linking between workbooks explained. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on TeachExcel.com
Views: 797466 TeachExcel
Excel Macros 1 - What is a Macro?
 
03:25
I explain what a Macro in Excel is, why you might want to use Macros in Excel, and I give you a simple example of a Macro and of the VBA code that was used to create it. For more: http://www.teachexcel.com
Views: 61334 TeachExcel
Finance Basics 4 - Calculating Annuities in Excel - Future Value for Annuities
 
06:31
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the total future value of a series of annuity payments. This is a must for finance majors as well as people who need to know the future value of and series of payments which they may be receiving. This tutorial covers this basic finance concept and shows you how to solve annuity problems by hand in Excel and also using the fv() future value function in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 75551 TeachExcel
Finance Basics 6 - Present Value Examples in Excel - How much something is worth today.
 
07:50
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial goes through 3 Present Value problems and shows you how to solve them using the PV() function in Excel. You will learn some of the basic applications for the present value function and also the different uses for this function. The three examples include how to figure out what a future amount is worth today; valuing annuity payments in the future for today; and how to value an asset with the present value function. This is a great tutorial for all of those just learning finance or for people who need to more accurately find the value of and asset or cash flow. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 73424 TeachExcel
Finance in Excel 4 - Calculate Straight Line Depreciation in Excel
 
03:08
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to calculate Straight Line Depreciation in Excel using the SLN() function. This is the first in a line of tutorials on how to calculate depreciation in Excel and therefore covers the most basic method of depreciation, which is the straight line method of depreciation. This is a good tutorial for those needing to improve their finance skills as well as to simply learn to apply them within the Excel environment. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 31529 TeachExcel
Generate Random Numbers with Decimals in Microsoft Excel
 
04:31
http://www.TeachMsOffice.com This tutorial shows you how to generate random numbers which have decimals in excel. This means the numbers will not just be integers; they will be decimals or fractions between two limits which you set. This is similar to the RANDBETWEEN() function except that that function only returns integers. Here, the RAND() function is used to create the decimal numbers in excel. To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions. Have a great day!
Views: 32806 TeachExcel
How to combine cells - Concatenate cells in Excel
 
07:00
More tutorials: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt How to use concatenation in excel to combine cell contents and including formulas within concatenation. Works well with large amounts of data. Often used when combining addresses - i.e. if you have 4 cells with 4 parts of one address and you want them to be in one cell, use the concatenation feature to do this quickly and consistently. Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website: TeachExcel.com
Views: 243303 TeachExcel
Combine/Consolidate Data Dynamically Between Seperate Excel files
 
06:48
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel Tutorials: https://www.teachexcel.com/src=yt How to consolidate data from multiple worksheets into one worksheet. This tutorial teaches you how to use the consolidate command in excel and shows you how to add sales data for parts from two different stores. This also teaches you how to consolidate the data so that it is dynamically linked and so that when any spreadsheet is updated, the consolidated worksheet will also be updated. Additionally, you can consolidate data from open or closed workbooks and also from different worksheets within the same workbook. To follow along with this tutorial and to get more free tutorials, free macros, and visit the forums, check out the website: http://www.TeachMsOffice.com
Views: 353503 TeachExcel
Excel Formatting Tip 2 - Highlight Unique or Duplicate Values with Conditional Formatting in Excel
 
04:31
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use Excel 2007's new features for conditional formatting to highlight the unique or duplicate values in a list of data within the spreadsheet. This is a great tutorial for users who need to regularly analyze large sets of data since it allows them to quickly identify if there are record entries that need to updated or changed. This is a simple and useful portion of the conditional formatting feature that anyone can use. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 36724 TeachExcel
Excel Tips 21 - Automatically Display the Current Date in Excel
 
03:05
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Visit https://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 will also learn how to format dates in Excel so that you can display the date exactly how you want to, in any format. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 108594 TeachExcel

Counter strike extreme v5 more guns mod

Counter strike madness interactive zombie mod A 10 games counter strike Maps in counter strike global offensive Counter strike global offensive russian to english Counter strike online play for free Counter strike global offensive gameplay german How to get ranked cs go Weapons mod for counter strike source Cs go for free non steam All weapons in counter strike nexon zombies Rutor counter strike global offensive Cs go aim ak 47 map Counter strike condition zero serial Vac banned for secure server cs go Cs go windows xp or 7 Cs go steam version free download Buy skins cs go credit card Counter strike source v 36 Counter strike cheats aimbot wallhack Free download counter strike 2013 for pc Cs go i have no words Counter strike 6 1 download Mod 10 counter strike source Counter strike 2016 for mac Trainers counter strike condition zero Wh aim counter strike source How to play cs go multiplayer Counter strike nexon zombies cheat Counter strike the real games Counter strike global offensive pc no steam Counter strike source ultra mod package 5 Cs go texture pack for minecraft Play counter strike games free Counter strike source map missing Counter strike unity 3d game Counter strike source pre alpha Counter strike source no sound download Counter strike condition zero full version pc free download Counter strike 1 6 release Counter strike zombie escape youtube Counter strike source v81 steam Counter strike source zombie mod Counter strike global offensive steamcmd Counter strike server list ip Ak 47 elite built cs go Counter strike condition zero com ua 4 3 cs go windows 10 Half life counter strike 1999 Torrent counter strike online edition Counter strike in minecraft plugin Counter strike team fortress half life Games action counter strike source Available memory less than 15 mb counter strike Cheats counter strike zero condition Map for counter strike 1 6 Cs go for mac free download Counter strike global offensive for mac free Counter strike global offensive patches Sxe injected counter strike download Counter strike source update error Play free counter strike global offensive How to fix cs go freezes Counter strike source no steam mods Counter strike source no steam v80 Counter strike condition zero weapons pack Counter strike games play online Counter strike download on mac Counter strike fatal error 15mb memory Cs go how to not lag For xtcs counter strike 1 6 Counter strike global offensive no steam mac os How to awp in counter strike How to do overwatch in cs go Palit gtx 750 ti cs go Half life counter strike indir Cs go free download ocean of games The best counter strike map Counter strike source mac x Counter strike source v88 wallhack Counter strike game unity 3d Counter strike zero condition game Counter strike for mac torrent Counter strike weapon free download Esl one katowice 2016 cs go Counter strike source mod skin Counter strike started as a mod Download free pc counter strike Anti cheat for counter strike source Counter strike indir full gezginler Sc counter strike s botami Counter strike source no facebook Cs go fatal error failed to connect with local steam client process Counter strike source mod by loki Cs go skins for free in csgo Counter strike source modern warfare 2 Steam free download for cs go Counter strike portable condition zero Counter strike in real life 3 Is counter strike on ps3 Download mods for counter strike source How to play free for all cs go Available at the counter strike A bit smarter multihack cs go 2016 Cs go launcher error unicode directory path Counter strike source by zloy pl ua Download mod for counter strike source Weapon mod for counter strike source Counter strike source v34 hack Do you level up in cs go Download condition zero counter strike Best games play counter strike Nvidia geforce gt 635m cs go Cs go gtx 1060 low fps Top 20 player cs go 2014 Can you draw in cs go Hide and seek cs go workshop Counter strike condition zero update Cs go fnatic vs envyus 2015 Counter strike source mod maps Intel core 2 duo cs go Download counter strike v6 extreme Counter strike source steam v34 Counter strike source v34 mansion Counter strike global offensive maps bots Download map counter strike zombie mod Download game counter strike xtreme Source engine 2 counter strike Counter strike condition zero kodlari Counter strike source gungame server Counter strike 2 pc game Dm ffa cs go aim of Counter strike bot add commands Counter strike 1 3 rus Cs go with intel hd 4000 Cs go pro players cfg 2015 Counter strike global offensive download no torrent Cs go dm pistol hs only Counter strike patch no steam Best counter strike 1 5 Cs go steam is not running Steam user is not allowed to join this server cs go Counter strike half life source Counter strike map fy iceworld Download counter strike game for free pc Free counter strike on steam Gtx 750 ti i5 cs go Dragon lore cs go how to get Counter strike 1 6 all cs Counter strike game com ua Download counter strike source no steam