Learn Excel in 24 Hours

Learn Excel in 24 Hours
Author : Alex Nordeen
Publisher : Guru99
Total Pages : 270
Release : 2020-09-15
ISBN 10 :
ISBN 13 :
Language : EN, FR, DE, ES & NL

Learn Excel in 24 Hours Book Description:

Learn to Use Microsoft Office Excel 2016 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. Table Of Content Chapter 1: Introduction 1. What is Microsoft Excel? 2. Why should I learn Microsoft Excel? 3. The difference between excel and CSV file 4. Running Microsoft Excel 5. Understanding the Ribbon 6. Understanding the worksheet (Rows and Columns, Sheets, Workbooks) 7. Customization Microsoft Excel Environment 8. Important Excel shortcuts Chapter 2: Getting Started 1. Basic Arithmetic 2. Formatting data 3. Setting the print area and printing (Print View) 4. Adding images to spreadsheets 5. Data validation 6. Data filters 7. Group and Ungroup Chapter 3: Formula & Functions 1. What is a formula? 2. What is a function? 3. Common functions 4. Numeric functions 5. String functions 6. Date Time functions 7. V Lookup function Chapter 4: Operators 1. What is a Logical Function? 2. What is a condition and why does it matter? 3. IF function example 4. Excel Logic functions 5. Nested IF functions Chapter 5: Charts 1. What is a chart? 2. Types of charts 3. The importance of charts 4. Step by step example of creating charts 5. Conditional Formatting Chapter 6: Case Study: Personal Finance Application using Excel 1. Why managing personal finance matters 2. Major components of a personal finance system 3. Using Excel to set personal budgets, record income and expenses 4. Visualizing the data using charts Chapter 7: Macros 1. What is a macro? 2. Macro Basics 3. Step by step example of recording macros 4. What is VBA? 5. Visual Basic for Applications VBA basics 6. Step by step example of creating a simple EMI calculator Chapter 8: Connecting Excel to External Data Sources 1. What is external data source? 2. MS Access external data source 3. Web external data source 4. Text file external data source 5. SQL Server external data source Chapter 9: Pivot Tables 1. What is a pivot table? 2. Step by step tutorial on creating pivot tables 3. 2-Dimensional pivot tables 4. Visualizing pivot table data using charts Chapter 10: Advanced Charts 1. What is an advanced chart? 2. The importance of advanced charts 3. Step by step example of creating advanced charts Chapter 11: Excel in the cloud: Office 365 1. Introduction to cloud computing 2. What is Office 365? 3. Advantages of Office 365 4. Disadvantages of Office 365

Learn Excel in 24 Hours
Language: en
Pages: 270
Authors: Alex Nordeen
Categories: Business & Economics
Type: BOOK - Published: 2020-09-15 - Publisher: Guru99

Learn to Use Microsoft Office Excel 2016 The book gives a detailed introduction to Excel. It proceeds to teach basic concepts like row, columns, ribbon, workshe
Microsoft Excel Simple Projects
Language: en
Pages: 98
Authors: Eric LeMoine
Categories: Electronic spreadsheets
Type: BOOK - Published: 2001-04 - Publisher: Teacher Created Resources

Projects for language arts, social studies, science and math. Provided templates can be modified to meet specific needs. Project samples also provided
Microsoft Excel for Teachers and Students
Language: en
Pages: 76
Authors: Donny Wise
Categories: Education
Type: BOOK - Published: 2015-02-19 - Publisher: Lulu.com

This book is a gentle introduction to the use of spreadsheets for organization of information and arithmetic computing. Learn the basics of cells, formulas, and
Microsoft Excel 2021 Programming Pocket Primer
Language: en
Pages: 326
Authors: Julitta Korol
Categories: Computers
Type: BOOK - Published: 2022-09-29 - Publisher: Stylus Publishing, LLC

As part of the successful Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without spending
Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP
Language: en
Pages: 1038
Authors: Julitta Korol
Categories: Computers
Type: BOOK - Published: 2019-05-13 - Publisher: Mercury Learning and Information

Updated for Excel 2019 and based on the bestselling editions from previous versions, Microsoft Excel 2019 Programming by Example with VBA, XML and ASP is a prac
Microsoft Excel Programming Pocket Primer
Language: en
Pages: 200
Authors: Julitta Korol
Categories: Computers
Type: BOOK - Published: 2015-05-15 - Publisher: Mercury Learning and Information

As part of the Pocket Primer series, this book provides an overview of the major concepts to program Microsoft Excel. The focus of this book is on basic program
Financial Analysis with Microsoft Excel
Language: en
Pages: 560
Authors: Timothy R. Mayes
Categories: Business & Economics
Type: BOOK - Published: 2020-01-16 - Publisher: Cengage Learning

Gain the hands-on experience and knowledge to solve real financial problems while taking your Excel spreadsheet skills to a new level with Mayes' FINANCIAL ANAL
Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP
Language: en
Pages: 800
Authors: Julitta Korol
Categories: Computers
Type: BOOK - Published: 2014-04-15 - Publisher: Mercury Learning and Information

This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercise
Succeeding in Business with Microsoft Excel 2013: A Problem-Solving Approach
Language: en
Pages: 720
Authors: Debra Gross
Categories: Computers
Type: BOOK - Published: 2013-08-21 - Publisher: Cengage Learning

SUCCEEDING IN BUSINESS WITH MICROSOFT OFFICE EXCEL 2013 prepares your students to solve business problems by moving beyond the basic point and click skills to t
Microsoft Excel 2019 Level 1 (English version)
Language: en
Pages: 77
Authors: AMC College
Categories: Computers
Type: BOOK - Published: - Publisher: Advanced Micro Systems Sdn Bhd

Microsoft Excel 2019 is the most common spreadsheet software for business or personal use. Even if you choose to work with another spreadsheet solution, most so