Sign-In
Cart
Excel 2019 Functions: 70 Top Excel Functions Made Easy
Paperback
Series: Excel 2019 Mastery, Book 3
ISBN13: 9781796379945
Publisher: Independently Published
Published: Feb 7 2019
Pages: 206
Weight: 0.62
Height: 0.44 Width: 6.00 Depth: 9.00
Language: English
Excel 2019 Functions provides a detailed walkthrough of 70 of the most useful Excel functions, including many tips to enable you to maximize the power of Excel through the use of functions.
This book provides a detailed description of each function, its arguments, and its use is demonstrated with fitting examples. Learn how to use functions like VLOOKUP, IFS, COUNTIFS, DATEDIF, NETWORKDAYS, FIND, NPV, SUMIFS etc. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.
Learn new functions introduced in Excel 2016 and 2019 like the IFS functions that enable you to create more powerful formulas with less syntax.
Excel 2019 Functions is a great reference guide for Excel functions whether you're a beginner or already competent with Excel. By the time you finish this guide, you will understand how functions work in Excel, how to find the right functions, and how to combine them in solving complex problems.
This book comes with downloadable Excel practice files for all examples, so, you can follow the tutorials without needing to create the examples from scratch.
In this book, you'll learn how to:- Find and enter functions in Excel.
- Use lookup and reference functions to find and reference values in your formulas.
- Use logical functions to execute conditional statements and calculations.
- Deploy IFS functions in place of convoluted nested functions for more efficient and robust formulas.
- Use a wide array of date and time functions to address all kinds of date calculations.
- Manipulate text strings with text functions.
- Carry out financial calculations with special financial functions.
- And much more...
Scroll up and click the 'Add to Cart' button on the right-hand side of the page to get started today!
1 different editions
Also available
Also in
Applications
Excel Formulas: Quickstudy Laminated Study Guide (Quickstudy Computer)
Jensen, Krista
Hales, John
Other
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Cetinkaya-Rundel, Mine
Wickham, Hadley
Grolemund, Garrett
Paperback
Dark Web: A Comprehensive Guide to Its Mechanics and Risks (The Insidious Happenings Lurking Right Beneath Our Internet Haven)
McClendon, Adolfo
Paperback
Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
Huyen, Chip
Paperback
Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Bruce, Andrew
Gedeck, Peter
Bruce, Peter
Paperback
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Zelensky, Maxim
Kolokolov, Alex
Paperback
Social Science Research Design and Statistics: A Practitioner's Guide to Research Methods and IBM SPSS Analysis
Rovai, Alfred P.
Baker, Jason D.
Ponton, Michael K.
Paperback
Software Wasteland: How the Application-Centric Mindset is Hobbling our Enterprises
McComb, Dave
Paperback
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
Paperback
Microsoft Excel in Easy Steps: Illustrated Using Excel in Microsoft 365
Price, Michael
McGrath, Mike
Paperback
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Storment, J. R.
Fuller, Mike
Paperback
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
Paperback
Orchestrating Transformation: How to Deliver Winning Performance with a Connected Approach to Change
Noronha, Andy
Wade, Michael
Macaulay, James
Hardcover
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Ferrari, Alberto
Russo, Marco
Paperback
Microsoft Excel 365 Tips & Tricks - 2019: A Quickstudy Laminated Software Reference Guide
Frye, Curtis
Other
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Mount, George
Paperback
Hands-On Salesforce Data Cloud: Implementing and Managing a Real-Time Customer Data Platform
Avila, Joyce Kay
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
Master Your Data with Power Query in Excel and Power Bi: Leveraging Power Query to Get & Transform Your Task Flow
Escobar, Miguel
Puls, Ken
Paperback
Excel 2023: A Comprehensive Guide to become an Expert on Excel 2023 With All-in-One Approach
Wright, Leonardo L.
Paperback
Prometheus: Up & Running: Infrastructure and Application Performance Monitoring
Brazil, Brian
Pivotto, Julien
Paperback
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
The Mathematical Corporation: Where Machine Intelligence and Human Ingenuity Achieve the Impossible
Zutavern, Angela
Sullivan, Josh
Hardcover
An Introduction to Statistical Learning: With Applications in Python
Witten, Daniela
Hastie, Trevor
James, Gareth
Hardcover
No B.S. Guide to Successful Marketing Automation: The Ultimate No Holds Barred Guide to Using Technology, Automation, and Artificial Intelligence in M
Shah, Parthiv
Kennedy, Dan S.
Paperback
React and React Native - Fifth Edition: Build cross-platform JavaScript and TypeScript apps for the web, desktop, and mobile
Boduch, Adam
Sakhniuk, Mikhail
Paperback
Learning Microsoft Power Apps: Building Business Applications with Low-Code Technology
Shrivastava, Arpit
Paperback
Fundamentals of Enterprise Architecture: Proven Frameworks for Effective Architecture Decisions
McCabe, Tanu
Paperback
Machine Learning Production Systems: Engineering Machine Learning Models and Pipelines
Crowe, Robert
Hapke, Hannes
Caveness, Emily
Paperback
Power Pivot and Power Bi: The Excel User's Guide to Dax, Power Query, Power Bi & Power Pivot in Excel 2010-2016
Collie, Rob
Singh, Avichal
Paperback
Mastering QuickBooks 2024 - Fifth Edition: Bookkeeping with US QuickBooks Online for small businesses
Shelton, Crystalynn
Paperback
Building LLM Powered Applications: Create intelligent apps and agents with large language models
Alto, Valentina
Paperback
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
The Transformative Magic of M Code in Power Query Excel & Power Bi: A Beginner's Guide to Mastering the Art of Data Metamorphosis to Get Just the Data
Girvin, Mike Excelisfun
Paperback
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
Software Profit Streams(TM): A Guide to Designing a Sustainably Profitable Business
Tanner, Jason
Hohmann, Luke
Paperback
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Lakshmanan, Valliappa
Robinson, Sara
Munn, Michael
Paperback
Generative AI with LangChain: Build large language model (LLM) apps with Python, ChatGPT, and other LLMs
Auffarth, Ben
Paperback
Fundamentals of Deep Learning: Designing Next-Generation Machine Intelligence Algorithms
Papa, Joe
Buduma, Nithin
Buduma, Nikhil
Paperback
Microsoft Outlook 365 - 2019: A Quickstudy Laminated Software Reference Guide
Belasco, Elizabeth
Lambert, Joan
Other
Microsoft PowerPoint 365 - 2019: A Quickstudy Laminated Software Reference Guide
Lambert, Joan
Belasco, Elizabeth
Other
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
Microsoft 365 Copilot at Work: Using AI to Get the Most from Your Business Data and Favorite Apps
Flock, Thomas
Van Laan, Sandar
Matfess, Jared
Paperback
Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
Maslyuk, Daniil
Raviv, Gil
Paperback
Microsoft 365 and SharePoint Online Cookbook - Second Edition: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Cop
Mahajan, Gaurav
Ghatak, Sudeep
Chamberlain, Nate
Paperback
Information Architecture: For the Web and Beyond
Morville, Peter
Arango, Jorge
Rosenfeld, Louis
Paperback
Istqb(r) Certified Tester Foundation Level: A Self-Study Guide Syllabus V4.0
Pilaeten, Michaël
Roman, Adam
Stapp, Lucjan
Hardcover
Artificial Intelligence with Microsoft Power Bi: Simpler AI for the Enterprise
Stirrup, Jen
Weinandy, Thomas J.
Paperback
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
Jelen, Bill
Paperback
Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence
Deckler, Greg
Powell, Brett
Paperback
Numerical Recipes: The Art of Scientific Computing
Vetterling, William T.
Press, William H.
Teukolsky, Saul A.
Hardcover
Aerospike: Up and Running: Developing on a Modern Operational Database for Globally Distributed Apps
Autin, Albert
Srinivasan, V.
Faulkes, Tim
Paperback
Hands-On Prescriptive Analytics: Optimizing Your Decision Making with Python
Paczkowski, Walter R.
Paperback
Discover QGIS 3.x - Second Edition: A Workbook for Classroom or Independent Study
Menke, Kurt
Paperback
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Shaffer, Jeffrey
Cotgreave, Andy
Wexler, Steve
Paperback
Artificial Intelligence with Power BI: Take your data analytics skills to the next level by leveraging the AI capabilities in Power BI
Diepeveen, Mary-Jo
Paperback
EXCEL Formulas and Functions 2024: 140 Most Popular Shortcuts and Tricks For Beginners to Experts
Rader, Steven M.
Paperback
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
Winston, Wayne
Paperback
Mastering QuickBooks(R) 2025 - Sixth Edition: Bookkeeping for small businesses with US QuickBooks(R) Online
Shelton, Crystalynn
Paperback
QuickBooks 2016: The Missing Manual: The Official Intuit Guide to QuickBooks 2016
Biafore, Bonnie
Paperback
Microsoft Word 2024: A Complete Practical Guide For Beginner and Advanced Users
Todd, Antonio
Paperback
Itil(r) 4: The New Frontier: A Practical Guidebook for Adopting ITIL(R) 4
Tefertiller, Jeffrey
Paperback
Planning and Control Using Oracle Primavera P6 Versions 8 to 21 PPM Professional
Harris, Paul E.
Paperback
Mastering KVM Virtualization - Second Edition: Design expert data center virtualization solutions with the power of Linux KVM
Dakic, Vedran
Chirammal, Humble Devassy
Mukhedkar, Prasad
Paperback
Microsoft Power BI Cookbook - Third Edition: Convert raw data into business insights with updated techniques, use cases, and best practices
Deckler, Greg
Powell, Brett
Paperback
Modern Business Analytics: Increasing the Value of Your Data with Python and R
Larson, Deanne
Paperback
Implementing Data Mesh: Design, Build, and Implement Data Contracts, Data Products, and Data Mesh
Perrin, Jean-Georges
Broda, Eric
Paperback
Learning Tableau 2020: Create effective data visualizations, build interactive visual analytics, and transform your organization
Milligan, Joshua N.
Paperback
Python for ArcGIS Pro: Automate cartography and data analysis using ArcPy, ArcGIS API for Python, Notebooks, and pandas
Parker, Bill
Toms, Silas
Paperback
Application Development with SAP Business Technology Platform
Acharya, Gairik
Bajaj, Govind
Dhar, Avijit
Hardcover
An Introduction to Statistical Learning: With Applications in R
Hastie, Trevor
James, Gareth
Witten, Daniela
Hardcover
Easy windows 11 for seniors 2024: Master easy ways and steps to get the best Windows 11 experience as a senior
Hopkins, Steve
Paperback