সম্পূর্ণ Microsoft Excell Learning ভিডিও Tutorial

সাম্পুরন Microsoft Excell Learning  ভিডিও টিউটরিইয়াল । 
 Learn Excel from the fast-paced free video lessons from Mr Excel. all.High quality, totally free Microsoft Excel 2007 tutorial videos. Easy help and exercises for beginners excell dummies and advanced software.,Free Excel Video Tutorial - Basic Skills. The site also provides support materials for our book: Learn Excel 2007 With The Smart Method.Free Microsoft Excel Video Tutorials From MS and Others.You can use this free online tutorial to learn Microsoft Excel 2007. Click here to start the tutorial. If you are using an older version of Excel, ...New! Excel Recorded Webinars 10 Must Have VBA Skills. Excel Basics Using "Paste Special" · Using Text to Columns · Tips on Filtering with "AutoFilter" ...VIDEO TUTORIALS. Video Home ... Excel 2003 · Excel 2007 ... The video tutorials are NOT included with the resource subscription licence ...These Excel 2003 Video Tutorials will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, ... 
Excel Video Lessons
You don't need to go spend an entire day at the local computer chain store to learn Excel. There are over 600 quick (2-4 minute) lessons available here, for free.Directory of Excel video tutorials from Mr Excel

• Show Full Menus All of the Time - Show full menus in Excel 2003 and earlier.
  
• Excel Standard & Formatting Toolbars - Quit hiding half the toolbar icons.
  
• New Icons - Add favorite icons to your toolbars.
  
• Secret Menu Items - Hold down the shift key to find secret menu items.
  
• Recent Files - Increase the number of files in the recently used file list
  
• Workspaces - Group files into a workspace so you can open them with one command.
  
• Cursor Direction - Change the direction that the cursor moves.
  
• See Headings - See Row 1 all the time as you scroll down.
  
• See Columns - See column A all the time as you scroll right.
  
• Print Titles - Print row 1 at the top of every page.
  
• Print Titles II - Select column headers from the middle cells on a p...
  
• Footers - Headers & Footers - Add text to print at the top o...
  
• Page Numbers - Change a multiple page report to print as one page...
  
• Arrange Windows - Arrange windows to see data from two or more open ...
  
• Arrange Worksheets - Arrange windows to view two worksheets in an open ...
  
• Default Workbooks - Have Excel always open certain workbooks. Episode ...
  
• Startup Switches - Set up Excel icons to open a specific file on star...
  
• Customize Startup - Use a simple macro to further customize startup wh...
  
• Customize Defaults for New Workbooks - Do you ALWAYS turn on Page 1 of n as your footer? ...
  
• Open a Copy - Open a copy of a workbook to make sure you don't a...
  
• Finding a File - Can't find a file? Use the file open command to so...
  
• Suppress Update Links - Suppress the update links message alert box when s...
  
• Send E-Mail - Send Excel file via e-mail as an attachment direct...
  
• Export Data - Export Excel Data for Other Applications - Do you ...
  
• Faster Macros - Have Excel calculate Excel macros faster by instal...
  
• Word Processing - Use Excel as a word processor to properly format t...
  
• Spell Check Region - Spell check only specified region or text instead ...
  
• Hyperlink Menu - Create an easy to use menu by inserting hyperlinks...
  
• Paste Special - There is a lot of power in the various PasteSpecia...
  
• Custom Toolbar - Create a totally new toolbar customized with the i...
  
• Reset Toolbar - Learn how to use the customize dialog box to reset...
  
• Best Trick Ever - Quickly copy a formula to all rows of data. Have y...
  
• Turn Data On Its Side - Quickly copy a formula to all cells in a row. Then...
  
• Stop Autocorrecting - Stop Excel from autocorrecting certain words. Epis...
  
• AutoCorrecting - Typing the same, long word over and over in a repo...
  
• Track Changes Woes - Track Changes is a fantastic feature in Word. It i...
  
• Copy to Worksheets - Let the Fill Across Worksheets command copy data f...
  
• Talk with Excel - Have Excel talk to you! Excel will read back data ...
  
• Special Symbols - Learn how to insert special symbols into your Exce...
  
• Numbers as Text - Have Excel find numbers stored as text. Episode 14...
  
• Relative References - Have Excel copy a formula to other cells using rel...
  
• Absolute References - How to have a cell reference in a formula always p...
  
• Mixed References - Sometimes you need a formula to always point to a ...
  
• References - Create formulas using relative, absolute, and mixe...
  
• Faster Dollar Signs - Use a shortcut to simplify dollar sign entries in ...
  
• R1C1 References - Learn Excel's R1C1 referencing to understand formu...
  
• Named Ranges - Create easier to understand formulas with named ra...
  
• Named Constants in Excel - While many know that you can assign a Name to a ce...
  
• Natural Language Formulas - Natural Language Formulas - Create formulas using ...
  
• Natural Language Formulas II - Part II of Natural Language Formulas shows you how...
  
• Named Formulas - A reader has a similar formula in thousands of cel...
  
• Total without Formulas - When your manager calls on the phone and starts dr...
  
• Quickly Average Without a Formula - The quick sum feature discussed in episode 152 has...
  
• Add two columns without using formulas - Use the Add option on the PasteSpecial dialog to a...
  
• Calculate Sales Over Quota - An introduction to using the IF function to change...
  
• Text Calculations in Excel - Use Excel to calculate text. In this podcast, lear...
  
• Break apart a column - Use the LEFT function to return just the left-most...
  
• MID Function - If you need to extract characters from the middle ...
  
• Get characters up to the Dash - The Left, Mid, Right functions are great, but what...
  
• Get characters after the Dash - Yesterday's podcast showed how to use LEFT and FIN...
  
• Get characters after the 2nd Dash - Another twist today - how to get characters that o...
  
• Use TextToColumns to Parse - Use the TextToColumns Wizard to eliminate the need...
  
• Joining Text and Paste Special Values - Have you ever deleted a column, only to find out t...
  
• Random numbers in Excel - Sometimes you need to create random numbers for a ...
  
• Sort to a Random Sequence in Excel - Another great feature of the Rand Function is sort...
  
• Create a Dice Simulation in Excel - Use the random number generator to create dice in ...
  
• Creating Random Letters in Excel - Not only does the Rand Function create/sort random...
  
