Home
Videos uploaded by user “Launch Excel”
Excel Pivot Tables: How to flatten a cross tab table (aka unpivot / reverse pivot in Excel 2010)
 
02:53
Excel Pivot Tables: How to flatten a cross tab table (aka unpivot / reverse pivot in Excel 2010) Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Power Pivot Already know how to use Pivot Tables? Why not take yourself to the next level in data analysis with Power Pivot for Excel? Power Pivot greatly enhances your ability to analyse huge data sets and means you can do a lot more in Excel without having to move to a different data analytics package. If you want to learn how to use Power Pivot for Excel do check out this link: Go to this link for Power Pivot course - http://www.launchexcel.com/chandoo-power-pivot When you have a cross tab table you might want to flatten it to make it easier to analyse. This is also known as unpivoting or reverse pivoting or converting a summary pivot table into a normalized data table. In Excel 2003 you would use the pivot table wizard with Multiple consolidation ranges to do this. In Excel 2007 and 2010 the pivot table wizard is not accessible from the Excel ribbon, so you must either add a button to your quick access toolbar or use a keyboard shortcut to bring up the pivot table wizard (press ALT, press D, press P) As you watch the video tutorial you may find it helpful to pause, so you can follow along in Excel. If you found this video helpful, click on the like button or share it on Facebook and Twitter, or write a comment. Thanks! Victor P.S. Check out this link to an Unpivot Utility, if you are interested in doing this with multiple columns http://spreadsheet1.com/unpivot-data.html
Views: 88877 Launch Excel
Excel Macro Tutorial - Learn how macros can really speed up your work in Excel
 
09:39
Get FREE 28-page e-book "Record Your First Macro" here → https://www.launchexcel.com/get-excel-macros-ebook ----- // Episode Notes Read more at http://www.launchexcel.com/excel-in-first-gear This video is an introduction to the basics of Macros and VBA in Excel. When you see the power of macros you will want to learn how to use them yourself! Think of a macro as a tape recording. It remembers word for word what you "say" to Excel. VBA = Visual Basic for Applications. This is the language used by Excel to record macros. In the video we cover a simple use-case for the macro recorder: how to change your number formats. For an interesting example of pretty advanced VBA, check out the article on using Google Maps in Excel with VBA: http://www.launchexcel.com/google-maps-excel-demo/ This video uses this sound from freesound: ferrari355underhood4.mp3 by enginemusic -- http://www.freesound.org/people/enginemusic/sounds/43484/
Views: 606936 Launch Excel
Excel Tutorial: How to fill in empty cells using data from above, so you don't have any gaps left
 
03:17
Excel Tutorial: How to fill in empty cells using data from above, so you don't have any gaps left Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Fill in blank cells from above, two methods compared (1) manual copy / paste using the fill handle vs (2) using Excel's F5 Go To feature to select only blank cells. Read my blog post on this subject at http://www.launchexcel.com/fill-in-blank-cells-from-above/ *** Jump to 2:00 minutes, Step by Step Method using Shortcut Menu F5 *** - Select all of the values and blanks in column B by clicking on the column B header. - Press F5 to bring up the Go To menu. - Press Alt and S to select Special Cells. - Press Alt and K to select all Blank cells. - Type in the formula "equals cell above". - Press Ctrl and enter to fill the formula into all the blank cells selected. - Select column B by clicking on the column header. - Right click the selection border. - Drag the selection one column to the right. - Then drag the selection one column to the left. - Finally select paste as values to overwrite any formulas as values. As you watch the video tutorial part you may find it helpful to pause, if you want to follow along in Excel and try out the shortcuts. Remember to visit http://www.launchexcel.com to launch your Excel learning journey! Stopwatch visuals were obtained from www.online-stopwatch.com
Views: 112329 Launch Excel
Excel Quick Tip: How to add check marks to a table in Excel 2010
 
01:55
Excel Quick Tip: How to add check marks to a table in Excel 2010 Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Quick tip showing how to add checkmark icons to an Excel to do list, using Excel 2010's conditional formatting tool. This will also work for Excel 2007 but with a slightly different menu look. In Excel 2003 and earlier you'll need to insert a tick mark symbol using a font like Wingdings, and apply conditional formatting to that. As you watch the video tutorial you may find it helpful to pause, so you can follow along in Excel. Visit http://www.launchexcel.com to launch your Excel learning journey!
Views: 92115 Launch Excel
Excel Tip: Watermarks in Excel 2010 when you're printing more than one page
 
02:44
Excel Tip: Watermarks in Excel 2010 when you're printing more than one page Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Read about how to insert watermarks in Excel. There is no "watermark" feature in Excel so this video shows a trick to get your own watermark to appear on your printed spreadsheets. When you want the same watermark to appear on several pages you can insert a picture into the page headers. The picture is not visible when you edit the spreadsheet on screen, and it only becomes visible when you select print preview. Read my article for more step-by-step details on adding watermarks in Excel and lots of other tips and tricks for using Excel. http://www.launchexcel.com/watermark-in-excel/ (COMING SOON)
Views: 28393 Launch Excel
Introduction to Excel Macros - Record your first Macro in Excel (plus free e-book)
 
11:55
GET FREE e-book "Record Your First Macro in Excel" Visit this link → https://www.launchexcel.com/get-excel-macros-ebook —— // EPISODE NOTES In the first video of this series I will: ▸ Reveal the *hidden* ribbon tab that allows you to start developing Macros in Excel (this is a secret that most Excel users never learn!) ▸ Take you through the Launch Excel 3-stage formula for Recording your First Macro in Excel ▸ Show you how to create a simple Macro that you can use to audit your worksheets ▸Teach you a super speedy shortcut method for playing back your Macros ▸ You will learn how easy it is to start using Macros to automate Microsoft Excel. —— // LEARN MACROS WITH LAUNCH EXCEL Most Excel users never start using Macros because they either haven't heard of them, or feel overwhelmed because they think it's all too hard. This is a shame because Macros and VBA can give you Excel superpowers. You can save vast amounts of time by automating repetitive tasks and even create your own new functionality to do things that Excel does not do by itself. But... it sometimes looks like Excel Macros are so technical. Don't worry, in this video I will talk you through step-by-step how to record your very first Macro. —— // VISIT MY WEBSITE For more awesome tutorials on Microsoft Excel visit my website → www.launchexcel.com
Views: 41065 Launch Excel
Excel Macros & VBA: 2 Write your first Macro in Excel VBA using the VBA Editor
 
