EXCEL 2023: From Beginner to Expert – The Illustrative Guide to Master All The Essential Functions and Formulas in Just 7 Days With Step-by-Step Tutorials, Practical Examples, Tips and Tricks by Richard Wilson
Table of contents
- Introduction
- Chapter 1: What Is Excel?
- What Is Microsoft Excel?
- History of Ms Excel
- Chapter 2: Getting Started with Excel
- Where Do You Find Excel?
- Excel File Extensions
- Chapter 3: The Excel Interface
- Understanding the Excel Interface
- Identification of The Screen Parts
- Title Bar
- Worksheet Tabs
- Ribbon Tabs
- What Is Spreadsheet?
- What Is a Cell?
- What Is a Row?
- What Is a Column?
- Chapter 4: Way to Use Excel Properly
- Opening A Spreadsheet
- Working With The Ribbon
- Managing Your Sheets
- Entering Data
- Chapter 5: Formulas in Microsoft Excel
- What Is Microsoft Excel Formulas?
- How to Insert Formulas in Microsoft Excel
- How to Use Most Common Microsoft Excel Formulas
- Chapter 6: Functions in Excel
- The Importance Of Functions
- The Parts of a Function
- Advanced Functions
- Working with Arguments
- Creating Function
- How to Enter a Function Manually
- The Function Library
- Insert Function Command
- Chapter 7: Excel Tricks and Keyboard Shortcuts
- Useful Tricks That Make Excel Easy
- Keyboard Shortcuts for Microsoft Excel
- Chapter 8: Analyzing Data in Excel
- Make Pivot Table
- Analyzing Data Sets with Excel
- Tips and Tricks
- Data Visualization
- Data Reporting
- The Importance of Reporting All Results
- Chapter 9: Tables & Their Importance
- Tables Types
- How Can You Make a Table in Excel?
- Why Are Tables in Excel Useful?
- Smart Tables Which Expand as Data Is Entered
- Creating an Excel Table from A Set
- Chapter 10: What Are Charts?
- A Chart Is the Set of Coordinates
- A Compression Algorithm Is A Chart
- How To Make An Excel Chart
- Chapter 11: Excel and Our Everyday Lives
- Solving Arithmetic Problems
- Formatting Alternatives
- Accessibility to the Internet
- Charts for Statistical Analysis
- All Information in One
- Human Resource Management (HRM)
- Chapter 12: Formatting
- Characters, Colors, Size
- Alignment, Merge, Wrap
- All Cell Data Types And Common Issue
- Conditional Formatting And Table Format
- Add And Remove Columns/Cells