• Convert Numbers to Text - Are your numeric entries sorting in the wrong plac...
  
• Calculate a Loan Payment - Buying a cool new car or a house? Use Excel to cal...
  
• Calculate Many Scenarios for Loan Payments - Want to see calculations of a loan payment if diff...
  
• Get Help on Any Function While Entering a Formula - Instant help with function arguments: Do you remem...
  
• Finding Functions - Confused when your manager asks you to do some str...
  
• Three Methods of Entering Formulas - There are THREE popular ways for entering formulas...
  
• AutoSum - Use the AutoSum button to quickly total columns of...
  
• AutoSum Woes - Why the AutoSum icon doesn't always work. Learn th...
  
• AutoAverage? - Yes - you can use the AutoSum icon to find average...
  
• Who Taught Excel How to Count? - Why does Excel say I have two cells when any seven...
  
• Number My List - How to add numbers to a list so that the numbers w...
  
• Rank Function - Do you need to determine where you rank in a list?...
  
• Sorting With A Formula - Need a Top Sellers Report? Use the VLOOKUP Functio...
  
• Kissing Your Sister - Ties can really screw up the RANK function. Learn ...
  
• Commenting a Formula - Have you just racked your brain to figure out an o...
  
• Calculate a Moving Average - When you are trying to analyze product demand for ...
  
• Straight Line Estimate - One of the simplest ways of forecasting is to assu...
  
• Multiple Regression - Why does Sally's ice cream stand either have a boo...
  
• Debug a Formula - Do you have a complicated formula? Use the F9 key ...
  
• Quick Calculator - One of the simplest tricks in Excel. See how to do...
  
• Formula Frustrations! - Frustrated because you've entered a formula and in...
  
• Calculate Percentage of Total - How to enter a formula to calculate percentage of ...
  
• Running Percentage of Total - I hate it when a calculation requires two differen...
  
• Powers in Excel - Exponents gave me headaches in math class, but the...
  
• The Root of the Problem - How to calculate square roots, cube roots, fourth ...
  
• Growth Rate - Your company is growing, but how fast? The formula...
  
• Like a Big Pizza PI - Whether you are figuring out the best pizza deal o...
  
• Starbucks or the Lottery? - I spend a couple bucks a day on Starbucks, UNLESS ...
  
• Steven Spielberg - Question: What do Steven Spielberg, an 8th grade m...
  
• Max, Abs and Forecast Error - Bill Jelen is the only guy on the planet who wants...
  
• Round Up to the Nearest 5 - Today, MrExcel handles yet another maddening reque...
  
• Floating Along - Why does that simple price show up as $2.099999999...
  
• When 2 + 2 = 5 - Are you updating numbers in your worksheet but the...
  
• Order of Operations - Excel has a certain order that it will perform a c...
  
• Claiming Dependents - It is tax time, but THESE dependents are not the k...
  
• Finding Precedents - When you have a large formula, all of the cells th...
  
• More Precedents - Use the Formula Auditing tools to find all of the ...
  
• Slow Motion Instant Replay - Rather than drawing a million blue arrows on your ...
  
• Time Formats - Learn the obscure formats to make your time calcul...
  
• Time Entered as Text - Someone entered a million time values as text. How...
  
• Time as Text Part 2 - In today's episode, someone keyed in hundreds of c...
  
• Relay Races - 10 runners each ran for about 3 minutes and Excel ...
  
• Daily Dates to Month - Make a series of daily dates appear as a month. Ep...
  
• Daily Dates to Months for Real - OK....the trick that I used in podcast 210 happene...
  
• Last day of February? - How can you convert a date to the last day of the ...
  
• Set up a Simple Time Sheet - What? I work hard all week and Excel can't add up ...
  
• Lucent or Lucille Ball - Learn how to compare two list to find an exact mat...
  
• Using VLOOKUP instead of MATCH - Use VLOOKUP to find the exact match when comparing...
  
• Matching Customers Using VLOOKUP - Compare and then add new customers and update reve...
  
• Gotchas when using VLOOKUP - Is VLOOKUP not finding all your entries? Find out ...
  
• COUNTIF - If you need to count records, use the COUNTIF func...
  
• Headcount by Department - I hate when senior managers ask for headcount by d...
  
• Age Discrimination - I can't help but thinking that this request is goi...
  
• Total Sales by Rep - Use the SUMIF function to figure out the total sal...
  
• Sales by Product and Rep - As you learned this week, SUMIF and COUNTIF are th...
  
• Ctrl+Shift+Enter - Learn about super-powerful amazing formulas that y...
  
• Bonus Payments - How to use Logical Formulas, along with the AND an...
  
• Down with IF - Use an old boolean logic trick to eliminate the IF...
  
• SumIf with 2 Conditions - Once someone learns SumIf they soon want to know h...
  
• Lake Wobegon - In Lake Wobegon, they say that all of the students...
  
• Beat Bob Barker - Rather than play the higher/lower game with Excel ...
  
• Protect Formulas - How to protect only the formula cells in your work...
  
• List Format - Set up your data for flawless use of items on the ...
  
• Two Rows in One Cell - If you need a long heading in a single cell, use t...
  
• Sorting Data - How to sort data in Excel. Episode 232 shows you h...
  
• Six-Way Sort - The Sort dialog only allows a three level sort. Ep...
  
• Custom Sort - Sort data into a custom sequence to match the conv...
  
• Quickly Find Records - Use the AutoFilter feature to quickly find records...
  
• Unique List - Use the Advanced Filter to generate a unique list ...
  
• Filtering Criteria - Use the Advanced Filter with a criteria. Episode 2...
  
• Adding Subtotals - An AMAZING trick for adding subtotals to a dataset...
  
• Just the Customer Totals - After using the Subtotals function, look for three...
  
• Visible Cells Only - After yesterday's podcast, I am sure you tried to ...
  
• Old Accountant's Trick - Today, I am appearing at the IMA Continuing Educat...
  
• Count Revenue - Subtotals worked great all week, but today we enco...
  
• Scroll Click Click Click - Using the automatic subtotals is a huge timesaver,...
  
• Totals Up - Sometimes, you might want your automatic subtotals...
  
• Manager Bliss - Today's episode discusses an obscure trick to add ...
  
