Ms Office Excel Basics Pdf

Microsoft excel is an electronic spreadsheet program that runs on a personal computer.

Ms office excel basics pdf. Microsoft excel tutorial handout opening microsoft excel 1. Microsoft office excel 2007 basics getting started the excel window 1 quick access toolbar stores shortcuts for commonly used tools such as save undo and print. Formulas are self dened instructions for performing calculations. What is microsoft office.

Once you have specified a name place and format for your new file press the save button. Today we will be going over the basics of using microsoft excel. Microsoft excel is a powerful electronic spreadsheet program you can use to automate accounting work organize data and perform a wide variety tasksof excel is designed to perform calculations analyze information and visualize data in a spreadsheet. We use it to create reports that need calculations and charts.

We will be using pc desktop computers running the windows operating system. In excelthe calculation can be specied using either a formula or a function. The term microsoft office refers microsofts entire suite of office productivity applications. 2 ms office button comparable to the menu bar in older versions of excel.

As with a paper spreadsheet you can use excel to organize your data into rows and columns and to perform mathematical calculations. Microsoft excel is part of the suite of programs called microsoft office which also includes word powerpoint and more. Microsoft excel for beginners 20 hours this is a basic computer workshop. Microsoft excel 2016 screen elements the ribbon the ribbon is designed to help you quickly find the commands that you need to complete a task.

Microsoft excel is a spreadsheet program. Each tab relates to a type of activity such as formatting or laying out a page. Microsoft excel will open a dialog box figure 3 where you can specify the new files name location of where you want it saved and format of the document. The excel screen name box standard toolbar formula bar active cell menu bar title bar select all button status bar tab scrolling buttons sheet tabs worksheet scroll bars minimize buttons.

Click on the start button. In either case all formulas and functions are entered in a cell and must begin with an equal sign. Commands are organized in logical groups which are collected together under tabs. Also this application includes database and charting features.

This is similar to clicking file and then open other commonly used commands are also. Click on microsoft excel. To reduce clutter some tabs.