Tutorial Excel Ppt

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.

Tutorial excel ppt. Commands are organized in logical groups which are collected together under tabs. Excel can also auto fill series of dates times days of the week months. It will complete the patternfor exampleif you put 4 and 8 in two cells select themclick and drag the fill handle excel will continue the pattern with 121620etc. Understand the use of spreadsheets and excel learn the parts of the excel window scroll through a worksheet and navigate between worksheets create and save a workbook file enter text numbers and dates into a worksheet resize insert and remove columns and rows new perspectives on microsoft office excel 2007.

Each tab relates to a type of activity such as formatting or laying out a page. Excel 2016 is a version of excel developed by microsoft that runs on the windows platform. To reduce clutter some tabs. Excelrocker pioneer in providing advanced excel training and professional powerpoint training in chennai and pune our team always do research and development in and around microsoft office products and keep on updating the customised training module meeting the organisation needs and according to the budget.

Advanced excel ppt 1. Microsoft excel uses a ribbon toolbar to allow you to modify your document. We can focus on specific recordrows in a large table of data by setting conditions so that only specific data is displayed and rest of the records are get hidden temporarily in the spreadsheet. Excel information excel training offered by.

This excel 2016 tutorial covered the basic concepts of spreadsheets such as. If you do not see these toolbars or to open up other toolbars go to view ribbon and place a checkmark by the toolbar you wish to open. Our speciality lies with our self designed crispy training hand outs tips tricks. Click the start button click all programs click microsoft office and then click microsoft excel 2010.

Excel will also allow you to customize your toolbar by going to view customize views. Cells rows and columns. The title bar the quick access toolbar the ribbon backstage view and the status bar. Both mac and pc have the same ribbon toolbar.

If you have two cells selected excel will fill in a series. Congratulations you have completed the excel 2016 tutorial. The excel program window has the same basic parts as all office programs.