Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

 
Download files for Learn Excel from Mr Excel
As I wrote Learn Excel from MrExcel - I saved the files used in the book. If you want to try a particular task in the book, feel free to download any of these files.

For people who have downloaded chapters from the free chapter preview, the number in parentheses indicates the week number will you will find this topic.

PART 1: THE EXCEL ENVIRONMENT
  • Page 0 - Foreword - use any workbook - no download provided (1)
  • Page 3 - Show Full Menus All the Time - use any workbook - no download provided (1)
  • Page 6 - Show Full Toolbars All the Time - use any workbook - no download provided (1)
  • Page 8 - Add a Close Button to the Standard Toolbar - use any workbook - no download provided (1)
  • Page 10 - Close All Open Workbooks - use any workbook - no download provided (2)
  • Page 11 - Double the Value of the Recently Used File List - use any workbook - no download provided (2)
  • Page 12 - Remember Workbooks to Open Using a Workspace - NewShapes.zip (2)
  • Page 13 - Automatically Move the Cell Pointer in a Direction After Entering a Number - Direction.zip (3)
  • Page 14 - How to See Headings as You Scroll Around a Report - SeeHeadings.zip (3)
  • Page 17 - How to See Headings and Row Labels as You Scroll Around a Report - FitToPage.zip (3)
  • Page 19 - How to Print Titles at the Top of Each Page - PrintHeadings.zip (3)
  • Page 22 - Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page - PrintCenterHeadings.zip (3)
  • Page 25 - How to Print Page Numbers at the Bottom of Each Page - PrintCenterHeadings.zip (4)
  • Page 27 - How to Make a Wide Report Fit to One Page Wide by Many Pages Tall - FitToPage.zip (4)
  • Page 30 - Arrange Windows to See Two or More Open Workbooks - AirlineCodes.zip (4)
  • Page 34 - Why Is There a “:2” After My Workbook Name in the Title Bar? - ColonTwo.zip (4)
  • Page 36 - Have Excel Always Open Certain Workbook(s) - use any workbook - no download provided (15)
  • Page 38 - Set up Excel Icons to Open a Specific File on Startup - use any workbook - no download provided (15)
  • Page 42 - Use a Macro to Further Customize Startup - DataForm.zip (15)
  • Page 44 - Control Settings for Every New Workbook and Worksheet - use any workbook - no download provided (15)
  • Page 46 - Open a Copy of a Workbook - use any workbook - no download provided (15)
  • Page 47 - Open a Saved File Whose Name You Cannot Recall - use any workbook - no download provided (15)
  • Page 48 - Suppress the Update Links Message - SuppressLinks.zip (36)
  • Page 50 - Send Excel File as an Attachment - use any workbook - no download provided (36)
  • Page 52 - Save Excel Data as a Text File - SaveAsText.zip (36)
  • Page 56 - Use a Laser Printer to Have Excel Calculate Faster - use any workbook - no download provided (36)
  • Page 56 - Use Excel as a Word Processor - Justify.zip (36)
  • Page 60 - Spellcheck a Region - Spell.zip (36)
  • Page 61 - Use Hyperlinks to Create an Opening Menu for Your Workbook - MenuLink.zip (37)
  • Page 63 - Get Quick Access to Paste Special - use any workbook - no download provided (37)
  • Page 64 - Use Shift Key to Reverse Popular Toolbar Icons - ReverseThem.zip (37)
  • Page 67 - Create a Menu or a Toolbar of Your Favorite Icons - CustomToolbar.zip (37)
  • Page 72 - Restore Your Menus After Customizing - use any workbook - no download provided (37)
  • Page 76 - Quickly Copy a Formula to All Rows of Data - FillSeries.zip (38)
  • Page 78 - Quickly Turn a Range on Its Side - PasteTranspose.zip (38)
  • Page 81 - Stop Excel from AutoCorrecting Certain Words - NoCorrect.zip (38)
  • Page 82 - Use AutoCorrect to Enable a Shortcut - Shortcut.zip (38)
  • Page 83 - Why Won’t the Track Changes Feature Work in Excel? - TrackChanges.zip (38)
  • Page 84 - Copy Cells from One Worksheet to Many Worksheets - CopyMany.zip (38)
  • Page 86 - Have Excel Talk to You - DataForm2.zip (16)
  • Page 88 - Enter Special Symbols - Symbols.zip (16)
  • Page 90 - Find Text Entries - FindText.zip (16)
PART 2: CALCULATING WITH EXCEL
  • Page 97 - Copy a Formula That Contains Relative References - CopyFormula.zip (8)
  • Page 100 - Copy a Formula While Keeping One Reference Fixed - CopyFormula.zip (8)
  • Page 102 - Create a Multiplication Table - CopyFormula.zip (8)
  • Page 104 - Calculate a Sales Commission - CopyFormula.zip (8)
  • Page 106 - Simplify Entry of Dollar Signs in Formulas - CopyFormula.zip (8)
  • Page 110 - Learn R1C1 Referencing to Understand Formula Copying - R1C1.zip (8)
  • Page 115 - Create Easier-to-Understand Formulas with Named Ranges - Names.zip (5)
  • Page 119 - Use Named Constants to Store Numbers - Constants.zip (5)
  • Page 120 - Build a Formula Using Labels Instead of Cell Addresses - NLFormula.zip (5)
  • Page 124 - Use Natural Language Formulas to Refer to the Current Row - NLFormula2.zip (5)
  • Page 125 - Assign a Formula to a Name - NamedFormula.zip (39)
  • Page 133 - Total Without Using a Formula - UseAutoSum.zip (39)
  • Page 136 - Count, Average, etc. Without Using a Formula - QuickSum.zip (39)
  • Page 138 - Add Two Columns Without Using Formulas - PasteAdd.zip (39)
  • Page 141 - How to Calculate Sales over Quota - SalesOverQuota.zip (39)
  • Page 143 - How to Join Two Text Columns - JoinText.zip (14)
  • Page 147 - How to Sort on One Segment of an Account ID - LEFT.zip (14)
  • Page 149 - How to Isolate the Center Portion of an Account ID - MID.zip (14)
  • Page 150 - How to Isolate Everything Before a Dash in a Column by Using Functions - FindLeft.zip (14)
  • Page 153 - How to Use Functions to Isolate Everything After a Dash in a Column - FindMid.zip (14)
  • Page 155 - How to Use Functions to Isolate Everything After the Second Dash in a Column - FindSecondDash.zip (14)
  • Page 158 - How to Separate a Part Number into Three Columns - Parse.zip (14)
  • Page 162 - Avoid #REF! Errors When Deleting Columns - PasteSpecialValue.zip (41)
  • Page 165 - Create Random Numbers - Random.zip (41)
  • Page 168 - Create Random Numbers to Sequence a Class of Students - RandomSeq.zip (41)
  • Page 170 - Play Dice Games with Excel - Dice.zip (51)
  • Page 173 - Play Bunco with Excel - Bunco.zip (51)
  • Page 178 - Play Craps with Excel - Craps.zip (51)
  • Page 180 - Create Random Letters - RandomLetters.zip (41)
  • Page 183 - Convert Numbers to Text - ConvertToText.zip (41)
  • Page 186 - Calculate a Loan Payment - LoanPayment.zip (9)
  • Page 187 - Calculate Many Scenarios for Loan Payments - LoanPayments.zip (9)
  • Page 189 - Get Help on Any Function While Entering a Formula - CtrlA.zip (9)
  • Page 192 - Discover New Functions Using the ƒx Button - CtrlA.zip (9)
  • Page 194 - Three Methods of Entering Formulas - EnterFormulas.zip (10)
  • Page 199 - Use AutoSum to Quickly Enter a Total Formula - UseAutoSum.zip (10)
  • Page 201 - AutoSum Doesn’t Always Predict My Data Correctly - UseAutoSum.zip (10)
  • Page 204 - Use AutoSum Button to Enter Averages, Min, Max, and Count - PowerAutoSum.zip (10)
  • Page 207 - The Count Option of the AutoSum Doesn’t Appear to Work - CountNoWork.zip (10)
  • Page 212 - Automatically Number a List of Employees - NumberEmployees.zip (11)
  • Page 215 - Rank Scores - FreshVoicesReport.zip (11)
  • Page 217 - Sorting with a Formula - FreshVoicesReport.zip (11)
  • Page 221 - Rank a List Without Ties - RankNoTies.zip (11)
  • Page 224 - Add Comments to a Formula - AddCommentFormula.zip (12)
  • Page 225 - Calculate a Moving Average - MovAvg.zip (32)
  • Page 226 - Calculate a Trendline Forecast - TrendLine.zip (32)
  • Page 231 - Build a Model to Predict Sales Based on Multiple Regression - Regression.zip (32)
  • Page 235 - Use F9 in Formula Bar to Test a Formula - F9Test.zip (32)
  • Page 236 - Quick Calculator - F9Test.zip (32)
  • Page 237 - When Entering a Formula, You Get the Formula Instead of the Result - F9Test.zip (32)
  • Page 241 - Calculate a Percentage of Total - CalcPctTotal.zip (12)
  • Page 244 - Calculate a Running Percentage of Total - CalcRunning.zip (12)
  • Page 247 - Use ^ Sign for Exponent - Exponent.zip (33)
  • Page 247 - Raise a Number to a Fraction to Find the Square or Third Root - Root.zip (33)
  • Page 249 - Calculate a Growth Rate - GrowthRate.zip (33)
  • Page 251 - Find the Area of a Circle - CircleArea.zip (33)
  • Page 253 - Figure out Lottery Probability - Lottery.zip (12)
  • Page 254 - Help Your Kids with Their Math - ObscureMath.zip (12)
  • Page 256 - Measure the Accuracy of a Sales Forecast - ForecastAccuracy.zip (13)
  • Page 259 - Round Prices to Next Highest $5 - RoundPrice.zip (13)
  • Page 261 - Why Is This Price Showing $27.85000001 Cents? - Floating.zip (13)
  • Page 263 - You Change a Cell in Excel but the Formulas Do Not Calculate - NoCalc.zip (13)
  • Page 264 - Use Parentheses to Control Order of Calculations - Parens.zip (26)
  • Page 266 - Before Deleting a Cell, Find out if Other Cells Rely on It - FindPrecedent.zip (26)
  • Page 270 - Navigate to Each Precedent - FindPrecedent.zip (26)
  • Page 274 - Formula Auditing - FindPrecedent.zip (26)
  • Page 277 - How Is This Cell Calculated? - FindPrecedent.zip (26)
  • Page 280 - Total Minutes That Exceed an Hour - TotalTime.zip (27)
  • Page 287 - Convert Text to Minutes and Seconds - TotalTime.zip (27)
  • Page 289 - Convert Text to Hours, Minutes, and Seconds - TotalTime.zip (27)
  • Page 293 - Convert Times From H:MM to M:SS - TotalTime.zip (27)
  • Page 299 - Display Dates as Months - InvDateMo.zip (27)
  • Page 302 - Group Dates by Month - MonthFirst.doc.zip (27)
  • Page 307 - Calculate Last Day of Month - LastOfMo.zip (27)
  • Page 310 - Create a Timesheet That Can Total over 24 Hours - Over40Hours.zip (27)
  • Page 313 - Find Which Customers Are in an Existing List - InList.zip (28)
  • Page 315 - Use VLOOKUP to Find Which Customers Are in an Existing List - InList.zip (28)
  • Page 316 - Match Customers Using VLOOKUP - InList.zip (28)
  • Page 320 - Watch for Duplicates When Using VLOOKUP - InList.zip (28)
  • Page 322 - Count Records That Match a Criteria - Census.zip (29)
  • Page 324 - Build a Table That Will Count by Criteria - Census2.zip (29)
  • Page 326 - Build a Summary Table to Place Employees in Age Bands - Census3.zip (29)
  • Page 329 - Total Revenue from Rows that Match a Criterion - TotMatch.zip (29)
  • Page 330 - Use Conditional Sum Wizard to Help with SUMIF - CondSumWizard.zip (29)
  • Page 336 - Create a CSE Formula to Build a Super Formula - CSE.zip (30)
  • Page 338 - Learn to Use Boolean Logic Facts to Simplify Logic - Boolean.zip (30)
  • Page 342 - Replace IF Function with Boolean Logic - Boolean2.zip (30)
  • Page 343 - Test for Two Conditions in a Sum - Sum2Cond.zip (30)
  • Page 346 - Can the Results of a Formula Be Used in COUNTIF? - CountIf2.zip (30)
  • Page 347 - Back into an Answer Using Goal Seek - GoalSeek.zip (33)
  • Page 350 - Protect Cells with Formulas - FinStmt.zip (33)
