Sign-In
Cart
Mastering Excel 365: An All-in-One Tutorial Resource
Paperback
ISBN13: 9781915476111
Publisher: Gtech Publishing
Published: Apr 24 2023
Pages: 642
Weight: 2.39
Height: 1.29 Width: 7.50 Depth: 9.25
Language: English
Mastering Excel 365 is your all-in-one, step-by-step tutorial to the latest and most powerful version of Excel from Microsoft 365 in 2023. This book contains everything you need to know to master the basics of Excel and a selection of advanced topics relevant to real-world productivity tasks you'll encounter in your job, business or home.
This guide has been designed as a resource for you, whether you're an Excel beginner or an advanced user. You learn how to use specific features and in what context those features need to be used.
This book is concise and to the point, using clear and practical examples that you can adapt to your own needs. The aim is to show you how to perform tasks in Excel as quickly as possible without getting bogged down with the unnecessary filler text you may find in some other Excel books.
Three Books in One!
Mastering Excel 365 is made up of Excel 22 Basics, Excel 365 Advanced Topics, and Excel 365 Functions. Now brought together and organized as a powerful all-in-one guide. This book brings you all the powerful material in those books and more.
Downloadable Practice Files for Hands-on Learning
Mastering Excel 365 also comes with downloadable practice files, making it easier to practice in Excel as you follow the examples in the book.
This book covers Excel for Microsoft 365 (2023 version).
By reading this book, you will:
- Master the fundamentals of Excel to create spreadsheet solutions for common Excel tasks quickly.
- Create basic and advanced formulas for different types of calculations.
- Use Excel tables to easily manage and manipulate your data.
- Filter, sort, and apply styles to data lists and Excel tables.
- Analyze your data visually with charts and sparklines.
- Import and use data from external sources like Access databases, CSV text files, and websites.
- Deploy macros to automate repetitive tasks and increase your efficiency.
- Create dynamic summaries of your data with pivot tables and pivot charts.
- Analyze different data scenarios and projections with What-If Analysis tools.
- Password-protect workbooks, worksheets, ranges, or even specific cells.
- Create formulas with over 80 of the most useful and powerful Excel functions, including modern functions like TEXTSPLIT, CHOOSEROWS, XLOOKUP, XMATCH, and FILTER.
1 different editions
Also available
Also from
George, Nathan
Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
George, Nathan
Paperback
Practical Data Science with Python: Learn tools and techniques from hands-on examples to extract insights from data
George, Nathan
Paperback
Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
George, Nathan
Hardcover
Excel 2022 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Hardcover
Excel 365 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity
George, Nathan
Paperback
WordPress For Beginners: A Visual Guide To Building Your WordPress Site + 22 Top WordPress Plugins
George, Nathan
Paperback
Convert Your Text To Audio: Boost Your Reading Capacity And Speed Using Free Tools Like Audacity
George, Nathan
Paperback
Excel 2016 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
Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Hardcover
Excel 365 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Paperback
Excel 365 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Hardcover
Keyword Research: How To Find And Profit From Low Competition Long Tail Keywords + 33 Profitable Niches Analysed
George, Nathan
Paperback
Fire Stick: A Step by Step Guide and Quick Tips for Getting the Most out of Your Fire Stick with Alexa Voice Remote
George, Nathan
Paperback
Day Game Step by Step: Approach Women On The Street, In Malls Or Shops, Start Conversations, And Get Dates!
George, Nathan
Paperback
Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity
George, Nathan
Paperback
Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Paperback
Mastering Excel VBA Programming: A Hands-On Guide to Automating Excel and Building Custom Solutions with VBA and Macros
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
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
Gedeck, Peter
Bruce, Peter
Bruce, Andrew
Paperback
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
Microsoft Excel 365 Tips & Tricks - 2019: A Quickstudy Laminated Software Reference Guide
Frye, Curtis
Other
Social Science Research Design and Statistics: A Practitioner's Guide to Research Methods and IBM SPSS Analysis
Baker, Jason D.
Ponton, Michael K.
Rovai, Alfred P.
Paperback
Software Wasteland: How the Application-Centric Mindset is Hobbling our Enterprises
McComb, Dave
Paperback
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Fuller, Mike
Storment, J. R.
Paperback
Orchestrating Transformation: How to Deliver Winning Performance with a Connected Approach to Change
Macaulay, James
Noronha, Andy
Wade, Michael
Hardcover
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
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
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Mount, George
Paperback
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
Hands-On Salesforce Data Cloud: Implementing and Managing a Real-Time Customer Data Platform
Avila, Joyce Kay
Paperback
Prometheus: Up & Running: Infrastructure and Application Performance Monitoring
Brazil, Brian
Pivotto, Julien
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
The Mathematical Corporation: Where Machine Intelligence and Human Ingenuity Achieve the Impossible
Sullivan, Josh
Zutavern, Angela
Hardcover
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Russo, Marco
Ferrari, Alberto
Paperback
React and React Native - Fifth Edition: Build cross-platform JavaScript and TypeScript apps for the web, desktop, and mobile
Sakhniuk, Mikhail
Boduch, Adam
Paperback
An Introduction to Statistical Learning: With Applications in Python
Hastie, Trevor
James, Gareth
Witten, Daniela
Hardcover
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
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
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
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
Mastering QuickBooks 2024 - Fifth Edition: Bookkeeping with US QuickBooks Online for small businesses
Shelton, Crystalynn
Paperback
Software Profit Streams(TM): A Guide to Designing a Sustainably Profitable Business
Hohmann, Luke
Tanner, Jason
Paperback
Machine Learning Production Systems: Engineering Machine Learning Models and Pipelines
Hapke, Hannes
Caveness, Emily
Crowe, Robert
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, Nithin
Buduma, Nikhil
Papa, Joe
Paperback
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Lakshmanan, Valliappa
Robinson, Sara
Munn, Michael
Paperback
Microsoft Outlook 365 - 2019: A Quickstudy Laminated Software Reference Guide
Belasco, Elizabeth
Lambert, Joan
Other
Building LLM Powered Applications: Create intelligent apps and agents with large language models
Alto, Valentina
Paperback
Microsoft PowerPoint 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
Artificial Intelligence with Microsoft Power Bi: Simpler AI for the Enterprise
Stirrup, Jen
Weinandy, Thomas J.
Paperback
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
Information Architecture: For the Web and Beyond
Rosenfeld, Louis
Morville, Peter
Arango, Jorge
Paperback
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Shaffer, Jeffrey
Cotgreave, Andy
Wexler, Steve
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
Istqb(r) Certified Tester Foundation Level: A Self-Study Guide Syllabus V4.0
Pilaeten, Michaël
Roman, Adam
Stapp, Lucjan
Hardcover
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
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
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
Hands-On Prescriptive Analytics: Optimizing Your Decision Making with Python
Paczkowski, Walter R.
Paperback
Learning Tableau 2020: Create effective data visualizations, build interactive visual analytics, and transform your organization
Milligan, Joshua N.
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
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
Jelen, Bill
Paperback
Python for ArcGIS Pro: Automate cartography and data analysis using ArcPy, ArcGIS API for Python, Notebooks, and pandas
Parker, Bill
Toms, Silas
Paperback
Itil(r) 4: The New Frontier: A Practical Guidebook for Adopting ITIL(R) 4
Tefertiller, Jeffrey
Paperback
Aerospike: Up and Running: Developing on a Modern Operational Database for Globally Distributed Apps
Autin, Albert
Srinivasan, V.
Faulkes, Tim
Paperback
Implementing Data Mesh: Design, Build, and Implement Data Contracts, Data Products, and Data Mesh
Broda, Eric
Perrin, Jean-Georges
Paperback
Discover QGIS 3.x - Second Edition: A Workbook for Classroom or Independent Study
Menke, Kurt
Paperback
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
Winston, Wayne
Paperback
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
EXCEL Formulas and Functions 2024: 140 Most Popular Shortcuts and Tricks For Beginners to Experts
Rader, Steven M.
Paperback
QuickBooks 2016: The Missing Manual: The Official Intuit Guide to QuickBooks 2016
Biafore, Bonnie
Paperback
Modern Business Analytics: Increasing the Value of Your Data with Python and R
Larson, Deanne
Paperback
An Introduction to Statistical Learning: With Applications in R
James, Gareth
Witten, Daniela
Hastie, Trevor
Hardcover
An Introduction to Statistical Learning: With Applications in Python
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
Using Microsoft Word - 2023 Edition: The Step-by-step Guide to Using Microsoft Word
Wilson, Kevin
Paperback
Efficient Algorithm Design: Unlock the power of algorithms to optimize computer programming
Makrehchi, Masoud
Paperback