Basic Excel Skill:
Excel is a massive application with 1000s of features and 100s of ribbon (menu) commands. It is very easy to get lost once you open Excel. So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for.
When you open Excel, there are 5 important areas:-
- Quick Access tool: This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, and Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).
- Ribbon:Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.
- Formula Bar:This is where any calculations or formulas you write will appear. You will understand the relevance of it once you start building formulas.
- Spreadsheet Sheet: This is where all your numbers, data, charts & drawings will go. Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active spreadsheet. To see more rows or columns you can use the scroll bars to the left or at bottom. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).
- Status bar: This tells us what is going on with Excel at any time. You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can change this by right clicking on it and choosing which summaries to show.
ENTERING & FORMATTING DATA, NUMBERS & TABLES
Handling Data would be one of the main reasons why you are using Excel. Excel is quite intuitive and simple to use when it comes to typing data or handling it. Because of its grid nature, it can store & manage thousands of data points with ease.Built in features like copy, paste, find, highlight, go to, styles etc. make the process of maintaining data very easy for you.
Formatting Data in Excel – Basics
- Using fonts
- Using colors
- Applying Cell Borders
- Aligning Text, wrapping text
- ALT+Enter to get a line break in a cell
- Using shapes, clip art in workbooks
- Applying cell formats – $, 0,00, Dates, Times etc.
- Clearing formats
CALCULATING TOTALS & SUMMARIES
USING FORMULAS
Formulas
make Excel smart. Without formulas, Excel is
just like a massive grid where you can keep
data. Using them you can calculate totals,
summaries, answer questions and gain
insights. Built in features
like Autosum make it very easy to write
formulas for your needs without thinking or
learning much.
Conditional formatting:
formatting is a powerful feature in Excel that is often underutilized. By using conditional formatting, you can tell Excel to highlight portions of your data that meet any given condition. For example: highlighting top 10 customers, below average performing employees etc. While anyone can set up simple conditional formatting rules, an advanced Excel user can do a lot more. They can combine formulas with conditional formatting to highlight data that meets almost any condition.
CREATING REPORTS QUICKLY
The number 1 reason why Excel is used in business is this – to create a report or chart. And this is also where a lot of beginners struggle. While entering data, calculting totals or formatting tables is easy, making a report is often a very complex task that requires days of learning & hours of work. Fortunately, it is not all tha complicated if you learn it right.
USING EXCEL PRODUCTIVELY
It is not enough to know various features of Excel. As a beginner, it helps to know how to use Excel productively. This includes knowing important keyboard shortcuts, mouse shortcuts, work-arounds, Excel customizations & how to make everything looks slick.
BEYOND BASICS – BECOMING AWESOME IN EXCEL
Once you know the basics, chances are you will be asking for more. The reason is simple. Anyone with good Excel skills is always in demand. Your bosses love you because you can get things done easily. Your customers love you becuase you create impressive things. Your colleagues envy you becuase your workbooks are shining and easy to use. And you want more, because you have seen the amazing results of Excel.
Office 365 Basics
Training
Accessing OWA
Apps (Outlook Web App)
Access to most
applications discussed in this manual can be
found under the grid icon, located in the
upper left-hand corner of your OWA mail
page. After clicking on the grid icon, a
dropdown menu will appear with different
applications to choose from.
Mail (Outlook Web
App)
To access your
account, you will need to login to outlook
Adding Folders
1.
Hover your mouse over your name.
2.
Click on the + icon that appears.
3.
Type the name of the new folder you would
like to create into the Textbox that
appears.
4. Press Enter.
Removing Folders
1.
Right Click the Folder you would like to
remove.
2. Click Delete.
3. Click
Okay.
TIPS & TRICKS
A
folder that is stored under Favorites cannot
be deleted until removed from Favorites
Adding Folders to
“Favorites”
1. Hover your
mouse over the folder you wish to add to
your Favorites until you see the star
icon.
2. Click the star icon to add the
folder into your Favorites.
Removing Folders from
“Favorites”
1. Hover your
mouse over the folder you would like to
remove from Favorites.
2. Click the
star icon to remove it from your
Favorites.
3. Click OK
Adding Subfolders
1.
Right Click the folder you wish to add a
subfolder to.
2. Click Create new
subfolder.
3. Type the name of your new
subfolder into the text box that
appears.
4. Press Enter.
Removing Subfolders
1.
Right Click the subfolder you wish to
delete.
2. Click Delete.
Automatic
Forwarding
1.Click on the
gear icon in the upper right hand corner of
your email.
2. Click Mail under Your
app settings at the bottom of the
menu.
3. Click Forwarding under the
Accounts section.
4. Click the circle
next to Start forwarding.
5. Type in
the email you would like your Wright State
email to forward to.
6.Click the box
next to Keep a copy of forwarded messages if
you would like a copy of the forwarded email
to save in your Wright State email.
7.
Click the circle next to Stop forwarding to
stop the automatic forwarding.
Filters
1. Click on the
gear icon in the upper right hand corner of
your email.
2. Click Mail under Your
app settings at the bottom of the
menu.
3. Click Inbox and sweep rules
under the Automatic processing
section.
4. Click the + icon.
5.
Name the filter.
6. Add your
conditions/actions.
7. Click OK to
save.
Automatic Replies
1.
Click the gear icon in the upper right hand
corner of your email.
2. Click
Automatic replies.
3. Click the circle
next to the Send automatic replies.
a.
OWA allows you to assign specific times and
actions to your automatic reply.
4.
Type the message that you would like to
appear in your automatic reply.
a. OWA
allows you to adjust how senders outside of
your organization see your automatic
reply.
5. Click OK to save.
Adding an Email
Signature
1.Click on the
gear icon in the upper right hand corner of
your email.
2. Click Mail under Your
app settings at the bottom of the
menu.
3. Click Email signature under
the Layout section.
4.Check the box
next to “Automatically include my
signature on new messages I compose, if you
would like the signature to appear on new
messages. Check the box next to
Automatically include my signature on
messages I forward or reply to in order to
have the signature appear on emails you
reply or forward to.
5. Type the
signature that you would like to appear in
your emails. 6. Click Save to apply your
changes
TIPS & TRICKS
Your
email signature will save as text.
Therefore, if there is ever an email you
wish to send without your signature, you can
simply delete the text, without altering
your settings.
Power point presentation
When you open power point, you’ll see some built-in themes and templates. A theme is a slide design that contains matching colors, fonts, and special effects like shadows, reflections, and more.
Choose a theme
1. On
the File tab of the ribbon, select New, and
then choose a theme.
2. Click Create,
or pick a color variation and then
click Create.
To make a custom theme, start with a built-in Office theme and modify it by changing any of the colors, fonts, or effects:
1. Change the theme’s color, font, and
effect settings.
2. Save the settings
as a new theme in your theme gallery.
Insert a new slideOn the Home tab, click the bottom half of new slide, and pick a slide layout.
When creating your presentation, you’ll
typically add new slides, move your slides
around, and delete the slides you don’t
need.
Add slides
1. Select the slide you want your new slide
to follow.
2. select home – new
slide
3. Select a layout.
4.
Select the text box and type.
Delete slides
For a single slide:
Right-click the
slide in the thumbnail pane on the left,
then select Delete Slide.
For multiple
slides:
Press and hold
Ctrl, and in the thumbnail pane on the left,
select the slides. Release the Ctrl key.
Then right-click the selection and
choose Delete Slide.
For a sequence of
slides:
Press and hold
Shift, and in the thumbnail pane on the
left, select the first and last slides in
the sequence. Release the Shift key. Then
right-click the selection and choose Delete
Slide.
Duplicate a slide
In the thumbnail pane on the left, right-click the slide thumbnail that you want to duplicate, and then click duplicate slide. The duplicate is inserted immediately after the original.
Rearrange the order of slides
Move a single slide:
In
the pane on the left, click the thumbnail of
the slide that you want to move, then drag
it to the new location.
Move multiple
slides:
Press and hold
Ctrl, and in the pane on the left, click
each slide that you want to move. Release
the Ctrl key, and then drag the selected
slides as a group to the new location.
Save your
presentation
As with any
software program, it is a good idea to name
and save your presentation immediately, and
save your changes frequently while you work.
Note: If you frequently save files to a certain folder, you can ‘pin’ the path so that it is always available.
1. On the file tab, select save.
2. To
save to your local drive, such as your
laptop, flash drive CD or DVD drive select
computer.
3. save as > recent
folders, select browse, pick a path and file
folder, and then name the file.
4.
select save
Tip: save your work as you go. Press Ctrl+S often or save the file to OneDrive and let AutoSave take care of it for you.
Add text
Select a text
placeholder, and begin typing.
Format
your text
1. Select the text.
2. Under drawing
tools, choose Format.
3. Do one of the following:
> To
change the color of your text, Fill, and
then choose a color.
> To change the
outline color of your text, choose text
outline, and then choose a color.
>
To apply a shadow, reflection, glow, bevel,
3-D rotation, a transform, choose Text
Effects, and then choose the effect you
want.
Changes you can also
do:-
Change the
fonts
Change the color of text on the
slide
Add bullets or numbers to
text
Format text as superscript or
subscript
Add pictures
On the
insert tab, select Pictures, then do one of
the following:
- To insert a picture that is saved on your local drive or an internal server, choose This Device, browse for the picture, and then choose Insert.
- (for Microsoft 365 subscribers) To insert a picture from our library, choose Stock Images, browse for a picture, select it and choose Insert.
- To insert a picture from the web, choose Online Pictures, and use the search box to find a picture. Choose a picture, and then click Insert.
Add
shapes
You can
add shapes to illustrate your
slide.
1. On the insert tab, select Shapes, and then
select a shape from the menu that
appears.
2. In the slide area, click
and drag to draw the shape.
3. Select
the Format or Shape Format tab on the
ribbon. Open the shape styles gallery to
quickly add a color and style (including
shading) to the selected shape.
Add speaker
notes
Slides are best when
you don’t cram in too much information. You
can put helpful facts and notes in the
speaker notes, and refer to them as you
present.
1. To open the notes pane, at the bottom of
the window, click Notes
2. Click
inside the notes pane below the slide, and
begin typing your notes.
Give your
presentation
On
the slide show tab, do one of the
following:
> To start the presentation at the first
slide, in the start slide show group, click
From Beginning.
> If you’re not at
the first slide and want to start from where
you are, click from current slide.
>
If you need to present to people who are not
where you are, click present online to set
up a presentation on the web, and then
choose one of the following options:
Get out of slide show
view
To get out of Slide
show view at any time, on the keyboard,
press Esc.