• GPF with co-stars - NateO and Starl join me in Toronto to discuss the ...
  
• Subtotals Times Two - When you need to subtotal by two different fields,...
  
• Subtotals Pop - Make your subtotals pop out at the reader. I'll us...
  
• Blank Row After Each Subtotal - This is a really easy request, but is incredibly h...
  
• Average & Total - How can you insert both automatic subtotals and au...
  
• WhatIf 32 - Today's podcast shows an old Lotus 1-2-3 trick tha...
  
• No Blanks - Two cool ways to get rid of all the blank cells in...
  
• 2% Across the Board - Time to raise everyone's rates by 2%. An obscure f...
  
• Wal*Mart - Using the replace dialog gets tricky when you need...
  
• Lost & Found - For every accountant who has ever tried to produce...
  
• Joining Two Lists - In today's podcast, we have two lists of customer ...
  
• Combining Records - In today's podcast, I have a single list, but cust...
  
• Citizen Aquanaut - The last trick for consolidation - how to see who ...
  
• Numbering Records - I - In today's podcast, you want to assign a sequentia...
  
• Numbering Records - II - In today's podcast, you want to assign all of the ...
  
• 1 Record on 5 Rows - Today, we deal with the most annoying dataset - ea...
  
• Customer SubHeadings - In today's dataset, someone tried to make a report...
  
• PivotTable 101 - You have 50,000 rows of transactional data and you...
  
• Changing Pivot - How to change an existing pivot table. Episode 264...
  
• Moving Pivot - There is an annoying limitation when you try to in...
  
• Pivot Doubts - They say that every data set has errors. Once you ...
  
• Pivot Update - Pivot tables don't automatically update. Episode 2...
  
• Pivot Zeroes - If you pull out your copy of John M. Nelson's The ...
  
• Pivot Fields - How to add or remove fields to a pivot table in Ex...
  
• Show Pivot Detail - Once you have three or more fields in a pivot tabl...
  
• Go Long! - In Excel 2003 and earlier, you only have 255 colum...
  
• AutoSort - Why are pivot tables always sorted by customer alp...
  
• Top Customers - Another hidden option allows you to have the pivot...
  
• PivotTable PageFields - What if you need to produce a report for each regi...
  
• AdHoc Reporting - Use Page Fields in a pivot table to create an ad-h...
  
• Unique Lists - There are many difficult methods for producing a l...
  
• Fast Pivot Tables - Skip the whole wizard and create a pivot table in ...
  
• Pivot Average - All of the pivot tables lately have been showing t...
  
• Pivot Data Fields - Yes - you can have multiple fields in the data are...
  
• Multiple Data Fields - Pivot Tables look horrible when you try to add two...
  
• Daily to Monthly - If your pivot table shows data by days, it is just...
  
• Pivot Table by Week - What if you need to group your daily dates up to w...
  
• Leading & Trailing Spaces - Kevin from Chicago called to ask how to remove lea...
  
• Order Leadtime Report - If you are trying to plan inventory in the warehou...
  
• Formatting Pivots - While pivot tables are incredibly powerful, they g...
  
• PivotTable NumberFormat - If you need to change the numeric format in your p...
  
• End of Month - Jackie from Chicago calls in with today's question...
  
• No Pivot Totals - Sometimes you need to take the results of your piv...
  
• Banished Outlines - If there is one thing that bugs me about pivot tab...
  
• Comparing Lists - I use this trick all of the time. Say that you hav...
  
• Show Pages - Szilvia from California calls in today with a grea...
  
• Calculated Pivot Field - Add a calculated field to a pivot table. Episode 2...
  
• Calculated Items - Unlike the calculated field in yesterday's podcast...
  
• Pivot Charts - Instead of creating Pivot Tables, create your summ...
  
• XLS in Data Query - This is a fairly wild concept. Sometimes you want ...
  
• Web Query - Rather than copy and paste data from your browser ...
  
• Web Options - How to control the options for your web query. Kee...
  
• Fresh WebData - Would you like to keep your web queries fresh? Pul...
  
• Replace Malfunction - I have this data and I am trying to replace the sp...
  
• Data Form - Create a simple data form to help when entering da...
  
• Quick Formatting - Make your boring black and white spreadsheets come...
  
• Styles - Microsoft Word gurus suggest using Styles in Micro...
  
• One-Click Charts - This is the first of several podcasts about creati...
  
• Chart Location - Charts can exist either on their own chart sheet o...
  
• Chart Formatting - Why do Excel charts look so horrible? Learn how to...
  
• Pi Rotation - Why do pie charts look so horrible? Episode 306 wi...
  
• Data Drop - Do you have to re-create charts each month? Learn ...
  
• Parsing Colon - Joe from Florida calls in with a great question......
  
• Future Charting - Can you predict the future with Excel? MrExcel thi...
  
• Profit Waterfall - The profit waterfall chart is a great way to show ...
  
• Conditional Rank - Ethan calls in with today's question - how to rank...
  
• 2007 Visualizations - Episode 312 features a preview of one of the cool ...
  
• Splitting Rows - There is a worksheet where every row in column A i...
  
• Copy Formatting - You have 12 reports. After formatting the first re...
  
• Excellers without Borders - Have you ever tried to copy a formula, only to hav...
  
• Comment Yourself - Leave yourself helpful notes in the spreadsheet. A...
  
• Garbage characters - Joel & Jared send in better ways to handle getting...
  
• Formatting Comments - If your cell comment is too long for the standard ...
  
• Visible Comments - Keep your comments always visible to guide people ...
  
• Comment Name - How to change the name in your comments, and the a...
  
• Comment Shape - Change your cell comments to fun shapes. Episode 3...
  
• Popup Pictures - Hover over a cell and have a picture pop up. Episo...
  
• Background Photo - Replace the plain white background in your workshe...
  
• Printable background - Yesterday's podcast talked about how to use a pict...
  
• Underline This! - Are you frustrated that Excel automatically turns ...
  
• Standard Width - Need to resize columns without unhiding the hidden...
  
• Numbering Pages - You might have many worksheets in your Excel workb...
  
• Quick Hideaway - Today's podcast talks about a quick and easy way t...
  
• Hiding Columns - If you need to remove columns from a printout, you...
  
• Quick Unhide - Do you need to temporarily see the values in a hid...
  
