Learn Excel in 24 Hours

Learn Excel in 24 Hours

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

GET EBOOK

Author
Publisher Guru99
Release Date
ISBN
Pages 270 pages
Rating 4/5 ( users)

More Books:

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
Excel 2007 PivotTables Recipes
Language: en
Pages: 272
Authors: Debra Dalgleish
Categories: Computers
Type: BOOK - Published: 2008-03-11 - Publisher: Apress

In this book, Debra Dalgleish, Microsoft Office Excel MVP since 2001 as well as an expert and trainer in Excel, brings together a one-stop resource for anyone c
Learn To Use Excel Pivot Tables In An Hour
Language: en
Pages: 98
Authors: Carl Nixon
Categories:
Type: BOOK - Published: 2018-04-02 - Publisher: Independently Published

Learn how to use Excel Pivot Tables in an hour! Even if you are a complete newbie! What if learning a new Excel skill could save you hours of time and make your
Knight's Microsoft Business Intelligence 24-Hour Trainer
Language: en
Pages: 432
Authors: Brian Knight
Categories: Computers
Type: BOOK - Published: 2011-11-30 - Publisher: John Wiley & Sons

A book-and-video introduction to Microsoft's Business Intelligence tools If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools,
Learn to Use Excel... ... in an Hour
Language: en
Pages: 177
Authors: Carl Nixon
Categories:
Type: BOOK - Published: 2018-04-27 - Publisher:

Master these 3 vital Excel skills in an hour! Even if you are a complete newbie! What if learning a new set of Excel skills could save you hours of time, make y
Excel Annoyances
Language: en
Pages: 235
Authors: Curtis Frye
Categories: Computers
Type: BOOK - Published: 2005 - Publisher: "O'Reilly Media, Inc."

A guide to handling a vareity of quirks, bugs, and hidden features found in Microsoft Excel.
Access 2010 24-Hour Trainer
Language: en
Pages: 544
Authors: Geoffrey L. Griffith
Categories: Computers
Type: BOOK - Published: 2011-05-10 - Publisher: John Wiley & Sons

This book-and-video package is the perfect introduction to Access 2010 Microsoft Access is the most popular database system in the world and this practical guid
Learn to Use Pivot Tables in an Hour
Language: en
Pages: 83
Authors: Carl Nixon
Categories:
Type: BOOK - Published: 2017-01-01 - Publisher:

Learn to use Pivot Tables in an Hour If you are new to Excel Pivot Tables they can seem daunting and scary. This easy to follow and fully illustrated guide by t
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours
Language: en
Pages: 496
Authors: Trudi Reisner
Categories: Computers
Type: BOOK - Published: 2003 - Publisher: Sams Publishing

Explains how to use the newest version of Excel to store and manipulate data, create and use formulas, customize spreadsheets, integrate Excel with other applic
Learn SAP BI in 24 Hours
Language: en
Pages: 380
Authors: Alex Nordeen
Categories: Computers
Type: BOOK - Published: 2020-09-15 - Publisher: Guru99

SAP Business Intelligence (BI) is a tool to analyze raw data and derive meaning inferences. SAP BI gives single point access to data from various sources. Robus