Tuesday, March 25, 2014

101 Excel 2013 Tips, Tricks and Timesavers

by John Walkenbach    (Find this book)
Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself!
Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, "101 Excel 2013 Tips, Tricks, & Timesavers" will save you time and help you avoid common spreadsheet stumbling blocks. Reveals ways to maximize the power of Excel to create robust applications. Draws on John Walkenbach's years of experience using Excel and writing more than 50 booksShares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation. Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables.
"101 Excel 2013 Tips, Tricks, & Timesavers" is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! -- Publisher Marketing

Tuesday, March 18, 2014

Teach Yourself Visually Complete WordPress

by Janet Majure    (Find this book)

Take your WordPress skills to the next level with these tips, tricks, and tasks
Congratulations on getting your blog up and running with WordPress! Now are you ready to take it to the next level? "Teach Yourself VISUALLY Complete WordPress" takes you beyond the blogging basics with expanded tips, tricks, and techniques with clear, step-by-step instructions accompanied by screen shots. This visual book shows you how to incorporate forums, use RSS, obtain and review analytics, work with tools like Google AdSense, and much more.Shows you how to use mobile tools to edit and update blogs, implement SEO, and incorporate blogs into other services such as Facebook, LinkedIn, and Twitter and vice versa. Shares insight on best practices for maximizing WordPress.com and WordPress.org, customizing templates, and creating written and visual content.  Offers advice for working with a variety of other tools and sites to get maximum results for your blog.
Beef up your blog completely with "Teach Yourself VISUALLY Complete WordPress"!

Tuesday, March 11, 2014

Blog Design for Dummies ( For Dummies )

by Melissa Culbertson    (Find this book)
The average blogger does not typically have experience with design or coding, but that shouldn't deter them from having a professional-looking blog design. This friendly and easy-to-understand guide provides you with the tools you need to establish a creative, unique, and aesthetically memorable blog without having to learn how to code beyond some basic CSS. Whether you're looking to write for a major brand, become a brand ambassador, sell a product, acquire new clients, advocate for a cause, or simply tell a story, you'll find design tricks, helpful techniques, and invaluable advice for creating a great-looking and functional blog. Provides the tools you need to understand what makes a successful blog from a design standpoint. Teaches you CSS coding that can be used to create an effective blog design that gets noticed. Helps you make design decisions regarding colors, fonts, and imagery. Places special emphasis on providing your readers with a site that is easy to use thanks to smart navigation.

"Blog Design For Dummies" empowers you to make smart and creative adjustments to your blog so that you can be the proud owner of an effective blog design that gets noticed! -- Publisher Marketing

Tuesday, March 4, 2014

Teach Yourself Visually Complete Excel

by Paul McFedries    (Find this book)

Get the basics of Excel and then go beyond with this new instructional visual guide.
While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more.Offers step-by-step instructions on a variety of tasks, some everyday and some more unique. Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more. Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced tools
Offering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions. -- Publisher Marketing