• Complex Printouts - What if the top section of your worksheet has colu...
  
• Far Out - Keep an eye on some distant far-off cells. Rather ...
  
• Watch Window - If you are using Excel 2003, use the new Watch Win...
  
• Page Breaks - The difference between automatic page and manual p...
  
• Page Break Preview - How to use Page Break Preview mode to see all of y...
  
• Fitting Report - How to make a report fit to one page wide by hundr...
  
• Hiding Errors - Need to print a report quickly but don't want the ...
  
• Tab Color - Change your worksheet tab colors - a new feature i...
  
• Format Painter - Today I show you a great trick for copying formatt...
  
• True SmartTags - Why does every TRUE value in your worksheet get a ...
  
• Printing Row Numbers - How to print your worksheet with the row and colum...
  
• Without Borders - Do you get annoyed when you copy a formula and the...
  
• Double Underline - Tricks for adding a double underline to your cells...
  
• Border Details - The complete guide to applying borders to a select...
  
• Shrink To Fit - How to make a value that is slightly too large for...
  
• Fractions - Change the decimals in your spreadsheet to display...
  
• Andy's Problem - Andy Cyber Walker once asked me what seemed like a...
  
• Max or If - Calculate Sales over Quota using either the IF or ...
  
• Chart Data - In Episode 349, learn a cool way to add new data t...
  
• Total Visible Rows - There is another way to use the AutoSum icon in th...
  
• Maddening Subtotals - What if you had to total 168 different fields usin...
  
• Numeric Keypad - If you have a lot of numeric data entry to complet...
  
• Fabulous F4 - Sure, you probably know that the F4 key can be use...
  
• Page 3 of 12 - Are you frustrated that as you print each workshee...
  
• Column Negation - Your company system produces a data export where a...
  
• Customizing Icons - You probably know that you can add new icons to yo...
  
• Date Differences - You have two dates in Excel and want to find the e...
  
• Top Five - In episode 358, a great new trick from Adam in the...
  
• Circular Data Entry - A great call from Georgia - how to ease the data e...
  
• PageBreak Every 35th - Today on Episode 360, a viewer question stumps MrE...
  
• Swap Rows & Columns - Bruce from Texas calls in today with an Excel prob...
  
• Pasted WebData - When you copy and paste data from a web browser to...
  
• Delete Objects - There is a secret icon that will let you select al...
  
• Unique List - If you need to find a unique list of values in any...
  
• Scroll Area - Back in August, the podcast showed a trick for pre...
  
• Arrows - Use the drawing tools to highlight data on your wo...
  
• Circling Cells - Using the circle tools on the Drawing toolbar to c...
  
• Adding Shapes - Use the AutoShapes to draw any of 70+ different sh...
  
• AutoShape Text - Create cool headlines by adding text to your autos...
  
• AutoShape Formulas - Rather than static text in the AutoShape, use a fo...
  
• Tear-Off Pallettes - A little known trick in Office - how to force the ...
  
• Custom Charts - Once you have customized a chart, add the chart to...
  
• Charting Magnitude - Sometimes you want a chart to show two different k...
  
• Logarithmic Scale - If you need to create a chart where each series co...
  
• Ad-hoc Reporting - Today's netcast talks about an easy-to-create repo...
  
• Select Visible Cells - When you have created automatic subtotals and want...
  
• GetPivotData Function - In Excel 2002+, try to create a formula next to yo...
  
• Cell Dropdown - If you are creating a worksheet for someone else t...
  
• Offsheet Validation - Yesterday's netcast showed how to set up data vali...
  
• Validation Messages - When you set up a validation dropdown, Excel won't...
  
• Indiscriminate Validation - Sometimes you want to have cell validation, but yo...
  
• Cell Tips - Add a tooltip to each cell in your worksheet that ...
  
• Dependent Validation - Setting up data validation lists, where the second...
  
• Formatting Macro - Someone posed this question in a recent Power Exce...
  
• Target Diagrams - Create a target diagram in Excel, using the busine...
  
• 2nd Tuesday - Ken from Chicago calls with a tough question - how...
  
• MegaFormula Copying - Sometimes when you have a difficult formula like t...
  
• Org Charts - Create an Org Chart in Excel. The org chart tool i...
  
• Eye-Catching Titles - Add visual interest to your reports by adding a co...
  
• Grey Background - Jim from Montreal calls in today to ask if there i...
  
• Ribbon Minimization - Starting on Tuesdays and Thursdays, I will be taki...
  
• Leading Zeroes - Have you ever tried to enter an ID number that sta...
  
• Shortcut Keys - It's another Excel 2007 Thursday. I'll take a look...
  
• Copy Values - Today's tip comes from Dave in Columbus, Indiana. ...
  
• Parsing Text - In today's episode a caller asks how to split name...
  
• Data Visualization - A look at Excel 2007 data bars and color scale fea...
  
• Leading Zeroes - A much better way of showing leading zeroes. After...
  
• QAT Taming - The only toolbar that is easy to customize in Exce...
  
• Workday Calculations - There are a couple of obscure functions in the ana...
  
• OffSheet Precedents - It is a real pain to try to trace precedents that ...
  
• Big Grid - Excel 2007 sports a massive grid. Take a tour of c...
  
• Find ##### - When a number is too large to fit in the width of ...
  
• 2007 Formats - Actually - there are three different file formats ...
  
• AutoShape Defaults - Have you ever needed to create many similar autosh...
  
• Morphing AutoShapes - Although Excel offers 100+ built-in AutoShapes, yo...
  
• Color Sort - New in Excel 2007 - you can sort by cell color! To...
  
• Logo Shapes - Use the freeform tool to make a 3-D version of you...
  
• 2 Column TextBox - How to use Excel as a word processor. This episode...
  
• Function Wizard - Learn how to use a simple English-language query i...
  
• Absolute References - Sometimes, you want to enter a formula where one r...
  
• Expanding FormulaBar - Do you notice that in Excel 97-2003, if you have a...
  
• Joining Text - How to join text from two columns using the concat...
  
• Mini Toolbar - Get quick access to all of the text formatting com...
  
• Joining Dates - If you try to use the concatenation character to j...
  
• Removing Duplicates - Excel 2007 offers powerful new features for removi...
  