08:14
GET FREE 28-page e-book "Record Your First Macro in Excel" Visit this link → https://www.launchexcel.com/get-excel-macros-ebook —— // EPISODE NOTES In today's video I will: ▸ Show how to write a new one-line macro in Excel 2016 (and run it) in less than 2 minutes ▸ Explain how to step line-by-line through your macros in the VBA Editor (use the keyboard shortcut F8) ▸You will learn how easy it is to start writing Macros to automate Microsoft Excel. —— // LEARN MACROS WITH LAUNCH EXCEL Most Excel users never start using Macros because they either haven't heard of them, or feel overwhelmed because they think it's all too hard. This is a shame because Macros and VBA can give you Excel superpowers. You can save vast amounts of time by automating repetitive tasks and even create your own new functionality to do things that Excel does not do by itself. But... it sometimes looks like Excel Macros are so technical. Don't worry, in this video I will talk you through step-by-step how to write your very first Macro. —— // VISIT MY WEBSITE For more awesome tutorials on Microsoft Excel visit my website → www.launchexcel.com
Views: 12117 Launch Excel
Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 1 of 2
 
13:03
Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 1 of 2 Download the interactive workbook at http://www.launchexcel.com/vlookup-formula-explained/ The workbook shows how the VLookup formula works in different use cases. This tutorial tells you the basics of how to use the VLookup formula in Excel: - Understand VLOOKUP with a simple address book analogy - How to use VLOOKUP Exact Match - How to use VLOOKUP Approximate Match Get the full transcript of the video with further screenshots here http://www.launchexcel.com/vlookup-formula-explained/
Views: 96347 Launch Excel
Excel Pivot Tables: How to keep your Pivot Table number formats from being reset (Excel 2010)
 
06:06
Excel Pivot Tables: How to keep your number formats from being reset (Excel 2010) Power Pivot Already know how to use Pivot Tables? Why not take yourself to the next level in data analysis with Power Pivot for Excel? Power Pivot greatly enhances your ability to analyse huge data sets and means you can do a lot more in Excel without having to move to a different data analytics package. If you want to learn how to use Power Pivot for Excel do check out this link: Go to this link for Power Pivot course - http://www.launchexcel.com/chandoo-power-pivot I put together this video to show how we can format a Pivot Table values area so that custom number formatting does not get reset every time we add or remove fields. You can download a sample file here: http://www.launchexcel.com/preserve-pivot-table-number-format Here are some highlights for the video: 0:38 - It's quite hard to read the $USD figures when they are in General number format 0:50 - Let's format the values into Currency format 1:10 - That's fantastic we can read the $USD figures much easier now 1:17 - Now let's see how much Sales Tax we paid 1:23 - Oh no we lost the number format 1:58 - So the question is "How do we keep the number format the same even when we change the value field?" 2:12 - Here's my answer (see LaunchExcel article for step-by-step written instructions) 3:20 - One little note: You have got to make sure that your Pivot Table options are set to Preserve Cell Formatting on Update 3:32 - Check out the next great tip! What happens when you want to select the values area when you have lots and lots of values? 4:36 - Step-by-step instructions for selecting the values area If you want to learn more about Pivot Tables head over to my website at http://www.launchexcel.com Cheers, Victor P.S. The article and sample workbook can be found at: http://www.launchexcel.com/preserve-pivot-table-number-format
Views: 29164 Launch Excel
Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation
 
21:14
Excel Power Tips: Learn these useful Techniques for creating Lists, setting up Drop Down Menus and doing Data Validation in Excel. Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda Treach: Go to this link - http://www.launchexcel.com/moth-excel-expert Download sample workbook to follow along at: http://www.launchexcel.com/excel-dropdown-list-data-validation In this 20 minute episode we'll look at lists, drop downs and data validation. These are very important areas of Excel that you should master if you want to take your Excel skills to the next level. Read the accompanying article and download the sample workbook at www.launchexcel.com: http://www.launchexcel.com/excel-dropdown-list-data-validation Video Highlights: --- Excel Built-in Lists --- 0:10 Excel's Built-in Lists (Days of week, Months of year) --- Excel Custom Lists --- 1:06 Three use cases for Custom Lists 3:57 How to create a Custom List (instructions for Excel 2010) --- Dependent Drop-down Lists (Country, City) --- 5:08 Drop Downs for Data Entry 6:47 How to create Dependent Drop Downs with Data Validation and Named Ranges 9:38 TIP: How to define multiple Named Ranges 10:02 The "Slow" Way using the Name Manager 11:24 The "Fast" Way using CTRL + SHIFT + F3 14:09 Why do we need "Helper" columns? --- Data Validation (E-mail, Date of Birth) --- 15:40 Data Validation of Email addresses 18:20 Data Validation of Date of Birth (you must be at least 15 years old) 19:48 Warning: Data validation can be easily overwritten by Copy ➜ Paste and what to do about this
Views: 220883 Launch Excel
Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate
 
