Pivot Table Data Crunching

Just after a promising job interview and before the job offer, many of today’s applicants are marched through an unassuming ritual called “the business lunch” so prospective employers can determine whether or not candidates have “the right stuff.” And while it may look innocent enough, this one meal often “makes or breaks” the applicant’s future with the interviewing corporation. Most college career counselors and many business schools prepare new grads for the job search with good baseline education and technical information, interview techniques, resume-writing skills and corporate research pointers but few of today’s job candidates have any guidance about conducting a successful business lunch/second interview. That’s when Rachel Seff – director of the University of Houston’s College of Business Career Center, Dr. Ron Adams, a veteran educator and Alice Adams, a former professor and current employment writer with The Houston Chronicle joined forces and developed the manuscript, “60 Minutes To Success: The Ultimate Guide to Power Lunching.

This Element is an excerpt from Focus: Your Key to More Productivity at Work (ISBN: 9780137002566) by Jurgen Wolff. Available in print and digital formats.

How to manage information overload so you can focus your efforts where you can have the greatest impact!

Information overload is one of the biggest problems plaguing creative people, who are naturally curious and tend to seek lots of ideas. It’s easy to be overwhelmed by the input from TV, radio, magazines, newspapers, and especially the Internet. Learning how to deal with this flood is vital if you’re to focus your effort where it will have most value.

In just 24 sessions of one hour or less, learn how to use today’s key networking techniques and technologies to build, secure, and troubleshoot both wired and wireless networks. Using this book’s straightforward, step-by-step approach, you master every skill you need–from working with Ethernet and Bluetooth to spam prevention to network troubleshooting. Each lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success!

Step-by-step instructions carefully walk you through the most common networking tasks.

Q&A sections at the end of each hour help you test your knowledge.

By the Way notes present interesting information related to the discussion.

Did You Know? tips offer advice or show you easier ways to perform tasks.

Watch Out! cautions alert you to possible problems and give you advice on how to avoid them.

Learn how to…

• Choose the right network hardware and software and use it to build efficient, reliable networks
• Implement secure, high-speed Internet connections
• Provide reliable remote access to your users
• Administer networks to support users of Microsoft, Linux, and UNIX environments
• Use low-cost Linux servers to provide file and print services to Windows PCs
• Protect your networks and data against today’s most dangerous threats
• Use virtualization to save money and improve business flexibility
• Utilize RAID technologies to provide flexible storage at lower cost
• Troubleshoot and fix network problems one step at a time
• Preview and prepare for the future of networking

• Childproof your Mac, with Mac OS X Lion
  

• Secure your Mac, with Mac OS X Lion
  

• Spruce up iTunes, by adding album art and lyrics and removing duplicate songs

• Video conferencing, with Mac OS X Lion

• Powering your home theater from your Mac

Maximize your Excel 2013 experience using VBA application development

The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

• Offers an analysis of Excel application development and a complete introduction to VBA
• Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small
• Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills
• Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else

Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.

Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you ever imagined.

Packed with easy-to-understand advice regarding all aspects of Excel, this book shares improved ways of speeding up application development with Excel and maximizing the power of Excel to create robust applications.

• Addresses the extensive changes to the 2010 version of Excel and shares tricks and shortcuts for making your Excel experience as successful and efficient as possible
• Reveals ways to deal with function arguments, create "impossible" charts, and tame the Ribbon bar
• Discusses absolute vs. relative references, change data entry orientation, and sort more than three columns
• Demonstrates ways to enter fake data for testing purposes

Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an “Excel Report.” What they don’t offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.

• Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization
• Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly
• Shows how to automate redundant reporting and analyses