The Microsoft Excel Step-By-Step Training Guide Book Bundle - C. J. Benton
-30% with code BOOKS
Shipping in 10-16 days
30-day return policy
3 books in 1 a consolidation of three books in the Microsoft(r) Excel(r) Step-By-Step Training Guide Series This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft(r) Excel(r) formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow you ... Full description
You May Also Like
TOP
If Anyone Builds It, Everyone Dies: Why Superhuman AI Would Kill Us All
Eliezer Yudkowsky, Nate Soares
-30% with code BOOKS
In stock at our supplier
TOP
The 21st Century Brain: Cutting edge neuroscience to help us navigate the future
-30% with code BOOKS
In stock at our supplier
TOP
Gödel, Escher, Bach: An Eternal Golden Braid
-30% with code BOOKS
In stock at our supplier
TOP
AI Engineering: Building Applications with Foundation Models
-30% with code BOOKS
In stock at our supplier
TOP
Empire of AI: Dreams and Nightmares in Sam Altman's OpenAI
-30% with code BOOKS
In stock at our supplier
TOP
Python Crash Course: A Hands-On, Project-Based Introduction to Programming
-30% with code BOOKS
In stock at our supplier
TOP
How To Think About AI: A Guide For The Perplexed
-30% with code BOOKS
In stock at our supplier
TOP
The Rust Programming Language
Steve Klabnik, Carol Nichols, Chris Krycho
-30% with code BOOKS
In stock at our supplier
TOP
How to Talk to AI: (And How Not To)
-30% with code BOOKS
In stock at our supplier
TOP
Why Machines Learn: The Elegant Math Behind Modern AI
-30% with code BOOKS
In stock at our supplier
TOP
The Pragmatic Programmer: journey to mastery, 20th Anniversary Edition, 2/e: your journey to mastery, 20th Anniversary Edition
-30% with code BOOKS
In stock at our supplier
TOP
Hackers. 25th Anniversary Edition: Heroes of the Computer Revolution
-30% with code BOOKS
In stock at our supplier
TOP
The Art of Game Design: A Book of Lenses
-30% with code BOOKS
In stock at our supplier
TOP
How Linux Works: What Every Superuser Should Know
-30% with code BOOKS
In stock at our supplier
TOP
Hands-On Large Language Models: Language Understanding and Generation
Maarten Grootendorst, Jay Alammar
-30% with code BOOKS
In stock at our supplier
TOP
Fundamentals of Software Architecture: A Modern Engineering Approach
-30% with code BOOKS
In stock at our supplier
TOP
Slanted 47 Digital Tools: Slanted Magazine
-30% with code BOOKS
In stock at our supplier
TOP
Linux Basics for Hackers, 2nd Edition: Getting Started with Networking, Scripting, and Security in Kali
-30% with code BOOKS
In stock at our supplier
TOP
Deep Learning: Foundations and Concepts
Christopher M. Bishop, Hugh Bishop
-30% with code BOOKS
In stock at our supplier
Description
This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft(r) Excel(r) formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft(r) Excel(r) at your own pace.
In addition to the following, this book bundle also includes sections on Excel(r) keyboard shortcuts and how to change the currency symbol, for example to the British Pound � or Euro e.
Part 1 - Excel(r) Formula Fundamentals
- SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
- AVERAGE
- MIN & MAX
- TODAY & NETWORKDAYS
- SUMIF
Part 2 - Pivot Tables & Dashboards
- Organize and summarize data
- Format results
- Insert Pivot Charts
- Display averages & percentages
- Group data into predefined ranges
- Rank results
- Insert calculated fields
- How to create and update a basic Dashboard using Pivot Table data
Part 3 - Excel(r) Features
- Data Sorting
- Formula Trace
- Text-To-Columns
- Conditional Formatting & Filtering
Part 4 - Text Functions
- LEN & TRIM
- CONCATENATE & MID
- PROPER, UPPER, & LOWER
Part 5 - Logic Formulas
- IF
- Nested IF
Part 6 - The VLOOKUP Formula
- What the VLOOKUP formula does
- The parts of a VLOOKUP formula
- Detailed examples on how to use the VLOOKUP formula
- Incorporating the IFERROR functionality into your VLOOKUP formula
- How to apply the VLOOKUP formula across multiple tabs & workbooks
- How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error
More Information
| Author | C. J. Benton |
|---|---|
| Publisher | CreateSpace Independent Publishing Platform |
| Release year | 2015 |
| Cover type | Softcover |
| EAN | 9781518628757 |