12:54
Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda Treach: Go to this link - http://www.launchexcel.com/moth-excel-expert Here are 10 top tips to make Data Entry faster and more accurate in Excel. Read the accompanying article on www.launchexcel.com: http://www.launchexcel.com/excel-data-entry-power-tips Video Highlights: --- Simple Data Entry --- 0:25 - Data Entry using Tab and Enter 1:00 - Fill down from above using CTRL + D 1:30 - Autocomplete using Tab key 2:10 - Show drop down list using ALT + Down arrow 4:15 - Enter values into multiiple cells using CTRL + Enter --- Excel Can Speak --- 5:19 - Get Excel to speak to you when you enter data! --- Data Entry Form --- 7:02 - Show the data entry form --- Keep Headers Visible --- 9:20 - Freeze Panes (ALT ➜ W ➜ F ➜ F) 10:20 - Split Window (ALT ➜ W ➜ S) 11:14 - Use Excel Table (CTRL + T to add table)
Views: 241885 Launch Excel
Excel Power Tips: 20 Tricks to help you become a Mouse Power User
 
13:06
Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda Treach: Go to this link - http://www.launchexcel.com/moth-excel-expert From the simple to the sophisticated we cover 20 top Excel tips. Make sure you read the accompanying article on www.launchexcel.com for more details: http://www.launchexcel.com/mouse-power-user-tricks-for-excel Video Highlights: --- Excel Ribbon Tricks --- 0:10 - Double click any Ribbon tab to toggle hide / show 0:50 - Use mouse scroll wheel to browse Ribbon menus --- Working with Worksheets --- 1:23 - Double click worksheet tab to rename 2:00 - Right click to show worksheet list in current workbook 2:15 - Select multiple worksheets using SHIFT or CTRL keys --- Locked Format Painter --- 4:00 - Double click to lock Format Painter tool (personal favorite) --- Editing Long Formulas --- 5:30 - Working with long formulas 6:45 - Selecting whole words and sentences using double click trick --- Fill Handle Tricks --- 7:15 - Basic fill handle dragging with left and right mouse buttons 7:48 - Double click fill handle to fill down to last row 8:18 - Fill a series of weekdays 8:30 - Fill a series growth trend (e.g. 1 2 4 8 16 32) --- Cell Range Tricks --- 9:35 - F2 to edit formula then drag formula cell ranges 9:50 - Double click on cell border to move to furthest part of table 10:12 - Hold SHIFT key and double click on cell border to select to furthest part of table 10:22 - Hold SHIFT key and single click to select range 10:42 - Hold CTRL key and click to select non-contiguous range 11:10 - Copy formulas and paste as values using mouse only 11:48 - Exchange position of columns or rows using SHIFT + drag (personal favorite)
Views: 108628 Launch Excel
Excel VBA Tutorial: Click on icon to run print preview (or any VBA code) by assigning macro to shape
 
11:02
DOWNLOAD WORKBOOK → https://www.launchexcel.com/media/samples/VBA/20180416-VBA_Click_Icon_To_Print.xlsm —— // EPISODE NOTES In this tutorial video we look at how to set up a Print Button on any Excel worksheet that launches Print Preview when it's clicked. Of course... you could use the normal Print function (with keyboard shortcut CTRL + P) for this purpose... ... but the value of this solution is that you can assign any VBA Macro to the Button and quickly run it from a worksheet. For example, you could run macros to: - Send off emails - Show help forms (with documentation for your spreadsheet) - Run automated reporting processes ... all with the click of a button on your worksheet. Here we use the .printout method to print the worksheet. Note: VBA = Visual Basic for Applications (Excel's built-in scripting language) —— // VIDEO TIMINGS 0:00 - Introduction 0:36 - Viewer Request Explained 1:33 - Overview of 7 steps 3:30 - Step 1 Insert Button (Form Control) 5:15 - Step 2 Set Button property to allow print object 5:31 - Step 3 Insert Printer Icon 6:18 - Step 4 Resize Printer Icon (and change color) 7:17 - Step 5 Group shapes together 8:08 - Step 6 Assign Macro 8:32 - Step 7 Write VBA Code 8:55 - Testing how the Print Button works —— // DOWNLOAD WORKBOOK FOR THIS TUTORIAL Please follow these instructions to learn from the workbook download: ▸ Download the sample Excel workbook: https://www.launchexcel.com/media/samples/VBA/20180416-VBA_Click_Icon_To_Print.xlsm ▸ Open the workbook and make sure to enable macros ▸ Follow the 7 steps on worksheet "Info" to create your own Print Icon ▸ Press ALT + F11 to open the VBA Editor ▸ Use F8 to step through the code in a subroutine (one line at a time) ▸ I suggest you adapt this to your own needs... just copy and paste the code, then change the code to work for you ▸ If you have a viewer request, leave me a comment below and I'll try to solve your problem in a new video —— // REFERENCES Excel Version: 2016 (used in video) —— // VISIT MY WEBSITE For more tutorials on Microsoft Excel and VBA visit my website → https://www.launchexcel.com Connect with me on Social Media → https://twitter.com/VictorChan_
Views: 7891 Launch Excel
Excel Project Timeline - Step by step instructions to make your own Project Timeline in Excel 2010
 
24:34
Excel Project Timeline - Step by step instructions to make your own Project Timeline in Excel 2010 The Launch Excel Timeline Template has been purchased by hundreds of professionals just like you. You can get your own copy by visiting - http://www.launchexcel.com/timeline-template-videos/ Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert This video is a 24 miunte in-depth explanation showing how I created a project timeline in Excel 2010. I take you step-by-step through most of the detail, and give helpful tips along the way. Also read my article which has additional information: "How to create a Project Timeline Template today in 10 simple steps using Excel 2010" http://bit.ly/xlv0Oz Enjoy! Victor P.S. Here's the purchase link again: http://www.launchexcel.com/timeline-videos/
Views: 616833 Launch Excel
Excel Quick Tip: Bullet in Excel using special fonts (2 of 5)
 
