Click to read - Part 3: Business Applications of Functions in Microsoft Excel.
You can also watch the introductory excel video on youtube
HOW TO STUDY THE CHAPTERS OF THIS TUTORIAL
Each chapter of this tutorial contains the procedures to achieve some tasks, some practical examples and some practical exercise for you in order to help you comprehend its content.
See the MS Access Full Course Contents.
CONTENTS
- HOW TO STUDY THE CHAPTERS OF THIS TUTORIAL
- INTRODUCTION
- ELECTRONIC SPREADSHEET
- SPREADSHEET PROGRAMS
- USES OF MS-EXCEL
- GETTING STARTED WITH MICROSOFT EXCEL AND THE HISTORY OF MS-EXCEL
- HISTORY OF MS-EXCEL
- THE NEW FEATURES IN EXCEL 2016
- HOW TO GET MS-ACCESS 2016 OR 2013 ON YOUR WINDOWS PC
- HOW TO LOAD MS-EXCEL INTO MEMORY
Almost all career fields keep record of their business organizations and also directly or indirectly perform calculations and data analysis. Most of these fields have expanded and developed to an extent that they need a computerized system to help them perform some difficult tasks or calculation s efficiently and accurately. Some of these tasks include staff payroll system, forecasting and sales trend, students’ grade list, loan amortization, sales report, etc. With an electronic spreadsheet package like Microsoft Excel, all these tasks can be simplified and managed.
ELECTRONIC SPREADSHEET
This is a computer program that enables one to carry out calculations on several rows and columns of numbers. MS-Excel is a typical example of an electronic spreadsheet.A spreadsheet can be used to perform mathematical and financial projects, budget, cash flow projections, stock price tracking, balance sheet, etc. in other words, spreadsheet is a programmed table of information much like an accountants ledger book designed with multiple rows and columns where numerical data could be entered and manipulated for easy financial interpretation and analysis.
SPREADSHEET PROGRAMS
These are programs or application systems used for spreadsheet management. There are many of them. Some of them include.1. Microsoft Excel
2. Lotus 123
3. Lotus Smart Suite
4. Multi-plan
5. Quattro pro
6. Super cals
7. Ami Pro
8. Symphony, etc.
WHAT IS MICROSOFT EXCEL?
It is an integrated electronic spreadsheet and graphics software package designed to perform mathematical calculations on rows and columns and produces result which can be either qualitative or quantitative. It has some powerful tools that allow you perform variety of tasks for business, science and engineering. It can also be used in database management.USES OF MS-EXCEL
1. It is used in preparing financial reports.2. It is also used in preparing financial budget.
3. It is used in preparing financial budget.
4. It is used to prepare students’ grade list.
5. It can be used to prepare reports (both sales and expense).
6. It is used in sales forecasting and trend.
7. It is also used to prepare inventory management.
8. It can be used to prepare Billing Statement
9. It can be used to design Blood pressure Tracker
10. It can be used to prepare Loan Amortization
11. It can be used to Time Card
GETTING STARTED WITH MICROSOFT EXCEL AND THE HISTORY OF MS-EXCEL
HISTORY OF MS-EXCEL
MS-Excel 2013
Welcome window
|
- Billing Statement
- Blood pressure Tracker
- Expense Report
- Loan Amortization
- Personal Monthly Budget
- Sales Report
- Time Card
- These templates can save you a lot of time and helps to standardize your projects.
THE NEW FEATURES IN EXCEL 2016
SOME NEW FUNCTION ADDED TO MS-EXCEL
These are some of the new functions added to MS-Excel 2016TEXTJOIN FUNCTION
CONCAT FUNCTION
IF FUNCTION
SWITCH FUNCTION
MAXIFS FUNCTION
MINIFS FUNCTION
Here is a list of newly added features in MS-Excel 2016:
- Funnel charts
Improved Autocomplete
Six new chart types
Get and transform (Query)
One Click Forecasting
3D Maps
Financial templates
Calendar Insights Template
Pivot Table enhancements
Pivot Chart drill-down buttons
Multi-select slicer
Publish and share your analysis with Power BI
Quick Shape Formatting
Insert pictures with the correct orientation
Do things quickly with “Tell me what you want to do” text box
The Insight Pane: Insights into what you're working on
Ink Equations
Sharing Simplified
Improved version history
Data Loss Protection (DLP) in Excel
New themes
OR
HOW TO GET MS-ACCESS 2016 OR 2013 ON YOUR WINDOWS PC
- MS-Access (for database management)
- MS-Excel (for spreadsheet Management)
- MS-Word (for document editing and formatting)
- MS-PowerPoint (for presentation in slides)
- MS-Publisher (for book publishing and editing)
HOW TO LOAD MS-EXCEL INTO YOUR PC MEMORY
2. Type the word access to call up the search charm.
3. From your search result, click on MS-Excel 2010 or MS-Excel 2013 or MS-Excel 2016 depending on the version installed on your PC .
![]() |
Search results
|
MS-Excel 2010
Welcome window
|
MS-Excel 2013 Welcome window |
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete