Power Excel 2007 with MrExcel (Video Training)

Power Excel 2007 with MrExcel (Video Training)

4 (5 ratings by Goodreads)
By (author) 

List price: US$32.99

Currently unavailable

We can notify you when this item is back in stock

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Power Excel 2007 with MrExcel Mastering the Smartest, Fastest Ways to Use Excel 2007 Bill Jelen For anyone who wants to get more done in less time with Excel 2007-from entrepreneurs to financial analysts, marketers to office managers! Bill Jelen ("MrExcel") presents focused, practical videos that teach you Excel 2007's best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, automation, and a whole lot more! Click play to follow along as Jelen walks you through using Excel 2007's most sophisticated features... all you need to do is watch! You've got Microsoft Excel...now get the most out of it, faster and more easily than ever before! In more than 90 quick video lessons, Bill Jelen ("MrExcel") shows you all you need to maximize your productivity with Excel 2007. Building on the live course he's taught to thousands of financial professionals, Jelen walks you through Excel's most powerful features and techniques. Just watch: You'll master Excel 2007's new Ribbon interface and most powerful techniques at your own pace-and get specific answers and solutions immediately, whenever you need them! These practical, easy-to-use videos cover Excel 2007's hottest new features: everything from charting improvements to conditional formatting, filtering to SmartArt. You'll find up-to-the-minute tips and tricks for using PivotTables, managing and automating worksheets, and a whole lot more-great new solutions that could save you hours every single week! Looking for a better way to master today's rapidly changing technologies? Want expert help but don't have the time or energy to read a book? Can't find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world's leading experts. LiveLessons is an eight-hour video course organized into bite-sized, self-contained sessions-you'll learn key skills in as little as five minutes! Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your instructor shows exactly how to get great results in your real-world environment. Bill Jelen is known worldwide as MrExcel. He presents live Excel seminars to accountants throughout the U.S. and has logged more than 60 appearances on The Lab with Leo Laporte. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his "Learn Excel from MrExcel" video podcast. He writes the monthly Excel column for Strategic Finance magazine. Microsoft Office Spreadsheets/Desktop Applications Contents: Part 1 Excel 2007 InterfaceLesson 1 Introducing the RibbonLesson 2 Quick Access ToolbarLesson 3 Finding IconsLesson 4 Keyboard ShortcutsLesson 5 Mini Toolbar and Live PreviewLesson 6 Zoom Slider and Page LayoutLesson 7 Recent DocumentsLesson 8 Save as PDFLesson 9 Excel OptionsLesson 10 Opening Templates, Closing ExcelPart 2 Excel 2007 New FeaturesLesson 11 Unlocking the Big Grid, File FormatsLesson 12 Cell Styles and ThemesLesson 13 Data VisualizationsLesson 14 Tables and Table FormulasLesson 15 Sort and Filter by ColorLesson 16 DuplicatesLesson 17 Picture Tools and WordArtLesson 18 New FeaturesPart 3 TextLesson 19 Drag the Fill Handle to Extend a SeriesLesson 20 Create Your Own SeriesLesson 21 Joining TextLesson 22 Rapid Formula CopyLesson 23 Convert to Proper CaseLesson 24 Joining DatesLesson 25 Converting Formulas to ValuesLesson 26 Breaking Apart TextLesson 27 Parsing Fixed WidthPart 4 Excel CustomizationsLesson 28 Data Entry TricksLesson 29 Customize All Future WorkbooksLesson 30 Copy WorksheetsLesson 31 Change All WorksheetsLesson 32 Arranging WindowsPart 5 Sorting and SubtotalsLesson 33 Data PreparationLesson 34 Sorting BasicsLesson 35 Random SortLesson 36 Sorting by WeekdayLesson 37 Rearranging ColumnsLesson 38 SubtotalsLesson 39 Collapsing SubtotalsLesson 40 Copy SubtotalsLesson 41 Formatting SubtotalsLesson 42 Multiple SubtotalsLesson 43 Filling In Data on Subtotal RowsLesson 44 Subtotal TricksPart 6 Pivot TablesLesson 45 Creating a Pivot TableLesson 46 Changing a Pivot TableLesson 47 Pivot GotchasLesson 48 Pivot SortingLesson 49 Drill DownLesson 50 Summarizing DatesLesson 51 Top 10 ReportLesson 52 Pivot CalculationsLesson 53 Pivot FormattingLesson 54 Unique ListLesson 55 Ad-Hoc QueriesLesson 56 New Filtering OptionsLesson 57 50 Reports in 5 SecondsLesson 58 Pivot CompatibilityLesson 59 Making Reports PivotablePart 7 Charting and SmartArtLesson 60 Creating and Formatting a ChartLesson 61 Adding or Removing Chart DataLesson 62 Interactive ChartLesson 63 Charting Differing Orders of MagnitudeLesson 64 Pie Chart Tricks, HistogramsLesson 65 XY and Bubble ChartsLesson 66 Saving Favorite Chart SettingsLesson 67 Creating Smart ArtLesson 68 Formulas in Smart ArtPart 8 FormulasLesson 69 AutoSum TricksLesson 70 Formula AuditingLesson 71 Three Ways of Entering FormulasLesson 72 Relative Versus Absolute FormulasLesson 73 Discovering FunctionsLesson 74 Goal SeekLesson 75 Unusual FunctionsLesson 76 IF FormulasLesson 77 VLOOKUPLesson 78 IFERRORLesson 79 SUMIFSLesson 80 Super FormulasLesson 81 Date and TimePart 9 MacrosLesson 82 Recording a MacroLesson 83 Recording NavigationLesson 84 How Many Rows?Lesson 85 Event MacrosPart 10 Tips and TricksLesson 86 Finding RecordsLesson 87 Web QueriesLesson 88 Copying Column WidthsLesson 89 Page NumberingLesson 90 Turn DataLesson 91 & in HeaderLesson 92 Choose from a ListLesson 93 Tool Tips for a CellLesson 94 Word Processing in ExcelLesson 95 Have a Talk with Excel
show more

