Office Applications: Gns 312 (Digital Skill Acquisition)
Office Applications: Gns 312 (Digital Skill Acquisition)
MODULE 3
OFFICE APPLICATIONS
WRITTEN BY:
1
B. A. Oluwade, 1M. A. Mabayoje, 2A. R. Tomori , 2M.
AbdulRaheem & 1S. A. Salihu
1
Department of Computer Science
Faculty of Communication and Information
Sciences,
University of Ilorin, Ilorin.
2
Computer Service and Information Technology
(COMSIT Unit)
University of Ilorin, Ilorin.
Authors
Dr. M. AbdulRaheem
Prof. B. A. Oluwade
To Cut or Copy:
• Highlight the text by clicking and dragging over the text to be cut or
copied.
• Go to Home Tab > Clipboard box > Copy or
• Home Tab > Clipboard box > Cut.
• Click the location where the information should be placed. Go to
Home Tab > Clipboard box > Paste.
Formatting Text
• Before typing, select your font
style, size, color and attributes (such
as bold, italic and underline)
• In the Home Tab. You can
expand the Font Menu box to get
more options by clicking the down-
arrow
• To change text that has already
been typed, click and drag over
the text to be changed to highlight it
(or go to Edit > Select All to select
the entire document) and change it
as before.
Numbered and Bulleted Lists
• To create a simple numbered or bulleted list, click on the
Numbering or Bullet button on the Paragraph toolbar in the Home
Tab.
• To have more control over the format of your list, click the down
arrows beside each style of list.
• Type the first item in the list and press Return to move to the next
number or bullet.
• Press Return twice to exit the list.
Adding Columns
• Go to Page Layout Tab > Page
Setup box > Columns. From the Columns
menu, you can choose the number of
columns.
• Click More Columns where you
can set column width and spacing.
• Click Ok.
Headers and Footers
• Go to Insert Tab > Header and Footer. Use this toolbar to insert
and format words and objects in the header.
• When editing the header, a new Top View will appear that is
specific to headers and footers.
WordArt
• Go to Insert Tab > Text box >
WordArt button.
• Select the desired style and
click OK.
• Type the desired text and click
Ok.
• To select your WordArt, click
on it, and small boxes will
appear in the corners .
Moving the circle arrow anchor on the top of the WordArt allows the
user to change the slant of the WordArt. WordArt can be resized and
deleted similarly to ClipArt.
Word Wrap
• Select your inserted image,
and go to the Format Tab >
Arrange box.
• Here users can choose the
type of text wrapping style
desired.
• For more options, select More
Layout Options.
Word Wrap
• Select your inserted image,
and go to the Format Tab >
Arrange box.
• Here users can choose the
type of text wrapping style
desired.
• For more options, select More
Layout Options.
Saving as A Pdf
Go to File Tab > Save As Adobe PDF.
or
Go to Mailings Tab > Acrobat box > Merge to Adobe PDF button.
Quitting
Go to File Tab > Exit Word. This is better than just closing the
window, as it ensures your document quits correctly.
SHORCUT KEYS FOR MICROSOFT
OFFICE
CTRL+K Create a hyperlink
CTRL+/ Display HTML tags
CTRL+T Create an Auto Thumbnail of the selected picture
CTRL+SHIFT+B Preview a page in a Web browser
SHIFT+ALT+F11 Display the Microsoft Script Editor
CTRL+N Create a new page
CTRL+B Bold
CTRL+I Italic
CTRL+U Underline
CTRL+C Copy
CTRL+V Paste
CTRL+Z Undo
CTRL+S Save
CTRL+P Print
CTRL+O Open
SPREADSHEET
Spreadsheet is a type of application program which manipulates numerical and
string data in rows and columns of cells. The value in a cell can be calculated
from a formula which can involve other cells. A value is recalculated
automatically whenever a value on which it depends changes. Different cells
may be displayed with different formats. Spreadsheet can also be defined as a
computer software program that is used for storing, organizing and manipulating
data. It is such an interactive computer application for organization, analysis and
storage of data in tabular form. The best known spreadsheets are MS Excel and
Lotus.
CREATING A NEW DOCUMENT
Opening Microsoft Excel on a
PC
1. Begin by opening Microsoft
Excel. On a PC, click Start > All
Programs > Microsoft Office >
Microsoft Excel 2013.
2. A new spreadsheet will pop
up on the screen. If this does not
happen click on the File tab >
New. From here a dialog box with
various different templates will
appear on the screen that you can
choose from. Once a template is
chosen, click Create.
SAVING YOUR DOCUMENT
Saving Initially
1. Click on the File tab > Save
2. Microsoft Excel will open a dialog
box where you will be prompted to
select a save location for your file. If
your desired location is not apparent
in this box, press the Browse icon and
a new window will appear allowing
you to input the name of your
document, where you want it saved,
as well as the format of the document.
3. Once you have specified a name, place, and format for your
new file, press the save button.
NOTE: Specifying your file format will allow you to open your
document on a PC. To do this, you use the drop down menu next to
the Format option. Also, when you are specifying a file extension
(i.e. .doc), make sure you know what you need to use.
Saving Later
4. To save, just click on the floppy disk, or for a shortcut press
CTRL + S.
TOOLBARS
Chart Options
Titles: Within the new chart Design tab, click the Add
Chart Element icon. Here, you will see the option to title
the chart as well as various components of the chart.
Change Chart Type: You can change your chart easily by
selecting this icon and navigating to a more desirable chart.
This feature is very convenient for someone who chose the
wrong chart and does not wish to reselect all their data and go
through the process a second time.
Format Chart Area: This allows for changes to be made to
the charts border, style, fill shadows, and more. To get this
option, you will need to right click on the charts border and
navigate to the Format.
Chart Area option. Once this is clicked, a dialog box will
appear.
INSERTING SMART ART GRAPHICS
Pictures
To insert Pictures: Go to the
Insert Tab> Picture, a dialog
box will appear and then you can
select the desired picture from the
location that is it stored. The
picture will be inserted directly
onto your document, where you
can change its size as desired.
Inserting Clipart: To insert Clip
Art you will need to go to the
Insert Tab > Online Pictures. A
window will appear giving you
the options to either pull clip art
from the
Microsoft Office website or search
for more options using a Bing
image search engine.
Creating Functions
When creating a function in Excel,
you must first have the data that
you wish to perform the function
with selected.
1. Select the cell that you wish for
the calculation to be entered in
(i.e.: if I want to know the sum
of B1:B5, I will highlight cell B6
for my sum to be entered into).
2. Once you have done this you
will need to select the Formulas
Tab located at the top of the screen.
3. A list of Most Recently Used,
Financial, Logical, Text, Date and
Time, Math and Trig formulas will
appear. To choose one of the
formula, click the icon that holds the
formula you are looking for.
4. Once you have clicked your
formula, this will display a dialog
box on your screen. In this screen it
lists the cells that are being
calculated, the values within the
cells, and the end result.
5.To accept that calculation, you can
press OK and the result will show
up in the selected cell.
PRINTING
• To print your document,
go to File Tab > Print, select
your desired settings, and then
click OK. You can also do this
by using the shortcut CTRL +
P
• To be able to change the
orientation of your page for
printing you can click on the
Portrait Orientation button
under the option under Print
then click the change the
layout.
OTHER HELPFUL FUNCTIONS
• Undo and Redo
In order to undo an action, you can click on the blue arrow
icon that is pointing to the left at the top of the screen.
• To redo an action, you can click on the blue arrow icon
pointing to the right. It is important to note that not all actions
are “undoable”, thus, it is important to save before you make
any major changes in your document so you can revert back to
your saved document.
• Quitting
Before you quit, it is a good idea to save your document one
final time. You will need to double click the Excel icon in the
upper lefthand corner. This is better than just closing the
window, as it ensures your document quits correctly.
Microsoft Powerpoint
Microsoft PowerPoint is a slide show presentation
program developed by Microsoft, for use on both
Microsoft and Apple Macintosh operating systems.
Getting Started
• There are three features that you should remember as you work
within PowerPoint 2013: the File menu tab, the Quick Access Toolbar,
and the Ribbon.
File Menu Tab
• Allows you to create a new
presentation, and
• Open an existing presentation,
save and save as, print, send, set
options, and close.
Ribbon
• The panel at the top portion of the document.
• It has seven tabs: Home, Insert, Design, Transitions, Animations,
Slide Show, Review and View.
Commonly utilized
features are displayed
on the Ribbon.
HOME: Clipboard, Slides, Font, Paragraph, Drawing, and
Editing
INSERT: Tables, Illustrations, Links, Text, and Media Clips
DESIGN: Page Setup, Themes, Background
ANIMATIONS: Preview, Animations, Transition to this Slide
SLIDE SHOW: Start Slide Show, Set Up, Monitors
REVIEW: Proofing, Comments, Protect
VIEW: Presentation Views, Show/Hide, Zoom, Window,
Macros.
Quick Access Toolbar
• A customizable toolbar that contains
commands that you may want to use.
• You can place the quick access toolbar
above or below the ribbon.
• To change the location of the quick
access toolbar, click on the arrow at the
end of the toolbar and click Show Below
the Ribbon.
Mini Toolbar
• This is a floating toolbar that
is displayed when you select text
or right-click text.
• It displays common text
formatting tools, such as Bold,
Italics, Fonts, Font Size and Font
Color.
Navigation
• Navigation through the slides
can be accomplished through the
Slide Navigation menu on the
left side of the screen.
• Also, an outline appears from
materials that have been entered
in the presentation. To access
the outline, click the outline tab.
Slide Views
• On the View tab, the Presentation Views group allows you to view the
slides as Normal, Outline View, Slide Sorter, Notes Page, and Reading
View.
• The Master Views group allows you to view the Slide Master,
Handout Master, and Notes Master for the current presentation.
Creating a Presentation
New Presentation
• Click the File menu tab
• Click New
• Click Blank Presentation
To create a new presentation
from a template:
• Click the File menu tab
• Click New
• Click or browse through for
Installed Templates
• Click the template you choose to see
a preview of the template
To add a text box
• Select the slide where you
want to place the text box.
• On the INSERT tab, click
Text Box.
• Click on the slide and drag the
cursor to expand the text box.
• Type in the text.
Select Text
• Highlight the text.
Copy and Paste
• Select the item(s) that you wish
to copy.
• On the Clipboard group of the
HOME Tab, click Cut
• Select the items(s) where you
would like to copy the data.
• On the Clipboard group of the
HOME Tab, click Paste.
Formatting Text
Change Font Typeface
and Size
• Click the arrow next to the
font name and choose a font.
• Preview how the new font
will look by highlighting the
text, and hovering over the
new font typeface.
To change the font size:
• Click the arrow next to the font size
and choose the appropriate size, or
• Click the increase or decrease font
size buttons.
Font Styles and Effects
• Select the text and click the Font
Styles included on the Font group of
the Home tab or
• Select the text and right click to
display the font tools.
Change Text Color
• Select the text and click the
Colors button included on the Font
Group of the Ribbon, or
• Highlight the text and right-click
and choose the Colors tool.
• Select the color by clicking the
down arrow next to the font color
button.
WordArt
• Select the text
• Click the Insert tab
• Click the WordArt button
• Choose the WordArt
To modify the styles of WordArt
• Select the WordArt.
• Click the Format tab for the Drawing Tools
• Click the WordArt Fill button, the
WordArt, Outline button, or the Text Effects
button.
Change Paragraph Alignment
• Click the Home Tab
• Choose the appropriate button for alignment
on the Paragraph Group.
Indent Paragraphs
• Click the Indent buttons to control the
indent, and
• Click an Indent button repeated times to
increase or decrease the amount of indentation.
Text Direction
• Click the Text Direction button
on the Home tab.
• Click the selection.
Graphics
Adding Picture
• Click the Insert Tab.
• Click the Picture Button.
• Browse to the desired picture
within your files.
• Click the name of the picture.
• Click the Insert button.
• To move the graphic, click it
and drag it to where you want it.
Adding Clip Art
• Click the Insert Tab.
• Click the Online Photos Button.
• Search for the clip art using the
search Clip Art dialog box.
• Click the clip art.
• Click the Insert button.
• To move the graphic, click it and
drag it to where you want it.
Adding a Shape
• Click the Insert Tab.
• Click the Shapes Button.
• Click the desired shape.
•
• Clickthe Slide
• Drag the cursor to expand the shape
Adding SmartArt
• Click the Insert Tab.
• Click the SmartArt Button.
• Click the SmartArt you choose
• Drag it to the desired location in the
slide.
To
adjust slide transitions
• Add sound by clicking the
arrow next to Transition
Sound:
Modify the transition speed by
clicking the arrows next to
Duration box:
To apply the transition to all
slides
• Click the Apply to All button
To select how to advance a
slide
• From the Advance Slide options,
• Choose On Mouse Click, or
• Choose After and enter a time to
have a slide automatically transition
after your set time.
Slide Animation
• Select the object.
• Click the ANIMATIONS tab on the Ribbon.
• Click the Animation dialog box.
• Choose the desired effect.
Animation Preview
• Click the Preview button on the
ANIMATIONS tab
Slide Up Slide Show
The options include:
• Whether the show will run
automatically or will be presented
by a speaker;
• The looping options;
• Narration options; and
• Monitor resolutions.