Excel 2021 For Beginners: A Practical Approach To The Basics Of Excel 2021 For Statistics And Analysis

Length: 245 pages
Edition: 1
Language: English
Publication Date: 2021-09-21
ISBN-10: B09GW1CMQ7
Sales Rank: #0 (See Top 100 Books)

LEARN EVERYTHING ABOUT EXCEL 2021!
Looking for a simplified Excel guide to help you learn the basics and intermediary Excel?
Want to enhance your Excel knowledge and implement more of the program’s functions into your workflow?
Are you an Excel beginner and need to understand how to use it?
If you answer yes to the above questions, you are at the right place!
Excel 2021 for Beginners- A Game-Changing Step-By-Step Guide To Help You Master The Excel Use & Take Full Advantage Of Its Multiple Functionalities!
Offering such a wide variety of functions, it comes as no surprise that Excel is so vital in individual and business operations. In this eye-opening book, you will access practical advice and easy-to-follow steps that will help you better understand how Excel works, so you can facilitate your work and make your life easier.
By the end of this comprehensive guide for beginners, you will be able to:

Discover Excel’s Importance & Contribution to Your Work Operations
Familiarize with Excel, Access Its Tools, and Learn Basic Processes, Like Data Entry, Sorting & Filtering
Choose the right formula to automate your analysis to save time and boost your productivity in Excel
Explore the Tabs, Pie Charts, Graphs, Pivot Tables and Spreadsheets & Learn How You Can Use Them to Present Your Work Results
Unlock More and Less Known Functions That Will Save You Time and Energy
Use excel for data analysis and manipulation

Preface
Acknowlegement
Dedication
Content
CHAPTER ONE INTRODUCTION            
Importance Of Ms – Excel
Excel features
Starting excel
Excel Worksbook
Modifying Worksheets
Selecting Cells And Ranges
Data  Entry
Editing Data
Cell References
Selecting Cells
Page Setup
Print Document
Keyboard Shortcuts
CHAPTER TWO
THE BASICS OF TABLES
Creating A Table
Formatting A Table
Editing A Table
CHAPTER THREE
SORTING AND FILTERING
Sorting By Alphabet
Sort Data Using A Custom List
Creating Personal Customer List
Sorting With Multiple Criteria
Sorting By Color
Sort By Font Colour
Filter
CHAPTER FOUR
CALCULATIONS
Operators In Excel
Comparing Values With Operator
Application Of Operators
Inbuilt Functions
Avedev Function
Application Of Avedev
Beta.Dist
Binom.Dist.Range
Binom.Inv
Chisq.Dist.
Chisq.Test
Devsq
Expon.Dist ( Exponential Distribution)
F.Dist
F.Test
Fisher
Gamma.Dist
Gauss
Hygeom.Dist
Lognorm.Dist
Negbinom.Dist.
Norm.S.Dist
Pearson
Permut
Poisson.Dist
Prob
CHAPTER SIX
GROUPING AND OUTLINING DATA
Basic Data Grouping
Applying An Outline
Method Of Hiding Cell
Creating A Group
Group Outline
Visibility
Combining Data In Multiple worksheet
Combining Data In Multiple Workbook
CHAPTER SEVEN
BASIC CHARTS
Charting
Types Of Charts
Column Chart
Bar Chart
Line Chart
Pie Chart
Area
Xy (Scatter)
Stock Chart
Surface Chart
Radar Chart
Combo Chart
Creating Chart
Column Chart
Bar Chart
Line Chart
Pie Chart
Area Chart
Xy (Scatter) Chart
Stock Chart
Surface Chart
Radar Chart
Combo Chart
Chart Tools
Basic Tasks With Charts
Chart Layouts
Chart Element
Quick Layout
Chart Style
Chart Colour
Design Data
Switch Row/Column
Select Data
Moving And Resizing A Chart
Move Chart From One Sheet To Another              
Creating A Standalone Chart
Editing And Adding To Chart Data
Changing The Way Excel Plots Blank Values
CHAPTER EIGHT
FORMATTING AND FINISHING CHARTS
Coloring The Background
Fancy Fills
Fancy Borders And Lines
Controlling A Chart's Scale
Adding Error Bars To Scientific Data
Formatting 3 D Charts
Exploding Slices In A Pie
Gaps, Widths, And Overlays In Chart
Creating Combination Charts
CHAPTER NINE
GRAPHICS
Picture Handling
Inserting Picture
Positioning And Resizing A Picture
Picture Set Up
Compressing Pictures
Remove Background
Crop And Shape Picture
Picture Borders, Effects, And Styles
Picture Effect
Smart Art
Shape