
Excel 2021
Everything you need to know about Excel to go from Beginner to Expert
By: Nora E. Wright
Paperback | 11 November 2021
At a Glance
144 Pages
22.86 x 15.24 x 0.79
Paperback
RRP $30.79
$30.75
or 4 interest-free payments of $7.69 with
orShips in 5 to 7 business days
Do you wish to perfect your Microsoft Excel knowledge to unlock its full range of functions, especially those that are most useful for individual users and businesses?
And are you looking for a guide that will take away the guesswork from the whole process and even show you cool shortcuts that will save you your valuable time while making sure that you unlock functions you probably didn't even think existed yet are very helpful?
If you've answered YES,
Let This Book Help You Understand Microsoft Excel Inside Out So You Can Make The Most Of What It Was Meant To Do!
Microsoft Excel is powerful. That's why it is a go-to tool for individuals and organizations around the world - because it supports functions that are useful for individual users and those that can be used for enterprise-level processing. And if you see what anyone with a strong background in Microsoft Excel can do with the program, you will want to learn about it to streamline so many things in your life.
But where do you start?
What functions are most important for beginners?
How do you use the different functions and make the most of them?
If you have these and other related questions, this book is for you so keep reading.
In it, you will discover:
- Why Excel is so important whether for work or work positions
- How to get started with Microsoft Excel, including how to create your first workbook
- Basic functions on MS Excel, including what are cells, how to select cells, how to start formulas, shortcuts and more
- How to make the most of different functions like Ctrl+C and Ctrl+Alt+V, creating columns and rows, selecting, activating and editing cells, formatting cells, how to format, searching workbooks, find, find and replace and more
- How to use the formula function on Excel, including some of the basic functions in Excel like additions, subtraction, multiplication, division and more
- The ins and outs of functions like sorting, grouping, filtering cells and merge cell
- How to make the most of conditional formatting to remove duplicates, and highlight duplicates
- The best way to use Pivot tables and charts in Excel
- And really...much more!
What's more - everything is clearly outlined and detailed to ensure that you unlock all the functions of Windows or Mac!
Even if you are not tech-savvy, this book will take away the guesswork so you feel confident about the whole process!
Scroll up and click Buy Now With 1-Click or Buy Now to get started!
INTRODUCTION
GETTING STARTED
Workbooks
The User Interface
Customization
MICROSOFT EXCEL BASICS
The Excel User Experience
What is the VLOOKUP Function?
Basic Functions in Excel
Customizing Excel
BASICS OF EXCEL FORMULAS
How to Enter a Formula
Using Spaces
How to Edit a Formula
The Formula Bar Can Be a Handy Calculator
Formula Operators
EXCEL CHARTS
The Pie Charts
Column Graphs
The Line Charts
Bar Charts
The Area Charts
Scatter Charts
Bubble Chart
Surface Chart
Radar Chart
Combo Chart
Excel Chart Customization
How Significant Are the Charts?
IMPORTANT THINGS YOU CAN MAKE IN EXCEL
All About Numbers
Making a Plan
Getting Stuff Done
Involving Other People
Staying in Touch
Just for Fun
CELL FORMATS AND THEIR CONTENT
Excel Environment
Manage The Sheets of The Book (Pages)
Formatting Of Cells
Border Format
ADVANCED FORMATTING OPTIONS IN EXCEL
Use of Fill Handle for Copying Formatting
Use of Paste Option for Copying Formatting
Copying Style Between the Workbook
Create Your Custom Format for Data That Is Readable
Creating Cell Style Indicating a Purpose
Verifying Page Orientation
Putting Page Break
How to View the Preview Option
Set or Clear the Print Area for Your Spreadsheet
Moving Your Worksheet Within the Same Workbook
Copying Your Worksheet Within Your Workbook
PIVOT TABLE
What Is Exactly a Pivot Table?
Where Does a Pivot Table Come From?
How To Create a Pivot Table?
CREATING A DATABASE USING AN EXCEL SPREADSHEET
How Relational Database Functions
Relational Database and Its Applications
A Simple Example of the Database
What Is Meant by a Master Database?
Creating a Database in Excel Along with the Use of Filters
Converting Data to the Tables
Creating the Relations
Adding the Fields
Filters Options
INPUT MASKS BEING EMPLOYED FOR DATA ENTRY
Input Masks
Where Possible, Avoid Using Input Masks
By Using Mask Wizard, Generate an Input Mask
Introducing Input Mask, A Question or Statement
Customizing An Input Mask
Using Certain Field Property Configurations to Customize Input Masks
Illustrations Of Input Masks
Utilizing An Email Address-Specific Input Mask
CONCLUSION
ISBN: 9781803611235
ISBN-10: 1803611235
Published: 11th November 2021
Format: Paperback
Language: English
Number of Pages: 144
Audience: General Adult
Publisher: LIGHTNING SOURCE INC
Dimensions (cm): 22.86 x 15.24 x 0.79
Weight (kg): 0.2
Shipping
| Standard Shipping | Express Shipping | |
|---|---|---|
| Metro postcodes: | $9.99 | $14.95 |
| Regional postcodes: | $9.99 | $14.95 |
| Rural postcodes: | $9.99 | $14.95 |
How to return your order
At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.
Additional postage charges may be applicable.
Defective items
If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.
For more info please visit our Help Centre.
You Can Find This Book In

Microsoft Power BI Data Analyst Associate Study Guide
Prepare for the Pl-300 Exam and Apply Best Practice Design
Paperback
RRP $114.00
$55.75
OFF

Apache Iceberg: The Definitive Guide
Data Lakehouse Functionality, Performance, and Scalability on the Data Lake
Paperback
RRP $133.00
$64.75
OFF





