• Mapping Data - Microsoft MapPoint is a great product that will al...
  
• Parsing Addresses - Sometimes you have a single column with several fi...
  
• Table Formatting - Excel 2007 adds new table intelligence that you ca...
  
• Adaptive Menus - In Excel 2000-2003, if you open a menu and only se...
  
• Table Extending - Once you have defined an Excel 2007 table, Excel w...
  
• Recent Files - This netcast has a couple of tips from Tools - Opt...
  
• Customizing Toolbars - Learn some new tricks with your Excel 97-2003 tool...
  
• Table Formulas - One of the best features of the new Excel 2007 tab...
  
• Toolbar Hyperlinks - More tricks for your Excel toolbars, including how...
  
• Table Formatting - Six accent colors x 7 options x 20 themes x your i...
  
• April Fools - One of my favorite April Fools Day tricks involves...
  
• Gantt Chart - This cool trick shows you how to create a Gantt ch...
  
• Table Filters - Excel 2007 offers amazing new AutoFilter functiona...
  
• Dr. Fill - Use the Fill Handle to extend a series. Episode 42...
  
• Free Book - Sign up to get a free chapter each week of my new ...
  
• Fill Weekdays - If you work Monday through Friday, Microsoft has a...
  
• Filling Bagels - Sure, Excel can fill in the months of the year. It...
  
• Excel 2007 - Office 2007 debuted at midnight last night. In Epi...
  
• Ribbon Mapping - As you dive in to get all the great features in Ex...
  
• OneNote - The Home & Student edition of Office 2007 includes...
  
• Goal Seek - Use the Goal Seek function to back into an answer....
  
• Adding Without Formulas - Did you ever notice the status bar below your spre...
  
• Translate - Excel 2007 offers an oddity - an icon to do transl...
  
• AutoFilter Woes - Jim from Montreal calls in wondering why the AutoF...
  
• Virtual AutoFilters - Excel 2007 does offer a number of improvements in ...
  
• Paste Formulas - Eric from Shanghai writes in with a question about...
  
• Combo Chart - How to create a combination chart that includes bo...
  
• Undo Toolbar Customizations - If you have inherited a computer where someone has...
  
• Overlay Charts - In a recent charting challenge, Jerome Sullivan se...
  
• Filter Copying - A question from Mike in Oklahoma City. Excel is su...
  
• PieChart Lies - Watch out when someone tips a pie chart backwards ...
  
• Dates as Numbers - Here is a bizarre problem sent in by a viewer. Man...
  
• Cone Chart Lies - Another popular way for people to lie with charts ...
  
• Unhide One Column - Stuart from the UK asks: say that you have columns...
  
• Hidden Column Tricks - As a follow-up to yesterday?s netcast, Episode 450...
  
• Filling an Outline - Heidi asks a question that is a new twist on an ol...
  
• Formula for Worksheet Name - Rupal asks how to return the worksheet name as the...
  
• MegaMillions Lottery - After Scott?s question for tomorrow?s podcast, I t...
  
• Lotto Probability - Scott from Australia sent in what should have been...
  
• OFFSET - Joe writes in with a question of how to subtract t...
  
• Chart Resizing Problems - Dan from Akron notes that when he inserts new colu...
  
• Text Files I - If you need to import a text file into Excel, you ...
  
• Importing Fixed Width Files - In our continuing look at importing text files, to...
  
• Importing Delimited Files - How to import a delimited text file into Excel. Le...
  
• Page Breaks Disappear - Dan has an unusually wide spreadsheet where the pa...
  
• March Madness - You are invited on Monday to download MrExcel?s NC...
  
• Entering Teams - March Madness has begun and commissioners in offic...
  
• Checking Data Entry - The first entries in the NCAA office pool are star...
  
• Gathering Entries - In offices throughout the US, people are starting ...
  
• Formulating the Future - As the NCAA games start today, the commissioner ne...
  
• Leading and Interior Spaces - Episode 466 shows how to get rid of leading spaces...
  
• Umlas Magic - Today?s podcast is the first in a series featuring...
  
• Dreamboat Formatting - I realize this is the Learn Excel podcast, but we ...
  
• Organizing Chart Data - Our guest host today is Jon Peltier. Jon maintains...
  
• Conditional Formatting - Today?s guest podcaster is MVP Zack Barresse. Zack...
  
• Fill Control - Today?s guest podcaster is Curt Frye, author of th...
  
• Quick Transpose - Do you need to turn data on its side in Excel 2007...
  
• Formulas in Word - Sure ? it is easy to add up a column of numbers in...
  
• Daily F9 - Dick Kusleika is our guest podcaster today. Dick i...
  
• Double Validation - Excel MVP from Brazil Robert Martim shows how to s...
  
• April Fools - Bill?s favorite Excel-related April Fool?s day tri...
  
• Cy Young - Play ball! In honor of baseball?s opening day, lea...
  
• Utilities for Excel - Today, an interview with Andrew Engwirda, author o...
  
• Parsing Irregular Text - Jason sends in our question today. He has a single...
  
• Text Dates - After importing data, your numbers and dates might...
  
• Leading CSV Zeroes - If you have a CSV file, you will always lose any l...
  
• Hide by Grouping - Today, Scott W sends in a better way to hide and u...
  
• Be Challenged - There is one week left to enter the current challe...
  
• VLOOKUP vs MATCH - The VLOOKUP function is one of the most versatile ...
  
• Index & Offset - These two functions allow you to dynamically point...
  
• Match & Index - In today?s podcast, we have hundreds of rows of VL...
  
• VLOOKUP LEFT - To finish up the recent discussion of VLOOKUP, IND...
  
• Classic Menus 2007 - Bill Gates asked the question: ?The ribbon is fine...
  
• Non-Sorting Dates - Viewer George sends in a column of dates that refu...
  
• Sum Bold - Mudit asks, is there any way to sum just the bold ...
  
• Tricky Validation - Mike writes in with a question that is way too har...
  
• Chart to PowerPoint - Bob from Dallas writes in with a question. Bob has...
  
• Non-Pivotable Data - In just about every pivot table tutorial, the writ...
  
• Time Stripping - Jonathan from California has a column with date & ...
  
• Grouping by Hour - In yesterday?s podcast, I proposed a formula to so...
  
