In this Excel 2016 beginners tutorial, you will learn almost everything about excel with pictures for easy understanding with step by step explanation.
Excel is a programme which lets you store, manage and analyze information.Anyone can learn Excel to take benefits of Excel powerful features.Whether, you are making a budget, creating an invoice.Excel makes it easy to work for you.
Excel 2016 beginners tutorial
The Excel interface
When you open Excel 2016, the Excel Start Screen will show.From that screen, you can create a new workbook, select a template or access your edited workbooks.
1.Locate and select a Blank workbook to access the Excel interface from the Excel Start Screen.
2.Click the buttons of Excel to become familiar with its interface.
Working With Excel Environment
Instead of traditional menus Excel 2016 uses a tabbed Ribbon system.The Ribbon has multiple tabs.Every tab has few groups of commands.These tags are used to perform the tasks in Excel.
1.Each tab has more than one categories.
2.Some groups will have more options you will see the arrow in the corner.
3.Hit a tab to view more commands.
4.You can adjust the Ribbon on the Ribbon Display Options.
The Quick Access Toolbar
It is found above the Ribbon.It lets you access common commands.Save, Undo and Repeat controls are by default.You can add other commands as well.
To add commands to the Quick Access Toolbar
1.Hit the drop-down arrow to the right of the Quick Access toolbar.
2.From the drop-down menu select the command that you want to add.
3.The command will get added to the toolbar.
How to use Tell me:
The Tell me box works like a search bar. It helps you find tools or commands you want to use.
1.Write in your own words what you want to do.
Excel has three types of worksheet views. Normal view, Page Layout view, orPage Break view.
1.Normal view is the default view for Worksheets in Excel.
Page Layout view displays how your worksheets will look when printed. You can also add headers and footers in this view.
Page Break View allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.
The backstage view provides you many options for saving, printing, opening and sharing your workbooks.
How To access Backstage view:
1.Hit the file tab to see the backstage view.
How To create a new blank workbook:
1.Hit the File tab.You will see the Backstage view.
2.Hit new then choose blank WorkBook.
3.A new Blank WorkBook will open.
How To open an existing workbook:
1.Go to backstage view then click on the open tab.
2.Select Computer, then click Browse. Alternatively, you can choose OneDriveto open files stored on your OneDrive.
3.The Open dialog box will appear. Locate and select your workbook, then click Open.
4.The selected workbook will open.
A template is a predesigned spreadsheet.You can use templates to create a new workbook quickly.Templates can save you a time and effort when starting a new project.
How to create a new workbook from a template:
1.Hit the file tab to go to Backstage view.
2.Hit new.Many templates will show under the Blank workbook option.
3.Choose a template to review it.
4.Click on create to use the selected template.
5.The selected template will be created.
How To save a workbook
1.Select the save command on the quick access toolbar.
2.If keeping the file for the first time, the Save As pane will show in the backstage view.
3.Choose where to save the file.To save select file computer then hit Browse.You can also click on Onedrive to save the file to your OneDrive.
4.The save as dialog box will show.
5.Write a file name then click on Save.
6.The workbook will be saved.
The worksheet is made up of thousands of rectangles.These are called cells.A cell is a meeting point of column and row.Columns are notified by letters while numbers notify rows.
How To select a cell
To input content in the cell or edit content in the cell.The first step is to choose the cell.
1.Click a cell to select it.
2.You will see a border around the selected cell.The cell will remain chosen till you hit another cell in the worksheet.
How To insert content
1.Hit a cell to select it.
2.Write something into the selected cell, then press Enter on your keyboard. The content will appear in the cell and the formula bar. You can also input and edit cell content in the formula bar.
How To delete cell content
1.Select the cell with its content that you want to remove.
2.Choose the clear command which is on the Home tab.Then click on clear.A drop-down menu will show. Click on clear content.
3.Cell content will be deleted.
How To copy and paste cell content
1.Select the cell you want to copy.
2.On Home tab click on copy command.
3.Choose the cell where you want to paste the copied cell.The copied cell will have a dotted line around it.
3.Click the paste command in the home tab.
4.The content will be pasted.
How To modify column width
1.Bring the mouse cursor over the column line which is in the column heading.You will see cursor becomes double.
2.Click and drag the mouse to increase or decrease the row and column width.
3.Release the mouse.The column width will be changed.
How To modify row height
1.Put the cursor on the row line.The cursor becomes a double.
2.Click and drag the mouse.To increase and decrease row height.
3.Release the mouse. The height of the row will be changed.
How to insert rows
1.Select the row heading.
2.On the home, tab click on insert command.
3.The new row will appear.
To download Excel 2016 click here.Excel 2016 beginners tutorial part2 link is given below.Excel 2016 beginners tutorial
See Also: Word 2016 tutorial for beginners.