Learn Excel in 1 Day: Definitive Guide to Learn Excel for Beginners
Learn Excel in 1 Day: Definitive Guide to Learn Excel for Beginners by Krishna Rungta
English | 9 Jan. 2017 | ASIN: B01NARV0DT | 132 Pages | PDF (conv) | 8.44 MB
English | 9 Jan. 2017 | ASIN: B01NARV0DT | 132 Pages | PDF (conv) | 8.44 MB
The book gives a detailed introduction to Excel. It proceeds to teach basic concepts like row, columns, ribbon, worksheet, shortcuts. Later provides a detailed explanation of Formulas, Operators, and Functions. The book also briefly touches the concept of VBA.
Pivot Tables, Connection to external Data Sources included.
The book also includes a case study to Managing personal finance using Microsoft Excel.
Chapter 1: Introduction
What is Microsoft Excel?
Why should I learn Microsoft Excel?
The difference between excel and CSV file
Running Microsoft Excel
Understanding the Ribbon
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
Customization Microsoft Excel Environment
Important Excel shortcuts
Chapter 2: Getting Started
Basic Arithmetic
Formatting data
Setting the print area and printing (Print View)
Adding images to spreadsheets
Data validation
Data filters
Group and Ungroup
Chapter 3: Formula & Functions
What is a formula?
What is a function?
Common functions
Numeric functions
String functions
Date Time functions
V Lookup function
Chapter 4: Operators
What is a Logical Function?
What is a condition and why does it matter?
IF function example
Excel Logic functions
Nested IF functions
Chapter 5: Charts
What is a chart?
Types of charts
The importance of charts
Step by step example of creating charts
Conditional Formatting
Chapter 6: Case Study: Personal Finance Application using Excel
Why managing personal finance matters
Major components of a personal finance system
Using Excel to set personal budgets, record income and expenses
Visualizing the data using charts
Chapter 7: Macros
What is a macro?
Macro Basics
Step by step example of recording macros
What is VBA?
Visual Basic for Applications VBA basics
Step by step example of creating a simple EMI calculator
Chapter 8: Connecting Excel to External Data Sources
What is external data source?
MS Access external data source
Web external data source
Text file external data source
SQL Server external data source
Chapter 9: Pivot Tables
What is a pivot table?
Step by step tutorial on creating pivot tables
2-Dimensional pivot tables
Visualizing pivot table data using charts
Chapter 10: Advanced Charts
What is an advanced chart?
The importance of advanced charts
Step by step example of creating advanced charts
Chapter 11: Excel in the cloud: Office 365
Introduction to cloud computing
What is Office 365?
Advantages of Office 365
Disadvantages of Office 365
What is Microsoft Excel?
Why should I learn Microsoft Excel?
The difference between excel and CSV file
Running Microsoft Excel
Understanding the Ribbon
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
Customization Microsoft Excel Environment
Important Excel shortcuts
Chapter 2: Getting Started
Basic Arithmetic
Formatting data
Setting the print area and printing (Print View)
Adding images to spreadsheets
Data validation
Data filters
Group and Ungroup
Chapter 3: Formula & Functions
What is a formula?
What is a function?
Common functions
Numeric functions
String functions
Date Time functions
V Lookup function
Chapter 4: Operators
What is a Logical Function?
What is a condition and why does it matter?
IF function example
Excel Logic functions
Nested IF functions
Chapter 5: Charts
What is a chart?
Types of charts
The importance of charts
Step by step example of creating charts
Conditional Formatting
Chapter 6: Case Study: Personal Finance Application using Excel
Why managing personal finance matters
Major components of a personal finance system
Using Excel to set personal budgets, record income and expenses
Visualizing the data using charts
Chapter 7: Macros
What is a macro?
Macro Basics
Step by step example of recording macros
What is VBA?
Visual Basic for Applications VBA basics
Step by step example of creating a simple EMI calculator
Chapter 8: Connecting Excel to External Data Sources
What is external data source?
MS Access external data source
Web external data source
Text file external data source
SQL Server external data source
Chapter 9: Pivot Tables
What is a pivot table?
Step by step tutorial on creating pivot tables
2-Dimensional pivot tables
Visualizing pivot table data using charts
Chapter 10: Advanced Charts
What is an advanced chart?
The importance of advanced charts
Step by step example of creating advanced charts
Chapter 11: Excel in the cloud: Office 365
Introduction to cloud computing
What is Office 365?
Advantages of Office 365
Disadvantages of Office 365