• Quick Zooming - Do you hate the Zoom control on the standard toolb...
  
• Finding Substrings - George sends in a question ? How can COUNTIF be ma...
  
• Running Average - In today?s netcast, a question about how to create...
  
• Spelling Numbers - George sends in a question ? how can you convert a...
  
• 500! - As we hit this milestone, you can win one of a tre...
  
• Data Entry - Today?s podcast shows a better way to do data entr...
  
• Color Pivot - There is a cool but subtle way to select all of th...
  
• Pivot Sections - Say that you have a pivot table with region and pr...
  
• Connecting Shapes - If you use the shapes on the drawing toolbar such ...
  
• Wildcard CountIf - Thanks to many viewers who wrote in after Episode ...
  
• Excel Gradebook - Christina asks how to create a gradebook in Excel....
  
• JanFebMar Conversion - Your crazy software exported a file where the date...
  
• Add a Dash - If you need to spice up a column in your report, E...
  
• Corralling Students - Christina asks how to make sure that the students ...
  
• Dismissing AutoFill - When you drag the fill handle, Excel offers an ext...
  
• Filling Blanks - While yesterday?s podcast talked about using the F...
  
• Moving Average - Ricardo sends in a tricky formula question for tod...
  
• Group Mode - Joe writes in with a faster way to get an entire w...
  
• Subtotals Count - Why does the automatic subtotals command sometimes...
  
• Paste Options Redux - Last Thursday, we pondered how to get rid of the a...
  
• Event Handlers - In honor of Memorial Day in the United States, a q...
  
• Conditional Find - Rod calls in a question today; how to use conditio...
  
• Copy Across - Richard sends in todays question: How do you copy ...
  
• Center Sorting - George has a dataset today where a serial number c...
  
• Custom Sort - Sometimes, your company tradition will force you t...
  
• Show Positives - Dermot sends in today?s question; a spreadsheet is...
  
• Finding Numerics - The Find command seems to work perfectly with text...
  
• Flight Numbers - JJ writes in with a question from Alaska. His home...
  
• Final Saturday of Month - Ammar from Iran sends in a question about how to f...
  
• MegaFormula Redux - Gary sent in a better way to build MegaFormulas. G...
  
• Color Palette - Excel 97 through Excel 2003 was limited to 56 colo...
  
• Color Templates - Rather than modify the 56 colors for every new wor...
  
• Copying Colors - Once you have a custom color palette set up in Exc...
  
• 2007 Themes - Rather than having to customize the color palette,...
  
• Theme Effects - In Excel 2007, a theme is comprised of fonts, colo...
  
• Custom Themes - It is easy to create a custom theme in Excel 2007....
  
• Favorites Playlist - Doug sends in a question today about managing his ...
  
• Upper Case - Gary asks about converting text from lower case to...
  
• Counting X?s - Kyle is trying to build a worksheet to create prac...
  
• Sorting by Month - Mario writes in with a comment about Episode 507 o...
  
• Indeterminate Substitution - Robbie calls in today to ask how to add a hyphen a...
  
• Appending Sequence - Ben asks how he can automatically append a sequenc...
  
• Overlapping 2007 Charts - Peter sends in a question that relates back to Epi...
  
• Is it your birthday? - George would like to mail birthday cards to all of...
  
• DATE EXTRADONAIRE - I love the DATE function. While some Excel functio...
  