02:17
http://www.launchexcel.com/bullet-in-excel/ How to insert bullets in Excel (2 of 5). Use a special font like Wingdings to insert a bullet point in Excel. Choose Wingdings and type a lowercase letter "l" to insert a large round bullet in Excel. Lowercase "m", "n" and "w" also insert good Excel bullets. Read my article for the Ultimate Guide to Bullet Points in Excel http://www.launchexcel.com/bullet-in-excel/
Views: 11924 Launch Excel
Excel Quick Tip: Insert Excel bullet with custom cell formatting (3 of 5)
 
02:39
http://www.launchexcel.com/bullet-in-excel/ How to insert bullets in Excel (3 of 5). • Select your cell, right click and select Format Cells • Select Category: Custom • Enter the following in the box labelled "Type:" • @ Here are the exact things you must type in the box: (1) ALT + 7 = to insert a bullet point (must type 7 with number keypad) (2) (Space) = to insert a blank space (3) @ = placeholder to indicate where text goes Read my article for the Ultimate Guide to Bullet Points in Excel http://www.launchexcel.com/bullet-in-excel/
Views: 63187 Launch Excel
Excel Formula Basics: How to use the SUM, COUNT, AVERAGE formulas to set up summary tables
 
12:23
Excel Formula Basics: How to use the SUM, COUNT, AVERAGE formulas to set up summary tables Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Want to learn Excel formulas? Visit http://www.launchexcel.com/formula-1 The spreadsheet I used was adapted from a Vertex42 spreadsheet. Vertex42 is a leading provider of Spreadsheet Templates for Microsoft Excel, OpenOffice.org, and Google Docs. To browse through the Vertex42 collection please visit this link: http://www.launchexcel.com/vertex42-youtube Please bear in mind that this is an affiliate link so I will make some commission if you buy from the Vertex42 website. There's also a nice range of FREE templates that are well worth downloading too - enjoy!
Views: 518830 Launch Excel
Excel Dashboard Tutorial: Learn how to create drop-down menus for interactive Charts and Dashboards
 
17:01
Excel Dashboard Tutorial: Learn how to create drop-down menus to make useful interactive Charts and Dashboards If you want access to many high quality Excel Dashboard spreadsheet templates, I recommend you check out Excel guru "Chandoo" who spent months creating awesome Dashboard templates that you can use right now. Go to this link for awesome templates - http://www.launchexcel.com/chandoo-dashboard-templates And if you want to learn how to create Dashboards in Excel do check out this link: Go to this link for comprehensive dashboard course - http://www.launchexcel.com/chandoo-dashboard-email Download a sample workbook to follow along with the video from: http://www.launchexcel.com/excel-drop-down-for-dashboards Note: workbook created in Excel 2010 so if you use a different version of Excel you may experience different results In this 17 minute episode we'll discover how to create interactive charts and image lookups using drop downs in Excel. Read the accompanying article and download the sample workbook at www.launchexcel.com: http://www.launchexcel.com/excel-drop-down-for-dashboards Video Highlights: --- Dashboard Demo --- 00:07 Immeria Web Analytics Dashboard (note: this is shared under a non-commercial Creative Commons license by Stéphane Hamel at the Immeria Blog, please visit that site to obtain a free copy of the dashboard: http://blog.immeria.net/2008/08/even-more-web-analytics-dashboards-fun.html) --- Sample workbook --- 00:50 What's in the sample workbook 01:43 Chart source data = Launch Excel pageview data from Google Analytics --- Method 1 (Chart) --- 02:56 Drop down using Data Validation 03:23 Show the Name Manager (CTRL + F3) 04:48 Formulas that drive the chart --- Method 2 (Chart) --- 06:23 Drop down using Combo Box Form Control 07:24 Quick Tip: Hold ALT key to snap object to cell borders 07:48 Quick Tip: Hold CTRL to select form control 09:31 How to get the Developer Tab in Excel 2010 --- Method 3 (Flags) --- 10:05 Image lookup using Combo Box Form Control 13:24 OFFSET formula for image lookup 15:10 INDEX formula for image lookup (alternative) 15:50 How to insert and position the flag images
Views: 107035 Launch Excel
Excel Tutorial: How to use VBA to delete filtered rows (fast!!) ... but not delete hidden rows
 
13:53
DOWNLOAD WORKBOOK → https://www.launchexcel.com/media/samples/VBA/20180118-Delete-Filtered-Rows.xlsm —— // EPISODE NOTES In this tutorial video we look at how to delete (or remove) filtered rows in your Excel spreadsheets using the built-in programming language VBA (Visual Basic for Applications). I walk through two sample VBA macros. VBA Macro 1 - Applies two filter criteria to your worksheet autofilter, then deletes the VISIBLE filtered rows. VBA Macro 2 - Applies two filter criteria to your worksheet autofilter, then deletes the HIDDEN rows. Please follow these instructions to learn from the workbook download: ▸ Download the sample Excel workbook: https://www.launchexcel.com/media/samples/VBA/20180118-Delete-Filtered-Rows.xlsm ▸ Open the workbook and make sure to enable macros ▸ Press ALT + F11 to open the VBA Editor ▸ Use F8 to step through the code one line at a time ▸ I suggest you adapt this to your own needs... just copy and paste the code, then change the code to work for you ▸ If you have a viewer request, leave me a comment below and I'll try to solve your problem and create a new video —— // REFERENCES Excel Version: 2016 (used in video) —— // VISIT MY WEBSITE For more tutorials on Microsoft Excel and VBA visit the website → www.launchexcel.com
Views: 8131 Launch Excel
Excel Quick Tip: Text box bullet points in Excel (4 of 5)
 
01:10
http://www.launchexcel.com/bullet-in-excel/ How to insert bullets in Excel (4 of 5). You can add text box bullets in Excel quite easily. Just enter your text on separate lines, select the text and right click. Select the bullet point menu and choose your style of bullet. Read my article for the Ultimate Guide to Bullet Points in Excel http://www.launchexcel.com/bullet-in-excel/
Views: 30430 Launch Excel
The Way to Excel: Use a decision matrix to make better decisions
 
