The Excel basics to Advanced book contains step-by-step exercises to explain the concepts in Excel.
The book begins with fundamental concepts in Excel and then takes a deep dive into basic and advanced calculations such as Logical, Text, Lookup and Reference, and DateTime functions.
The book illustrates how to use PivotTable, and Excel tables to analyze data. Readers also learn how to automate Excel tasks using Macros.
Author(s): Chandraish Sinha
Publisher: Books District Publication
Year: 2023
Language: English
Pages: 247
1.MS Excel Fundamentals
Introducing MS Excel
Importance of MS Excel
MS Excel Terminology
Installation
Installation of Office 365
Understanding the ribbon
Ribbon Tabs
Understanding the Workbook
Creating your first Workbook
Auto fill
Flash fill
Copy data from one sheet to another
Saving the Excel Workbook
Freeze Pane
Sorting
Filtering the data
Task bar
Printing in Excel
Printing Options
2.Formatting in Excel
Cell Formatting in MS Excel
Format Cells
Conditional Formatting
Custom Conditional Formatting
3.Introduction to Formulas
Overview of Formulas
Cell Reference
Relative Cell reference
Absolute Cell reference
Mixed Cell reference
3-D reference
R1C1 reference
Copy values of a Formula
4.Logical Functions
Overview of Logical Functions
The IF function
The AND function
The OR function
The NOT function
The IFERROR function
5.Text Functions
Overview of Text Functions
The LEFT, RIGHT, and MID function
The LEFT function
The RIGHT function
The MID function
The LEN function
The CONCAT function
6.DateTime Functions
Overview of Dates
Add or subtract days from dates
The EDATE function
The DATE, YEAR, MONTH, and DAY functions
The DATE function
The YEAR function
The MONTH function
The DAY function
Calculating Quarters
TODAY, NOW, and TIME functions
TODAY and NOW functions
The TIME function
7.Mathematical Functions
The COUNT functions
COUNT function
COUNTA function
COUNTIF function
The SUM functions
SUM function
SUMIF function
SUMIFS function
8.Lookup and Reference
The VLOOKUP function
How it works
VLOOKUP features
Look up value in the same sheet
Look up value in different sheets
Look up value in different workbooks
The LOOKUP function
The INDEX function
The MATCH function
Combining INDEX and MATCH function
9.Pivot tables and Charts
Understanding Pivot Tables
Pivot Table Interface
Creating Pivot table
Charts in Excel
Standard Charts
Pivot Charts
Updating PivotTable Data
Updating the PivotTable with New Data Rows
Automatically Updating the PivotTable on open
10.Excel Table
Overview of Excel Tables
Creating an Excel table
SubTotal function
SUBTOTAL vs. SUM
11.Introduction to Excel Macros
Overview of Macros
Enabling the Developer tab
Recording a Macro
Visual basic code for Macros
