11.02.2017 von Maddin_O
Aufrufe: 2 Hits
Vote 4 Us
Learn Excel in 1 Day Definitive Guide to Learn Excel for Beginners PDF
115 Min.
8 MB
Kein Passwort
Video Codec:
MPEG-4 H.264 / AVC
Audio Stream:
Audio Bitrate:
Zeige NFOVerberge NFO
Derzeit leider keine Info verfügbar.
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 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. 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 und 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 Sach und Fachbuecher English
Direct Download Links | DDL-Links

Ähnliche Releases der Kategorie