PART 3: WRANGLING DATA
  • Page 357 - How to Set up Your Data for Easy Sorting and Subtotals - ListFormat.zip (34)
  • Page 358 - How to Fit a Multiline Heading into One Cell - AltEnterTrick.zip (34)
  • Page 362 - How to Sort Data - SortData.zip (34)
  • Page 364 - How to Specify More Than Three Columns in a Sort - SortSix.zip (34)
  • Page 367 - How to Sort a Report into a Custom Sequence - CustomSort.zip (34)
  • Page 370 - Quickly Filter a List to Certain Records - AutoFilter.zip (35)
  • Page 374 - Find the Unique Values in a Column - AdvancedFilterUnique.zip (35)
  • Page 376 - Copy Matching Records to a New Worksheet - AcvFilterInPlace.zip (35)
  • Page 380 - Add Subtotals to a Dataset - Subtotals.zip (6)
  • Page 384 - Use Group & Outline Buttons to Collapse Subtotaled Data - Subtotals.zip (6)
  • Page 386 - Copy Just Totals from Subtotaled Data - Subtotals.zip (6)
  • Page 389 - Enter a Grand Total of Data Manually Subtotaled - TwoTotals.zip (7)
  • Page 392 - Why Do Subtotals Come out as Counts? - SubCount.doc.zip (7)
  • Page 394 - Subtotal Many Columns at Once - SubMany.zip (7)
  • Page 396 - My Manager Wants Subtotals Above the Data - SubAbove.zip (7)
  • Page 397 - Add Other Text Data to the Automatic Subtotal Lines - SubAddData.zip (40)
  • Page 402 - Be Wary - use any workbook - no download provided (40)
  • Page 403 - General Protection Faults - GPF.zip (40)
  • Page 405 - Create Subtotals by Product Within Region - SubTwo.zip (40)
  • Page 411 - My Manager Wants the Subtotal Lines in Bold Pink Tahoma Font - SubPink.zip (40)
  • Page 413 - My Manager Wants a Blank Line After Every Subtotal - SubBLank.zip (40)
  • Page 429 - Subtotal One Column and Subaverage Another Column - SubAverage.zip (40)
  • Page 435 - How to Do 40 Different What-if Analyses Quickly - DataTable.zip (35)
  • Page 439 - Remove Blanks from a Range - SkipBlanks.zip (35)
  • Page 440 - Remove Blanks from a Range While Keeping the Original Sequence - BlanksSequence.zip (35)
  • Page 443 - Increase a Range by Two Percent - PasteSpecialMultiply.zip (42)
  • Page 445 - Use Find and Replace to Find an Asterisk - ReplaceStar.zip (42)
  • Page 447 - Use a Custom Header of “Profit & Loss” - PL.zip (42)
  • Page 450 - Use Consolidation to Combine Two Lists - Consol.zip (42)
  • Page 455 - Find Total Sales by Customer by Combining Duplicates - Consol2.zip (42)
  • Page 458 - Create a Summary of Four Lists - FourLists.zip (42)
  • Page 461 - Number Each Record for a Customer, Starting at One for a New Customer - NumCust.zip (17)
  • Page 463 - Add a Group Number to Each Set of Records with a Unique Customer Number - NumGroup.zip (17)
  • Page 465 - Deal with Data Where Each Record Takes Five Physical Rows - 5Rows.zip (17)
  • Page 476 - Add a Customer Number to Each Detail Record - CustNbr.zip (17)
  • Page 480 - Use a Pivot Table to Summarize Detailed Data - PivTable1.zip (18)
  • Page 487 - Your Manager Wants Your Report Changed - PivChange.zip (18)
  • Page 489 - Move or Change Part of a Pivot Table - PivMove.zip (18)
  • Page 491 - See Detail Behind One Number in a Pivot Table - PivDetail.zip (18)
  • Page 493 - Update Data Behind a Pivot Table - PivUpdate.zip (19)
  • Page 495 - Replace Blanks in a Pivot Table with Zeroes - PivZeroes.zip (19)
  • Page 499 - Add or Remove Fields from an Existing Pivot Table - PivThree.zip (19)
  • Page 502 - Summarize Pivot Table Data by Three Measures - PivField.zip (19)
  • Page 505 - Make Pivot Tables Be Taller than Wide - PivPortrait.zip (19)
  • Page 506 - Manually Resequence the Order of Data in a Pivot Table - PivOrder.zip (19)
  • Page 509 - Present a Pivot Table in High-to-Low Order by Revenue - PivSort.zip (20)
  • Page 511 - Limit a Pivot Report to Show Just the Top 12 Customers - PivTop20.zip (20)
  • Page 514 - Quickly Produce Reports for Each Region - PivPageField.zip (20)
  • Page 516 - Create an Ad-Hoc Reporting Tool - PivAdHoc.zip (20)
  • Page 517 - Create a Unique List of Customers with a Pivot Table - PivUnique.zip (20)
  • Page 519 - Create a Pivot Table with Fewer Clicks - PivQuick.zip (20)
  • Page 521 - Create a Report Showing Count, Min, Max, Average, etc. .. - PivCount.zip (21)
  • Page 522 - Use Multiple Data Fields as a Column Field - PivMult.zip (21)
  • Page 523 - Compare Four Ways to Show Two Data Fields in a Pivot Table - PivFourWays.zip (21)
  • Page 526 - Group Daily Dates up by Month in a Pivot Table - PivMonth.zip (21)
  • Page 528 - Group by Week in a Pivot Table - PivWeek.zip (21)
  • Page 530 - Produce an Order Lead-time Report - PivLeadtime.zip (21)
  • Page 536 - Use AutoFormat with Pivot Tables - PivFormat.zip (22)
  • Page 542 - Specify a Number Format for a PivotTable Field - PivNumberFmt.zip (22)
  • Page 546 - Suppress Totals in a Pivot Table - PivNoTotal.zip (22)
  • Page 549 - Eliminate Blanks in the Outline Format of a Pivot Table - PivOutline.zip (22)
  • Page 554 - Use a Pivot Table to Compare Two Lists - PivCompare2.zip (22)
  • Page 559 - Calculated Fields in a Pivot Table - PivCalcField.zip (51)
  • Page 562 - Add a Calculated Item to Group Items in a Pivot Table - PivCalcItem.zip (51)
  • Page 566 - Quickly Create Charts for Any Region - PivChart.zip (51)
  • Page 570 - Use Query to Get a Unique Set of Records - DataQuery.zip (23)
  • Page 580 - Import a Table from a Web Page into Excel - WebQuery.zip (23)
  • Page 584 - Have Web Data Update Automatically When You Open Workbook - WebQuery.zip (23)
  • Page 586 - Have Web Data Update Automatically Every Two Minutes - WebQuery.zip (23)
  • Page 588 - The Spaces in This Web Data Won’t Go Away - FindChar.zip (23)
  • Page 592 - Use a Built-in Data Entry Form - DataForm2.zip (52)
  • Page 594 - Transform Black and White Spreadsheets into Color - AutoFormat.zip (52)
  • Page 596 - Your Manager Is Obsessed with Formatting and Cannot Make up Her Mind - Styles.zip (52)
