Excel: The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming

Length: 128 pages
Edition: 1
Language: English
Publisher: Independently published
Publication Date: 2019-08-19
ISBN-10: 1687366535
ISBN-13: 9781687366535
Sales Rank: #991829 (See Top 100 Books)

Do you need a spreadsheet that offers calculation, graphing tools, pivot tables and more?

Is this an essential tool for your business or home?

Are you new to this concept and need a step-by-step guide to get going?

Millions of us, whether in business or our daily lives, like to be able to keep track of expenditure, jobs and other things we do. Having everything in one handy spreadsheet that can instantly tell us what we are spending or the status of our current project, is invaluable.

If you are new to the idea then Excel is a great place to get started and with Excel: The Ultimate Comprehensive Step-by-Step Guide to the Basics of Excel Programming you can learn some of the fundamentals like:

An introduction to VBA
How to Use Data From Excel
How to Manipulate Data In Excel
Working With Loops, Strings and Conditional Statements
Error Handling and Debugging
Common Mistakes for You to Avoid
And much more…

This book is the perfect place for any beginner to get started and with examples and simple and basic tutorials you will soon be on the way to using Excel for all your tasks, making you wonder how you ever got on without it.

Get a copy now and see how it will change the way you work and live!

Title Page
Copyright Page
Also By Kevin Clark
Introduction
Chapter One: Working With Worksheets
Creating a New Worksheet
Renaming and Deleting Worksheets
Moving and Copying Worksheets
Coloring Worksheet Tabs
How to Make Worksheets Work for You
Chapter Two: Formatting Worksheets
Most Common Formatting Commands
Font Group
Alignment Group
Number Group
Selecting the Range Of Cells
Hiding Worksheets
Adding Themes to Workbooks
Customize a Workbook Using Themes and Tab Colors
Solution
Adding a Watermark
The Font Group
Bold, Italicize Or Underline Text
Add Borders To Cells
Change Text And Cell Colors
Set Font And Font Size
Working With Font Group Commands
Solution
The Alignment Group
Align Text
Wrap Text
Indent Text
Merge And Center Text
Working With Alignment Group Commands
Solution
The Number Group
Number Formats
Date Formats
Showing Decimals
Smart Lookup
Working with Number Group Commands
Solution
Chapter Three: Cell Referencing in Excel
What is Cell Referencing?
Relative Cell Referencing
Absolute Cell Referencing
Mixed Cell Referencing
Cell Referencing through link cells
Circular Referencing
How do you overcome cell referencing?
Chapter Four: More Formulae
Computing GDPs
Currency
Decimal Places
Percentage
Editing Text with Formulas
Number of Characters
Counting Numbers
Trim
Sum
IF Statements
SUMIF, COUNTIF, AVERAGEIF
Concatenate
Looking for Information
Chapter Five: Data Validation
Chapter Six: Working With Charts
Understanding Charts
Column Charts
Bar Charts
Line Charts
Pie Charts
Doughnut
Other Charts
Parts of a Chart
Vertical Axis
Horizontal Axis
Data Series
Inserting a Chart
Chart Layout and Style
Other chart options
To switch row and column data
To change the chart type
To move a chart
Keeping charts up to date
Chapter Seven: What – If Analysis
Goal Seek
Set Cell
To Value
By Changing Cell
Scenario testing
Chapter Eight: Excel Made Easy
Delete Unnecessary Stuff from the Web
Hide Duplicate Records
Delete X Rows
Use Pivot Table to Count Items
Create Macros to Merge Cells
Highlight Specific Cells
Ignore Other Applications
Paste Column Widths
Make Templates out of Charts
Save Personal Workbooks
Export Excel to AutoCad
Chapter Nine: What Else Can Excel Be Used For?
Creating Animations on Excel
A Spreadsheet Canvas
Using Excel as an Animation Viewer
Chapter Ten: 15 Fun Things to Do In Excel
Change the Shape and Color of Comments in Cells
Filtered a List to Find Unique Items
Sort Data Left to Right
Hide Gridlines
Smooth off Your Charts with Rounded Borders
Get Live Stock Quotes with One-Click
Repeat Rows and Show Table Headers When Printing
Remove All Formatting or Conditional Formatting with One-Click
Auto Sum a range of Cells with One-Click
Use a Formula to Find the Column Width
Find the Total Number of Working Days in Between Two Dates
Freeze Rows and Columns
Split a Sheet in Half for Side-by-Side comparison
Change the Color on the Sheet Name tabs
Insert an Organization Chart
Chapter Eleven: How to Become an Excel Power User with These 11 Tricks
Vlookup
Creating Charts
IF Formulas
PivotTables
PivotChart
Flash Fill
Quick Analysis
Power View
Conditional Formatting
Transpose Columns to Rows and Vice Versa
Essential Shortcuts Using the Keyboard
Conclusion
References
Sign up for Kevin Clark's Mailing List
Also By Kevin Clark