• MOD FUNCTION - Daan Sprunken (who was a runner up in one of the l...
  
• Shortcuts - Jonathan writes in to mention Ctrl+; enters today?...
  
• Rearranging Columns - Mary from Chicago asked how to rearrange columns i...
  
• Rearranging all Columns - In yesterday?s podcast, I showed how to rearrange ...
  
• Sparse Copy - My favorite trick is to double click the fill hand...
  
• Adding Headings - Today?s problem involves a complex data set with h...
  
• Strikethrough a Portion - Today, Bob calls in with a question. He has an Exc...
  
• Scrollbar Size - If you navigate your worksheet rows by dragging yo...
  
• Negatives to Positive - Simon from the UK sends in a question. He has a ra...
  
• Custom Functions - Way back in Episode 499, I talked about adding the...
  
• Red-Flag Dates - Van writes in with a suggestion about podcast 539....
  
• Hiding Negatives - In today?s podcast, Episode 552, I use the IF func...
  
• Formatting Away Negatives - In today?s podcast, a custom number format that sh...
  
• Formatting Zones - Building on yesterday?s podcast, Episode 554 shows...
  
• Thousands Display - Need to convert a report or a chart to display in ...
  
• Multiple Consolidation 2007 - Rivky writes in to ask how to do multiple consolid...
  
• Manual Recalc - Do you have a spreadsheet where the calculation ti...
  
• Moving Columns - Udo from Dresden Germany sends in a tip for a fast...
  
• Zeroth Day - Erik points out that the best way to find the last...
  
• Negative Workdays - How can you figure out a date that is a certain nu...
  
• Negative Time? - Excel does not deal well with negative times. What...
  
• Better Scientific Notation - Ryan from Schaumberg sends in a tip for improving ...
  
• Mapping Data - Turn a list of customer locations into a map right...
  
• Floating Point Errors - Have you ever had an Excel calculation show up wit...
  
• Restoring Scrollbar - Back in Episode 548, I talked about the frustratin...
  
• Text to Columns - Going back to Podcast 453, I talked about taking d...
  
• Truncation Justify - Are you a fan of Edit ? Fill ? Justify? If so, wat...
  
• Monthly Subtotals - If you have a column of daily dates, how can you s...
  
• Moving Columns III - Derek from the UK checks in with yet another way t...
  
• Random Quiz - Giovanni asks how he can create a random multiple ...
  
• AutoFilter Doesn?t Contain - Joe asks about using custom autofilters with Excel...
  
• 2007 Filters - Excel 2007 adds some amazing new features to the E...
  
• Plus or Equals - All Excel formulas start with an equal sign, right...
  
• Repeating Characters - If you need to fill a cell with a character, eithe...
  
• Editing Formula Ranges - A quick trick showing how you can make a formula p...
  
• RSS Size - In today's Episode 576, I ask, How many episodes o...
  
• End of Month - Using the EOMonth function to find the end of a mo...
  
• Merge Words - Mike from Kansas City asks if there is a way to ta...
  
• Double Click Fill Handle - One of my Greatest Hits ? a fast way to copy a for...
  
• Fixing Crystal - Susan writes in with an annoying problem. Crystal ...
  
• Massive Page Breaks - Steve wonders how he can add a page break after ev...
  
• Validation Dropdowns - Brent asks if it is possible to make the data vali...
  
• Validation Lists Elsewhere - Brent asks how you can set up validation lists on ...
  
• Refreshable Validation - Store your validation lists on a separate workshee...
  
• Text Length - Ron from Dallas asks how he can limit the number o...
  
• Shrink To Fit - Here is another solution to Episode 585: Instead o...
  
• Concatenate Range in VBA - Back in Episode 578, I used an incredibly complex ...
  
• Sample Spreadsheets - When you use the New command, you have access to h...
  
• Ctrl+Alt+X - Bill from Addison TX sent in a great tip to allow ...
  
• Rolling Charts - Say that you need to show a rolling 6 month chart....
  
• Missing Dates - When you create a chart from data that might have ...
  
• Missing Pivot Dates - Today?s question is a follow-up to yesterday?s que...
  
• Unprotect Green Cells - Today, the questioner asks how to unprotect the gr...
  
• Run Macro Button - You?ve created a simple macro and want to assign t...
  
• Faster Fill Handle - Today, Dr Fill Handle provides a faster way to use...
  
• Auto Formula Copying - Rod notes that Excel has a cool feature that will ...
  
• Show All - After you?ve used an AutoFilter to see just a few ...
  
• Evenly Distributing Numbers - Jerry from Georgia asks how to randomly distribute...
  
• Text Box Length - Joe Marten sends in a better way to limit the numb...
  
• 500th Episode - I wonder if there is a mile-high club for podcasti...
  
• Redocking Properties - If, in the VBA editor, you accidentally undock the...
  
• Indirect Address - Rod asks how to set up a summary worksheet that wi...
  
• Adding Worksheets - Add new worksheets in seconds. Episode 603 shows y...
  
• Breaking Charts - Do you have a chart which is too confusing? Try re...
  
• Frequency Distribution - Creating a Frequency Distribution with the FREQUEN...
  
• Histogram - To create a true histogram from frequency informat...
  
• Double Click - My favorite Excel trick is to double-click the fil...
  
• Navigate Worksheets - Learn how to quickly navigate worksheets. Episode ...
  
• Hiding Chart Rows - When you hide a row, Excel will remove that series...
  
• Ball of Paint - We figure out the thickness of a coat of paint, li...
  
• Unhide All Sheets - You can hide several sheets with a single command,...
  
• Default Footer - Anne sends in today?s question: How can I change t...
  
• Multiple VLOOKUPs - Alicha asks ? how can you return many columns from...
  
• Filter Most Recent - Alicia and George have sent in similar questions; ...
  
• Filter Recent II - In today?s podcast, I address the same question fr...
  
• Spilling Cells - Ethan sends in a question about optionally allowin...
  
• Spilling Values II - In today?s episode, I take a look at three non-mac...
  
• Underlining Woes - Mark sends in a question about why Excel underline...
  
• Sorting Subtotals - Say that you add automatic subtotals and collapse ...
  
• Forecasting - Leon asks how to forecast the next number in a ser...
  
• Array Forecast - Today, we take a second look at Leon?s question ? ...
  
• LINEST Regression - Rather than using FORECAST to choose the next numb...
  
• Exponential Growth - Sometimes the growth in a model is not linear, but...
  
• Multiple Regression - How much ice cream will Sally sell on any given da...
  
• Formula Bar - Excel 2007 features an amazing expanding formula b...
  
• VBA Naming Ranges - The macro recorder uses a confusing way to name ra...
  
• Relative Recording - When recording a macro to enter a SUM formula, you...
  
• Pivot Rearrangement - Sometimes, you might need to rearrange the heading...
  
• Column Function - I want to revisit a topic from podcast 613; using ...
  
• Customer Templates - Jennifer from Illinois asks if you can use the tri...
  
• Realllly Long Text - Excel can allegedly handle 4096 characters in a ce...
  
• Array Function Arguments - Back in podcast 621, I wondered why the function a...
  
• Keyboard Shortcuts - Vincent from Montreal shares a tip today to print ...
  
• Dragging Chart Points - Did you know that you can change numbers in the un...
  
• Four Conditions - Today?s question deals with conditional formatting...
  
• Combining Worksheets - James asks how he can combine data from all rows o...
  
• Validation Unique - Ben asks today?s question: Can I set up Validation...
  
• AutoFilter Navigation - Joe Marten sends in today?s tip; how to quickly na...
  
• Recent Records - How can you find the most recent record for each c...
  
• Filtered Greenbar - Rod from Cincinnati notes that the trick used in P...
  
• Conditionally Summing - Patrick asks how he can summarize his monthly time...
  
• Pulling Web Data Into Excel - Maxwell asks how best to pull web data into Excel....
  
• Excluding Zero Values From Pie Charts - Patrick wrote in to address my answer from podcast...
  
• Previous Banking Day - A great question from one of my Excel seminars sta...
  
• Fibonacci Sequence - John from New York asks if Excel can be used to cr...
  
• Exit Excel - In Excel 2007, Microsoft has changed the behaviour...
  
• Extending ABC - Excel knows how to extend any series, but it can n...
  
• Changing Numbers Graphically - Steve asks if he can build an Excel worksheet wher...
  
• Slider Controls - Today, a second answer to Steve?s question about c...
  
• 2007 Filter - In Episode 650, I take a look at the new functiona...
  
• Remove Duplicates - Excel 2007 offers a fantastic new way to remove du...
  
• Pivot 2007 - Excel 2007 offers new pivot table functionality. E...
  
• Non-Numeric Managers - Do you have a manager who?s eyes glaze over when p...
  
• The Ribbon is Cool - There. I?ve said it. Let me say it again? ?The Rib...
  
• Year vs Year - Hiro asks how to build a pivot table to show year ...
  
• Negative Charts - Chris from Long Island asks how to conditionally f...
  
• Find All - Today we take a look at some nifty tricks in the F...
  
• Subtotal Row Formulas - Debbie from Virginia asks about adding new calcula...
  
• Deleting Borders Deletes Gridlines - Greg from Indiana sends in a great mystery today. ...
  
• Weeks Ending on Sunday - Add a validation dropdown with all weeks ending on a Sunday
  
• OR Conditional Sums - Conditionally summing records that match one condition or another
  
• SumProduct - Do conditional sums with SUMPRODUCT
  
• Pasted Icons - Pasted web data often has annoying icons. Remove them.
  
• Extracting Links - Have a bunch of hyperlinks in Excel? Extract the URL from each link to a new column.
  
• Scraping Webpages - VBA to grab data from all web pages in a list
  
• Clustered Columns - Create a clustered column chart using Excel - a question sent in by Rodney
  
• Totaling Visible Rows - After applying an AutoFilter, total only the visible rows
  
• Total Diagonally - Can you total that diagonally for me?
  
• Total Diagonally 2 - Create running diagonal totals, improving yesterday's formula
  
• Total Duh-agonally - A simpler way to total diagonally
  
• Proper Case - Changing names to proper case
  
• OffSheet References - Do VLOOKUPs from one sheet to another sheet
  
• Custom Numbers - Finding numbers in a column with special numeric formatting.
  
• Negative Invert - Better way to color negative chart columns in red.
  
• Named Ranges - Naming a range to simply formula entry. Also using F3 for Paste Name
  
• Recording Naming - Use a macro to name the current range
  
• Preventing Spills - Fill blank cells with an apostrophe to prevent adjacent long cells from spilling.
  
• Page Break Preview - Use Page Break Preview or Page Layout View in Excel 2007
  
• Pivot Source Data - Change pivot table source in Excel 2007.
  
• Timestamp - A VBA event handler to timestamp new records in an Excel worksheet
  
• Indirect - Using INDIRECT to build a Summary worksheet that can be copied to new workbooks.
  
• Quiz Practice - Use Excel to practice for quiz
  
• Chart >4% - Use a filter to remove small pie wedges from a pie chart.
  
• Bar of Pie - Automatically move pie wedges under n% to a secondary chart.
  
• Tracking Runners - Track finishing times for runners in Excel.
  
• Preventing Spills - Prevent long text from spilling into adjacent cells, take II
  
• VBA in 2007 - VBA is alive and well in Excel 2007
  
• Month End - Ask for the 0th day of next month to find the last day of this month
  
• Hiding in 2007 - Use Excel 2003 Keyboard shortcuts in Excel 2007
  
• Page Setup - Repeat headings and titles at the top of each printed page, with page numbers.
  
• Insersection Operator - Using the intersection operator in Excel
  
• Ditto - Copy the exact formula from above using Ctrl+' or Ctrl+"
  
• Easy Greenbar - Use Excel 2007 Table functionality to format a range with greenbar.
  
• Double Greenbar - Set up greenbar formatting with stripes that are two rows high.
  
• Scale Selection - A macro to scale a selected range.
  
• Alt Shortcuts - New Alt shortcuts in Excel 2007
  
• VLOOKUP or INDEX? - Is it better to use VLOOKUP or INDEX and MATCH?
  
• Column Widths - Copy column widths from one range to another range.
  
• 2007 Pivot Interface - Bring back the Pivot Table drag-and-drop interface in Excel 2007
  
• Mapping Data - Plot your Excel data on a map using MapPoint.
  
• VBA Userforms - Create a userform in VBA
  
• 2 Field Column - Extract region data using IF statements
  
• Filling Outline Blanks - Fill in blank cells with the value immediately above it.
  
• Deleting Blank Rows - Sort data to move blanks to the bottom of the data set.
  
• Pivoting Time Columns - Change a pivot data set that has quarters going across to rows going down
  
• Pivot 2007 - Create your first pivot table in Excel 2007
  
• Changing Pivot - Changing a pivot table in Excel 2007
  
• Pivot Sorting - Sorting a pivot table field.
  
• Pivot Dates - Group daily dates up to months in an Excel 2007 Pivot Table
  
• Pivot Filters - Filter a pivot table to show only records from this week.
  
• Show Pages - Create a report for each customer in a few clicks.
  
• First Subtotaled Item - Grab the first item from a subtotaled group using CHOOSE() and an array formula
  
• Validation Woes - Why validation dropdowns don't jump to an entry when you type the first letter.
  
• Choose Value - VBA userform to allow you to choose a value.
  
• PI Day - PI() and SQRTPI(), in honor of PI-day (3/14)
  
• NCAA MapPoint - Use RANDBETWEEN to choose a person at random, mapping with MapPoint
  
• Event Calendar - Show events visually on a calendar in Excel
  
• AutoComplete vs Validation - Use AutoComplete and Validation to allow easier entry of values.
  
• Sampling - Choose a random sample of 20 invoices from a population
  
• Dynamic Validation - Define a dynamic list for your validation lists using OFFSET
  
• Leading Zeroes - Keep leading zeroes in Excel.
  
• Paul McCartney - Capitalize the interior C in McCartney when using the PROPER function
  
• PivotText - Show Yes or No in the data area of a pivot table.
  
• Custom Number - Obscure custom number formatting tricks
  
• Row Differences - Finding differences between two columns using Go To Special Row Differences
  
• Random Drawing - Use RANDBETWEEN to choose prize winners
  
• Building Formulas with Text - Using INDIRECT with concatenation.
  
• Table Formulas - Stop Excel from created calculated columns within a table
  
• 2003 Icon Sets - Create an icon set in Excel 2003 using wingdings.
  
• Insert Worksheets - Add a new worksheet for every customer on the summary worksheet
  
• Copying Subtotals Only - Copy the subtotal rows from the automatic subtotals
  
• Dates from Text to Columns - Prevent Text to Columns from converting 7-3 to a date
  
• Bingo Draw - Draw bingo numbers down column A
  
• Bingo No Duplicates - Generate random bingo numbers without generating duplicates
  

If you like this video, there are hundreds of 2-5 minute videos available here:

• Excel training videos about Charts
  
• Excel training videos about VBA
  
• Excel training videos about Pivot Tables
  
• Excel training videos about Data Analysis
  
• Excel training videos about Formulas
  
• Excel training videos about Formatting
  
• Excel training videos about Printing
  
• Excel training videos about Excel 2007
  
• Index to all videos