GETTING STARTED WITH EXCEL 2016

Introduction



Excel is a spreadsheet program that allows you to store, organize, and analyse information. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.

Getting to know Excel


If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface.

The Excel interface


When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks.


· From the Excel Start Screen, locate and select Blank workbook to access the Excel interface.

T
The picture below will help you become familiar with the Excel interface.

Working with the Excel environment


The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document.

The Ribbon


Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.


  • Each tab will have one or more groups.


  • Some groups will have an arrow you can click for more options.




· Click a tab to see more commands.



· You can adjust how the Ribbon is displayed with the Ribbon Display Options.



Certain programs, such as Adobe Acrobat Reader, may install additional tabs to the Ribbon. These tabs are called add-ins.

To change the Ribbon Display Options:

The Ribbon is designed to respond to your current task, but you can choose to minimize it if you find that it takes up too much screen space. Click the Ribbon Display Options arrow in the upper-right corner of the Ribbon to display the drop-down menu.


There are three modes in the Ribbon Display Options menu:

· Auto-hide Ribbon: Auto-hide displays your workbook in full-screen mode and completely hides the Ribbon. To show the Ribbon, click the Expand Ribbon command at the top of screen.


· Show Tabs: This option hides all command groups when they're not in use, but tabs will remain visible. To show the Ribbon, simply click a tab.



· Show Tabs and Commands: This option maximizes the Ribbon. All of the tabs and commands will be visible. This option is selected by default when you open Excel for the first time.

The Quick Access Toolbar


Located just above the Ribbon, the Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.

To add commands to the Quick Access Toolbar:

1. Click the drop-down arrow to the right of the Quick Access Toolbar.
2. Select the command you want to add from the drop-down menu. To choose from more commands, select More Commands.
3. The command will be added to the Quick Access Toolbar.


How to use Tell me:

The Tell me box works like a search bar to help you quickly find tools or commands you want to use.



1. Type in your own words what you want to do.


2. The results will give you a few relevant options. To use one, click it like you would a command on the Ribbon.

Worksheet views

Excel 2016 has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view,or Page Break view.

1. Normal view is the default view for all worksheets in Excel.

2.Page Layout view displays how your worksheets will appear when printed. You can also add headers and footers in this view.



3. Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.




Backstage view

Backstage view gives you various options for saving, opening a file, printing, and sharing your workbooks.

To access Backstage view:
1. Click the File tab on the Ribbon. Backstage view will appear.



The Back Stage interface is shown below:



Try This!

1. Open Excel 2016.
2. Click Blank Workbook to open a new spreadsheet.
3. Change the Ribbon Display Options to Show Tabs.
4. Using the Customize Quick Access Toolbar, click to add New, Quick Print, and Spelling.
5. In the Tell me bar, type the word Color. Hover over Fill Color and choose a yellow. This will fill a cell with the color yellow.
6. Change the worksheet view to the Page Layout option.
7. When you're finished, your screen should look like this:
8. Change the Ribbon Display Options back to Show Tabs and Commands.
9. Close Excel and Don't Save changes.



Comments

Post a Comment

Popular posts from this blog

Number Bond App

Image
INTRODUCTION Number bond is a mental picture of the relationship between a number and the parts that combine to make it. The concept of number bonds is very basic, an important foundation for understanding how numbers work. A whole thing is made up of parts. If you know the parts, you can put them together (add) to find the whole. If you know the whole and one of the parts, you take away the part you know (subtract) to find the other part. Number bonds let children see the inverse relationship between addition and subtraction. Subtraction is not a totally different thing from addition; they are mirror images. To subtract means to figure out how much more you would have to add to get the whole thing. Children start to learn about number bonds in the Foundation stage, when they might be given a number, such as 5, and then asked to select two groups of objects that will add up to that number. Number bonds in Year 1 Children are expected to know
Read more

A To Z of Excel Functions | Series 1

Image
  INTRODUCTION Excel is a spreadsheet program that helps calculate and organize data. It has many functions that allow you to do more than just calculations with your data. There are so many different functions in Excel that it is impossible to cover all of them in one article. But we will cover all in 5 different sections. We will show their functionalities, as well as how to use them for a range of purposes from data calculations to data visualizations. What is a Function? How to Find and Insert Functions on a Spreadsheet A function is a set of instructions for the spreadsheet that allows you to perform calculations on data. Functions can be inserted into a spreadsheet by typing them in, or selecting from a list. A function is typically made up of three components: a name, an argument, and an instruction. The name identifies what type of calculation the function will perform. Arguments are values that correspond to the data you want to use within the function. Instructions tell the s
Read more

Download Excel Functions Bank Workbook

Image
  Download the Excel Functions Bank for FREE. Where should we send your workbook? Put In Your Info To Download The Workbook. Name: Email: We respect your email privacy Excel With Excel | Prime Tech Academy  Microsoft Excel Online Course | Start Course Today
Read more

QUIZ WHIZ APP

Image
SimpleSchool QUIZ WHIZ- An editable and interactive quiz platform for both individual and group assessment with 1000+ Questions Bank and Timer. Good for mental drills, reviews, set induction, evaluation of concepts, group quiz competition and more… It can be used on PC and on Interactive White Board. It Contains 3 sections: 1. Instruction Page The Instruction/Home page is what you see when you load the application. It contains information and instruction on how to use the App. 2. Questions Bank This is a database where questions are stored. You can store up to 1000 questions under 10 categories (100 questions per category). You can make each category store questions on different subjects. To Upload or Type Questions in the Questions Bank Double-Click and type in the Category/Subject. Double-Click and type the questions in the questions box one after the other under your chosen
Read more

Excel Formula Expert 2

Image
Excel Formula  Excel Formulas in View If you're new to Excel, you'll soon find that it's more than just a grid in which you enter numbers in columns or rows. Sure, you can use Excel to find totals for a column or row of numbers, but you can also calculate a mortgage payment, solve math or engineering problems, or find a best case scenario based on variable numbers that you plug in. Excel does this by using formulas in cells. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (like a + or - sign for addition or subtraction), and built-in Excel functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11. =2*3+5 Here are some additional examples of formulas that you can enter in a worksheet. =A1+A2+A3
Read more

Number Bond App 2- With 10 Timed Questions

Image
INTRODUCTION This is an updated version of 'My Number Bond App.' This version includes the 10 timed self graded questions with instant result. All the functionalities of the previous version remains. To get details of the other component Go to My Number Bond App 1 My Number Bond App 2 In order to make the teaching and learning of this important fundamental Mathematical concept easy to understand, Prime Academy Resource made this Microsoft Excel App called "My Number Bond." NUMBER BOND 1 VIDEO NUMBER BOND 2 VIDEO GET MY NUMBER BOND APP How Does My Number Bond App Works? When you load the Workbook you have this interface: You are required to update the setting form to suit your needs. The Setting Form Here you set the following: DECIMAL PLACE:  The decimal place tab has 3 options None 1 Decimal Place and 2 Decimal Place You click the drop  down arrow to select your preference. MATH OP
Read more