Catalog Search Results
10) Modern data analytics in Excel: using Power Query, Power Pivot, and more for enhanced data analytics
Author
Publisher
O'Reilly Media, Inc
Pub. Date
2024.
Language
English
Description
If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics. George Mount of Stringfest Analytics shows business analysts, data analysts, and business...
Author
Series
Publisher
In Easy Steps
Pub. Date
[2023]
Language
English
Description
Excel VBA in easy steps, 4th edition neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. This 4th edition is updated for Microsoft 365. Areas covered include: Recording and editing Macros; Creating your own Macro programs; Coding with the VBA language; Responding to Worksheet events; Programming Excel procedures; Making...
Author
Publisher
John Wiley & Sons, Inc
Pub. Date
2016
Language
English
Description
Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis--SQL and Excel--to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the...
Author
Series
Publisher
John Wiley & Sons, Inc
Pub. Date
[2019]
Language
English
Description
"Office 365 is Microsoft's #1 productivity suite, and this book helps you get work accomplished with it right away. The minibooks found inside explain how to use each application, how the applications work together, what commands and features are common to all the tools, ways you can streamline your work, and how to collaborate online with other users."--Back cover.
Author
Series
Publisher
In Easy Steps Limited
Pub. Date
[2023]
Language
English
Description
"Microsoft Excel in easy steps guides you through the essential functions of Microsoft Excel - whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing."--Amazon.
Didn't find it?
Can't find what you are looking for? Make a purchase suggestion. Submit Request