pickabook books with huge discounts for everyone
pickabook books with huge discounts for everyone
Visit our new collection website www.collectionsforschool.co.uk
     
Email: Subscribe to news & offers:
Need assistance? Log In/Register


Item Details
Title: POWER EXCEL 2007 WITH MREXCEL (VIDEO TRAINING)
By: Bill Jelen
Format: Mixed media product

List price: £28.99


We currently do not stock this item, please contact the publisher directly for further information.

ISBN 10: 0789738252
ISBN 13: 9780789738257
Publisher: PEARSON EDUCATION (US)
Pub. date: 1 April, 2008
Pages: 128
Description: Designed for Excel 2007 users, this video tutorial features demonstrations of more than 50 techniques that viewers can immediately apply in their own workbooks. This DVD package includes a 96-page booklet with an outline of the topics.
Synopsis: 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 Interface Lesson 1 Introducing the Ribbon Lesson 2 Quick Access Toolbar Lesson 3 Finding Icons Lesson 4 Keyboard Shortcuts Lesson 5 Mini Toolbar and Live Preview Lesson 6 Zoom Slider and Page Layout Lesson 7 Recent Documents Lesson 8 Save as PDF Lesson 9 Excel Options Lesson 10 Opening Templates, Closing Excel Part 2 Excel 2007 New Features Lesson 11 Unlocking the Big Grid, File Formats Lesson 12 Cell Styles and Themes Lesson 13 Data Visualizations Lesson 14 Tables and Table Formulas Lesson 15 Sort and Filter by Color Lesson 16 Duplicates Lesson 17 Picture Tools and WordArt Lesson 18 New Features Part 3 Text Lesson 19 Drag the Fill Handle to Extend a Series Lesson 20 Create Your Own Series Lesson 21 Joining Text Lesson 22 Rapid Formula Copy Lesson 23 Convert to Proper Case Lesson 24 Joining Dates Lesson 25 Converting Formulas to Values Lesson 26 Breaking Apart Text Lesson 27 Parsing Fixed Width Part 4 Excel Customizations Lesson 28 Data Entry Tricks Lesson 29 Customize All Future Workbooks Lesson 30 Copy Worksheets Lesson 31 Change All Worksheets Lesson 32 Arranging Windows Part 5 Sorting and Subtotals Lesson 33 Data Preparation Lesson 34 Sorting Basics Lesson 35 Random Sort Lesson 36 Sorting by Weekday Lesson 37 Rearranging Columns Lesson 38 Subtotals Lesson 39 Collapsing Subtotals Lesson 40 Copy Subtotals Lesson 41 Formatting Subtotals Lesson 42 Multiple Subtotals Lesson 43 Filling In Data on Subtotal Rows Lesson 44 Subtotal Tricks Part 6 Pivot Tables Lesson 45 Creating a Pivot Table Lesson 46 Changing a Pivot Table Lesson 47 Pivot Gotchas Lesson 48 Pivot Sorting Lesson 49 Drill Down Lesson 50 Summarizing Dates Lesson 51 Top 10 Report Lesson 52 Pivot Calculations Lesson 53 Pivot Formatting Lesson 54 Unique List Lesson 55 Ad-Hoc Queries Lesson 56 New Filtering Options Lesson 57 50 Reports in 5 Seconds Lesson 58 Pivot Compatibility Lesson 59 Making Reports Pivotable Part 7 Charting and SmartArt Lesson 60 Creating and Formatting a Chart Lesson 61 Adding or Removing Chart Data Lesson 62 Interactive Chart Lesson 63 Charting Differing Orders of Magnitude Lesson 64 Pie Chart Tricks, Histograms Lesson 65 XY and Bubble Charts Lesson 66 Saving Favorite Chart Settings Lesson 67 Creating Smart Art Lesson 68 Formulas in Smart Art Part 8 Formulas Lesson 69 AutoSum Tricks Lesson 70 Formula Auditing Lesson 71 Three Ways of Entering Formulas Lesson 72 Relative Versus Absolute Formulas Lesson 73 Discovering Functions Lesson 74 Goal Seek Lesson 75 Unusual Functions Lesson 76 IF Formulas Lesson 77 VLOOKUP Lesson 78 IFERROR Lesson 79 SUMIFS Lesson 80 Super Formulas Lesson 81 Date and Time Part 9 Macros Lesson 82 Recording a Macro Lesson 83 Recording Navigation Lesson 84 How Many Rows?Lesson 85 Event Macros Part 10 Tips and Tricks Lesson 86 Finding Records Lesson 87 Web Queries Lesson 88 Copying Column Widths Lesson 89 Page Numbering Lesson 90 Turn Data Lesson 91 & in Header Lesson 92 Choose from a List Lesson 93 Tool Tips for a Cell Lesson 94 Word Processing in Excel Lesson 95 Have a Talk with Excel
Illustrations: sd., col.
Publication: US
Imprint: Que Corporation,U.S.
Returns: Returnable
Some other items by this author:
ADVANCE EXCEL 2016 IN DEPTH (PB)
BRILLIANT MICROSOFT EXCEL 2007 CHARTS & GRAPHS (PB)
BRILLIANT MICROSOFT EXCEL 2007 PIVOT TABLES (PB)
BRILLIANT MICROSOFT EXCEL 2007 VBA AND MACROS (PB)
CHARTS AND GRAPHS (PB)
CHARTS AND GRAPHS FOR MICROSOFT OFFICE EXCEL 2007 (PB)
CTRL+SHIFT+ENTER (PB)
DON'T FEAR THE SPREADSHEET (PB)
EXCEL 2007 MIRACLES MADE EASY (PB)
EXCEL 2010 LAMINATED TIP CARD
EXCEL 2013 CHARTS AND GRAPHS (PB)
EXCEL 2013 IN DEPTH
EXCEL 2013 IN DEPTH (PB)
EXCEL 2013 IN DEPTH / POWER EXCEL 2013 WITH MREXCEL LIVELESSONS BUNDLE
EXCEL 2013 LAMINATED TIP CARD
EXCEL 2013 PIVOT TABLE DATA CRUNCHING
EXCEL 2013 PIVOT TABLE DATA CRUNCHING (PB)
EXCEL 2013 VBA AND MACROS
EXCEL 2013 VBA AND MACROS (PB)
EXCEL 2016 IN DEPTH (PB)
EXCEL 2016 PIVOT TABLE DATA CRUNCHING (PB)
EXCEL 2016 VBA AND MACROS (PB)
EXCEL CHARTING LAMINATED TIP CARD
EXCEL FOR AUDITORS (PB)
EXCEL FOR MARKETING MANAGERS (PB)
EXCEL FOR TEACHERS
EXCEL FOR TEACHERS (PB)
EXCEL FOR THE MATH CLASSROOM (PB)
EXCEL FORMULAS LAMINATED TIP CARD
EXCEL GURUS GONE WILD (PB)
EXCEL MACRO RECORDER TO VBA LAMINATED TIP CARD
EXCEL PIVOT TABLES LAMINATED TIP CARD
EXCEL VBA AND MACROS WITH MREXCEL LIVELESSONS (VIDEO TRAINING)
EXCEL VLOOKUP LAMINATED TIP CARD
GUERILLA DATA ANALYSIS USING MICROSOFT EXCEL
GUERILLA DATA ANALYSIS USING MICROSOFT EXCEL
GUERRILLA DATA ANALYSIS USING MICROSOFT EXCEL
GUERRILLA DATA ANALYSIS USING MICROSOFT EXCEL (PB)
HOLY MACRO! IT'S 2,500 EXCEL VBA EXAMPLES (CD)
LEARN EXCEL 2007 THROUGH EXCEL 2010 FROM MR EXCEL (PB)
LEARN EXCEL 2007 THROUGH EXCEL 2010 FROM MREXCEL
LEARN EXCEL 2007 THROUGH EXCEL 2010 FROM MREXCEL
LEARN EXCEL 97 THROUGH EXCEL 2007 FROM MR EXCEL (PB)
MASTERING EXCEL 2010 (PB)
MICROSOFT EXCEL 2010 IN DEPTH (PB)
MICROSOFT EXCEL 2019 INSIDE OUT (PB)
MICROSOFT EXCEL 2019 PIVOT TABLE DATA CRUNCHING
MICROSOFT EXCEL 2019 VBA AND MACROS
MICROSOFT EXCEL 365 PIVOT TABLE DATA CRUNCHING
MICROSOFT EXCEL 365 VBA AND MACROS
MICROSOFT EXCEL INSIDE OUT
MICROSOFT EXCEL PIVOT TABLE DATA CRUNCHING INCLUDING DYNAMIC ARRAYS, POWER QUERY, AND COPILOT
MICROSOFT EXCEL VBA AND MACROS (MICROSOFT 365 AND EXCEL 2024)
MREXCEL 2021
MREXCEL 2022
MREXCEL 23
MREXCEL LIVE (PB)
MREXCEL LX THE HOLY GRAIL OF EXCEL TIPS
MREXCEL XL
MREXCEL XL
MREXCEL XL (PB)
PIVOT TABLE DATA CRUNCHING
PIVOT TABLE DATA CRUNCHING (PB)
PIVOT TABLE DATA CRUNCHING (PB)
PIVOT TABLE DATA CRUNCHING FOR MICROSOFT OFFICE EXCEL 2007 (PB)
POWER EXCEL 2003 WITH MREXCEL LIVELESSONS (VIDEO TRAINING)
POWER EXCEL 2003 WITH MREXCEL LIVELESSONS (VIDEO TRAINING)
POWER EXCEL 2007 LIVELESSON BUNDLE
POWER EXCEL 2010 WITH MREXCEL LIVELESSONS (VIDEO TRAINING) (VID)
POWER EXCEL 2013 WITH MREXCEL LIVELESSONS (VIDEO TRAINING)
POWER EXCEL 2019 WITH MREXCEL (PB)
POWER EXCEL WITH MREXCEL
POWER EXCEL WITH MREXCEL
POWER EXCEL WITH MREXCEL (PB)
POWER EXCEL WITH MREXCEL (PB)
POWERPIVOT ALCHEMY
POWERPIVOT ALCHEMY
POWERPIVOT ALCHEMY (PB)
POWERPIVOT FOR THE DATA ANALYST
POWERPIVOT FOR THE DATA ANALYST (PB)
REV UP TO EXCEL 2010 (PB)
SPECIAL EDITION USING MICROSOFT OFFICE EXCEL 2007 (PB)
UNLEASH THE POWER OF ONENOTE (PB)
USING MICROSOFT EXCEL 2010 (PB)
VBA AND MACROS
VBA AND MACROS (PB)
VBA AND MACROS FOR MICROSOFT EXCEL (PB)
VBA AND MACROS FOR MICROSOFT OFFICE EXCEL 2007 (PB)
VLOOKUP AWESOME QUICK

