Sign-In
Cart
Learn Excel 2019 for Mac Expert Skills with The Smart Method: Tutorial teaching Advanced Techniques
Paperback
ISBN13: 9781909253339
Publisher: Lightning Source Inc
Published: Nov 17 2018
Pages: 372
Weight: 1.96
Height: 0.77 Width: 8.27 Depth: 11.69
Language: English
At long last there is now a professional Excel course available for Mac users.
Please note that this book is only suitable for the Apple Mac version of Excel 2019. (There's also an Excel for Windows book available).
By the end of the book you'll be able to use all of the power available from the world's most powerful business tool. Your Excel skills will be greater and broader than almost all other Excel users in the workplace. Mike Smart's revolutionary teaching method provides an entirely new, easier and better way to learn Excel 2019 for Mac. Here are just six of the many ways in which this book is unique:
- This book won't waste your time by teaching basic Excel 2019 for Mac skills that you already know. All of that material is covered already in our beginner's Excel 2019 for Mac Essential Skills book. By assuming that you are already able to use Excel 2019's basic features, far more ground can be covered.
- Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book). You can complete each self-contained lesson in a few minutes.
- Each lesson has a sample file that models a real-world business problem.
- The teaching methods used in the book were developed and refined using over fifteen years of experience teaching real students Excel skills in classroom courses. The teaching method is fun, absorbing and virtually 100% effective.
- Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses. This has made Smart Method books a popular choice for schools, colleges and universities all over the world.
Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way.
Here is a small selection from the many advanced Excel skills you will learn:
- Visually filter data using Slicers
- Master dynamic tables and structured table references
- Enforce complex business rules using function-driven custom validations
- Perform What-If analysis to model and compare business scenarios
- Use advanced functions to solve real-world business problems
- Create intuitive user interfaces using form controls
- Eliminate errors using Excel's advanced formula auditing tools
- Understand and use all of Excel's security features
- Design advanced Pivot Tables
- Create and use dynamic and table-based range names
- Record macros and then execute them from button controls
- Use Excel's three different sharing methods for efficient teamwork
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, The British Museum, The National Gallery, Pokerstars, Marks & Spencer, Virgin, O2, BMW... and many, many others.
1 different editions
Also available
Also in
Applications
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Grolemund, Garrett
Wickham, Hadley
Paperback
Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
Huyen, Chip
Paperback
Microsoft 365 Excel All-In-One for Dummies
Kusleika, Dick
Ringstrom, David H.
Alexander, Michael
Paperback
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Cetinkaya-Rundel, Mine
Wickham, Hadley
Grolemund, Garrett
Paperback
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Fuller, Mike
Storment, J. R.
Paperback
Microsoft Copilot Studio Step by Step: Customizing Copilot and Creating Agents
Crosbie, Lisa
Paperback
Excel Formulas: Quickstudy Laminated Study Guide (Quickstudy Computer)
Hales, John
Jensen, Krista
Other
Ingeniería de Ia (Spanish Edition): Creación de Aplicaciones Con Modelos Fundacionales
Huyen, Chip
Paperback
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
Winston, Wayne
Paperback
Learning Generative AI Tools for Excel: Speed Up Your Everyday Tasks with Microsoft Excel, Copilot, Chatgpt, and Beyond
Duca, Angelica Lo
Paperback
Learning Tableau 2025 - Sixth Edition: Leverage Tableau's newest features to revolutionize your data storytelling with AI-enhanced insights
Milligan, Joshua N.
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 Power Bi Data Analyst Associate Study Guide: Prepare for the Pl-300 Exam and Use Power Bi Successfully
Turley, Paul
Paperback
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
Materials Management with SAP S/4hana: Business Processes and Configuration
Akhtar, Jawad
Murray, Martin
Hardcover
The AI Workweek: Cut Hours, Automate Busywork, and Focus on What Actually Matters
Gross, Ashley
Paperback
Planning and Control Using Oracle Primavera P6 Versions 8 to 21 PPM Professional
Harris, Paul E.
Paperback
The AI Agent Blueprint: A Practical Playbook for Building Agentic Artificial Intelligence: Launch Your First Agent in 30 Days
Daniels, Alexander J.
Paperback
Python in Excel: Unlocking Powerful Data Analysis and Automation Solutions
Bastick, Liam
Newitt, Kathryn
Paperback
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
Building Event-Driven Microservices: Leveraging Organizational Data at Scale
Bellemare, Adam
Paperback
Information Architecture: For the Web and Beyond
Morville, Peter
Arango, Jorge
Rosenfeld, Louis
Paperback
Illustrated Microsoft(r) 365(r) & Office(r) Introductory, First Edition
Wermers, Lynn
Beskeen, David
Duffy, Jennifer
Paperback
Software Profit Streams(TM): A Guide to Designing a Sustainably Profitable Business
Tanner, Jason
Hohmann, Luke
Paperback
Soccer Analytics with Machine Learning: Learning Predictive Modeling Techniques with Sports Data
Gao, Haipeng
Shen, Weining
Joury, Ari
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 24 PPM Professional
Harris, Paul E.
Hanak, Jan
Paperback
Between You and AI: Unlock the Power of Human Skills to Thrive in an Ai-Driven World
Iorio, Andrea
Hardcover
Mastering QuickBooks 2026 - Seventh Edition: The complete guide to small business accounting with US QuickBooks Online
Shelton, Crystalynn
Paperback
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
Microsoft 365 Copilot Adoption: A Practical Guide for Business Leaders and Consultants
Smith, Megan
Smith, Mark
Paperback
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
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
AI for Gig Workers: Essential Strategies to Transform Your Freelance Career
Cerdeira, Pamela
Savage, Saiph
Savage, Liliana
Paperback
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
Microsoft Copilot 365 User Guide: The Complete AI Productivity Companion for Word, Excel, Outlook & Teams
Jk Stratton, Evan
Paperback
Regression Modeling Strategies: With Applications to Linear Models, Logistic and Ordinal Regression, and Survival Analysis
Harrell Jr, Frank E.
Paperback
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
Me, My Customer, and AI: The New Rules of Entrepreneurship
Thorne, Nicholas
Werdelin, Henrik
Hardcover
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
Paperback
How to Measure Anything in Project Management
Bang Leed, Andreas
Budzier, Alexander
Hubbard, Douglas W.
Hardcover
Managing AI Projects: Drive Innovation and Successfully Navigate the Full AI Project Lifecycle
Runtasewee, Malini Jain
Sánchez, Adrián González
Paperback
The Insider You Built: How Organizations Stay in Control of Autonomous AI Agents
Stewart Gloster, Camille
Paperback
Warehouse Management with SAP S/4hana: Embedded and Decentralized Ewm
Sachan, Namita
Jain, Aman
Hardcover
AI Can Make You Smarter: Practical Skills. Sharper Thinking. Business Value.
Kreitzberg, Charles B.
Paperback
Power BI for Beginners: The 7-Day Method to Build Dashboards and Become a Data Strategist (Video Course Included)
Pierce, Callum
Pierce, Kora
Paperback
Deep Learning for Biology: Harness AI to Solve Real-World Biology Problems
Ravarani, Charles
Latysheva, Natasha
Paperback
Salesforce Certified Platform Administrator Study Guide: Launch and Elevate Your Salesforce Career
Wheeler, Mike
Paperback
Applied AI for Enterprise Java Development: Leveraging Generative Ai, Llms, and Machine Learning in the Java Enterprise
Eisele, Markus
Vinto, Natale
Bueno, Alex Soto
Paperback
Beyond Bullet Points: Using PowerPoint to Tell a Compelling Story That Gets Results
Atkinson, Cliff
Paperback
Microsoft Excel in Easy Steps: Illustrated Using Excel in Microsoft 365
Price, Michael
McGrath, Mike
Paperback
Planning and Control Using Microsoft Project 365 and 2021: Including 2019, 2016 and 2013
Harris, Paul E.
Paperback
ML and Generative AI in the Data Lakehouse: Building and Deploying AI Applications at Scale
Haelen, Bennie
Paperback
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
Paperback
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Mount, George
Paperback
Python Machine Learning - Second Edition: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow
Raschka, Sebastian
Mirjalili, Vahid
Paperback
Microsoft Excel VBA and Macros: Your Guide to Efficient Automation
Jelen, Bill
Syrstad, Tracy
Paperback
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
Microsoft Office 365 Bible: Expert Tips for Word, Excel, Teams, and More
Shepherd, Michael L.
Paperback
Generative AI for Software Development: Building Software Faster and More Effectively
Pereira, Sergio
Paperback
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
Autonomous Minds: How Agentic AI Predicts and Learns to Enable Productivity and Empowerment
Campos Zabala, Francisco Javier
Paperback
Hexagonal Architecture Explained: How the Ports & Adapters architecture simplifies your life, and how to implement it, Updated 1st Ed.
Garrido de Paz, Juan Manuel
Cockburn, Alistair
Paperback
High Performance Browser Networking: What Every Web Developer Should Know about Networking and Web Performance
Grigorik, Ilya
Paperback
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Shaffer, Jeffrey
Cotgreave, Andy
Wexler, Steve
Paperback
Boost Your Skills In Computer Basics for ESL Learners: (+ Online Simulations & Resources)
Wooden, Lois
Paperback
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Munn, Michael
Lakshmanan, Valliappa
Robinson, Sara
Paperback
Microsoft Power Automate Cookbook: Automating Business Processes Easily, Intuitively, and Quickly
Najjar, Ahmad
Paperback
Articulate Storyline 360: The Essentials and Beyond [2026 Edition]: A Hands-On, Project-Based Classroom in a Book for Building Engaging eLearning
Siegel, Kevin
Hadi, Kal
Paperback
Quickbooks Pro Desktop User Guide 2024: A Step-by-Step Handbook for Efficient Bookkeeping and Finance Management
Duncan, Michel M.
Paperback