10:25
http://www.launchexcel.com/resources/decision-matrix/ A decision matrix is a tool that helps you to compare different options against criteria of your choosing. Highlights in the video: Principles 0:12 - What is a decision matrix? 0:35 - What product to buy? 1:21 - Criteria (objective or subjective) 1:55 - Simple decision matrix 2:20 - Launch Excel Redesign Spreadsheet 4:18 - Outline of Spreadsheet 4:43 - Enable macros & Fill in title 5:08 - Options along the top 5:35 - Criteria along the left 6:10 - Weightings 6:47 - Score Options 8:00 - Summary of Decision 8:18 - Was it a good decision? 9:01 - How the decision matrix helped 9:33 - Download the spreadsheet You can download a copy of my spreadsheet by visiting this page: http://www.launchexcel.com/resources/decision-matrix/ Read my articles at Launch Excel for more information: http://www.launchexcel.com/decision-matrix-1/ http://www.launchexcel.com/decision-matrix-2/
Views: 15754 Launch Excel
Excel Macros & VBA: 4 Introduction to the VBA Editor and hiding worksheets with the visible property
 
15:08
GET FREE 28-page e-book "Record Your First Macro in Excel" Visit this link → https://www.launchexcel.com/get-excel-macros-ebook —— // EPISODE NOTES In episode 4 I will: ▸ Introduce you to 6 parts of the VBA Editor (VBA = Visual Basic for Applications) ▸ Show you how to make sheets visible, hidden and VERY hidden (cannot be unhidden from normal Excel interface) ▸ Walk through a simple macro to Toggle sheets between visible and hidden ▸ You will learn how easy it is to start writing Macros to automate Microsoft Excel. —— // LEARN MACROS WITH LAUNCH EXCEL Most Excel users never start using Macros because they either haven't heard of them, or feel overwhelmed because they think it's all too hard. This is a shame because Macros and VBA can give you Excel superpowers. You can save vast amounts of time by automating repetitive tasks and even create your own new functionality to do things that Excel does not do by itself. But... it sometimes looks like Excel Macros are so technical. Don't worry, in this video I show you that the VBA Editor is a good tool for writing and testing code in Excel. And we have fun with hiding and unhiding worksheets. Cool! —— // VISIT MY WEBSITE For more awesome tutorials on Microsoft Excel visit my website → www.launchexcel.com - - - - - - - - - - Extra Notes - - - - - - - - - - 1. You can access the VBA Editor using the shortcut key combination ALT + F11 2. To step line-by-line through your macros in the VBA Editor use the keyboard shortcut F8 3. Here is the sample code for the macros to toggle worksheets between visible and hidden. It's here for entertainment purposes only. Please use reasonably, and remember to keep backups of your documents before you run macros on them. You need to copy and paste these into one code module, and you can assign the sub ToggleHide() to a Form Control Button in one of your workbooks. Remember to change the sheet names to ones in your own workbook (Sheet1, Sheet2, Sheet3) Remember it's a good idea to comment your code using the apostrophe (‘) at the start of a line or middle of a line. Excel will ignore everything after the apostrophe (‘) on any given line. ------------------------------------------------------------------ Sub ToggleHide() 'ASSIGNED: Form control button on worksheet "Visible" 'ACTION: Toggles worksheet visibility by showing and hiding sheets If Sheet3.Visible = xlSheetVisible Then Call HideSheets Else Call ShowSheets End If Sheet1.Activate End Sub ------------------------------------------------------------------ Sub HideSheets() 'Set Sheet1 to VISIBLE 'Set Sheet2 to HIDDEN - it can still be unhidden from Excel UI 'Set Sheet3 to VERY HIDDEN - it cannot be unhidden from Excel UI Sheet1.Visible = xlSheetVisible Sheet2.Visible = xlSheetHidden Sheet3.Visible = xlSheetVeryHidden End Sub ------------------------------------------------------------------ Sub ShowSheets() 'Make Sheet1, Sheet2, Sheet3 visible Sheet1.Visible = xlSheetVisible Sheet2.Visible = xlSheetVisible Sheet3.Visible = xlSheetVisible End Sub
Views: 6416 Launch Excel
Excel Project Timeline - 10 simple steps to make your own Project Timeline in Excel 2010
 
06:08
Excel Project Timeline - 10 simple steps to make your own Project Timeline in Excel 2010 The Launch Excel Timeline Template has been purchased by hundreds of professionals just like you. You can get your own copy by visiting - http://www.launchexcel.com/timeline-videos/ Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Background: If you are running a project it is important to be able to show how many tasks there are and when they are due to happen. This helps to explain key events in your project's life to team members and other people involved in the project. In my experience I've seen project managers show project tasks using Gantt charts, but here I offer an alternative - the simple project timeline tool. A project timeline shows how events relate to each other in time. Although timelines don't look as sophisticated as Gantt charts, they do a really good job at communicating the big picture. A well crafted project timeline can convey useful information relating to task progress and overall project progress. Read my article "How to create a Project Timeline Template today in 10 simple steps using Excel 2010" http://bit.ly/xlv0Oz Enjoy! Victor P.S. Here's the purchase link again: http://www.launchexcel.com/timeline-videos/
Views: 85029 Launch Excel
Google Maps in Excel ➜ Demo Workbook
 
