Getting Started with Excel

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.


Understanding User Interface

The Ribbon

PowerPoint uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. For example, the Font group on the Home tab contains commands for formatting text in your document.

Some groups also have a small arrow in the bottom-right corner that you can click for even more options.

Showing and hiding the Ribbon

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.

  • 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 PowerPoint for the first time.

Using the Tell me feature

If you’re having trouble finding command you want, the Tell Me feature can help. It works just like a regular search bar: Type what you’re looking for, and a list of options will appear. You can then use the command directly from the menu without having to find it on the Ribbon.

 


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, Redo, and Start From Beginning commands. You can add other commands depending on your preference.

To add commands to the Quick Access Toolbar:

Click the drop-down arrow to the right of the Quick Access Toolbar.

Select the command you want to add from the drop-down menu. To choose from more commands, select More Commands.

The command will be added to the Quick Access Toolbar.

The Ruler, guides, and gridlines

PowerPoint includes several tools to help organize and arrange content on your slides, including the Ruler, guides, and gridlines. These tools make it easier to align objects on your slides. Simply click the check boxes in the Show group on the View tab to show and hide these tools.

Developer Tab

Turn on the Developer tab in Excel if you want to create a macro, export and import XML files or insert controls. To turn on the Developter tab, execute the following steps.

1. Right click anywhere on the ribbon, and then click Customize the Ribbon.

2. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).

3. Check the Developer check box.

4. Click OK.

You can find the Developer tab next to the View tab.

Leave a Reply

Your email address will not be published.