Take your Excel formulas to the next level with this updated reference John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods yo…
A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing.
A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing.
A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing.
Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize the spreadsheet program Excel.
Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize the spreadsheet program Excel.
Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize the spreadsheet program Excel.
Getting started with Excel formulas and functions. Tapping into formula and function fundamentals ; Saving time with function tools ; Saying "array!" for formulas and functions ; Fixing formula boo-boos -- Doing the math. Calculating loan payments and interest rates ; Appreciati…
This thorough guide to Excel formulas and over 100 of the most popular functions covers the basics of setting up formulas as well as more advanced skills such visualizing data.
Veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world's most popular spreadsheet app. The book contains easy two-page lessons with large-size screenshots and walkthroughs demonstrating common and useful …
Become a stats superstar by using Excel to reveal the powerful secrets of statistics.
This is learning made easy. Gt more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screenshots show you exactly what to do, step by step.
"This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screenshots show you exactly what to do, step by step."--Page 4 of cover.
Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits It's time to put the full power of Excel quantitative analysis behind your management decisions! Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers a…
Provides information on efficiently creating Excel reports, covering such topics as keyboard shortcuts, style formation, formulas and functions, data analysis, charts, and conditional formatting.
Screenshots and step-by-step instructions explain how to use Microsoft Excel 2010 to manage, analyze, and present data, covering graphics, charts, diagrams, filters, PivotTables, templates, macros, and more.
A task-based introduction to the popular spreadsheet program explores the updated features of Microsoft Office Excel 2007, including the new user interface, the new charting engine, and Excel Services, while explaining how to enter, manipulate, analyze, and display data using Ex…