Lesson 1: Introduction to Ms Excel

• Microsoft Excel is a spreadsheet program developed by Microsoft.
• Excel organizes data in columns and rows and allows you to do mathematical functions.
• The first version of Excel was released in 1985 and has gone through several changes over the years.
• Excel 1985 V 1.5 is the most popular spreadsheet program in the world.
• The skill ceiling in Excel is high, which means that you can do more advanced things as you become better.
• Excel can be used with both work and in everyday life, such as to create a family budget.
• Excel has a huge community support.
• Excel is continuously supported by Microsoft.
• Templates and frameworks can be reused by yourself and others, lowering creation costs.
• Excel can be used for accounting, budgeting, billing and sales, reporting, planning, tracking, calendars, and common uses.
• Accounting is the powerful calculation features of Excel can be used in many financial accounting statements.
• Excel can be used for creating any type of budget.
• Excel is useful for managing billing and sales data.
• The Ribbon in Excel is a list of commands to perform the different tabs.
• The File Tab in Excel includes all the basic needs in your file like saving, opening, printing, creating new and closing the program.
• The Home Tab in Excel includes all the basic tools for entering, editing and formatting data.
• The Page Layout Tab in Excel provides command to format the overall look of your workbook.
• The Formula Tab in Excel lets you turn automatic calculation updating on and off and manually update if necessary and quickly access the functions command.
• The Data Tab lets you analyze data.
• The Column Headers in Excel represent letter from A to XFD columns.
• The Row Headers in Excel represent numbers from 1 up to 1,048,576.
• The Sheet Tabs in Excel is a list of sheets in a workbook.
• You can create up to 256 sheets in one workbook depending on the availability of your computer memory.
• The Status Bar in Excel display the current command.
• The Scroll Bar in Excel has different ways to view your worksheet.
• You can view through Normal, Page Layout, Page Break Preview and from 10% Zoom in to 400% Zoom out view in Excel.
• Budgeting is where you can create personal/business related data in Excel.
• Billing & Sales is useful for managing billing and sales data.
• Accounting uses: Cash Flow Statement, Income Statement, Profit and loss Statement.
• Budgeting make plans through: Marketing Budgeting Plan, Event Budget, Retirement Budget
• Billing & Sales goes through: Sales Invoice, Packing Slip, Purchase Order.
• The Review Tab provides commands to review your workbook in Excel.
• The Insert Tab adds publishing elements to your workbooks.