Product details

  • Mixed media product | 128 pages
  • 190.5 x 228.6 x 27.94mm | 362.87g
  • Que Corporation,U.S.
  • Indianapolis, IN, United States
  • English
  • 0789738252
  • 9780789738257
  • 1,453,539

About Bill Jelen

Bill Jelen is the host of MrExcel.com and the author of 20 books on Microsoft Excel, including Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA & Macros for Microsoft Excel. He has made more than 75 guest appearances on TechTV with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced more than 600 episodes of his daily video Learn Excel podcast. Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent 12 years "in the trenches" as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company has automated Excel reports for hundreds of clients around the world. The website answers more than 30,000 questions a year-for free-for readers all over the world.
show more

Table of contents

Introduction Part 1 Excel 2007 InterfaceLesson 1 Introducing the RibbonWhat You Will LearnRelated LessonsNotes from the LessonLesson 2 Quick Access ToolbarWhat You Will LearnMore Details Notes from the LessonLesson 3 Finding IconsWhat You Will LearnRelated LessonsNotes from the LessonLesson 4 Keyboard ShortcutsWhat You Will LearnRelated LessonsNotes from the LessonLesson 5 Mini Toolbar and Live PreviewWhat You Will LearnRelated LessonsNotes from the LessonLesson 6 Zoom Slider and Page LayoutWhat You Will LearnNotes from the LessonLesson 7 Recent DocumentsWhat You Will LearnRelated LessonsNotes from the LessonLesson 8 Save as PDFWhat You Will LearnNotes from the LessonLesson 9 Excel OptionsWhat You Will LearnRelated LessonsNotes from the LessonLesson 10 Opening Templates, Closing ExcelWhat You Will LearnRelated LessonsNotes from the LessonPart 2 Excel 2007 New FeaturesLesson 11 Unlocking the Big Grid, File FormatsWhat You Will LearnNotes from the LessonLesson 12 Cell Styles and ThemesWhat You Will LearnNotes from the LessonLesson 13 Data VisualizationsWhat You Will LearnNotes from the LessonLesson 14 Tables and Table FormulasWhat You Will LearnRelated LessonsNotes from the LessonLesson 15 Sort and Filter by ColorWhat You Will LearnRelated LessonsNotes from the LessonLesson 16 DuplicatesWhat You Will LearnRelated LessonsNotes from the LessonLesson 17 Picture Tools and WordArtWhat You Will LearnNotes from the LessonLesson 18 New FeaturesWhat You Will LearnRelated LessonsNotes from the LessonPart 3 TextLesson 19 Drag the Fill Handle to Extend a SeriesWhat You Will LearnRelated LessonsNotes from the LessonLesson 20 Create Your Own SeriesWhat You Will LearnRelated LessonsNotes from the LessonLesson 21 Joining TextWhat You Will LearnRelated LessonsNotes from the LessonLesson 22 Rapid Formula CopyWhat You Will LearnRelated LessonsNotes from the LessonLesson 23 Convert to Proper CaseWhat You Will LearnNotes from the LessonLesson 24 Joining DatesWhat You Will LearnRelated LessonsNotes from the LessonLesson 25 Converting Formulas to ValuesWhat You Will LearnNotes from the LessonLesson 26 Breaking Apart TextWhat You Will LearnRelated LessonsNotes from the LessonLesson 27 Parsing Fixed WidthWhat You Will LearnRelated LessonsNotes from the LessonPart 4 Excel CustomizationsLesson 28 Data Entry TricksWhat You Will LearnNotes from the LessonLesson 29 Customize All Future WorkbooksWhat You Will LearnRelated LessonsNotes from the LessonLesson 30 Copy WorksheetsWhat You Will LearnNotes from the LessonLesson 31 Change All WorksheetsWhat You Will LearnRelated LessonsNotes from the LessonLesson 32 Arranging WindowsWhat You Will LearnNotes from the LessonPart 5 Sorting and SubtotalsLesson 33 Data PreparationWhat You Will LearnNotes from the LessonLesson 34 Sorting BasicsWhat You Will LearnRelated LessonsNotes from the LessonLesson 35 Random SortWhat You Will LearnRelated LessonsNotes from the LessonLesson 36 Sorting by WeekdayWhat You Will LearnRelated LessonsNotes from the LessonLesson 37 Rearranging ColumnsWhat You Will LearnRelated LessonsNotes from the LessonLesson 38 SubtotalsWhat You Will LearnRelated LessonsNotes from the LessonLesson 39 Collapsing SubtotalsWhat You Will LearnRelated LessonsNotes from the LessonLesson 40 Copy SubtotalsWhat You Will LearnRelated LessonsNotes from the LessonLesson 41 Formatting SubtotalsWhat You Will LearnRelated LessonsNotes from the LessonLesson 42 Multiple SubtotalsWhat You Will LearnMore Details Notes from the LessonLesson 43 Filling In Data on Subtotal RowsWhat You Will LearnRelated LessonsNotes from the LessonLesson 44 Subtotal TricksWhat You Will LearnNotes from the LessonPart 6 Pivot TablesLesson 45 Creating a Pivot TableWhat You Will LearnRelated LessonsNotes from the LessonLesson 46 Changing a Pivot TableWhat You Will LearnRelated LessonsNotes from the LessonLesson 47 Pivot GotchasWhat You Will LearnNotes from the LessonLesson 48 Pivot SortingWhat You Will LearnNotes from the LessonLesson 49 Drill DownWhat You Will LearnNotes from the LessonLesson 50 Summarizing DatesWhat You Will LearnRelated LessonsNotes from the LessonLesson 51 Top 10 ReportWhat You Will LearnRelated LessonsNotes from the LessonLesson 52 Pivot CalculationsWhat You Will LearnNotes from the LessonLesson 53 Pivot FormattingWhat You Will LearnRelated LessonsNotes from the LessonLesson 54 Unique ListWhat You Will LearnRelated LessonsNotes from the LessonLesson 55 Ad-Hoc QueriesWhat You Will LearnRelated LessonsNotes from the LessonLesson 56 New Filtering OptionsWhat You Will LearnRelated LessonsNotes from the LessonLesson 57 50 Reports in 5 SecondsWhat You Will LearnRelated LessonsNotes from the LessonLesson 58 Pivot CompatibilityWhat You Will LearnNotes from the LessonLesson 59 Making Reports PivotableWhat You Will LearnNotes from the LessonPart 7 Charting and SmartArtLesson 60 Creating and Formatting a ChartWhat You Will LearnRelated LessonsNotes from the LessonLesson 61 Adding or Removing Chart DataWhat You Will LearnNotes from the LessonLesson 62 Interactive ChartWhat You Will LearnRelated LessonsNotes from the LessonLesson 63 Charting Differing Orders of MagnitudeWhat You Will LearnNotes from the LessonLesson 64 Pie Chart Tricks, HistogramsWhat You Will LearnNotes from the LessonLesson 65 XY and Bubble ChartsWhat You Will LearnNotes from the LessonLesson 66 Saving Favorite Chart SettingsWhat You Will LearnRelated LessonsNotes from the LessonLesson 67 Creating Smart ArtWhat You Will LearnRelated LessonsNotes from the LessonLesson 68 Formulas in Smart ArtWhat You Will LearnRelated LessonsNotes from the LessonPart 8 FormulasLesson 69 AutoSum TricksWhat You Will LearnNotes from the LessonLesson 70 Formula AuditingWhat You Will LearnNotes from the LessonLesson 71 Three Ways of Entering FormulasWhat You Will LearnRelated LessonsNotes from the LessonLesson 72 Relative Versus Absolute FormulasWhat You Will LearnNotes from the LessonLesson 73 Discovering FunctionsWhat You Will LearnNotes from the LessonLesson 74 Goal SeekWhat You Will LearnNotes from the LessonLesson 75 Unusual FunctionsWhat You Will LearnRelated LessonsNotes from the LessonLesson 76 IF FormulasWhat You Will LearnRelated LessonsNotes from the LessonLesson 77 VLOOKUPWhat You Will LearnNotes from the LessonLesson 78 IFERRORWhat You Will LearnNotes from the LessonLesson 79 SUMIFSWhat You Will LearnRelated LessonsNotes from the LessonLesson 80 Super FormulasWhat You Will LearnNotes from the LessonLesson 81 Date and TimeWhat You Will LearnNotes from the LessonPart 9 MacrosLesson 82 Recording a MacroWhat You Will LearnRelated LessonsNotes from the LessonLesson 83 Recording NavigationWhat You Will LearnRelated LessonsNotes from the LessonLesson 84 How Many Rows?What You Will LearnRelated LessonsNotes from the LessonLesson 85 Event MacrosWhat You Will LearnRelated LessonsNotes from the LessonPart 10 Tips and TricksLesson 86 Finding RecordsWhat You Will LearnRelated LessonsNotes from the LessonLesson 87 Web QueriesWhat You Will LearnNotes from the LessonLesson 88 Copying Column WidthsWhat You Will LearnNotes from the LessonLesson 89 Page NumberingWhat You Will LearnRelated LessonsNotes from the LessonLesson 90 Turn DataWhat You Will LearnNotes from the LessonLesson 91 & in HeaderWhat You Will LearnNotes from the LessonLesson 92 Choose from a ListWhat You Will LearnNotes from the LessonLesson 93 Tool Tips for a CellWhat You Will LearnNotes from the LessonLesson 94 Word Processing in ExcelWhat You Will LearnNotes from the LessonLesson 95 Have a Talk with ExcelWhat You Will LearnNotes from the LessonAfterword 0789738252 TOC 3/21/2008
show more

Rating details

5 ratings
4 out of 5 stars
5 20% (1)
4 60% (3)
3 20% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X