PART 4: MAKING THINGS LOOK GOOD
  • Page 607 - Create a Chart with One Click - OneClick.zip (24)
  • Page 609 - Change a Chart from a Chart Sheet to an Embedded Chart - ChartLocation.zip (24)
  • Page 610 - Customize Anything on a Chart with Right-click - FormatChart.zip (24)
  • Page 618 - How to Minimize Overlap of Pie Chart Labels - RotatePieLabels.zip (24)
  • Page 620 - Add New Data to a Chart - ChartDrop.zip (24)
  • Page 622 - Add a Trendline to a Chart - ChartTrendline.zip (25)
  • Page 628 - Display Profitability in a Profit Waterfall Chart - Waterfall.zip (25)
  • Page 641 - For Each Cell in Column A, Have Three Rows in Column B - MergeCells.zip (25)
  • Page 643 - Copy Formatting to a New Range - PasteFormats.zip (25)
  • Page 646 - Copy Without Changing Borders - NoBorders.zip (25)
  • Page 648 - Leave Helpful Notes with Cell Comments - CellComments.zip (43)
  • Page 651 - Change Appearance of Cell Comments - CellComments.zip (43)
  • Page 656 - Force Certain Comments to be Always Visible to Provide a Help System to Users of Your Spreadsheet - Comments2.zip (43)
  • Page 658 - Control Name That Appears in Comments - Comments2.zip (43)
  • Page 660 - Change Shape of Comment to a Star - Comments2.zip (43)
  • Page 664 - Add a Pop-up Picture of an Item in a Cell - SunglassPromo.zip (43)
  • Page 670 - Add a Pop-up Picture to Multiple Cells - AddManyPics.zip (43)
  • Page 672 - Change the Background of the Worksheet - WSBackground.zip (44)
  • Page 676 - Add a Printable Background to Your Spreadsheet - PrintBackground.zip (44)
  • Page 680 - Remove Hyperlinks Automatically Inserted by Excel - RemoveLink.zip (44)
  • Page 681 - Change Width of All Columns in One Command - AllWidth.zip (44)
  • Page 684 - Control Page Numbering in a Multisheet Workbook - PgNumbers.zip (44)
  • Page 685 - Use White Color for Fonts to Hide Data - HideWhite.zip (44)
  • Page 687 - Hide and Unhide Data - F9Test.zip (44)
  • Page 689 - Temporarily See a Hidden Column Without Unhiding - F9Test.zip (45)
  • Page 691 - Build Complex Reports Where Columns in Section 1 Don’t Line up with Section 2 - ComplexPrint.zip (45)
  • Page 697 - Paste a Live Picture of a Cell - LivePicture.zip (45)
  • Page 699 - Monitor Far-off Cells in Excel 2002 and Later Versions - WatchWindow.zip (45)
  • Page 701 - Add a Page Break at Each Change in Customer - PgBrks.zip (45)
  • Page 707 - Use Horizontal Page Breaks Even When You Use Fit to N Pages Wide - HorizFit.zip (45)
  • Page 709 - Hide Error Cells When Printing - HideError.zip (45)
  • Page 710 - Organize Your Worksheet Tabs with Color - TabColor.zip (46)
  • Page 711 - Copy Cell Formatting, Including Column Widths - FormatPainter.zip (46)
  • Page 713 - Why Does Excel Mark All My TRUE Cells with an Indicator? - True.zip (46)
  • Page 715 - Debug from a Printed Spreadsheet - True.zip (46)
  • Page 716 - Copied Formula Has Strange Borders - EraseBorders.zip (46)
  • Page 718 - Double Underline a Grand Total - DubUnder.zip (46)
  • Page 719 - Use the Border Tab in the Format Cells Dialog - Borders2.zip (46)
  • Page 722 - Fit a Slightly Too-Large Value in a Cell - Fit.doc.zip (47)
  • Page 724 - Show Results as Fractions - Fraction.zip (47)
  • Page 727 - Color All Sales Green for a Day if Total Sales > $999 - RecGreen.zip (47)
  • Page 733 - Color Sales for a Day That Exceeds $999 - SalesOverQuota2.zip (47)
  • Page 737 - Turn off Wrap Text in Pasted Data - UnDoWrapText.zip (47)
  • Page 739 - Delete All Pictures in Pasted Data - RemoveObj.zip (47)
  • Page 741 - Draw an Arrow to Visually Illustrate That Two Cells Are Connected - Arrow.zip (47)
  • Page 743 - Add an AutoShape to Your Worksheet - F9Test.zip (48)
  • Page 746 - Draw Perfect Circles - Circle.zip (48)
  • Page 748 - Draw Perfect Squares - Square.zip (48)
  • Page 750 - Draw More Than the Four Basic Shapes - NewShapes.zip (48)
  • Page 753 - Change an Existing AutoShape - NewShapes.zip (48)
  • Page 756 - Add Text to an AutoShape - NewShapes.zip (48)
  • Page 758 - Use the Toolbar to Change Three Colors of an AutoShape - NewShapes.zip (49)
  • Page 763 - Rotate an AutoShape - NewShapes.zip (49)
  • Page 764 - Alter the Key Inflection Point in an AutoShape - NewShapes.zip (49)
  • Page 767 - Add a Shadow to an AutoShape - NewShapes.zip (49)
  • Page 770 - Add a 3-D Effect to an AutoShape - NewShapes.zip (49)
  • Page 774 - Add Connectors to Join Shapes - NewShapes.zip (49)
  • Page 777 - Join Two AutoShapes - NewShapes.zip (49)
  • Page 779 - Change Properties of Only One AutoShape in a Group - NewShapes.zip (49)
  • Page 782 - When Two AutoShapes Overlap, Control Which Is on Top - NewShapes.zip (49)
  • Page 784 - Make Any Logo into an AutoShape - Logo.zip (50)
  • Page 786 - Use the Scribble Tool - Scribble.zip (50)
  • Page 789 - Place Cell Contents in an AutoShape - ShapeFormula.zip (50)
  • Page 793 - Draw Business Diagrams with Excel - BizDiag.zip (50)
  • Page 801 - Draw Org Charts with Excel - OrgCharts.zip (50)
  • Page 808 - Add WordArt to a Chart or Worksheet - WordArt.zip (50)
  • Page 818 - Use MapPoint to Plot Data on a Map - MapMe.zip (50)
  • Page 821 - Add a Dropdown to a Cell - Dropdown.zip (31)
  • Page 825 - Store Lists for Dropdowns on a Hidden Sheet - Dropdown.zip (31)
  • Page 828 - Add a ToolTip to a Cell to Guide the Person Using the Workbook - CellTip.zip (31)
  • Page 830 - Configure Validation to “Ease up” - EaseUp.zip (31)
  • Page 833 - Use Validation to Create Dependent Lists - ValidDepend.zip (31)
Download all 217 files in learnfiles.zip

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.