Excel 2021 in 7 days: The All-in-One Course to Master Excel, Full of Practical Examples and Advanced Tips

Length: 219 pages
Edition: 1
Language: English
Publication Date: 2021-11-18
ISBN-10: B09M8W2C1L
Sales Rank: #0 (See Top 100 Books)

Are you looking for a simple but effective guide to improve your knowledge of one of the most used software in the world?

Do you want to take advantage of the full potential of Microsoft Excel simply following a step-by-step guide full of practical examples?

Many people have successfully learned to use Excel with this 7-days method.

The method is based on a 7-day approach with a lot of examples: each day you will learn new Excel features of gradually increasing difficulty.

With this book you’re going to learn all the secrets of Microsoft Excel following a plan of just 7 days, even if you are newbie.

DAY #1
On the first day you’ll understand what it’s for and how powerful Microsoft Excel is. You’ll learn about the main components of the software and the concepts of cells, rows, columns, and so on.
DAY #2
The second day is focused on to data manipulation. How to insert data, how to modify them, all supported with many examples. You will also learn what worksheets are and how to use them.
DAY #3
Sorting and filtering data is a very important activity when using Microsoft Excel. In the third day you’ll learn all you need to know about filters, how and when to use them, always supported by lots of practical examples.
DAY #4
We have already reached the halfway point. On day #4 you will learn how to validate data, how to decide which data can be entered and which cannot. You’ll learn how to beautify your worksheets to highlight the really important data. Lots of practical examples will make it all very concrete.
DAY #5
Among Excel’s most powerful tools are formulas and functions. The fifth day is focused entirely to that. How to enter a formula, how to find the right function you need, how to properly address cells. You’ll learn the main numeric, logical, textual, counting and date/time functions. Lots of examples are provided at this stage too, because with examples everything is much clearer.
DAY #6
The sixth day is dedicated to a little-known but very powerful feature of excel: tables. You’ll learn what tables are and how to create them. You will be able to create a pivot table and much more. Again, there will be no shortage of examples.
DAY #7
It’s the last day. We round off with the most fascinating features of excel: charts. Excel offers so many types of charts and we’ll go through them all one by one, to give you a chance to be able to choose the one that best suits your specific needs. This section is awesome!

In just 7 days you will learn everything you need to use Excel professionally.

Sure, you’ll need to get some practice.

And to help you with your practice, we have provided two additional sections in this book.

The first section contains 12 magic tips on how to use Excel efficiently and quickly. Little tricks that will take you to the next level.

The second section contains a step-by-step tutorial on creating a monthly family budget. This section will take you step-by-step through creating your first worksheet, including charts. This is a great opportunity to really practice Excel.

In 7 days, you will learn a skill that is in high demand in the business world and very useful in your personal life.

Introduction
Chapter 1: Introduction to Microsoft Excel
    1.1 What is Excel?
    1.2 History of Microsoft Excel
    1.3 Why Use and Learn Excel?
    1.4 Examples of Using Excel
    1.5 Where to download it?
Chapter 2: Getting started with using Microsoft Excel
    2.1 What is Ribbon?
    2.2 How to customize your Ribbon:
    2.3 Worksheet in Excel
    2.4 Row in Microsoft Excel
    2.5 Column in Microsoft Excel
    2.6 Other Commands on Excel Interface
Chapter 3: Entering, Editing and Managing Data
    3.1 Concept of Cell
    3.2 Enter Data in a Cell
    3.3 Modifying Data in Excel
    3.4 Rows and Columns
    3.5 Hide or Unhide Row or Column
    3.6 Insert or Delete Row or Column
    3.7 Moving Column or Row
    3.8 To Swap Rows and Columns
Chapter 4: Working with Worksheets
    4.1 What is a worksheet?
    4.2 Cell in Worksheet
    4.3 Difference between workbook and Worksheet
    4.4 Excel Worksheet Tab
    4.5 How to add a new Worksheet?
    4.6 How to delete the Worksheet?
    4.7 How to Copy Worksheet?
    4.8 How to Change Color of Worksheet?
    4.9 Grouping and Ungrouping of Worksheet
    4.10 To Group Worksheet
    4.11 Benefits of Grouping Worksheets
    4.12 Ungrouping of Worksheets
    4.13 How to Identify Grouped Sheets?
    4.14 Why Ungroup Worksheets?
Chapter 5: Sorting and Filtering Data
    5.1 Sorting data
    5.2 To sort data of a Sheet
    5.3 To sort data of Cell Range
    5.4 To Sort Data in one column
    5.5 To Sort Data in multiple Columns
    5.6 Custom Sorting
    5.7 To Sort Data in a Row
    5.8 Sorting by Conditional formatting
    5.9 Filtering Data
    5.10How to Add Filters:
    5.11 Number Filters Option
    5.12 Text Filters
Chapter 6: Data Validation
    6.1 How to Validate Data in Excel?
    6.2 How to make a validation rule in Excel?
    6.3 List of Excel data validations (dropdown)
    6.4 Copy Excel data validation rule for other cells
    6.5 How to remove data validation
Chapter 7: Formatting Cells
    7.1 Change the Font
    7.2 To adjust the font of your data
    7.3 To adjust the font size of your data
    7.4 To modify the font color
    7.5 Cell Alignment
    7.6 Adding borders and Fill colors in a cell
    7.7 Formatting Text and Numbers
Chapter 8: Formulas and Functions
    8.1 Formula
    8.2 To enter the formula
    8.3 To Edit Formula
    8.4 Make a Formula by Copy/Paste
    8.5 Add Formula Using Insert Function Key
    8.6 How to use formula?
    8.7 Function
    8.8 Number Functions
    8.9 Text Functions
    8.10 Logical Functions
    8.11 Counting Functions
    8.12 Date and Time Functions
    8.13 Difference between Formula and Function
Chapter 9: Working with Excel Tables
    9.1 What are Excel Tables?
    9.2 Create an Excel Table
    9.3 Why Use Table?
    9.4 Excel Tables with Structured Referencing
    9.5 Pivot Table
    9.6 Two Dimensional pivot tables
    9.7 Uses of Pivot Table
    9.8 Style and Formatting of Table
    9.9 Excel table styles
    9.10 Table Style Options
    9.11 Select Table Style When Creating a Table
    9.12 Change the table style
    9.13 Remove table formatting
Chapter 10: Creating Charts
    10.1 What are Excel Charts?
    10.2 Types of Charts
    10.3 Choose the finest Excel charts
    10.4 Creating Chart in Excel
    10.5 How to Create a Process- Behavior Chart in Excel
    10.6 Creating Process- Behavior Chart
Chapter 11: Magical Tips for Excel
    11.1 How to add multiple rows
    11.2 Conditional Formatting
    11.3 How to detect duplicate data
    11.4 List of Excel Shortcut Keys
    11.5 Editing Shortcuts Keys
    11.6 Formatting Shortcuts Keys
    11.7 Navigation Shortcut keys
    11.8 File Shortcut key
    11.9 Ribbon Shortcut
    11.10 Paste Special Shortcut keys
    11.11 Clear Shortcut Keys
    11.12 Selection Shortcut Keys
    11.13 Data Editing Shortcut Keys
    11.14 Data Editing Within Cell Shortcut Keys
    11.15 Other Shortcut Keys
    11.16 Why Use Shortcut Keys
    11.17 More Useful Tricks
Conclusion
Tutorial: How to Create Family Monthly Budget Using Excel