TOP SELLERS IN THIS CATEGORY
MOS 2016 Study Guide for Microsoft Excel Expert (Paperback)
Microsoft Press,U.S.
Our Price : £15.25
more details
Excel 2016 in Depth (Paperback)
Pearson Education (US)
Our Price : £24.33
more details
Brilliant Excel VBA Programming (Paperback)
Pearson Education Limited
Our Price : £16.49
more details
Analyzing Data with Power BI and Power Pivot for Excel (Paperback)
Microsoft Press,U.S.
Our Price : £22.12
more details
Excel 2013 Power Programming with VBA (Paperback)
John Wiley & Sons Inc
Our Price : £32.85
more details
BROWSE FOR BOOKS IN RELATED CATEGORIES
 COMPUTING AND INFORMATION TECHNOLOGY
 computer software packages
 spreadsheet software
 excel


Information provided by www.pickabook.co.uk
SHOPPING BASKET
  
Your basket is empty
  Total Items: 0
 






Early Learning
Little Worried Caterpillar (PB) Little Green knows she''s about to make a big change - transformingfrom a caterpillar into a beautiful butterfly. Everyone is VERYexcited! But Little Green is VERY worried. What if being a butterflyisn''t as brilliant as everyone says?Join Little Green as she finds her own path ... with just a littlehelp from her friends.
add to basket

Early Learning
add to basket

Picture Book
All the Things We Carry PB What can you carry?A pebble? A teddy? A bright red balloon? A painting you''ve made?A hope or a dream?This gorgeous, reassuring picture book celebrates all the preciousthings we can carry, from toys and treasures to love and hope. With comforting rhymes and fabulous illustrations, this is a warmhug of a picture book.
add to basket