Sign-In
Cart
Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
Hardcover
Series: Excel 2019 Mastery, Book 1
ISBN13: 9781916211353
Publisher: Gtech Publishing
Published: Jan 1 2020
Pages: 234
Weight: 1.06
Height: 0.56 Width: 6.00 Depth: 9.00
Language: English
Excel 2019 Basics covers all you need to quickly get up to speed with creating spreadsheets to provide solutions for your data. If you are new to Excel and the thought of spreadsheets makes your head spin, then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel.
If you already have some Excel skills and you want to skill-up on more advanced topics like functions, Excel tables, pivot tables, and charts, then you've also come to the right place. Excel 2019 Basics goes beyond introduction topics and covers topics like functions, Excel tables, and analysing your data with charts.
The aim of this book is to guide you from beginner to being skilled with Excel within a few short hours.
Learn Excel Quicker by Avoiding Unnecessary FillersThis book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly carry out various tasks in Excel. Hence, Excel 2019 Basics focuses on providing direct instructions for how to complete tasks with screenshots where necessary to illustrate the concepts.
IMPORTANT: The accompanying sample files are easily downloadable with the provided weblink inside the book. Some people may be unaware that entering a weblink to a zip file automatically downloads the file to your computer's Downloads folder. So, the download process has been updated to make it clearer with added instructions and a support email to contact if you encounter any issues.
In this book, you'll learn how to:
- Add, name, copy and move worksheets.
- Freeze and unfreeze panes (rows and columns).
- Use AutoFill and Flash Fill to automate repetitive tasks.
- Move and copy data.
- Format cells, ranges and tables.
- Create formulas for different types of calculations.
- Use absolute and relative cell references.
- Use AutoSum to quickly automate calculations.
- Use functions like IF, DATE, DATEDIF, LEN, MID, VLOOKUP, and XLOOKUP.
- Work with Excel tables, including applying table styles.
- Easily filter and sort your data.
- Dynamically analyze your data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually!
- Use the Quick Analysis tool to generate charts and sparklines with just a few clicks.
- Secure your workbook data and design with a password.
- Use many more Excel features...
Scroll up and click the Buy Now button on the right-hand side of the page to get started today!
2 different editions
Also available
Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Paperback
Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Paperback
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
Wickham, Hadley
Grolemund, Garrett
Cetinkaya-Rundel, Mine
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, Peter
Bruce, Andrew
Gedeck, Peter
Paperback
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
Social Science Research Design and Statistics: A Practitioner's Guide to Research Methods and IBM SPSS Analysis
Ponton, Michael K.
Rovai, Alfred P.
Baker, Jason D.
Paperback
Microsoft Excel 365 Tips & Tricks - 2019: A Quickstudy Laminated Software Reference Guide
Frye, Curtis
Other
Software Wasteland: How the Application-Centric Mindset is Hobbling our Enterprises
McComb, Dave
Paperback
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Storment, J. R.
Fuller, Mike
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
McGrath, Mike
Price, Michael
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
Wade, Michael
Macaulay, James
Noronha, Andy
Hardcover
An Introduction to Statistical Learning: With Applications in R
Hastie, Trevor
James, Gareth
Witten, Daniela
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
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
Prometheus: Up & Running: Infrastructure and Application Performance Monitoring
Pivotto, Julien
Brazil, Brian
Paperback
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
Master Your Data with Power Query in Excel and Power Bi: Leveraging Power Query to Get & Transform Your Task Flow
Puls, Ken
Escobar, Miguel
Paperback
The Mathematical Corporation: Where Machine Intelligence and Human Ingenuity Achieve the Impossible
Sullivan, Josh
Zutavern, Angela
Hardcover
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Russo, Marco
Ferrari, Alberto
Paperback
Learning Microsoft Power Apps: Building Business Applications with Low-Code Technology
Shrivastava, Arpit
Paperback
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
An Introduction to Statistical Learning: With Applications in Python
Witten, Daniela
Hastie, Trevor
James, Gareth
Hardcover
React and React Native - Fifth Edition: Build cross-platform JavaScript and TypeScript apps for the web, desktop, and mobile
Sakhniuk, Mikhail
Boduch, Adam
Paperback
Fundamentals of Enterprise Architecture: Proven Frameworks for Effective Architecture Decisions
McCabe, Tanu
Paperback
Excel 2023: A Comprehensive Guide to become an Expert on Excel 2023 With All-in-One Approach
Wright, Leonardo L.
Paperback
Mastering QuickBooks 2024 - Fifth Edition: Bookkeeping with US QuickBooks Online for small businesses
Shelton, Crystalynn
Paperback
Machine Learning Production Systems: Engineering Machine Learning Models and Pipelines
Hapke, Hannes
Caveness, Emily
Crowe, Robert
Paperback
Building LLM Powered Applications: Create intelligent apps and agents with large language models
Alto, Valentina
Paperback
Power Pivot and Power Bi: The Excel User's Guide to Dax, Power Query, Power Bi & Power Pivot in Excel 2010-2016
Singh, Avichal
Collie, Rob
Paperback
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Munn, Michael
Lakshmanan, Valliappa
Robinson, Sara
Paperback
Software Profit Streams(TM): A Guide to Designing a Sustainably Profitable Business
Tanner, Jason
Hohmann, Luke
Paperback
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
Fundamentals of Deep Learning: Designing Next-Generation Machine Intelligence Algorithms
Buduma, Nikhil
Papa, Joe
Buduma, Nithin
Paperback
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
Microsoft PowerPoint 365 - 2019: A Quickstudy Laminated Software Reference Guide
Lambert, Joan
Belasco, Elizabeth
Other
Microsoft Outlook 365 - 2019: A Quickstudy Laminated Software Reference Guide
Belasco, Elizabeth
Lambert, Joan
Other
Generative AI with LangChain: Build large language model (LLM) apps with Python, ChatGPT, and other LLMs
Auffarth, Ben
Paperback
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
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 365 Copilot at Work: Using AI to Get the Most from Your Business Data and Favorite Apps
Matfess, Jared
Flock, Thomas
Van Laan, Sandar
Paperback
Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
Maslyuk, Daniil
Raviv, Gil
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
Information Architecture: For the Web and Beyond
Morville, Peter
Arango, Jorge
Rosenfeld, Louis
Paperback
Microsoft 365 and SharePoint Online Cookbook - Second Edition: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Cop
Ghatak, Sudeep
Chamberlain, Nate
Mahajan, Gaurav
Paperback
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Cotgreave, Andy
Wexler, Steve
Shaffer, Jeffrey
Paperback
Hands-On Prescriptive Analytics: Optimizing Your Decision Making with Python
Paczkowski, Walter R.
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
Discover QGIS 3.x - Second Edition: A Workbook for Classroom or Independent Study
Menke, Kurt
Paperback
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
Jelen, Bill
Paperback
Aerospike: Up and Running: Developing on a Modern Operational Database for Globally Distributed Apps
Autin, Albert
Srinivasan, V.
Faulkes, Tim
Paperback
Learning Tableau 2020: Create effective data visualizations, build interactive visual analytics, and transform your organization
Milligan, Joshua N.
Paperback
EXCEL Formulas and Functions 2024: 140 Most Popular Shortcuts and Tricks For Beginners to Experts
Rader, Steven M.
Paperback
Implementing Data Mesh: Design, Build, and Implement Data Contracts, Data Products, and Data Mesh
Broda, Eric
Perrin, Jean-Georges
Paperback
QuickBooks 2016: The Missing Manual: The Official Intuit Guide to QuickBooks 2016
Biafore, Bonnie
Paperback
Numerical Recipes: The Art of Scientific Computing
Teukolsky, Saul A.
Vetterling, William T.
Press, William H.
Hardcover
Itil(r) 4: The New Frontier: A Practical Guidebook for Adopting ITIL(R) 4
Tefertiller, Jeffrey
Paperback
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
Winston, Wayne
Paperback
Python for ArcGIS Pro: Automate cartography and data analysis using ArcPy, ArcGIS API for Python, Notebooks, and pandas
Parker, Bill
Toms, Silas
Paperback
An Introduction to Statistical Learning: With Applications in Python
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Hardcover
Architecture Modernization: Socio-Technical Alignment of Software, Strategy, and Structure
Tune, Nick
Perrin, Jean-Georges
Paperback
Mastering KVM Virtualization - Second Edition: Design expert data center virtualization solutions with the power of Linux KVM
Mukhedkar, Prasad
Dakic, Vedran
Chirammal, Humble Devassy
Paperback
Microsoft Word 2024: A Complete Practical Guide For Beginner and Advanced Users
Todd, Antonio
Paperback
Easy windows 11 for seniors 2024: Master easy ways and steps to get the best Windows 11 experience as a senior
Hopkins, Steve
Paperback