04:59
Download sample workbook to follow along at: http://spreadsheet1.com/map--street-view-api.html In this 5 minute video we check out a cool little demo spreadsheet that takes a Point of Interest and creates a panorama of that location by pulling together four Google StreetView images. It also shows the location on two Static Maps (Road and Satellite). The demo spreadsheet uses VBA (Visual Basic for Applications) to fetch images from the Google Maps database of images using URLs generated from the selected Point of Interest. You can read more about the spreadsheet and VBA at www.launchexcel.com http://www.launchexcel.com/google-maps-excel-demo Video Highlights: 0:28 Launch application from Custom Ribbon Tab "Map Panorama" 1:20 Point of Interest: Buckingham Palace 2:12 Visual representation of what the application does 2:40 VBA Sub StreetViewPanarama(...) 3:52 VBA Sub GoogleStaticMap(...) Image Credits in Video: King's College Cambridge by Sarah under the Creative Commons License Attribution 2.0 Generic (CC BY 2.0) http://www.flickr.com/photos/dichohecho/2625539960/ Buckingham Palace by Peter Robers under the Creative Commons Attribution 2.0 Generic (CC BY 2.0) http://www.flickr.com/photos/peter_roberts/5427705008/sizes/s/in/photostream/
Views: 12119 Launch Excel
Excel Quick Tip: Smart Art bullet points in Excel (5 of 5)
 
02:06
http://www.launchexcel.com/bullet-in-excel/ How to insert bullets in Excel (5 of 5). Go all out and dress to impress with Excel SmartArt. SmartArt gives you stunning ways to easily add bullet points to Excel. Read my article for the Ultimate Guide to Bullet Points in Excel http://www.launchexcel.com/bullet-in-excel/
Views: 4441 Launch Excel
Excel Quick Tip: In-cell bullet points in Excel (1 of 5)
 
01:09
http://www.launchexcel.com/bullet-in-excel/ How to insert bullets in Excel (1 of 5). Add a round bullet in Excel by typing ALT + 7 on the number keypad. There are other key combinations you can use such as ALT + 249, or ALT + 0149 but why type those extra numbers when ALT + 7 works just fine? Read my article for the Ultimate Guide to Bullet Points in Excel http://www.launchexcel.com/bullet-in-excel/
Views: 13049 Launch Excel
Excel Tip: How to insert a watermark in Excel 2010
 
01:43
Excel Tip: How to insert a watermark in Excel 2010 Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Read about how to insert watermarks in Excel. There is no "watermark" feature in Excel so this video shows a trick to get your own watermark to appear on your printed spreadsheets. This works well when you only have one page to print but it gets more difficult if you have several pages to print. Read my article at http://www.launchexcel.com/watermark-in-excel/ to find out how to deal with getting watermarks on many pages (COMING SOON)
Views: 72219 Launch Excel
Excel Macros & VBA: 3 Learn simple Excel VBA using the Macro Recorder
 
17:39
GET FREE 28-page e-book "Record Your First Macro in Excel" Visit this link → https://www.launchexcel.com/get-excel-macros-ebook —— // EPISODE NOTES In episode 3 I will: ▸ Reveal that the Macro Recorder tool can be used to learn simple Excel VBA ▸ Demonstrate the types of Excel statements the Macro Recorder can write ▸ Explain what the Excel Macro Recorder cannot do for you ▸ You will learn how easy it is to start writing Macros to automate Microsoft Excel. —— // LEARN MACROS WITH LAUNCH EXCEL Most Excel users never start using Macros because they either haven't heard of them, or feel overwhelmed because they think it's all too hard. This is a shame because Macros and VBA can give you Excel superpowers. You can save vast amounts of time by automating repetitive tasks and even create your own new functionality to do things that Excel does not do by itself. But... it sometimes looks like Excel Macros are so technical. Don't worry, in this video I show you that the Macro Recorder tool can be a good friend for learning the Macro language of VBA (Visual Basic for Applications) —— // VISIT MY WEBSITE For more awesome tutorials on Microsoft Excel visit my website → www.launchexcel.com - - - - - - - - - - Extra Notes - - - - - - - - - - 1. You can access the VBA Editor using the shortcut key combination ALT + F11 2. To step line-by-line through your macros in the VBA Editor use the keyboard shortcut F8 3. Here is the sample code for two worksheet event handlers. It's here for entertainment purposes only. Please use cautiously, and remember to keep backups of your documents before you run macros on them. You need to copy and paste these into worksheet modules, not code modules. When you want to stop them, just delete the code from the module. Or comment it out using the apostrophe (‘) at the start of a line. Excel will skip over comment lines that start with an apostrophe (‘) ------------------------------------------------------------ Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub Dim i As Integer i = Target.Interior.ColorIndex Select Case i Case -4142 i = 1 Case 0 To 55 i = i + 1 Case Is > 55 i = 0 End Select Target.Interior.ColorIndex = i End Sub --------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) Target.Interior.ColorIndex = 1 'black End Sub
Views: 8577 Launch Excel
Excel Tutorial: Use VBA to instantly change row height based on value entered in worksheet cell
 
15:53
DOWNLOAD WORKBOOK → https://www.launchexcel.com/media/samples/VBA/20180315-Change-Row-Height.xlsm —— // EPISODE NOTES In this tutorial video we look at how to automatically change row height by changing the value of a cell on your Excel worksheet using the built-in programming language VBA (Visual Basic for Applications). We use a Worksheet_Change event to drive the automatic update. I walk through two sample VBA Subroutines. VBA Sub 1 - Automatically changes row height for ONE row. VBA Sub 2 - Automatically changes row height for MANY rows. —— // VIDEO TIMINGS 0:00 - Introduction 0:41 - Viewer Request Explained 2:00 - Worksheet Change Macro 4:15 - VBA Sub 1 Update_Row_Height 7:03 - How to Enter Worksheet Change Events (VBA Editor) 9:59 - Demo: Multiple Rows 10:51 - VBA Sub 2 Update_Row_Height_Range1 14:01 - Test Subroutines 15:40 - Outro —— // DOWNLOAD WORKBOOK FOR THIS TUTORIAL Please follow these instructions to learn from the workbook download: ▸ Download the sample Excel workbook: https://www.launchexcel.com/media/samples/VBA/20180315-Change-Row-Height.xlsm ▸ Open the workbook and make sure to enable macros ▸ Press ALT + F11 to open the VBA Editor ▸ Use F8 to step through the code one line at a time ▸ I suggest you adapt this to your own needs... just copy and paste the code, then change the code to work for you ▸ If you have a viewer request, leave me a comment below and I'll try to solve your problem in a new video —— // REFERENCES Excel Version: 2016 (used in video) —— // VISIT MY WEBSITE For more tutorials on Microsoft Excel and VBA visit the website → www.launchexcel.com
Views: 4394 Launch Excel
Excel Formula Tutorial: How to use the SUMIF, COUNTIF, AVERAGEIF formulas to analyse data in a list
 
