Sign-In
Cart
Mastering Excel 365: An All-in-One Tutorial Resource
Hardcover
ISBN13: 9781915476135
Publisher: Gtech Publishing
Published: May 8 2023
Pages: 642
Weight: 2.88
Height: 1.38 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.
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.
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 Excel VBA Programming: A Hands-On Guide to Automating Excel and Building Custom Solutions with VBA and Macros
George, Nathan
Paperback
Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
George, Nathan
Hardcover
Mastering Excel VBA Programming: A Hands-On Guide to Automating Excel and Building Custom Solutions with VBA and Macros
George, Nathan
Hardcover
Excel 365 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Paperback
Practical Data Science with Python: Learn tools and techniques from hands-on examples to extract insights from data
George, Nathan
Paperback
Excel 2022 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Hardcover
Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
George, Nathan
Paperback
Excel 365 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel
George, Nathan
Hardcover
Excel 2019 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
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
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
Paperback
Convert Your Text To Audio: Boost Your Reading Capacity And Speed Using Free Tools Like Audacity
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
Keyword Research: How To Find And Profit From Low Competition Long Tail Keywords + 33 Profitable Niches Analysed
George, Nathan
Paperback
Excel 2019 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
Also in
Applications
Microsoft 365 Excel All-In-One for Dummies
Alexander, Michael
Kusleika, Dick
Ringstrom, David H.
Paperback
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Russo, Marco
Ferrari, Alberto
Paperback
Excel Formulas: Quickstudy Laminated Study Guide (Quickstudy Computer)
Jensen, Krista
Hales, John
Other
Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
Huyen, Chip
Paperback
Me, My Customer, and AI: The New Rules of Entrepreneurship
Werdelin, Henrik
Thorne, Nicholas
Hardcover
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Wickham, Hadley
Grolemund, Garrett
Cetinkaya-Rundel, Mine
Paperback
Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Bruce, Andrew
Gedeck, Peter
Bruce, Peter
Paperback
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Fuller, Mike
Storment, J. R.
Paperback
Between You and AI: Unlock the Power of Human Skills to Thrive in an Ai-Driven World
Iorio, Andrea
Hardcover
Dark Web: A Comprehensive Guide to Its Mechanics and Risks (The Insidious Happenings Lurking Right Beneath Our Internet Haven)
McClendon, Adolfo
Paperback
Deep Learning for Biology: Harness AI to Solve Real-World Biology Problems
Ravarani, Charles
Latysheva, Natasha
Paperback
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
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
Power Query Beyond The User Interface: Solving Advanced Data Cleaning Problems Using M
Chhabra, Chandeep
Paperback
Building Rocketships: Product Management for High-Growth Companies
Udezue, Ezinne
Udezue, Oji
Paperback
Microsoft 365 Copilot Adoption: A Practical Guide for Business Leaders and Consultants
Smith, Mark
Smith, Megan
Paperback
Microsoft Copilot Studio Step by Step: Customizing Copilot and Creating Agents
Crosbie, Lisa
Paperback
How to Measure Anything in Project Management
Budzier, Alexander
Hubbard, Douglas W.
Bang Leed, Andreas
Hardcover
Dark Web: A Complete Guide to the Dark Web True Tales (The Addictive Input down able Gripping Crime Thriller of Mystery and Suspense)
Guerrero, Theodore
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
Building Event-Driven Microservices: Leveraging Organizational Data at Scale
Bellemare, Adam
Paperback
Materials Management with SAP S/4hana: Business Processes and Configuration
Akhtar, Jawad
Murray, Martin
Hardcover
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
Fundamentals of Microsoft Fabric: Designing End-To-End Analytics Solutions
ILIC, Nikola
Weissman, Ben
Paperback
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
Planning and Control Using Oracle Primavera P6 Versions 8 to 21 PPM Professional
Harris, Paul E.
Paperback
Take Back Your Life!: Using Microsoft Office Outlook to Get Organized and Stay Organized
McGhee, Sally
Paperback
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam Mo-200
Butow, Eric
Paperback
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
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
Ingeniería de Requisitos: Software Orientado al Negocio
Vazquez, Carlos Eduardo
Siqueira Simões, Guilherme
Paperback
Enterprise Architecture with Sap: Planning, Management, and Transformation
Klee, Peter
Reichel, Johannes
Das, Anup
Paperback
Microsoft Excel VBA and Macros: Your Guide to Efficient Automation
Jelen, Bill
Syrstad, Tracy
Paperback
Numerical Recipes: The Art of Scientific Computing
Press, William H.
Teukolsky, Saul A.
Vetterling, William T.
Hardcover
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
Generative AI for Software Development: Building Software Faster and More Effectively
Pereira, Sergio
Paperback
Dark Web: Everything You Didn't Know About Dark Web (Know All Everything You Need About Exploiting the Dark Web)
Slaton, Cynthia
Paperback
3D Data Science with Python: Building Accurate Digital Environments with 3D Point Cloud Workflows
Poux, Florent
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
Mastering QuickBooks(R) 2025 - Sixth Edition: Bookkeeping for small businesses with US QuickBooks(R) Online
Shelton, Crystalynn
Paperback
ITIL(R) 4 Create, Deliver and Support (CDS): Your companion to the ITIL 4 Managing Professional CDS certification
Agutter, Claire
Paperback
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
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
Quantitative Methods for the Social Sciences: A Practical Introduction with Examples in R
Stockemer, Daniel
Bordeleau, Jean-Nicolas
Hardcover
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Cotgreave, Andy
Wexler, Steve
Shaffer, Jeffrey
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
Warehouse Management with SAP S/4hana: Embedded and Decentralized Ewm
Sachan, Namita
Jain, Aman
Hardcover
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
Raviv, Gil
Maslyuk, Daniil
Paperback
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
Paperback
Microsoft Power BI Quick Start Guide - Third Edition: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more
Ostrowsky, Erin
Knight, Devin
Pearson, Mitchell
Paperback
SAP S/4hana Financial Accounting Certification Guide: Application Associate Exam
Pougkas, Stefanos
Paperback
Microsoft Excel in Easy Steps: Illustrated Using Excel in Microsoft 365
McGrath, Mike
Price, Michael
Paperback
No B.S. Guide to Successful Marketing Automation: The Ultimate No Holds Barred Guide to Using Technology, Automation, and Artificial Intelligence in M
Kennedy, Dan S.
Shah, Parthiv
Paperback
Understanding Google Docs - 2025 Edition: The Full Color Guide to Document Creation, Formatting, and Collaboration
Wilson, Kevin
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
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
Microsoft Power Automate Cookbook: Automating Business Processes Easily, Intuitively, and Quickly
Najjar, Ahmad
Paperback
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
Autonomous Minds: How Agentic AI Predicts and Learns to Enable Productivity and Empowerment
Campos Zabala, Francisco Javier
Paperback
Tableau Certified Data Analyst Study Guide: Learn the Core Concepts and Techniques Necessary to Ace the Exam
Gardner, Christopher
Paperback
Information Architecture: For the Web and Beyond
Rosenfeld, Louis
Morville, Peter
Arango, Jorge
Paperback
The AI Selling Revolution: The Ultimate Guide to Unlocking AI-Powered Strategies for Winning Sales
Sim, Lionel
Paperback
Learning Tableau 2025 - Sixth Edition: Leverage Tableau's newest features to revolutionize your data storytelling with AI-enhanced insights
Milligan, Joshua N.
Paperback
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
Excel 2023: A Comprehensive Guide to become an Expert on Excel 2023 With All-in-One Approach
Wright, Leonardo L.
Paperback
FrameMaker - Working with Content (2020 Release): Updated for 2020 Release (8.5"x11")
Sullivan, Matt R.
Paperback
Data Science at the Command Line: Obtain, Scrub, Explore, and Model Data with UNIX Power Tools
Janssens, Jeroen
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
SAP Activate Project Management Certification Guide: Certified Associate Exam
Lal, Aditya
Viswanathan, Jeyaganesh
Paperback
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Robinson, Sara
Munn, Michael
Lakshmanan, Valliappa
Paperback
Machine Learning Production Systems: Engineering Machine Learning Models and Pipelines
Hapke, Hannes
Caveness, Emily
Crowe, Robert
Paperback
Version Control with Git: Powerful Tools and Techniques for Collaborative Software Development
Loeliger, Jon
Ponuthorai, Prem Kumar
Paperback
EXCEL Formulas and Functions 2024: 140 Most Popular Shortcuts and Tricks For Beginners to Experts
Rader, Steven M.
Paperback
Cloud Integration with SAP Integration Suite: The Comprehensive Guide
Singh, Swati
Bilay, John Mutumba
Singh, Shashank
Hardcover
Building LLM Powered Applications: Create intelligent apps and agents with large language models
Alto, Valentina
Paperback
Software Wasteland: How the Application-Centric Mindset is Hobbling our Enterprises
McComb, Dave
Paperback