06:22
Excel Formula Tutorial: How to use the SUMIF, COUNTIF, AVERAGEIF formulas to analyse data in a list Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Free articles on learning Excel. Visit http://www.launchexcel.com/ Sumif, Countif and Averageif help you to analyse data in a list that matches the conditions you specify. Named ranges make it simpler to read formulas and easily enter large ranges. Together they make a simple and powerful combination in Excel. For more information see http://www.launchexcel.com/formula-basics-sum-count-average-if Highlights in the video: 0:58 - Named range tricks (Ctrl + F3 to bring up name manager, Ctrl + Shift + F3 to create named range from selection) 1:52 - Create unique list of names (using Excel's Remove duplicates feature, available in Excel 2007+) 2:30 - Set up data validation drop down list, sourced from a defined named range 3:35 - SUMIF() formula (total lifetime sales) 4:21 - COUNTIF() formula (number of months with sales) 5:04 - AVERAGEIF() formulas (average monthly sales) 5:49 - Using drop down list to select new sales person, formulas automatically recalculate You can discover more Excel tips and tricks to make you productive in Excel by visiting my website at http://www.launchexcel.com
Views: 12629 Launch Excel
Excel VBA: How to quickly close multiple code windows in the VBA Editor
 
03:02
Here's the code to copy and paste: ------------------------------------------------------------------ Sub Close_All_VBE_Windows() 'CR v5207 '// Source: https://access-programmers.co.uk/forums/showthread.php?t=293239 '// Posted: Apr 18, 2017 '// Thanks to: Colin Ridders (https://access-programmers.co.uk/forums/member.php?u=143597) ' '// Modified by Victor Chan Dec 15, 2017 '// PURPOSE: Closes all VBE windows except this one ' '// Note: Needs library 'Microsoft Visual Basic for Applications Extensibility' '// 1. Click on Tools ... References in the VBE '// 2. Scroll down and tick the entry for Microsoft Visual Basic for Applications Extensibility 5.3 On Error GoTo Err_Handler Dim vbWin As VBIDE.Window For Each vbWin In Application.VBE.Windows If (vbWin.Type = vbext_wt_CodeWindow Or _ vbWin.Type = vbext_wt_Designer) And _ Not vbWin Is Application.VBE.ActiveWindow Then vbWin.Close End If Next Exit_Handler: Exit Sub Err_Handler: 'CR 02/02/2016 - added error handling to fix issue in 64-bit Office If Err.Number = 424 Then Resume Next 'object required MsgBox "Error " & Err.Number & " in Close_All_VBE_Windows procedure: " & Err.Description Resume Exit_Handler End Sub ------------------------------------------------------------------ —— // EPISODE NOTES Please follow these instructions: ▸ Copy and paste the code into a Personal Macro workbook module ▸ Click on Tools ... References in the VBE ▸ Scroll down and tick the entry for Microsoft Visual Basic for Applications Extensibility 5.3 ▸ Run the code (F5) and it will close every code window except the active window —— // REFERENCES The VBA code was from the following page: https://access-programmers.co.uk/forums/showthread.php?t=293239 Thanks Colin Ridder for sharing! —— // VISIT MY WEBSITE For more tutorials on Microsoft Excel and VBA visit the website → www.launchexcel.com
Views: 1159 Launch Excel
Excel Auto Filter: How to quickly filter tables + keyboard shortcut to get even faster
 
06:41
Excel Auto Filter: How to quickly filter tables + keyboard shortcut to get even faster Advanced Excel Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Take a look at the Excel Expert course by Mynda Treacy: Go to this link - http://www.launchexcel.com/moth-excel-expert Using the auto filter, and a keyboard shortcut for applying and clearing filtered items. Best viewed in 720p Expanded. You can download a sample workbook with the GNI data in the video, from this page on Launch Excel http://www.launchexcel.com/autofilter-keyboard-shortcut-video/ *** Link to World Bank website *** http://data.worldbank.org/indicator/NY.GNP.PCAP.CD *** Keyboard shortcut *** Ctrl + Shift + L (toggle filters on/off) As you watch the video you may find it helpful to pause and try out the steps in your own Excel workbook. Remember to visit http://www.launchexcel.com to launch your Excel learning journey!
Views: 51816 Launch Excel
Excel VBA Tutorial: Find the Last Cell, Row or Column on a Worksheet
 
24:40
READ BLOG POST → https://www.launchexcel.com/excel-vba-find-the-last-cell-row-or-column-on-an-excel-worksheet DOWNLOAD WORKBOOK → https://www.launchexcel.com/media/samples/VBA/20180606-VBA_Find_Last_Cell_Row_Column.xlsm VIDEO TIMINGS (See Below... VBA CHEAT SHEETS → https://www.launchexcel.com/excel-vba-cheat-sheets —— // EPISODE NOTES In this tutorial video we look at four ways to find the Last Cell, Row or Column on any Excel worksheet using VBA. #1 - Range.SpecialCells : Find the last USED cell (note: last used cell may be different from the last non-blank cell... e.g. if you change font or color then Excel treats that as a used cell even if there's no data in it) #2 - Range.End : Like using CTRL + Arrow (watch out... can be confused by blank cells in your data set) #3 - Range.Find : Like using CTRL + F to bring up the Find & Replace dialog box to search for "*" asterisk wildcard character... except we start in A1 and go backwards instead of forwards #4 - Custom Function (UDF) : Create your own User Defined Function to handle multiple situations easily (my UDF does last cell, row or column depending on what you enter into the first parameter) Note: VBA = Visual Basic for Applications (Excel's built-in scripting language) If you're totally new to Excel Macros & VBA... get my FREE e-book at this link (plus subscribe to my email newsletter): DOWNLOAD EBOOK → https://launchexcel.lpages.co/first-macro-ebook —— // VIDEO TIMINGS 0:00 - Introduction 0:30 - Quick announcement (visit my blog post https://www.launchexcel.com/excel-vba-find-the-last-cell-row-or-column-on-an-excel-worksheet) 0:53 - Option #1 SpecialCells - introduction 1:17 - Option #1 SpecialCells - VBA code 1:47 - Option #1 SpecialCells - last used cell vs last non-blank cell 3:26 - Option #1 SpecialCells - refresh used range in VBA without saving 3:56 - Recap 4:10 - Option #2 Range.End - introduction 5:00 - Option #2 Range.End - keyboard shortcut equivalent 5:52 - Option #2 Range.End - VBA code 7:22 - Option #2 Range.End - last row and column on GOOD data 7:43 - Option #2 Range.End - last row and column on BAD data 8:41 - Option #3 Range.Find - introduction 9:20 - Option #3 Range.Find - VBA code for last ROW 11:29 - Option #3 Range.Find - run macro for last ROW 11:54 - Option #3 Range.Find - how it works (illustration) 12:34 - Option #3 Range.Find - VBA code for last COLUMN 13:13 - Recap 13:41 - Option #4 User Defined Function - introduction 14:05 - Option #4 User Defined Function - VBA code parameters 14:42 - Option #4 User Defined Function - VBA code part 1 - setting defaults 15:48 - Option #4 User Defined Function - tongue twister! 16:14 - Option #4 User Defined Function - error handler 16:44 - Option #4 User Defined Function - VBA code part 2 - select case 17:02 - Option #4 User Defined Function - VBA code part 3 - ROW 18:04 - Option #4 User Defined Function - VBA code part 4 - COL 18:55 - Option #4 User Defined Function - VBA code part 5 - CELL 20:34 - Option #4 User Defined Function - use in VBA subroutine 21:51 - Option #4 User Defined Function - use in worksheet formulas 23:10 - Recap 23:21 - Question: Have you ever struggled to...? 23:30 - VBA Cheat Sheets! —— // DOWNLOAD WORKBOOK FOR THIS TUTORIAL Please follow these instructions to learn from my free sample workbook: ▸ Download here: https://www.launchexcel.com/media/samples/VBA/20180606-VBA_Find_Last_Cell_Row_Column.xlsm ▸ Open the workbook and make sure to enable macros ▸ Click on "Get Started" button to see Overview sheet ▸ Press ALT + F11 to open the VBA Editor ▸ Use F8 to step through the code in a subroutine (one line at a time) ▸ I suggest you adapt this to your own needs... just copy and paste the code, then change the code to work for you ▸ If you have a viewer request, leave me a comment below and I'll try to solve your problem in a new video —— // REFERENCES Excel Version: 2016 (used in video) —— // VISIT MY WEBSITE For more tutorials on Microsoft Excel and VBA visit my website → https://www.launchexcel.com Connect with me on Social Media → https://twitter.com/VictorChan_
Views: 1744 Launch Excel
Learn Excel functions fast with the Formula 1 E-Book
 
05:33
http://www.launchexcel.com/formula-1/ Read my article for the full transcript http://www.launchexcel.com/formula-1-ebook/ Download the Formula-1 E-book from Chandoo's online shop, learn 75 Excel functions for only $10 (USD) http://www.launchexcel.com/formula-1/ Formula-1 E-book features: - 19 math functions including sum, count, average, countif - 10 logic functions including If, And, Or, Not, Choose, Iferror - 15 text functions including concatenate, left, mid, right, proper, substitute - 6 lookup functions including vlookup, hlookup, match - 8 statistical functions including min, max, small, large - 12 date & time functions including today, now, networkdays, weekday - 5 financial functions npv, fv, pmt, ipmt, ppmt Remember to visit http://www.launchexcel.com/ to launch your Excel learning journey!
Views: 7700 Launch Excel
Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 2 of 2
 
14:56
Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 2 of 2 Download the Sample workbook to follow with the video - visit this page on my website - http://www.launchexcel.com/dynamic-vlookup-formula-examples/ This tutorial helps you learn 3 ways to write a VLookup formula to make it dynamic. - Simple method (type in numbers for column index number) - Using COLUMN function to specify column index number - Using MATCH function to specify column index number You can find the full video transcript with more screenshots here: http://www.launchexcel.com/dynamic-vlookup-formula-examples/
Views: 20700 Launch Excel
Excel Dashboard Course Review: MyOnlineTrainingHub.com online video course
 
19:30
This is a review of the Excel Dashboard course created by Mynda Treacy at http://www.launchexcel.com/myhub-dashboard You can find a full transcript of my video review with further screenshots of the course material at http://www.launchexcel.com/myonline-traininghub-dashboard-course-review
Views: 7165 Launch Excel
Excel Power Tips - Coming Soon!
 
01:48
Visit this link http://www.launchexcel.com/excel-power-tips-announcement-1/ To find out more about the Excel Power Tips course
Views: 3191 Launch Excel

Wellbutrin 150 mg daily
Cardura generico regulator
Fertomid 100 mg
Pram 20 mg erfahrungsberichte
Como se toma tinidazole 500mg prices