IntroductionWelcome| 00:00 | (music playing)
| | 00:04 | Hi and welcome to Office 2013 New Features.
I'm David Rivers.
| | 00:08 | The entire Office Suite has gone through a major makeover.
| | 00:11 | In this course we'll see all about what's new
or improved in each of the programs
| | 00:15 | in the latest version of the Microsoft Office Suite.
| | 00:19 | Changes like the new and improved User Interface,
Integration with the cloud and Touch mode.
| | 00:25 | Then we'll move on to the first program
in the suite, Microsoft Word.
| | 00:30 | We'll explore some cool new features
like adding online video to a Word document
| | 00:34 | and not only opening a PDF file,
but editing it in Word as well.
| | 00:39 | In Excel, we'll examine some new and enhanced
features to help you work more efficiently
| | 00:43 | like the Flash Fill feature to speed up
how cells are filled with relevant content.
| | 00:48 | In PowerPoint, we'll explore the new
and improved Presenter View
| | 00:51 | for those times when you need to present one thing
to your audience while you view additional information.
| | 00:56 | There's lots to cover.
| | 00:58 | So, let's get started with Office 2013 New Features.
| | Collapse this transcript |
| Using the exercise files| 00:00 | If you're a Premium Subscriber with lynda.com,
you'll have access to the exercise files,
| | 00:05 | and the exercise files allow you to
follow along with me step-by-step.
| | 00:09 | So, if you do plan on using them,
I highly recommend placing them in a
| | 00:12 | convenient location such as your Desktop
and if you double-click this folder,
| | 00:16 | you'll notice it's made up of sub folders
representing each of the programs in
| | 00:20 | the Office Suite where we'll
actually use an exercise file.
| | 00:23 | Now, if you don't have access to
the exercise files, not to worry.
| | 00:26 | You can still learn lots by using your
own sample files or even by just simply
| | 00:31 | sitting back, relaxing, and watching.
| | Collapse this transcript |
|
|
1. Suite-Wide EnhancementsExploring the new user interface| 00:00 | One of the most obvious changes
to the Office Suite you'll notice
| | 00:04 | the very first time you launch any of the programs
is the user interface.
| | 00:08 | And that's what we're going to talk about right now.
| | 00:10 | As you can see, I'm working in a Windows 8 environment.
| | 00:13 | I'll be using Microsoft Office 2013 ProPlus.
| | 00:16 | And I've already launched PowerPoint,
Publisher, Excel, etcetera.
| | 00:21 | We're going to launch Word here because all of
the user interfaces are consistent across the board.
| | 00:27 | So, when we click Word 2013,
notice it takes us to a desktop environment
| | 00:31 | where it launches and displays down
the left-hand side a color-coded area;
| | 00:36 | for Word, it's blue; PowerPoint, it's orange;
for Excel, it's green.
| | 00:40 | But they all look the same in that,
in the top-left corner, you'll have access
| | 00:43 | to your recently worked on documents,
spreadsheets, presentations, etcetera.
| | 00:49 | If they don't appear on the list,
you'll have a link to open other documents
| | 00:53 | where you can go browsing locally and online
for Word documents that you've worked on previously.
| | 00:59 | And then over to the right, you'll see an area
where you can start creating new documents;
| | 01:03 | the default being a blank document,
a blank spreadsheet, a blank presentation etcetera.
| | 01:08 | You'll also have access to a number
of templates to help you get started
| | 01:11 | creating specific kinds of documents or files.
| | 01:15 | There's also a search field up here at the top
where you can search online for templates.
| | 01:20 | Also, in the very top right-hand corner,
you'll see information about your SkyDrive account.
| | 01:25 | Your Microsoft account gives you some
free space in the cloud with SkyDrive
| | 01:30 | where you can store your files
and then have anywhere access to them.
| | 01:34 | And if you needed to switch accounts,
here's where you do that.
| | 01:37 | Now also, a little bit higher and in the
top right-hand corner some familiar buttons;
| | 01:41 | they just look a little bit cleaner,
they're flat, not three-dimensional.
| | 01:45 | This is to be consistent with the Windows 8 interface.
| | 01:48 | There's the Close button in the top right-hand corner.
| | 01:51 | We also have Minimize and Maximize buttons,
and a Help button up here as well.
| | 01:56 | F1 is still your keyboard shortcut.
| | 01:58 | So, let's say we go to create a new blank document.
| | 02:02 | We'll just give it a click.
| | 02:04 | You're also going to see this new look here
in Microsoft Word, PowerPoint, Excel, and so on,
| | 02:09 | and that is that flat clean look
so you can stay focused on your work.
| | 02:14 | We still have a Ribbon-style interface, a Navigation pane
that opens up by default over here on the left.
| | 02:21 | It can be closed up.
| | 02:22 | And if yours is closed, it can be reopened
with the View Tab in the Show section on the Ribbon.
| | 02:28 | You'll notice tabs across the top
including a File Tab on the Ribbon
| | 02:32 | where all of your file-related commands like
creating new files, opening, saving, printing, and sharing.
| | 02:39 | You'll also see a Back button to take you back, though.
| | 02:42 | And clicking that takes you back to the previous interface
where you'll see tabs across the Ribbon
| | 02:47 | with different related commands.
| | 02:49 | So, for example, if we click the Insert Tab,
these are all the things that can
| | 02:53 | be inserted into a Word document.
| | 02:56 | The Design Tab focuses on
design-specific commands and so on.
| | 03:01 | Let's go back to the Home Tab.
| | 03:03 | Now, if we want to switch to another program,
let's say Microsoft Excel,
| | 03:08 | you can still use Alt+Tab whether you're in
a Windows 7 environment, Windows 8.
| | 03:11 | Using Alt+Tab allows you
to cycle through your open programs.
| | 03:15 | I'm going to go to Excel, and if you need to,
you can launch Excel if you want to follow along.
| | 03:19 | And as you can see, there's that similar interface,
the Welcome Screen
| | 03:23 | with the color-coding down the left-hand side
and the default is to create a blank workbook.
| | 03:28 | When we click there,
we're now creating a new blank workbook.
| | 03:33 | All right. From here, we again have a Ribbon
across the top, a File Tab;
| | 03:37 | everything looks very consistent and familiar
if you've been working
| | 03:41 | in any of the other programs like
Microsoft Word for example.
| | 03:45 | In the very top left-hand corner, you'll also see
some buttons up here; a Save button.
| | 03:49 | We call this the Quick Access toolbar.
| | 03:51 | There is an Undo and Redo button here.
| | 03:54 | Then there's a little dropdown where
you can pick and choose what's going
| | 03:57 | to appear on this Quick Access toolbar;
| | 04:00 | anything with a check mark is already there,
anything unchecked can be added by simply clicking it.
| | 04:05 | Maybe Quick Print for example would be a good one.
| | 04:07 | There's our Quick Print icon, now.
| | 04:09 | We remove icons the same way we add them,
and that's just by clicking them.
| | 04:14 | So here in our user interface, in the
top right-hand corner, those familiar buttons
| | 04:18 | for closing, maximizing, minimizing,
there's our information about our
| | 04:24 | SkyDrive account where we can change accounts.
| | 04:27 | Let's flip back to Microsoft Word now using Alt+Tab;
| | 04:31 | all of that information up here as well.
| | 04:33 | It's just a different color-coding of course.
| | 04:35 | The program is totally different in what it is
you're going to be creating with that program.
| | 04:41 | So, that's a quick look at the user interfaces
for the new Office 2013 Suite of programs;
| | 04:47 | consistent, clean, flat.
| | 04:50 | You should be able to stay focused
on what you're working on
| | 04:53 | and not being distracted by what's around you
on your screen.
| | Collapse this transcript |
| Integrating with the cloud| 00:00 | One of the biggest changes to any of the programs
you might launch from Office 2013
| | 00:05 | is this push towards cloud computing.
| | 00:08 | We're going to explore it now,
starting with Microsoft Word.
| | 00:11 | As you can see, I've opened up a document
called No Obstacles Home Recipes.
| | 00:15 | If you have the exercise files, you can
open it up to follow along with me,
| | 00:19 | but really any document will do at this point.
| | 00:22 | Next, we're going to go up to the File Tab,
and I want to show you a couple of defaults.
| | 00:26 | First, we'll go down to Open and click there.
| | 00:29 | On the right-hand side under Open,
you'll always have quick access
| | 00:32 | to Recent Documents that you've worked on.
| | 00:34 | After that, the next default is SkyDrive;
| | 00:37 | and you'll see the cloud icon next
to it because this is cloud computing.
| | 00:41 | SkyDrive is storage space in the cloud
with your Windows live account, which is free,
| | 00:46 | seven gigabytes of free storage space.
| | 00:50 | You can always purchase more if you need it.
| | 00:52 | So, by going to David Rivers' SkyDrive,
it knows my name because
| | 00:56 | I'm logged in as David Rivers.
| | 00:58 | I have access to my Recent Folders in SkyDrive.
| | 01:02 | Click, Browse, and you'll be able to see the default folders.
| | 01:05 | You get a Documents folder, a Pictures folder,
and one for sharing called, Public.
| | 01:10 | Now, of course, you can create as many folders
as you like,
| | 01:13 | creating your own folder structure all in the cloud.
| | 01:16 | Let's click, Cancel, and go back to
the left-hand side and click, Save As.
| | 01:22 | Look what the default is at the
top here for saving your documents.
| | 01:26 | Again, it's SkyDrive.
| | 01:28 | By selecting it, you can go to Recent Folders
and browse just like we did for opening files.
| | 01:33 | All right, let's go back for a second here.
| | 01:37 | We'll make a quick change to this.
| | 01:39 | Let's just scroll down in our document and all
we're going to do is take out the word Valued.
| | 01:45 | We'll hit, Delete and now we'll go back to File.
| | 01:50 | We'll click Save As;
| | 01:52 | make sure your SkyDrive is selected.
| | 01:54 | Now, if you haven't already logged in or set up
your account you might be prompted to do so right now.
| | 01:59 | Once, it's all set up, you'll have it as an option
just as I do, and now,
| | 02:04 | we can choose a folder such as Documents.
| | 02:06 | When you select it, you're going to notice
the same name and the location.
| | 02:11 | Let's click, Save and you've now just saved
your document to the cloud.
| | 02:15 | So, what's the big advantage?
| | 02:17 | The big advantage is you now have access to it
from any device that's connected
| | 02:21 | to the Internet, anywhere at anytime.
| | 02:25 | So, it could be another computer in
another location connected to the Internet.
| | 02:29 | It could be your Smartphone;
| | 02:30 | it could be your tablet.
| | 02:31 | As long as you're connected,
you'll have anytime, any access to your documents.
| | 02:36 | All right, so that's Microsoft Word,
and if we switch to any of the other programs,
| | 02:39 | let's go over to Microsoft Excel for example,
where you may want to
| | 02:44 | begin or start a brand new notebook.
| | 02:47 | This is a new Blank spreadsheet.
| | 02:49 | You can see Book1 at the top.
| | 02:51 | If I go up to the File Tab, under, Open,
you can see the same layout.
| | 02:56 | There's my SkyDrive.
| | 02:57 | If I go to, Save As, look what's at the top, the default.
| | 03:01 | Again, it's my SkyDrive.
| | 03:02 | We'll click the Back button.
| | 03:04 | Let's try one more.
| | 03:06 | Let's go to PowerPoint, where again,
we can start a brand New presentation.
| | 03:10 | Go up to the File Tab, you're going to see a
very consistent and familiar layout under Open.
| | 03:16 | There's your Recent Presentations;
| | 03:17 | but then again, SkyDrive is next. Go to, Save As.
| | 03:21 | There it is at the top, the default,
your SkyDrive or the cloud.
| | 03:25 | We'll, hit the Back button to go back and leave it at that.
| | 03:29 | So, this is a push by Microsoft.
| | 03:31 | You're going to get used to this cloud computing push,
because it is a great advantage
| | 03:36 | if you're connected, to have anytime,
anywhere access to your files when you need them.
| | Collapse this transcript |
| Exploring Touch mode| 00:00 | When Microsoft redesigned the Office Suite here,
Microsoft Office 2013,
| | 00:05 | they had to take into consideration
that many users might be using these apps
| | 00:10 | on their Touch devices, like Smartphones
or Tablets, including the new Microsoft Surface
| | 00:15 | or even A Touch Screen connected to their computer.
| | 00:18 | That's why they came up with something called
Touch mode and we're going to look at this now.
| | 00:22 | In Touch mode, Microsoft wanted
to make sure that users weren't
| | 00:25 | accidentally tapping the wrong feature or function
and when it came to swiping and other gestures;
| | 00:31 | that it was going to be clean and error-free.
| | 00:34 | So, let's take a look.
| | 00:35 | The first thing we need to do is open up
any one of the programs.
| | 00:38 | I'm in PowerPoint and I've started
a new Blank presentation but you could be
| | 00:42 | in Word, you could be in Excel,
Publisher, it really doesn't matter.
| | 00:45 | You're going to go up to this area
in the top left corner called the Quick Access toolbar.
| | 00:50 | Now, you won't see a button for switching
to Touch mode or the default Mouse mode,
| | 00:54 | but if you click the dropdown,
you'll see that that option is on the list.
| | 01:00 | It's not checked off by default, but when
you click it, you're actually going to
| | 01:04 | display it now on the Quick Access toolbar.
| | 01:07 | So, you actually haven't switched modes at this point,
all you've done is displayed it
| | 01:10 | on the Quick Acces toolbar.
| | 01:12 | Clicking it displays the two options.
| | 01:14 | The one that is highlighted is the default.
| | 01:17 | This is Mouse mode.
| | 01:19 | You get a standard Ribbon and commands and
it is optimized for clicking with your mouse.
| | 01:24 | Touch mode, however, is going to create
a little more space between commands.
| | 01:27 | It's optimized for using touch.
| | 01:30 | So, let's give it a click and see what happens.
| | 01:33 | Well, sure enough, things are really spread out.
| | 01:35 | It is subtle so we're not actually
losing things on our screen.
| | 01:39 | We can still see our slide and our content,
but notice at the Quick Access
| | 01:43 | toolbar the buttons are well-spaced.
| | 01:45 | So are the tabs on the Ribbon.
| | 01:48 | Each of the options that appear on
the various ribbons are spread out.
| | 01:52 | So, you're not going to be accidentally tapping
the wrong option.
| | 01:55 | Now, if you're going to be on a Touch Screen,
a Tablet, or even your Smartphone, this is ideal.
| | 02:01 | If you're not, you can switch back to Mouse mode
by clicking the same button
| | 02:04 | that now appears on your Quick Access toolbar
and selecting Mouse.
| | 02:09 | This actually gives you a little more real estate
for working on your content.
| | 02:13 | Everything is kind of crammed back in.
| | 02:14 | You can see the buttons are very tight up here
on the Quick Access toolbar;
| | 02:19 | it's the same thing for the ribbon tabs and their commands.
| | 02:22 | So, that's a Touch mode, ideal for working
with Touch devices like your Smartphones and Tablets;
| | 02:28 | and even Touch Screens connected to your computer.
| | 02:31 | If it's something that you're not interested in,
you're not going to be using it;
| | 02:34 | you really don't need it up here
on your Quick Access toolbar, you can go
| | 02:37 | back to that dropdown.
| | 02:39 | Notice Touch/Mouse mode actually appears
with a check mark, now.
| | 02:42 | Clicking it again removes it from the Quick Access toolbar.
| | 02:45 | It doesn't switch modes, keep that in mind,
but it's now not accessible from the
| | 02:49 | Quick Access toolbar and you need to go there to get it back.
| | Collapse this transcript |
| Using the bookmark feature| 00:00 | I'm a big fan of this next new feature
that appears both in Microsoft PowerPoint
| | 00:05 | and Microsoft Word 2013, and to some extent
you'll see it in Excel as well.
| | 00:10 | It's a bookmarking feature that remembers
where you were in a long document or
| | 00:15 | presentation that will give you the option
to go back to that spot when you
| | 00:19 | resume work on that document or presentation.
| | 00:22 | Let's show you what I'm talking about
here in Microsoft Word.
| | 00:25 | We'll use this file from your exercise files
called No Obstacles Home Recipes
| | 00:30 | and let's just go over to the right.
| | 00:31 | On the scroll bar, we'll scroll
all the way down to say, Page 6.
| | 00:34 | And here on Page 6, we see a
recipe for Butternut Squash Soup.
| | 00:40 | We'll just click anywhere on the page
for example, we don't even have to make a
| | 00:44 | change to the content or even save it;
| | 00:46 | all we have to do is be on the page.
| | 00:49 | And if something else happens like
it's the end of the day and we want to
| | 00:53 | close this up or maybe we need to go
to another project and we go
| | 00:57 | to the File tab and we close this up.
| | 00:59 | And we go to that other project or
we come back a couple days later.
| | 01:03 | Go back to the File tab here in Word
and when we go to Recent Documents
| | 01:08 | to open up the same document, look what
happens over here on the right.
| | 01:11 | A little message pops up, Welcome Back!
| | 01:14 | Pick up where you left off.
| | 01:15 | It will after a few second disappear but
the Bookmark icon remains over here,
| | 01:20 | so you can hover over it to see the
message and the option is to go right back
| | 01:24 | to that spot where you left off.
| | 01:26 | And now, in my case it says a few seconds ago.
| | 01:28 | But if you left the document for a week, it
would say a week ago, a month ago, etcetera.
| | 01:33 | Let's just click the message and it will
take us right back to the page where we
| | 01:37 | were working when we closed up Microsoft Word.
| | 01:39 | The same thing happens in PowerPoint.
| | 01:41 | It'll take you right to the slide you were
working on last when you closed up PowerPoint.
| | 01:45 | In Microsoft Excel you won't see
that bookmarking message in the icon.
| | 01:49 | Instead, if you were on a certain cell
in a spreadsheet when you closed up Excel,
| | 01:53 | you'll be taken directly back to
that cell in the spreadsheet by default.
| | 01:58 | No option to start at the beginning or where you left off.
| | 02:01 | It just takes you there automatically.
| | 02:02 | So, if you want to experiment with this,
you could go to PowerPoint, for example,
| | 02:06 | and open up a presentation.
| | 02:08 | Close it up while you're looking at one of the slides
in the presentation and reopen it,
| | 02:12 | you'll see the same bookmarking feature,
a nice little timesaver here in Office 2013.
| | Collapse this transcript |
| Customizing the Ribbon with display options| 00:00 | Here's a neat new feature that appears
in every one of the programs in Office 2013,
| | 00:04 | allowing you to customize how your ribbon is displayed.
| | 00:08 | The ribbon does take up quite a bit of
real estate across the top of your screen
| | 00:12 | and by default you're going to see
all of the tabs and their contents.
| | 00:15 | But there are a couple of other views
or displays that can be adjusted
| | 00:19 | individually for each program in the Suite.
| | 00:21 | So, let's take a look at it here in PowerPoint.
| | 00:23 | Now, it really doesn't matter what file you're looking at.
| | 00:26 | I've got No Obstacles PowerPoint open here.
| | 00:28 | And in the top right-hand corner,
you're accustomed to just seeing your
| | 00:31 | Minimize and Maximize and Close buttons,
but just left of the Minimize button is a new button.
| | 00:36 | This is the Ribbon Display Options button
and clicking this will give you your three options.
| | 00:42 | Let's give it a click.
| | 00:43 | At the top, you'll see Auto-Hide,
which is going to Hide the Ribbon in its entirety.
| | 00:48 | Now, you can move across the top of
your application window to get it back,
| | 00:53 | but by default you won't see any of the
ribbon, giving you more space to work on
| | 00:57 | your documents and files and presentations.
| | 01:00 | Another option is to only hide a portion
of the ribbon and that is to Show Tabs.
| | 01:05 | All you're going to see are the ribbon tabs
across the top until you go to one of those tabs and click.
| | 01:10 | So, it does give you more space to work on,
but it does also give you the
| | 01:14 | ability to view the tabs for each of the
ribbons and select them with a click.
| | 01:20 | Lastly is the Default View, which is what
we see right now, showing tabs and commands.
| | 01:24 | And of course, this does take up
the most real estate on your screen.
| | 01:28 | So, let's try Auto-Hide Ribbon.
| | 01:30 | We'll give it a click.
| | 01:31 | You can see what happens, not only does the ribbon
disappear and we don't see the Quick Access toolbar.
| | 01:37 | It's as if we maximize the application window.
| | 01:40 | Now, as we move up to the top,
you can see there's a bar here that kind of
| | 01:44 | highlights and when we click,
there's our ribbon. We get it back.
| | 01:47 | Go down into your presentation
and click anywhere and it disappears.
| | 01:51 | So, it's automatically hidden.
| | 01:53 | Let's go back up to the top and click
and we'll go back to our Display Options button.
| | 01:58 | Give that a click and choose the second option,
which is Show Tabs.
| | 02:03 | Now, in this case you can see we still have
our Quick Access toolbar across the top.
| | 02:07 | We still see our Title bar and then all we see
are the tabs for each of the ribbons here in PowerPoint.
| | 02:12 | So, if we wanted to go to inserting
something into our presentation,
| | 02:16 | we can click the Insert tab,
which will display that ribbon.
| | 02:19 | When go back to our presentation and
click there, it's automatically hidden.
| | 02:23 | However, the tabs remain.
| | 02:25 | I kind of like this view.
| | 02:26 | It gives me a lot more real estate
for working on my presentation,
| | 02:30 | but it still gives me quick access to the ribbon.
| | 02:32 | All right, next, we'll go back to our default
by clicking that same Display
| | 02:35 | Options button and select
Show Tabs and Commands.
| | 02:38 | This is the one you're going to see by default,
so we'll leave it open as we continue
| | 02:43 | to work in the various programs here in Office 2013.
| | 02:46 | This is not a global change, by the way,
so when you make a change here in PowerPoint,
| | 02:50 | you're not affecting Word, Excel, Publisher and so on.
| | 02:53 | The changes are individual.
| | 02:55 | In other words, they only affect
the program you're working in.
| | Collapse this transcript |
|
|
2. WordInserting online video| 00:00 | Considering the shift towards cloud computing
that we're seeing here
| | 00:04 | with the Microsoft Office Suite 2013,
this new feature in Word makes perfect sense
| | 00:09 | and that is inserting video that exists online,
directly into your document and even accessing
| | 00:15 | that video to watch it without leaving Microsoft Word.
| | 00:19 | That's exactly what we're going to do
with this document called No Obstacles Media Campaign.
| | 00:24 | With that open, you'll notice on the first page
a couple of the images;
| | 00:27 | one including a ride by, by this bicyclist.
| | 00:30 | We'll click that image and hit Delete
on the keyboard to remove it.
| | 00:34 | We'll replace it with an online video,
an online video that exists in YouTube,
| | 00:39 | one of the options for inserting online video.
| | 00:42 | To insert it, we go to the Insert tab
and make sure that's selected and on the ribbon,
| | 00:47 | we'll move around the middle to the Online Video button,
| | 00:51 | give it a click, and a dialog box opens up
with a few different options.
| | 00:54 | Now, if you wanted to just search for video,
you could do so using Bing,
| | 00:58 | add your keywords in the Search field and hit Enter.
| | 01:01 | Or you could go directly to searching
YouTube for the video if you know it's there.
| | 01:06 | And you might even have an Embed Code
that you can paste, paste it right in there
| | 01:10 | and wherever it exists online, you'll be able
to view it in your Word Document when it's inserted.
| | 01:17 | Let's go to YouTube because I do have one
sitting in YouTube for you to work with.
| | 01:21 | We'll add some keywords here.
| | 01:22 | Let's type in rideby, all one word,
leave a space, we'll add another keyword,
| | 01:28 | how about b-roll, leave a space,
and we'll add lynda.com here as well.
| | 01:35 | Hit Enter on your keyboard, search happens;
| | 01:38 | notice that there is one result here
from YouTube and as we hover over it,
| | 01:43 | we see it's our b-roll rideby. Perfect.
| | 01:45 | We'll click it to select it.
| | 01:47 | Once selected, we can now go to the
insert button and give that a click and it's
| | 01:51 | inserted into our document, not in
the perfect place, maybe not the perfect size,
| | 01:55 | but we can adjust all of that now.
| | 01:58 | Notice that it is selected.
| | 01:59 | We see handles all the way around the outside,
which means we can do things like resize it.
| | 02:04 | Let's go to the bottom right corner.
| | 02:06 | When you see the double diagonal arrow,
click and drag to adjust the size.
| | 02:10 | Now, as soon as you get to a certain point,
it might look like it's disappearing,
| | 02:14 | but just move up and you can see it's actually fitting
into that empty space now.
| | 02:19 | I'm going to size this one down a little bit more,
just a bit.
| | 02:22 | And the other thing that's happening is,
it's being positioned for us and that's based on,
| | 02:28 | as we move over to our Layout icon here
to see the Layout Options,
| | 02:32 | give that a click, you can see it's actually In Line with Text
| | 02:36 | and that is a default, meaning, it's being treated
like any other character you might type in your document.
| | 02:41 | So as you add text, it's going to move around.
| | 02:44 | As you add paragraphs, it's going to be pushed down.
| | 02:47 | We can change that.
| | 02:48 | Let's change it so that the text is going
to wrap around it at the top and bottom.
| | 02:53 | That's this option down here,
Top and Bottom, give it a click.
| | 02:56 | And now text will never appear
on either side of our video.
| | 03:00 | It's actually just going to appear above or below.
| | 03:03 | Now, let's move it.
| | 03:04 | We'll go right into the middle here,
click and drag with the four sided arrow
| | 03:08 | and we'll try to align it around the center.
| | 03:10 | Notice when you get to the center,
there is this Alignment Guide that shows up
| | 03:14 | and we'll be talking more about these a little bit later on.
| | 03:17 | We'll let go, and now it's positioned perfectly.
| | 03:19 | Now of course the other neat thing is we
don't have to go to YouTube to view this video.
| | 03:24 | We can view it directly in our document.
| | 03:26 | There is a play button right here.
| | 03:28 | When we give it a click, look what happens,
a window opens up
| | 03:32 | and we'll be watching our video momentarily.
| | 03:34 | Click Play, click Pause.
| | 03:41 | You could continue to watch the entire video
directly from YouTube and when
| | 03:45 | you're done all you need to do is just
click anywhere outside that video and
| | 03:49 | you're back to your document with a reference to
that YouTube video sitting right there on the page.
| | 03:55 | That's a brand new feature here in Word 2013,
one that's going to save you some time,
| | 03:59 | a convenient way to insert video that already exists online.
| | Collapse this transcript |
| Editing PDF documents| 00:00 | Odds are you're already familiar with PDF files,
stands for Portable Document Format.
| | 00:05 | Typically, you'll need some type of Reader
like Adobe Reader to look at these Read-only files.
| | 00:11 | But did you know in Office 2013 you can
use Microsoft Word to save to that format
| | 00:16 | and even open up PDF files, even make
changes to those files and save them.
| | 00:22 | We're going to take a look at it now.
| | 00:24 | In my opinion, it's not perfect yet,
but you can be the judge.
| | 00:29 | We're going to start by looking at the file
we're going to work with in a Reader.
| | 00:33 | I'm in Windows 8, so I'm going to use the Reader here.
| | 00:36 | If you're in Windows 7 you can use
Adobe Reader, a free download.
| | 00:39 | For me, I need to find the app by going
to the Charms here, clicking search and
| | 00:44 | I'm going to type in Reader. There it is.
| | 00:47 | I'm going to give it a click.
| | 00:48 | Next, I'm going to open up the file in Reader
and you can see what it looks like.
| | 00:53 | It's called No Obstacles Bio and as I scroll
through this document, notice the formatting,
| | 00:58 | left aligned paragraphs.
| | 01:01 | You can see there is a header and a footer.
| | 01:04 | We have some graphics in there.
We have a bulleted list. Okay.
| | 01:08 | I'm going to back to Microsoft Word now.
| | 01:11 | Go to the File tab, under Open,
we're going to go to our exercise files
| | 01:18 | where you're going to find No Obstacles Bio.
| | 01:20 | You can follow along with me.
| | 01:22 | There's my Word folder, there it is, No Obstacles Bio.
| | 01:25 | Notice the icon looks different. It is a PDF file.
| | 01:28 | When we hover over it, we get that information.
| | 01:31 | So, by clicking it and then clicking open,
we're actually going to be opening up a PDF file.
| | 01:36 | What's really going to happen is you'll see
a message here that Word is about to
| | 01:40 | convert the PDF file to a Word document, which we can edit.
| | 01:44 | It could take a while depending on
the size of your document,
| | 01:47 | if you have graphics, etcetera.
| | 01:48 | And the other thing that might happen
is it might not look exactly like the original PDF,
| | 01:53 | especially if there are a lot of graphics in there.
| | 01:56 | If you don't like seeing this message every time,
you can deselect it
| | 02:00 | by clicking the check box, so it won't show again,
and then click OK to open up the file.
| | 02:06 | Now, remember what it look like in the Reader.
| | 02:08 | Here, you can see it looks a
little bit different in Microsoft Word.
| | 02:12 | So as we scroll down, the paragraphs are spaced out.
| | 02:18 | And as we go a little bit further we do
have the headers and footers,
| | 02:23 | but it's really not easy to read in this format.
| | 02:26 | So, there might be some editing of the
format itself that needs to be done,
| | 02:30 | as well as any content that might need to be edited.
| | 02:33 | There's our list and it really doesn't look as nice
as it did in the Reader.
| | 02:38 | But the neat thing is we can go in here and start
making changes to the text, the spacing, etcetera.
| | 02:44 | And when we're done, when we go up to the Save button,
look what happens when you click Save.
| | 02:49 | It's the Save As window that appears and by default,
| | 02:53 | you will be saving it to the same name,
but in the Word Document format.
| | 02:56 | If you want to save it back to PDF,
you do have to click the Save As type
| | 03:01 | dropdown and select PDF and then click Save.
| | 03:05 | You'll be asked to replace the current PDF version.
| | 03:09 | Now, you also have some options before clicking Save.
| | 03:11 | Notice down below, Standard publishing,
great for online and printing.
| | 03:16 | But if it's only going to appear online,
you might choose Minimize size option here,
| | 03:21 | which does minimize the size of your document
and that is ideal for posting, say on a web page.
| | 03:26 | There are some other Options here as well.
| | 03:29 | Notice that the check box next to Open file
after publishing is checked off
| | 03:33 | so we'll open up in Reader or Adobe
Reader depending on what you're using.
| | 03:37 | And when we click the Options button,
there are a number of different options,
| | 03:40 | for example, the Page Range.
| | 03:42 | What are we going to be saving?
| | 03:43 | Just the Current page, All of the pages,
you can select which Pages,
| | 03:47 | Publishing the entire document.
| | 03:49 | We can Create bookmarks using, as you can see
Headings or any Word bookmarks that might be in there.
| | 03:55 | And that's great in the navigation pane.
| | 03:57 | You can then quickly go to specific sections
of your document if the bookmarks are created.
| | 04:02 | Notice also down below we have some PDF options.
| | 04:05 | So, for example, if you want it to be
ISO 19005 compliant, you have that ability.
| | 04:12 | Bitmap text when fonts may not be embedded
is selected by default and you can
| | 04:17 | Encrypt the document with a password
if you wanted to, to further protect it.
| | 04:21 | I'm just going to click OK with all of these options.
| | 04:25 | And now if I wanted to, I can change the location.
| | 04:28 | I'm going to do that as well and save it
to my Desktop and click Save,
| | 04:35 | and I now have a PDF document that has
been edited in Microsoft Word.
| | 04:38 | It's going to open up in Reader and notice
hat those changes come from Word
| | 04:43 | back into my PDF here, and it doesn't look
as nice as it did originally
| | 04:48 | and that's why I say you can decide
if this is a feature that's right for you.
| | 04:53 | I'm going to back to Microsoft Word now,
and we'll continue from here.
| | Collapse this transcript |
| Inserting and reading comments| 00:00 | Collaborating on documents is important for many people
and there have been some improvements
| | 00:05 | to how you collaborate on documents in Word 2013
| | 00:08 | beginning with a feature that I really like,
the commenting feature.
| | 00:12 | We're going to work with this file
called No Obstacles Recipes Collaboration.
| | 00:16 | And you can see when you open this up
something happens over here on the right-hand side.
| | 00:20 | This is called the mark up area.
| | 00:22 | And if there are comments that have already
been added to a document this area opens up.
| | 00:27 | This is where your comments go.
| | 00:29 | So, if we wanted to for example
insert a comment on a file that we might be
| | 00:33 | working on with someone else, all we have to do
is click anywhere in the document
| | 00:36 | where we want to add the comment.
| | 00:38 | If we wanted to comment, for example,
on the formatting of this subtitle,
| | 00:42 | we could click next to it, or if you prefer,
you could click and drag across the entire title,
| | 00:47 | so it's clear that we're commenting
on the entire paragraph in this case.
| | 00:52 | And now, we're going to insert our comment
by going to the Insert tab on the ribbon
| | 00:55 | and clicking Comment halfway across.
| | 00:59 | Notice the comment does go over here
to the right-hand side.
| | 01:02 | It also shows a shading around the text
that we highlighted or selected,
| | 01:08 | and we're ready to comment on that by simply typing.
| | 01:11 | So, let's just type in a question here.
| | 01:13 | Is this the right font for this subtitle?
| | 01:20 | Now, that's our comment and when we're done,
I'll just click anywhere in the document
| | 01:24 | to deselect and you can see the comment
remains over here in the markup area.
| | 01:29 | Now, depending on your resolution and your
current view, you might not be seeing everything.
| | 01:35 | Let's go up to the View tab here for a second
to make sure we're seeing the entire page width.
| | 01:40 | In the Zoom area, click Page Width and
you'll be able to see as we hover over
| | 01:44 | our comment, there's actually an icon
over here on the top right-hand corner.
| | 01:48 | That's where we can go to
quickly reply to someone's comment.
| | 01:51 | So, as we scroll further down this document,
actually to Page 3, you'll notice
| | 01:56 | that there's already a comment here
from someone named Karen.
| | 02:00 | And when we hover over that,
you can see that there is an area of text that
| | 02:04 | has been highlighted or shaded and she's added
a comment giving credit to someone named Anne.
| | 02:09 | Now, we can reply to this by clicking
the icon that appears just off to the
| | 02:14 | right in the top corner, give it a click
and automatically you're inserting your
| | 02:19 | own comment and it becomes a
thread of the original comment.
| | 02:23 | So again, all we have to do is type in
our comment like we did when we created one.
| | 02:28 | We have our own color coding and of course,
our name is attached to the comment itself.
| | 02:32 | I'm going to just type in, Good idea. Thanks.
| | 02:36 | And again, we can click anywhere in the document,
continue working on this document
| | 02:40 | adding comments wherever we like,
and then when we share it with others,
| | 02:44 | they'll be able to see our comments,
reply to them, you'll always see
| | 02:47 | the entire thread over here in the markup area.
| | 02:50 | A nice improvement to the commenting feature
here, in Word 2013.
| | Collapse this transcript |
| Tracking changes and conversations| 00:00 | Here's a new feature in Word 2013
you might enjoy if you're accustomed to
| | 00:03 | tracking changes while editing documents, especially
those you might be collaborating with others on.
| | 00:09 | We're going to work with this filed called,
No Obstacles Home Recipes Tracking.
| | 00:13 | Next, we'll go to the Review tab here
and click Track Changes.
| | 00:18 | Now, that turns it on and just to the right of this button
you'll notice the default is called Simple Markup.
| | 00:24 | This is the new feature.
| | 00:26 | It's kind of an uncluttered way to show markup
on your page as you're tracking changes.
| | 00:31 | Let's click the dropdown and you'll see
some standard defaults from previous
| | 00:35 | versions like All Markup. Let's start there.
| | 00:38 | With All Markup selected and Track Changes on,
let's make a change to our
| | 00:42 | document here in the title where it says,
Essential Veggie Recipes for the No Obstacles Kitchen,
| | 00:47 | let's change it to from.
| | 00:49 | So, we'll double-click for, and we'll type in from,
and you can see what happens.
| | 00:53 | We're seeing all of the Markup.
| | 00:55 | We're seeing what was deleted, what's strike-through;
| | 00:57 | we're seeing what was inserted.
| | 00:59 | As we hover over this, we see some
information about who did it and when.
| | 01:03 | And now if we change it to this new feature
called Simple Markup, it's more of an uncluttered view.
| | 01:10 | We see the change here, but the only thing
that's changed on our page as far as
| | 01:14 | an addition is over here in the left-hand side,
this red bar indicating
| | 01:19 | that a change was made on this line.
| | 01:21 | As we hover over that red bar, we can see a message
indicating we need to click it to show the track changes.
| | 01:27 | So, when we do that, we see those changes,
just as though we had All Markup and
| | 01:31 | you can see it actually switches to All Markup.
| | 01:34 | And now we'll go back to that bar, which has
changed from red to gray, click it again to hide.
| | 01:39 | Notice that here on the Ribbon,
we're switched back to Simple Markup.
| | 01:43 | And that's not just for tracking changes,
but any other markup like comments
| | 01:47 | from the previous lesson, for example.
| | 01:49 | Let's just scroll down to the next page.
| | 01:52 | There's a letter to the customer, and as
we scroll down it's an uncluttered view
| | 01:56 | but markup is appearing over here in the left-hand margin.
| | 01:59 | There's that red bar indicating something changed here.
| | 02:02 | To see what it is, we just click.
| | 02:04 | Okay, it changed from thanks to thank you,
and then we'll click it again to hide it.
| | 02:09 | So, that's a new feature called Simple Markup
that allows you to unclutter your page
| | 02:14 | as your tracking changes, but still be able
to know where those changes are being made.
| | Collapse this transcript |
| Using object zoom in Read mode| 00:00 | Continuing on the topic of Read mode,
we're going to look at another feature
| | 00:04 | that allows you to focus in on the objects
that may appear in your document,
| | 00:08 | objects like graphics, could be charts or tables,
for example that might be difficult to view
| | 00:13 | unless you zoom in to them.
| | 00:16 | We're going to take a look at that as we continue
working with our No Obstacles Bio Reading document.
| | 00:21 | We're going to switch to Read mode.
| | 00:23 | You can do that from the View tab on the Ribbon,
or if you prefer, go down to the bottom of the screen
| | 00:27 | and click the Read mode icon.
| | 00:31 | Let's also make sure we're looking at
the same zoom level here.
| | 00:34 | We'll make sure 100% appears off to the right.
| | 00:37 | You can use the minus sign to decrease or
the plus sign to increase your text size.
| | 00:41 | Now from here, we're going to navigate
to the next set of pages.
| | 00:46 | Let's click the arrow that appears off to the right here.
| | 00:49 | And sure enough there's an object on this page.
We have a logo.
| | 00:53 | Now at our zoom level currently, it might be
difficult to really see the details of this object.
| | 00:58 | Imagine a chart, for example, with some data
or even a table crammed with data.
| | 01:03 | To zoom in, all we have to do is double-click in Read mode,
any of the objects that appear on our pages.
| | 01:09 | So, let's double-click the logo.
| | 01:10 | And you can see a separate window opens up here on top,
so we can really focus in on the contents of our object.
| | 01:17 | Notice in the background also that every thing's
been faded out so we can really focus on this object.
| | 01:22 | And if we need an even better look, there's actually
a button up here in the top right corner
| | 01:26 | that allows us to zoom in even further.
| | 01:29 | Let's give it a click.
| | 01:30 | Now, we really get a good feel for the content.
| | 01:33 | When we're done we can zoom out.
| | 01:35 | The buttons change to a zoom out button
or just simply click anywhere outside the window
| | 01:39 | to return to the document in Read mode.
| | 01:43 | So just keep in mind if you are using Read mode
and there are objects you need to see details,
| | 01:47 | double-click them.
It applies to graphics, tables, and charts.
| | Collapse this transcript |
| Using Read mode for longer documents| 00:00 | If you're going to be opening up a document
here in Word 2013
| | 00:03 | for the sole purpose of reading its contents,
as opposed to writing or editing the document,
| | 00:09 | you might consider a new feature called Read mode.
| | 00:12 | We're going to take a look at it now, using
this document named No Obstacles Bio Reading.
| | 00:17 | When we open up this document, there are
certain defaults, for example, the view.
| | 00:21 | If we moved down to the bottom of our screen,
you'll notice a little toolbar with, Print Layout selected.
| | 00:27 | There's an icon just left of that, to switch to read mode,
which we'll do momentarily.
| | 00:31 | Let's make sure we're all on the same page
and looking at the same thing.
| | 00:35 | My zoom level is set to 100%.
| | 00:37 | You can do that as well.
| | 00:39 | Use the minus sign to go down,
the plus sign to bump up.
| | 00:42 | But once you're at 100%, I also want you
to notice that in the bottom left corner,
| | 00:47 | we're looking at a total of five pages for this document,
and we should be looking at Page 1 of 5.
| | 00:53 | Also, with the navigation pane open,
we have access to the headings in this document.
| | 00:59 | That allows us to quickly jump from one section
of the document to another by clicking the heading.
| | 01:04 | We can go right to the top, clicking just above
Mission Statement to jump back to the beginning.
| | 01:09 | If we go up to the View Tab,
you're also going to notice some of these options.
| | 01:14 | First of all, if you're not seeing the navigation pane,
you can turn it on by clicking the check box.
| | 01:19 | You'll also notice over here in the View section
that Print Layout is highlighted or selected,
| | 01:24 | meaning that's our current view.
| | 01:26 | If we wanted to switch to Read mode,
we could also do it from here.
| | 01:30 | Let's go ahead and do that.
| | 01:32 | Now, a number of things happen
when we switch to Read mode.
| | 01:35 | Now, our focus is reading content.
| | 01:36 | So, the first thing you'll notice at the top,
the Ribbon's collapsed, we have a little more space.
| | 01:41 | The logo has disappeared.
| | 01:43 | We're just looking at text content now.
| | 01:45 | We still have our navigation pane and we can still
jump around from section to section here,
| | 01:49 | but look down at the bottom left-hand corner.
| | 01:52 | We're now looking at screens instead of pages,
screen full of information based on our zoom level.
| | 01:58 | Let's go down to the bottom right-hand corner,
notice my zoom level is at 130%.
| | 02:04 | You may be at the same or something different.
| | 02:06 | It depends on what you were looking at last.
| | 02:08 | Let's bump it down by clicking the minus sign
and we'll click that a few times until we get down to 100%.
| | 02:16 | Notice now, we're actually seeing two pages per screen.
| | 02:19 | We're still looking at screens down below
and now we're looking at screens 1 and 2 simultaneously.
| | 02:25 | We also have some navigation buttons that appear.
| | 02:29 | Notice to the right-hand side, we have an arrow,
inside a circle,
| | 02:33 | give that a click to go to the next couple of pages.
| | 02:36 | Really, what we're looking at is one screen full
containing two pages.
| | 02:40 | Click again and you can see this is a great way to read.
| | 02:43 | If you're in Touch mode, you can swipe
as well on a Touch Screen.
| | 02:48 | Let's go back using the arrow that now
appears on the left, until we get back to
| | 02:51 | the very beginning, it's no longer accessible.
| | 02:54 | Now, there's something else we can do here as well.
| | 02:57 | Notice that when we move over a heading
like Mission Statement or Company Description,
| | 03:02 | a little arrow shows up next to it.
| | 03:04 | Now, that doesn't only appear in Read mode,
it also appears in your document and Print Layouts,
| | 03:09 | but we can click those when we're
done reading them to collapse them.
| | 03:13 | Each time we click an arrow, it collapses that section,
so we can read the next section and be focused on it.
| | 03:19 | Of course, we can expand those by clicking the
same arrows that appear next to those headings.
| | 03:25 | And one last thing, in the top right-hand corner,
you'll notice a little icon here
| | 03:29 | to Auto-hide the Reading toolbar.
| | 03:31 | Now, when you click that, you get even more real estate.
| | 03:35 | Notice down at the bottom, we no longer have
that toolbar. It's gone.
| | 03:40 | Also our tabs on the Ribbon, they've disappeared at the top.
| | 03:43 | We're really focused on the content now that we're reading.
| | 03:46 | Of course, we can always go back to that button.
| | 03:49 | Click it again to bring those back.
| | 03:52 | When we're done with Reading mode,
we can go to the View Tab or go down
| | 03:56 | to the bottom of your screen and switch back
to the default view, which is Print Layout.
| | 04:00 | We'll give it a click and we're back where we started
with our Ribbon and our toolbars, and so on.
| | 04:07 | So, that's a great new feature if your
focus is going to be reading content,
| | 04:11 | as opposed to working on a document.
| | Collapse this transcript |
| Exploring new templates in Word| 00:00 | One enhancement worth mentioning
here in Word 2013 is the number
| | 00:06 | of new templates you have at your
disposal when creating new documents.
| | 00:08 | We're going to do a little exploring now.
| | 00:10 | So, really it doesn't matter
if you have anything open at this time.
| | 00:13 | We're going to go to the File Tab and click New.
| | 00:17 | Now off to the right, you're going to see some
templates ready for you to pick and choose from
| | 00:21 | thumbnail representations including the default here,
which is a Blank document.
| | 00:25 | Here's where we go to create a blank document,
which is really based on a template called Blank document.
| | 00:31 | There are a number of other templates here,
some you may have used recently,
| | 00:35 | others I just recommended
and I see some familiar faces here.
| | 00:39 | Now, there aren't really all that many to choose from
on this screen, but there are suggested searches.
| | 00:45 | So if you're connected and online,
you have access to thousands of templates.
| | 00:51 | Notice Letters, Resume, Fax, Labels, Cards,
Calendar and Blank are all options here.
| | 00:57 | If you want to be more specific,
you can use the Search field as well.
| | 01:01 | Click in there and start typing in some key words.
| | 01:03 | Maybe you're ready to create a business report
and you need some help.
| | 01:06 | We'll type in the two words, business and report.
| | 01:10 | Press Enter and it will search through thousands
of templates and give you some thumbnails here,
| | 01:16 | based on a number of categories that
show up over here on the right-hand side.
| | 01:20 | You'll see numbers next to them representing
the number of templates in those categories.
| | 01:25 | So for example, we're seeing a
number of Business Reports here.
| | 01:28 | If we want to go to Industry, for example,
and click there, you'll see some
| | 01:32 | business reports based on industry.
| | 01:35 | Once you find one that you like,
you just simply give it a click.
| | 01:38 | Here's a due diligence document to get more information.
| | 01:42 | So, when your company is undergoing a
merger acquisition and so on, you can see
| | 01:46 | the download size and if you like it, you can click Create.
| | 01:50 | You may even see more images.
| | 01:52 | They'll give you a better idea of what you're about to create.
| | 01:57 | So again, if you do like it, you can click Create;
| | 01:59 | otherwise, you simply close this up and you're
back to the list of templates at your disposal.
| | 02:04 | One other thing you'll see in this
little window though, is a push pin.
| | 02:07 | It means that if you're going to be
using this template over and over again,
| | 02:12 | you can click the pin template button to
add it to that list of default templates
| | 02:16 | that shows up whenever you go
to the File Tab and click New.
| | 02:20 | So, let's click Create, just to get
a quick peek at what this looks like.
| | 02:23 | It will be downloaded
and you're ready to start filling in blanks.
| | 02:27 | There's the Company Name.
| | 02:28 | We can replace this Logo with our own Logo and so on.
| | 02:31 | So, we get the layout for our business report, for due
diligence here, and we just saved ourself a lot of time.
| | 02:40 | So, that's how templates work, but the
key enhancement here in Word 2013
| | 02:44 | is the number of templates you have to choose from.
| | Collapse this transcript |
| Inserting objects with onscreen alignment guides| 00:00 | This next new feature in Word 2013
will help you save some time and hassle
| | 00:04 | when working with the objects you're trying to place
in the right spots, inside your document.
| | 00:09 | They're called the Alignment Guides,
and they'll pop up when you need them,
| | 00:13 | disappear when you don't, and they'll work
with objects like tables, charts and images.
| | 00:18 | So, we're going to experiment with this file
called Identity Branding Alignment.
| | 00:22 | There's a space between the title and the
first paragraph where we could insert an image.
| | 00:27 | So, let's just click in there.
| | 00:29 | Next, we'll go to the Insert Tab
if you have the exercise files.
| | 00:32 | When you click, Pictures, here on the Ribbon
and go to the Word folder of those
| | 00:36 | exercise files, you'll find a couple of graphic images
that we might want to use in this document.
| | 00:42 | We're going to start with the NO_sport_on_white,
No Obstacle Sport Logo.
| | 00:47 | Give it a click and click Insert.
| | 00:48 | Now, it will be inserted in its original size
where the cursor was flashing,
| | 00:53 | where we clicked in our document.
| | 00:55 | But when we go to resize this or even
move it around, those alignment guides
| | 00:58 | will help us get it in the right spot.
| | 01:01 | We'll start by going off to the right-hand corner
here at the top where we see
| | 01:05 | some layout options when we click the logo.
| | 01:07 | What we want to do is make sure that text is not
going to wrap around the sides, just above and below.
| | 01:13 | So, let's go down to Text Wrapping here and
select the option known as Top and Bottom.
| | 01:20 | Also, do we want this to move with any text
we might add or remove from this
| | 01:24 | document or would it rather be fixed
wherever we place it on the page?
| | 01:27 | Let's choose a Fixed Positioning on Page.
| | 01:31 | Now, it's time to work with our logo.
| | 01:34 | So, go right in to the center of the logo itself.
| | 01:36 | You'll see a four-sided arrow.
| | 01:38 | Click and drag it around and you'll see these
little green alignment guides pop up.
| | 01:41 | When you get to the center for example,
you'll know it's aligned up perfectly
| | 01:45 | down the middle and this is horizontally on the page,
when that alignment guide
| | 01:50 | appears going up and down through the center of your logo.
| | 01:54 | So, you can let go if that's where you want it.
| | 01:56 | Move up and down until you're in the right spot
and when you release, it will be perfectly centered.
| | 02:01 | The same thing goes for sizing.
| | 02:04 | Let's say we wanted to stretch
from the left margin to the right margin.
| | 02:07 | Well, let's start by just moving it all the way to the left.
| | 02:10 | When we see the alignment guide appear
on the left margin, we can let go.
| | 02:14 | Now, we're going to stretch it out
by going to the bottom right-handle.
| | 02:18 | When we see the double diagonal arrow,
we can click and drag across and down
| | 02:23 | until we see an alignment guide appear
for the right margin and then you can let go.
| | 02:28 | Now, you know it's perfectly placed
from margin to margin on your page.
| | 02:33 | That's the size that fits our options that we've selected.
| | 02:37 | So, that's an example of alignment guides
working right on the page.
| | 02:41 | Let's scroll down a little further.
| | 02:44 | When we see that paragraph that begins with,
No Obstacles Sport logo helps establish,
| | 02:48 | let's say we want to insert a little image here as well.
| | 02:52 | So, we'll just click towards the right-hand side.
| | 02:55 | Go to the Insert Tab, and again,
we're going to insert another picture.
| | 02:59 | This time it's the NO_transparent logo.
| | 03:02 | So, we'll select it and click Insert.
| | 03:04 | That's going to be way too big to fit on the page there.
| | 03:07 | So, we're going to size it down.
| | 03:09 | Let's go the bottom right corner.
| | 03:10 | Just click and drag and you can see
by default it's treated just like any other
| | 03:15 | character in the paragraph. All right.
| | 03:18 | So it moves back up to the previous page.
| | 03:20 | We have some extra space in here that we can delete.
| | 03:23 | Just click above the paragraph and hit
the Delete key a couple of times and
| | 03:27 | now let's move this kind of into the paragraph,
but we want it to not be
| | 03:32 | treated as a separate character in our paragraph,
but as an object that's inside the paragraph.
| | 03:37 | Let's go over to our Layout options again.
| | 03:40 | Click that icon and this time we want it
to wrap around, all around.
| | 03:44 | Let's go to Square.
| | 03:46 | You can see what's happening now.
| | 03:49 | As we move it inside the paragraph, notice,
there's an alignment guide that
| | 03:53 | appears across the top to let us know that we're lined
up perfectly with the top of the paragraph.
| | 03:59 | As we move down towards the bottom,
you can see we have the ability to move it
| | 04:03 | anywhere inside the paragraph, but as
soon as we get near the top, we will see
| | 04:08 | an alignment guide telling us
we're at the top of the paragraph.
| | 04:11 | I'm going to go to the top of the paragraph
and to the right margin, so I see
| | 04:16 | Alignment Guides on the right and at the top and release.
| | 04:19 | Now, we can just click anywhere in the
paragraph to see the end result. I like that.
| | 04:23 | So, with the Alignment Guides, there's no guess work.
| | 04:26 | You know exactly where you're placing it in
relation to other parts of your page or paragraph.
| | 04:31 | Alignment Guides, a nice little timesaver.
| | Collapse this transcript |
|
|
3. ExcelFilling empty cells using Flash Fill| 00:00 | The first new feature we're going to explore
here in Excel 2013 is a huge timesaver.
| | 00:05 | It's called Flash Fill and it will help you
to fill in empty cells in a spreadsheet
| | 00:10 | based on patterns that already exist.
| | 00:12 | To show you what I'm talking about,
we will work with this file named,
| | 00:15 | No Obstacle Sport Customer Database.
| | 00:17 | Once you've open it from the exercise files,
we'll just zoom out to about 100%,
| | 00:22 | so we can see all of the columns in our spreadsheet.
| | 00:25 | We have our First Name and Last Name column.
| | 00:27 | What we're missing is log in information.
| | 00:30 | This is the information our customers
will use to access our website, let's say.
| | 00:34 | So, we'll just type in a heading here
in cell G6, type in Login.
| | 00:38 | Press Enter and we're ready to
start creating the login credential.
| | 00:42 | Let's say it's going to be a combination of their First Name,
Last Name and some additional information.
| | 00:46 | So for our first customer, we'll type in their first name, evan.
| | 00:50 | Let's use a period dot, santos, then the @ sign.
| | 00:54 | We'll type in No-Obstacles-Inc.com.
| | 01:00 | That's a bit of data to type in for every single customer.
| | 01:03 | So, when we press Enter and it gets formatted
automatically like an email address, that's perfect.
| | 01:08 | We're on to the next one now.
| | 01:10 | We have to repeat this for a couple hundred customers.
| | 01:12 | Look what happens though, when we start
to type in the next first name,
| | 01:16 | which is micah, mi, well it's automatically filling in
the rest of the information for me in that cell.
| | 01:21 | If you look at subsequent rows down below,
it's going to be filled in the exact
| | 01:26 | same way if we hit Enter. So, let's do that.
| | 01:28 | We press Enter and there they are.
| | 01:30 | We just saved a lot of time.
| | 01:32 | Now, there is a little icon that pops up here,
the Flash Fill options button that we can click.
| | 01:37 | If we don't like the results, we can undo
the Flash Fill or maybe we don't want
| | 01:41 | it to automatically pick up the pattern.
| | 01:43 | Here's where you go to turn that off.
| | 01:45 | If you like everything, you can click Accept Suggestions.
| | 01:48 | And if you wanted to, you can reformat all
of those cells by using the Select all,
| | 01:51 | changed cells, in this case a 199.
| | 01:55 | They'd all be highlighted or selected
so we could do things to those cells.
| | 01:59 | Let's just click Accept Suggestions
and that little icon disappears.
| | 02:03 | So, all we need to do now is make sure that
column G is wide enough for our longest entry.
| | 02:08 | We'll go in between G and H up here
and double-click and there we go.
| | 02:12 | Now, that's one example of Flash Fill where
it's combining the contents of two separate cells.
| | 02:17 | We can also do the reverse and
that is to split up the information.
| | 02:20 | For example, let's say we didn't
have the First Name and Last Name.
| | 02:24 | Over here on the right-hand side, we'll experiment.
| | 02:26 | Let's just scroll over so we're looking
at two columns, H and I. Here's where
| | 02:31 | we want to put in their First Name and
here's where we want to put in their Last Name.
| | 02:35 | So, just type it in, tab across.
| | 02:37 | We're ready to start typing now.
| | 02:38 | So it will be based on information.
| | 02:40 | Let's say we downloaded this information
including email addresses and we want
| | 02:44 | to create a First Name and Last Name columns.
| | 02:46 | In this case, we'll type in Evan, hit Enter.
| | 02:50 | Next, First Name is Micah.
| | 02:51 | We'll type that in.
| | 02:52 | You can see what's happening.
| | 02:53 | It's picking up the pattern even
the capital that we're adding to the
| | 02:57 | beginning of the First Name.
| | 02:58 | All we have to do is hit Enter now
to accept all of those names.
| | 03:02 | Do the same for the Last Name.
| | 03:04 | In this case, Santos with a capital; press Enter.
| | 03:06 | The next one is Harvey.
| | 03:07 | Again, as we start to type, the Flash Fill kicks in,
we press Enter and everything is filled in for us.
| | 03:13 | What a huge timesaver that can be,
if you have spreadsheets where you're going
| | 03:17 | to be filling an empty cells based on
existing patterns in the spreadsheet.
| | 03:21 | We don't really need these two columns,
so let's go up to H, drag across to I,
| | 03:25 | hit Delete on the keyboard and press
your Home key on the keyboard to go back to
| | 03:29 | the very top of your spreadsheet.
| | 03:31 | That's the Flash Fill feature brand new here in Excel 2013.
| | 03:34 | It has the potential to save you a lot of time and stress.
| | Collapse this transcript |
| Filtering records using a Timeline| 00:00 | If you like to use pivot tables to analyze data,
you're going to like this next new feature
| | 00:04 | that allows you to filter via a timeline.
| | 00:07 | It's called the Timeline Filter.
| | 00:09 | We're going to use this file named,
No Obstacle Sport - July 2012 Sales Report,
| | 00:13 | which as you can see from the very first Data sheet here
is a list of sales for each of the days in July.
| | 00:19 | So, we have multiple sales on the first of July.
| | 00:21 | You can see the SKUs for the items,
their prices, and if we scroll all the way
| | 00:25 | down to the bottom of this sheet, we're going to see
a grand Total Revenue for the month of July 2012.
| | 00:31 | This is a perfect opportunity for a pivot table
that will help us to analyze that data
| | 00:35 | and make it a little bit easier to understand.
| | 00:38 | Let's go to the Pivot Tab where a pivot table
has already been created based on two fields.
| | 00:43 | As you can see we have the Date field and we
have the Sum of the Price field next to it.
| | 00:47 | So, instead of individual sales, we see the total sales
for the first of July, the second, and so on.
| | 00:53 | And as we scroll down, there's our Grand Total.
| | 00:55 | That's for each of the days in July
where there were sales, and if wanted to
| | 00:59 | analyze that further by date,
we can use this new Timeline Filter.
| | 01:02 | All we need to do now is make sure
that we're on cell A2. Click there.
| | 01:07 | That's the beginning of our Pivot table.
| | 01:09 | Go to the Insert Tab, and next we'll go
to the Filter section where you'll find
| | 01:14 | the new one called Timeline.
| | 01:15 | We'll give that a click and there's only
one Date field or table to choose from here.
| | 01:20 | If there were multiple tables, we could select
the table we want to base our timeline on,
| | 01:24 | but there's just this one over here.
| | 01:26 | It's called Date, we'll click the check box and click OK.
| | 01:30 | All right. So, there's our object.
| | 01:32 | We can move it around, we can size it.
| | 01:35 | There is a Scroll bar, so we can see the contents.
| | 01:38 | In this case, we're looking at the default,
which is the various months of 2012,
| | 01:43 | but we know our table only has sales showing for July.
| | 01:47 | If we go to July, we're not going to
see any changes over here in our table
| | 01:51 | because all of these dates fall in that month.
| | 01:53 | However, we can go to the dropdown
to choose a different filter.
| | 01:56 | We have Years, Quarters, we also have
Months, which is already checked off,
| | 02:01 | but the one we want is Days.
| | 02:02 | So, when we click Days, now
we're looking at different object.
| | 02:06 | As we scroll across, we're looking at
each of the individual days in July,
| | 02:11 | and they are all highlighted right now.
| | 02:12 | That's why we're seeing all of the
data over there on the left-hand side.
| | 02:16 | Let's just stretch this out so we can see at least
most of the days in July as we scroll left to right.
| | 02:22 | Now, we can pick an individual day if we wanted to.
| | 02:25 | For example, how did we do on the first?
| | 02:27 | Well, we just click the one and that's
all we're going to see, sales for the
| | 02:31 | first including the Grand Total.
| | 02:32 | What about the first ten days?
| | 02:34 | We can click and drag from one all
the way across to 10 and release.
| | 02:38 | There is our total sales for the first ten days in July.
| | 02:42 | Wondering about the second half?
| | 02:44 | Well, again you could click and drag over the dates.
| | 02:46 | Let's go from the 15th all the way to the 30th and release.
| | 02:50 | So, it's a great way to quickly review data based on a timeline.
| | 02:54 | In this case, viewing it by Days, but we also have
the ability to view by Months, Quarters and Years.
| | 03:00 | It's a handy little feature, and it is an object
that we can move around and size to our liking.
| | 03:05 | It's just a great way to save some time when
you're trying to analyze complicated or extensive data.
| | Collapse this transcript |
| Previewing with Quick Analysis| 00:00 | This next new feature in Excel 2013
might be my personal favorite.
| | 00:04 | I think you'll like it too, it's called Quick Analysis.
| | 00:07 | It allow us to highlight or select data
and quickly analyze it using a number
| | 00:11 | of different options that we're going to
explore right now as we continue to work
| | 00:14 | with our No Obstacle Sport - July 2012 Sales Report.
| | 00:18 | I'm just going to scroll down a little bit so we can
see all of the sales for the first day in July.
| | 00:24 | They go from row seven all the way down to row 16.
| | 00:27 | Now, let's say we want to analyze over here
in the Price column, our sales for that day.
| | 00:31 | We'll click and drag from cell E7 all the way down
to E16 and we've highlighted all of our sales for that day.
| | 00:38 | Now, you'll notice something appears
in the bottom right-hand corner.
| | 00:41 | It's our Quick Analysis icon, Ctrl+Q is the keyboard
shortcut to get all of the options available.
| | 00:46 | Just click it though and you'll see there are
a number of different categories
| | 00:50 | including Formatting, Charts,
Totals, Tables and Sparklines.
| | 00:53 | So let's start with Formatting.
| | 00:55 | Under the Formatting heading, which is
selected by default, we have Data Bars.
| | 00:59 | Now, we don't need to click these.
| | 01:00 | We can preview them before selecting them.
| | 01:02 | So, just hover over Data Bars and you'll see
the actual bars appear in each of the cells.
| | 01:08 | The bars that go from left all the way
over to the right are our highest prices.
| | 01:12 | Our lowest prices are the smallest bars.
| | 01:15 | So, it's a quick way to get a feel for how many
high-priced items we sold versus low-priced.
| | 01:20 | Or we could use a color scale.
| | 01:21 | In this case, the green items are our highest prices
and you can see the red items are the lowest.
| | 01:26 | It looks a little more red than green,
probably not ideal for our company.
| | 01:29 | Let's go to Icon Set, just another way using arrows.
| | 01:33 | We have Greater Than, Top 10%,
with only 10 rows highlighted, only one is
| | 01:37 | showing up in the top 10 and
that's our $112.99 priced item.
| | 01:42 | And if we don't like anything we've selected,
we can use the Clear Format.
| | 01:45 | We'll keep that in mind later on
when we actually make a selection.
| | 01:48 | Right now we're not going to select anything.
| | 01:50 | We're going to go to Charts.
| | 01:52 | This is another way to analyze data.
| | 01:54 | For example, if we hover over Clustered Column,
a chart appears over top of our data
| | 01:57 | and this would be created for us if we selected it.
| | 02:00 | It gives us a good idea of the items.
| | 02:03 | As you can see, we have 10 of them and it looks
like item three and nine are highest priced.
| | 02:08 | We can see that horizontally using Clustered Bar.
| | 02:11 | There are Line Charts, Scatter and if we wanted
to access some of the many more
| | 02:15 | charts we have in Excel 2013, we could go to More Charts.
| | 02:18 | Let's go to Totals now.
| | 02:20 | Totals allow us to do some neat things
like Sum for example.
| | 02:24 | What you're going to see in the next cell down below
is the total, the sum total
| | 02:28 | for our selected cells which is $446.23.
| | 02:30 | How about the Average?
| | 02:32 | The Average price of our items that we sold
on the first day of July, $4,462.
| | 02:38 | Account, we're going to see 10.
| | 02:39 | That's the number of items.
| | 02:41 | You can see % Totals, Running Totals;
| | 02:43 | it all depends on the type of data you're looking at.
| | 02:46 | Over here we can have those items show up off to the right.
| | 02:49 | So, we have Sum, Average, Count, etcetera,
but you'll see a yellow column off to
| | 02:53 | the right where we can show those totals.
| | 02:55 | And one that I like the most is actually hidden.
| | 02:58 | Let's click the arrow and go to Running Total.
| | 03:00 | Just hover over that one and you can
see it's actually totalling up our items
| | 03:04 | reaching the very last one at $446.23.
| | 03:06 | So, you can experiment with some of those,
Tables as well.
| | 03:11 | When we go to Tables, give that a click.
| | 03:13 | We could have a PivotTable if we wanted to
and there are different ways to view data in PivotTable.
| | 03:18 | So, there are many more options to choose from
by clicking More.
| | 03:21 | If you're comfortable with PivotTables,
you can experiment in that area.
| | 03:25 | Sparklines as well, so when we go
down to Line for example, Column,
| | 03:30 | and Win/Loss, you can see for this particular
type of data, Sparklines are not very useful;
| | 03:35 | but keep in mind, Quick Analysis works on all kinds of data.
| | 03:38 | So, depending on the actual content in your spreadsheet,
Sparklines might be a good option.
| | 03:43 | Let's go back to Formatting though.
| | 03:45 | Let's go down to the Icon Set and give it a click.
| | 03:49 | Now, that locks it in and you can see
when we click anywhere off to the right here,
| | 03:52 | we have those little icons showing up for our first day of July.
| | 03:56 | Maybe we don't like that one.
| | 03:57 | We selected the wrong one.
| | 03:59 | We want to go back, no problem.
| | 04:00 | Just reselect those cells.
| | 04:03 | Again the Quick Analysis icon appears.
| | 04:05 | Give it a click and if you want Clear Format,
go back to the icon, choose something different.
| | 04:10 | I like this Color Scale, I'm going to select it,
and deselect by clicking off to the right.
| | 04:16 | So that's called Quick Analysis.
| | 04:17 | It's new in Excel 2013 and it's a great way
to get a quick look at some of the data
| | 04:23 | you may have highlighted, analyzing it
using formatting, tables, graphs and charts;
| | 04:29 | all kinds of cool options here
in the Quick Analysis tool in Excel 2013.
| | Collapse this transcript |
| Using Chart Advisor recommendations| 00:00 | As you continue to work with Excel 2013,
you'll begin to realize how
| | 00:05 | Microsoft has made it a little more intuitive.
| | 00:07 | You're going to get help along the way
including with this new feature we're
| | 00:09 | going to look at next, Recommended Charts.
| | 00:12 | When you select data, Microsoft is going
to help you pick the right chart for
| | 00:16 | the type of data you've selected.
| | 00:18 | So, we'll continue to work with our
No Obstacles Sport - July 2012 Sales Report.
| | 00:22 | If you you've been following along,
all we're going to do is select our data next.
| | 00:26 | Now, if you jump to this lesson, you want to
get caught up, go to your exercise files,
| | 00:30 | open up No Obstacles Sport - July 2012 Sales Report2.
| | 00:33 | You'll see exactly what I see and we're going to
select our first column of data which contains our Date.
| | 00:38 | So, let's go right up to the heading,
column heading A and click there.
| | 00:42 | That selects the entire column.
| | 00:43 | We also want our Price column.
| | 00:45 | So, we'll go over to column heading E,
while holding down Alt and Ctrl,
| | 00:49 | we'll click that column header to select it as well.
| | 00:52 | So, now we have two columns of data
and we're ready to create a chart.
| | 00:55 | Well, Microsoft already has an idea of what types
of charts would best suit the data we have selected.
| | 01:00 | So, let's go to Insert and over here in the Charts section,
you'll notice something new, Recommended Charts.
| | 01:06 | Give that a click and you'll see a dialog box
with two tabs, Recommended Charts
| | 01:11 | which are displayed down the left here and All Charts.
| | 01:14 | So, if don't like any of the recommendations,
no problem, just go to All Charts
| | 01:18 | and select the chart that you like best,
just like you always did in previous versions.
| | 01:23 | But here under Recommended Charts
you'll see at the top, this one is highlighted
| | 01:26 | and we see a preview over here of the Scatter Chart.
| | 01:29 | Now, based on the scale that's being shown here,
we don't see any variation.
| | 01:33 | So, we would have to do a little bit of work with our scale;
| | 01:37 | same thing for the Line Chart.
| | 01:38 | The third one which is a Stacked Area Chart
does show all of our fluctuations,
| | 01:42 | and if we go to the fourth one, you can
see it's like the others, we would have
| | 01:46 | to adjust the scale using the Clustered Column.
| | 01:48 | So, let's go with the third one, our Stacked Area.
| | 01:51 | We select it by clicking and then click OK.
| | 01:53 | Now, it's going to create the chart for us
right on top of our data.
| | 01:57 | We can go to the border though
and right on the border when you see
| | 02:00 | the four-sided arrow, click and drag it off to the right.
| | 02:03 | We'll just move it off to the right a little bit. It looks good.
| | 02:06 | You'll notice something's happened on the Ribbon.
| | 02:07 | We're looking at Chart tools now
with the Design tab selected.
| | 02:10 | So, we can actually hover over these
different designs to get a preview,
| | 02:14 | and if we see one that we like better than the
original, all we have to do is select it by clicking.
| | 02:19 | I think I'm going to go with this one here, Style number 6.
| | 02:23 | Give it a click and I have all of my other
Chart tools available to me here,
| | 02:28 | just as though I created this chart from scratch.
| | 02:30 | But with Recommended Charts, I have a
pretty good suspicion that I'm going to be
| | 02:34 | selecting the right type of chart for the data I had selected.
| | 02:37 | I'll just click off in a cell in behind
to deselect our chart and continue from here.
| | Collapse this transcript |
| Finding errors and issues with Power view| 00:00 | The next new feature we're going to explore
here in Excel 2013 is actually an add-in.
| | 00:05 | It's an add-in that's included in Excel 2013 Professional Plus.
| | 00:08 | So, if that's what you're working with
you already have it, otherwise,
| | 00:11 | you may need it to download it
from Microsoft.com to follow along with me.
| | 00:15 | It's called Power View, and it's a great tool
for taking existing data
| | 00:19 | that might exist in a sheet and manipulate
that data in a safe place where you can
| | 00:23 | play with it and use visualizations
to look at your data differently.
| | 00:27 | We're going to explore this now using our
No Obstacles Sport - Customer Database2 Workbook.
| | 00:34 | Now, the next thing were going to do is
click the Insert tab because
| | 00:38 | Power View is actually a separate sheet.
| | 00:39 | It's a safe area where you can play with your data
without any fear of messing up the original data.
| | 00:45 | From the Insert tab you'll see Power View
here in the Reports section.
| | 00:48 | Now, before we click this, if you have never
used this you will be prompted to enable it.
| | 00:53 | So, you just click Enable and you're ready to go.
| | 00:55 | The other thing you'll need is Silverlight,
and that's to take advantage of the visualizations.
| | 01:00 | If you don't have Silverlight installed,
again, you'll be prompted to that as well.
| | 01:04 | It could take a few minutes.
| | 01:05 | So if you need to do those things, you can hit pause here
and rejoin me once that's completed.
| | 01:11 | Then it's on to the Power View button.
| | 01:13 | When we click this, a new sheet is actually
added down below.
| | 01:17 | You'll see Power View and you'll see a number.
| | 01:19 | It depends how many times you've worked with this.
| | 01:22 | And if you don't see any data here,
that's because we didn't select any data.
| | 01:26 | So, let's go back to Sheet1
and click anywhere in our data area.
| | 01:31 | So, we could select columns if wanted to,
or just click in any of the columns
| | 01:36 | and Excel will know to use all of this data.
| | 01:38 | And now, when we go to Insert>Power View,
you can see what's happening,
| | 01:45 | all of our data is highlighted and we can
create a new Power View Sheet or add selected data
| | 01:49 | to our existing Power View, which is what we're going to do.
| | 01:53 | So, with that selected we'll click OK.
| | 01:55 | Now, all of a sudden things are going to change
here in our Power View Sheet.
| | 01:59 | We're going to see over here in the
left-hand side our first visualization,
| | 02:03 | which is actually just a table, and a table
that doesn't look a whole a lot different
| | 02:07 | than our original spreadsheet.
| | 02:08 | However, the formatting can be adjusted.
| | 02:09 | We don't have grid lines going up and down,
left and right, rows and columns.
| | 02:13 | It's a little bit different.
| | 02:14 | And over here on the right-hand side, you can see
the fields that have been created based on those columns.
| | 02:19 | And all of them, but Login are checked off.
| | 02:22 | So, we're seeing everything here
except for our Login information.
| | 02:25 | For some reason, Excel thinks maybe we don't need that.
| | 02:27 | If we do want to see it, all we do is click the checkbox
and you can see it's added as well.
| | 02:32 | Maybe we don't need that, we can deselect it,
and anything else we don't need,
| | 02:36 | can be deselected by clicking the checkbox.
| | 02:38 | Now, this is a table, an object that can be adjusted.
| | 02:41 | So, we can widen it, we can make it a
little bit longer if we want to see more data.
| | 02:46 | There is a Scroll Bar for scrolling through our data.
| | 02:48 | But really, there's nothing exciting happening here quite yet.
| | 02:51 | However, one thing that we can do
is change the visualization itself.
| | 02:55 | So, up here, you'll see the Power View tab.
| | 02:57 | That's what we're looking at now.
| | 02:59 | We have some options for Fitting to Window,
again our Field List that we already
| | 03:03 | have over there on the right, Filtering.
| | 03:05 | But we're going to go up to Design now,
and from here, you'll see we can switch visualizations.
| | 03:10 | So, if we want to switch to something else,
a different table for example, we could do that.
| | 03:14 | Click the dropdown and you'll see
Matrix and Card are two other options.
| | 03:18 | We're currently viewing the default table.
| | 03:20 | There are also Bar Charts and Column Charts.
| | 03:23 | Now, it doesn't really apply to a customer database,
but maybe the Map would.
| | 03:26 | If we click Map right now, something is going to happen.
| | 03:30 | By default, Excel is going to use one of our fields
to map the various entries on to a physical map.
| | 03:37 | Now, you can see it's using the Phone Number field,
which, really, there are too many values,
| | 03:41 | that's why we're seeing that,
but we can change that over here on the right.
| | 03:45 | So as we scroll down, you can see the Color
is using the Phone field.
| | 03:49 | So, the color coding, we'll click the dropdown
and remove that field.
| | 03:53 | Now, what we really want is probably something like
the City or Zipcode to show up in the Color field.
| | 03:59 | So all I have to do is find it.
| | 04:01 | There is our Zipcode right there, and
if we wanted to, just drag it down in to
| | 04:06 | the Color field and let go, and now
that's what's going to appear on our map.
| | 04:10 | Now, each of the maps represents each of the various
codes and you can see each of the people in those codes.
| | 04:16 | So, all we're going to do now is play with the map.
| | 04:19 | You can click a map. You can zoom in.
| | 04:21 | You can move it around by clicking and dragging.
| | 04:24 | Now, this is something you can experiment with
using your own data if you wanted to,
| | 04:28 | we're going to go back to a different visualization now.
| | 04:31 | Let's go back to table, but let's go to one called Card.
| | 04:36 | Let's see what that looks like.
| | 04:37 | Now, when we do that, we're looking
at our data again at different ways.
| | 04:41 | It's visualized using kind of a Card feature,
it looks like it could be contacts for example.
| | 04:46 | Over here on the right now as we look
at our Power View fields,
| | 04:50 | we might be missing Phone Number,
so we can check that box to add it.
| | 04:53 | And here's the cool thing.
| | 04:55 | Really, wouldn't it be nice if could look
at it by Zipcode or by City for example.
| | 05:00 | These are called tiles.
| | 05:01 | So, if we wanted to we could go down to
for example, the City field and drag
| | 05:06 | that into the Tile By field here and release.
| | 05:09 | Suddenly, we have tiles across the top.
| | 05:12 | Now we're looking at the various cities.
| | 05:14 | So, if we want to see all of our customers
in San Diego, we click that tile
| | 05:18 | at the top and now all we're seeing using that Card view
is our various customers in that one city.
| | 05:26 | We can change the Card Style if we want,
by clicking here in the Options, changing it to callout.
| | 05:31 | Actually, that's harder to look at,
so let's change it back to Card.
| | 05:35 | Now, this could be an entire chapter talking about
the Power View add-in feature here in Excel 2013.
| | 05:41 | Really, you should experiment with your
own data to get a good feel for all the
| | 05:45 | things you can do with Power View.
| | 05:48 | Let's go up here where it says Click
to add a title, and we'll just add a
| | 05:51 | simple title here, we'll call it Customers 2012
and then just click anywhere outside that to lock it in.
| | 05:59 | That's our new Power View sheet,
the new add-in feature in Excel 2013 Professional Plus.
| | 06:04 | You could download it if you're not using Professional Plus.
| | 06:07 | A lot you can do with it.
| | 06:09 | Very cool tool and it's a safe place
where you can play around with your data
| | 06:13 | and look at it in different ways.
| | Collapse this transcript |
| Converting roman numerals into arabic numbers| 00:00 | If you ever need to work with
Roman numerals and Arabic numbers,
| | 00:03 | this next new feature in Excel 2013
might be of interest to you.
| | 00:07 | It's the ability to not only convert
to Roman numerals, but also to convert
| | 00:11 | Roman Numerals back to Arabic numbers.
| | 00:14 | We're going to explore it using this spreadsheet named,
| | 00:17 | No Obstacles Sport - July 2012 Sales Report_short.
| | 00:20 | All we're going to do is add a column heading here at Cell F6.
| | 00:24 | We'll type in ROMAN, and press enter.
| | 00:28 | And now, as you can see we have a Size column
using Arabic numbers and we want
| | 00:32 | the Roman equivalent over here.
| | 00:33 | Depending on our location where we're selling
our product, we may need to use one or the other.
| | 00:38 | So, we could type in the Roman numeral for seven,
which is a VII.
| | 00:41 | When you press Enter, we now have text in there.
| | 00:46 | Now, of course we could also do the conversion
like we always could before.
| | 00:50 | Let's use a formula here in the next cell,
which is column F, row 8.
| | 00:53 | We'll start with =roman(
and what we want to do is
| | 00:59 | convert this number over here in cell D8,
so we will click there and then close it up
| | 01:05 | with a closing round bracket and press Return.
| | 01:08 | You can see we get the same thing.
| | 01:09 | We get a Roman numeral here.
| | 01:11 | Now, when we click in that cell we see up here
in the Formula Bar, the actual formula that gives us that.
| | 01:17 | It is text, just as we see text in the cell above.
| | 01:21 | Clicking in cell F7 shows the text in the Formula Bar.
| | 01:25 | It really doesn't matter how we get it, we're looking at text.
| | 01:29 | Now, if wanted to,
we could just copy this formula all the way down.
| | 01:32 | Click in cell F8, go to the bottom right-hand corner
and we'll just click and drag
| | 01:36 | all the way down to the bottom of our data.
| | 01:38 | So, we've got to go quite away all the way
to row 69 and let go and you can see
| | 01:44 | everything is converted nicely. Okay.
| | 01:46 | Now, let's say we didn't have these numbers
here in the Size column.
| | 01:49 | Let's say they didn't exist and we wanted to add them.
| | 01:52 | We can use a formula now, this is the new part,
to convert Roman Numerals over to Arabic numbers.
| | 01:58 | So, let's just type in ARABIC and hit Return,
and now the formula just like
| | 02:03 | the conversion to Roman numerals we use the
Equal sign (=), but this time we type Arabic.
| | 02:07 | That's the new part.
| | 02:08 | An opening round bracket, we'll click in the text field
here showing us the Roman numeral VII,
| | 02:13 | and when we close it up
with a closing round bracket and press Return,
| | 02:16 | as you can see it's converted to an actual number.
| | 02:21 | So, the formula shows up in the Formula Bar,
but the number is displayed.
| | 02:26 | Again, we could click and drag
from the bottom corner to copy that formula
| | 02:30 | all the way down getting our actual Arabic numbers
out of the text version of the Roman numeral.
| | 02:36 | So, that's what's new here in Excel 2013
when converting to Arabic from Roman Numerals.
| | Collapse this transcript |
| Protecting data in a shared spreadsheet| 00:00 | A very common scenario when working
with Excel is to share a workbook,
| | 00:05 | that is to have more that one person having
access to the data, either to make changes
| | 00:10 | or update or additions.
| | 00:12 | Protecting that workbook is then something
to consider and there are some new options
| | 00:16 | here in Excel 2013, we're going to
explore them using this file named
| | 00:20 | No Obstacle Sport - Customer Database3.
| | 00:23 | As you can see down below there are more in than one tab.
| | 00:26 | There is our main sheet, Sheet1,
containing our customer data base information;
| | 00:30 | and there's also a Power View,
and if we switch over to that tab, you can see
| | 00:34 | we're looking at a table with some tiles. Okay.
| | 00:37 | So, maybe this is an area where anyone can have access
to manipulate the data and visualize it in different ways.
| | 00:44 | We don't need to protect that.
| | 00:45 | But if we go back to our sheet,
maybe we do want to protect this sheet.
| | 00:49 | Well, maybe we want to protect a part
of this sheet, and that is an option now
| | 00:53 | using a Range Protection, so let's talk about that.
| | 00:57 | Looking at our data, we have First Name, Last Name
and we have Phone, Street Address, City, Zipcode.
| | 01:02 | There is some information here
that should never change, like our customers' first
| | 01:06 | and last names and their logins, everything else,
like phone number and their address, might change.
| | 01:12 | So, we want to get certain users access to
this range even when our sheet is protected.
| | 01:16 | So, let's do that now.
| | 01:18 | First, we'll go up to the Review tab on
the ribbon and here's where we see our
| | 01:22 | Protection Options like protecting a workbook.
| | 01:25 | This is nothing new.
| | 01:26 | Using the Protect Workbook option
allows us to password protect our workbook.
| | 01:30 | Anyone trying to open up the file called
No Obstacle Sport - Customer Database3,
| | 01:34 | would have to know the password,
but then they'd have full access to the content.
| | 01:39 | Here's Protect Sheet which allows us to
password protect the sheet we're looking at.
| | 01:43 | That would leave our Power View
available to users to make changes.
| | 01:47 | However, here in Sheet1, they would
need to know the password to get in.
| | 01:50 | But maybe we want to make it so that
we could protect our sheet and give users
| | 01:54 | access to this range containing the phone number and address.
| | 01:58 | In that case, you'll see this new feature
Allow Users to Edit Ranges. Let's go there.
| | 02:04 | We'll give it a click and now all we need to do
is create our New Range.
| | 02:08 | Click the New button and we'll give it a name.
| | 02:11 | Let's call it Customer_Info.
| | 02:14 | Now, the range itself, we could have selected it
ahead of time and it would
| | 02:18 | appear here in the Refer to cells field,
but we can go ahead and select it
| | 02:22 | using this button off to the right,
give it a click and temporarily now
| | 02:26 | we have access to our spreadsheet.
| | 02:27 | So, let's start with the Phone field here at cell C6.
| | 02:32 | We'll click and drag across to the Zipcode
and all the way down to bottom.
| | 02:37 | Now, as we scroll quickly, you'll notice
Excel slows down as it gets close to the end,
| | 02:42 | which is well in to the 200s here. There we go.
| | 02:45 | 206 is the last row.
| | 02:48 | So, we'll let go there.
| | 02:50 | That's the range, so we'll click that same button.
| | 02:52 | Notice the range now appears in the New Range field.
| | 02:54 | Click that same button to get back in,
and we'll give this range a password.
| | 02:59 | Let's type in any password you like.
| | 03:01 | You won't see what you are typing and when you click OK,
| | 03:04 | you'll be prompted to type it in again,
to make sure you got it right and click OK.
| | 03:08 | All right, so we now have our New Range.
| | 03:12 | You can see it there.
| | 03:13 | We can add as many ranges as we like.
| | 03:16 | And if we wanted to assign permissions
that is to specify who can edit the range without a password.
| | 03:22 | And if you have a number of contacts,
for example, this is workbook that is
| | 03:27 | available to people on the network,
you could select names and just give them
| | 03:30 | straight out permission without using the password.
| | 03:33 | When we click Apply, it gets applied to our range
and now we have to actually protect the sheet.
| | 03:38 | So, let's go to Protect Sheet.
| | 03:39 | We could also have done it from up here
in the changes section, Protect Worksheet.
| | 03:43 | When we click that, we get to choose now exactly
what our users will be allowed to do in this worksheet.
| | 03:50 | Select locked cells, Select unlocked cells,
is checked off by default,
| | 03:54 | so is Protect worksheet and contents of locked cells,
unless they know the Password.
| | 03:58 | So, we'll type in a Password here for the sheet,
click OK, and just like we saw with the range,
| | 04:03 | we need to reenter it and click OK.
| | 04:08 | All right, we've protected our sheet
and we actually have a range.
| | 04:12 | Ctrl+Home on your keyboard is going to
take you back to the top.
| | 04:16 | Let's say we wanted to make a change now to
the First Name or Last Name here at the top.
| | 04:21 | So, we type in there, click, and type something like Rivers.
| | 04:26 | As soon as I start to type, you can see the cell or chart
that I'm trying to change is on a protected sheet.
| | 04:32 | To make changes, I have to unprotect it
and I'd have to know the password to do that.
| | 04:36 | So, I go up to Unprotect Sheet.
| | 04:38 | But what if I did want to make changes here to this range?
| | 04:41 | I know I'm allowed to.
| | 04:43 | Let's say someone's zipcode has changed.
| | 04:45 | We click in there, and when we go to change the zipcode,
you see it's a different message that pops up,
| | 04:51 | a cell that I'm trying to change is password protected.
| | 04:53 | Well, I know the password for the range.
| | 04:55 | I don't know it for the worksheet, so I can't unprotect it,
but I can get access to this cell.
| | 05:00 | So, I type is the password, click OK or press Enter,
| | 05:05 | and now when I go to type in a new zipcode,
I'm allowed to.
| | 05:10 | So, that's how you can protect ranges within a sheet,
protect an entire sheet,
| | 05:14 | even an entire workbook and assign permissions
all at the same, here in Excel 2013.
| | Collapse this transcript |
|
|
4. PowerPointWorking with new templates| 00:00 | As you'll find with each of the programs
in Microsoft Office 2013 here in PowerPoint,
| | 00:05 | you have access to a number of new Templates
and when you first launch PowerPoint,
| | 00:09 | this is what you're going to see.
| | 00:12 | First of all, in the left-hand side,
a list of your Recent presentations,
| | 00:15 | so you have quick access to them.
| | 00:17 | Over time a list will build up here.
| | 00:20 | You have a link to open other presentations you can browse to,
| | 00:23 | whether they'd be stored locally or on a network, for example.
| | 00:27 | Then over here to the right
is where you're going to see Templates.
| | 00:30 | You're going to see a number of suggested templates
here and as you scroll down, the list is not all that extensive.
| | 00:36 | But there are number of different categories and formats.
| | 00:40 | The default is a Blank Presentation.
| | 00:42 | So, you're going to start from scratch.
| | 00:44 | All you do is click Blank presentation
and you're off to the races.
| | 00:47 | But I as I mentioned,
you have access to thousands of Templates.
| | 00:51 | Up at the top is where you go
to search for online Templates and Themes.
| | 00:56 | Now, if you wanted to quickly go to any one
of the categories next to Suggested searches,
| | 01:01 | you simply click them.
| | 01:02 | If you're looking for a Business presentation,
maybe Charts and Diagrams,
| | 01:06 | look at Medical, Nature, etcetera, just click
those and automatically PowerPoint
| | 01:11 | will search online, through the thousands of
Templates available for that category.
| | 01:16 | If you prefer, you can be more specific by clicking
in the field and typing in a keyword or two.
| | 01:22 | Let's say we want to create some kind
of marketing presentation.
| | 01:26 | We could type in the word, marketing.
| | 01:28 | When you press Enter, you're going to notice
that PowerPoint does search through
| | 01:33 | thousands of online Templates and will come up with a list;
| | 01:36 | including a category list over here on the right-hand side.
| | 01:40 | If you notice, marketing over here has a hundred 127.
| | 01:42 | Now, as we scroll through these,
you're going to notice each of them has a title.
| | 01:47 | But if you want more information about a thumbnail
you're looking at, all you have to do is click it.
| | 01:52 | So let's scroll through our list here
and when we get to this one called
| | 01:56 | Currency design (wide screen), we'll give it a click.
| | 02:00 | This allows you to see a nice view of the title slide.
| | 02:03 | Here's a Title Layout.
| | 02:04 | There are some information over here about this template.
| | 02:07 | You notice there's a Rating as well.
| | 02:10 | And you have access to more images.
| | 02:12 | In other words, a sneak peek at some of
the other slides in this presentation.
| | 02:16 | So, let's click the arrow pointing to the right
to go to the next slide, the next slide, and so on.
| | 02:21 | So, if you think it's something that you
are going to want to use, well,
| | 02:27 | you can go to Create it right away or
notice there's a little push pin here.
| | 02:31 | If this is something you're going to come back to,
you can pin the Template and
| | 02:35 | it will always show up without having to search
on that main screen of templates
| | 02:39 | when you go to Create a new presentation
or launch PowerPoint.
| | 02:44 | Now, if you want to just simply go to the
next thumbnail, you could do so from here.
| | 02:48 | You don't have to close this up.
| | 02:50 | Just click the navigation buttons that appear
on the right-hand side and the left-hand side,
| | 02:54 | to go through each of them with detailed information.
| | 02:59 | When you're done, you can, of course,
create your presentation based on that Template
| | 03:03 | or simply close this up to go back to the list.
| | 03:06 | Select another Category for example,
and you'll see some different choices.
| | 03:13 | Now, if at any time you want to go back,
just click the Back button
| | 03:16 | in the top left-hand corner of the screen, you're back
where you started when you launched PowerPoint.
| | 03:21 | That's a quick look at just a few of the thousands of Templates
| | 03:25 | you have available to you here online, in PowerPoint 2013.
| | Collapse this transcript |
| Exploring the new Presenter view| 00:00 | As a person who does a lot of presenting, this next
new feature in PowerPoint 2013 is my personal favorite.
| | 00:06 | It's called Presenter View.
| | 00:08 | We're going to take a look at it now using our
| | 00:11 | No Obstacles PowerPoint presentation.
| | 00:13 | So, if you have the exercise files,
you can open it up, but really,
| | 00:16 | it doesn't matter what presentation
you're looking at to use Presenter View.
| | 00:20 | All it means is as a presenter, you'll be able to see
more information on your screen
| | 00:24 | than what your audience sees,
say on a projected screen or on another monitor.
| | 00:29 | Of course, you'll need two monitors.
| | 00:32 | Typically, I'm presenting with a laptop.
| | 00:34 | I have my own monitor on my laptop
and a projector plugged in.
| | 00:38 | That's the second monitor.
| | 00:39 | But even if you don't have two monitors, you can take
a sneak peek at Presenter View by using a little trick.
| | 00:45 | First of all, let's go up to the Slide Show tab
and notice that there is a checkbox next to
| | 00:50 | Use Presenter View.
| | 00:53 | And as you hover over that,
Presenter View will automatically kick in.
| | 00:57 | If you have two monitors, you'll be able to see
something different on your screen
| | 01:00 | and the audience will see the presentation itself.
| | 01:03 | But notice that we can use a shortcut key
called Alt+F5 to try out Presenter View.
| | 01:09 | So, let's do that instead of running the presentation.
| | 01:12 | Alt+F5 gets you into Presenter View. Now check it out.
| | 01:18 | We're looking at our very first slide.
| | 01:20 | This is what the audience sees, just simply the slide
on their monitor or on the big screen using a projector.
| | 01:27 | What they don't see is a timer that's running,
so the timer, as a speaker,
| | 01:32 | is a great way to keep track of how much time
you've spent on the presentation and
| | 01:37 | how quickly you need to move through the remaining slides.
| | 01:40 | You'll see that information down below.
| | 01:42 | In this case we're at Slide 1 of 6.
| | 01:44 | We can move from slide to slide
using these navigation buttons.
| | 01:49 | So let's go to Slide 2, for example.
| | 01:51 | Notice that we get a Preview of the next slide.
| | 01:54 | This is a great way to speak about the contents
of one slide and know what's coming next.
| | 01:59 | Your audience doesn't, and you can segue
into that next slide.
| | 02:03 | If you have notes as well, you'll see notes
just below that next slide. I like that.
| | 02:09 | And if you're having difficulty reading those notes,
notice that you have the ability
| | 02:13 | to bump up the text to a larger font.
| | 02:16 | Right now I have no notes.
| | 02:18 | You can also knock it down if you want
to be able to see more of your notes.
| | 02:22 | And then over here in the left, we have access to
those usual tools, for example,
| | 02:26 | the Pen and Laser Pointer tool.
| | 02:28 | So, if you want to highlight something on a slide,
of course, your audience will see that,
| | 02:33 | but what they don't see is the list of tools down below.
| | 02:36 | If you want to see All your slides, you can give that a click.
| | 02:40 | This gives you an opportunity to see
all of the slides in your presentation.
| | 02:43 | Meanwhile, your audience is seeing the current slide.
| | 02:47 | You can jump to a slide this way
without having to show every single slide in order.
| | 02:51 | Just give it a click and you're looking at that slide.
| | 02:56 | Notice we also have the magnifying glass to zoom in to
the slide if we wanted to see something in more detail.
| | 03:03 | We also have the Black or Unblack Slideshow.
| | 03:06 | So, if there are going to be questions, for example,
you don't want people reading the slide,
| | 03:10 | just click that to Black it out.
| | 03:12 | Click it again to bring it back.
| | 03:14 | And then you'll also see this typical icon
that we're used to seeing here in the New Office Suite,
| | 03:20 | which means More Options.
| | 03:22 | Clicking this will show you
more slideshow options in a pop-up.
| | 03:26 | We can End the Show right now,
we can change the Screen to White,
| | 03:30 | Hide Presenter View if we wanted to,
go back to the Last Viewed slide by clicking that.
| | 03:35 | There are lots of options here in Presenter View;
a lot of options that your audience won't see,
| | 03:40 | but will give you a nice advantage
when speaking in front of an audience.
| | Collapse this transcript |
| Using color adjustments| 00:00 | When working with objects like images here
in a PowerPoint presentation,
| | 00:04 | you have the ability to make color adjustments.
| | 00:07 | In the past, the color adjustment tools
haven't always been clearly labeled
| | 00:12 | or easy to use and understand.
| | 00:14 | Here in PowerPoint 2013 things have changed,
so we're going to explore that
| | 00:18 | using our No Obstacles PowerPoint presentation.
| | 00:21 | Over on the left-hand side, looking at
the thumbnails let's click slide #4
| | 00:25 | where we do have a couple of images.
| | 00:28 | So let's make some color adjustments
beginning with the image on the right,
| | 00:32 | our snow covered mountain.
| | 00:33 | We'll click there and as soon as we
select an image like this, you'll notice
| | 00:37 | Picture tools appear on the ribbon
with Format underneath. Let's click there.
| | 00:41 | Now we have a number of picture formatting options,
including Picture Styles,
| | 00:45 | Layout Effects, Borders,
but we're going over to the left-hand side here
| | 00:50 | and focus on Color Adjustments.
| | 00:51 | When we click, you'll notice the improvements
I was talking about.
| | 00:55 | First of all we have categories like Color Saturation.
| | 00:58 | On the far left, you'll notice no color at all or 0% saturation,
| | 01:03 | representing black and white.
| | 01:04 | And as we hover over these, we see a live preview
on the slide itself.
| | 01:09 | This is what it would look like in black and white.
| | 01:11 | As we move over to the right,
you can see the color is increased, 200%, 300%,
| | 01:17 | even 400%, with a high saturation,
it's not a realistic looking photo anymore
| | 01:22 | but maybe a little more artistic.
| | 01:25 | Let's leave it right down the middle at 100%.
| | 01:28 | Next, you'll see Color Tone and color tone
allows you to cool down an image or warm it up.
| | 01:33 | As we go to the very far right,
looking at the warmest temperature you can see
| | 01:37 | how the image on the slide itself has really warmed up.
| | 01:40 | Go to the far left and you could see it's cooled down.
| | 01:44 | I think because we're on a snow covered mountain
maybe we should cool this down
| | 01:48 | a little bit, let's go to temperature 5300K. Give that a click.
| | 01:53 | We'll go back to our Picture tools now
with Format and click Color
| | 01:59 | and notice that we also have the ability to recolor.
| | 02:02 | Now, the default is No Recoloring,
right here in the top-left corner.
| | 02:06 | But as we hover over these other ones,
we could see Grayscale, Sepia,
| | 02:09 | you can see some Green Accent, Orange Accent,
some cool effects none of them actually improve our image.
| | 02:17 | So we'll just leave it at no recoloring.
| | 02:20 | Give it a click and there's our finished product.
| | 02:23 | Let's go to this other image now.
| | 02:25 | On the left-hand side, select it and we'll go to Color.
| | 02:30 | And maybe that would look better in Grayscale
with 0% Color Saturation you can see in the background.
| | 02:36 | Not a bad effect or maybe it would look better
with more saturation.
| | 02:40 | I actually like the 300%.
| | 02:43 | Let's give that a click, very nice.
| | 02:46 | Let's click anywhere off the slide to deselect the image
| | 02:49 | and you can see how much easier it is to understand
what you're doing with those color tools,
| | 02:54 | thanks to the labeling, and a lot easier
to apply with the live preview.
| | Collapse this transcript |
| Inserting new charts| 00:00 | Inserting and editing charts into a PowerPoint
presentation gets much easier
| | 00:04 | here in PowerPoint 2013 with some intuitive tools
we're going to explore as we
| | 00:08 | continue to work with our No Obstacles
PowerPoint presentation.
| | 00:12 | If you have been following along we're going to Slide 5.
| | 00:15 | If you've jumped to this lesson you can
open up No Obstacles PowerPoint2 and
| | 00:19 | click the thumbnail down the left-hand side
for Slide 5 and you can see we
| | 00:23 | actually have some data here, we just don't have
the chart on the right-hand side of our data yet.
| | 00:29 | So to insert a chart, we can go to the Insert tab,
but in this case we have a
| | 00:32 | slide layout that includes an actual placeholder
here for many different types of objects,
| | 00:37 | including as you can see, an Insert Chart icon.
| | 00:41 | So let's get our data ready first.
| | 00:43 | Let's just click and drag across all of the
data in the table that appears on this slide.
| | 00:48 | So, clicking and dragging from the
Week heading in column one on the left,
| | 00:52 | across and down to highlight all of that, let's copy it.
| | 00:56 | You can use Ctrl+C on your keyboard or right-click
and choose Copy, however, you like to do it.
| | 01:00 | It's now in the clipboard waiting for us to paste it.
| | 01:04 | Well, we're going to paste it into our new chart
that needs to be inserted now.
| | 01:09 | So we'll go over to the placeholder here,
and click the Insert Chart icon,
| | 01:14 | which is going to analyze our data and give us a default
recommendation, which is our Clustered Column here.
| | 01:21 | So you can see Column in the categories on the left-hand side.
| | 01:24 | Select it, the first option, Clustered Column,
and as we move in to the thumbnail,
| | 01:28 | we get a nice preview, zoomed right in
so we get a feel for what we're about to create.
| | 01:33 | Of course we can go to other types of charts,
some of them may or may not apply.
| | 01:37 | Bar would work nicely, so would Area,
but let's go back to Column
| | 01:42 | and choose the 3-D option here, 3-D Clustered Column.
| | 01:45 | Even though we're only going to have one
series of data, it's going to look pretty good.
| | 01:50 | If we select this option, we'll move down
inside the thumbnail to preview it. Great!
| | 01:54 | We'll click OK and watch what happens.
| | 01:56 | It's going to create a chart, but not based on
our data, it's going to use some sample data.
| | 02:01 | You can see there's actually three Series of data
and you can see four Categories by default.
| | 02:06 | Let's not worry about that right now.
| | 02:07 | Let's just remove it all by clicking and dragging
from cell A1 across to column D down to row 5,
| | 02:14 | hit Delete on your keyboard to remove all of that.
| | 02:17 | You can see what happens, a live preview back here,
we have no data now.
| | 02:21 | And we're about to paste in the data
we copied a little bit earlier.
| | 02:26 | So let's click in cell A1, next we'll paste,
you can use a keyboard shortcut
| | 02:30 | Ctrl+V like I am, or right-click and Paste.
| | 02:33 | And you can see what's happening here,
we're seeing the beginnings of our chart.
| | 02:37 | But if we were to expand this window here
where we see our data, let's go to the bottom.
| | 02:42 | When you see the double arrow, click and drag it down,
| | 02:45 | so that we're actually looking at all of the rows.
There they are.
| | 02:49 | You can see that the area being used to create our chart
is still representing the sample data.
| | 02:54 | We need to adjust that.
| | 02:56 | So let's go to the bottom-right corner,
when you see the double diagonal arrow,
| | 02:59 | just click and drag across and down.
| | 03:02 | And now we have a single series of data,
we have our headers at the top,
| | 03:07 | and you can see we have our labels down the left.
| | 03:09 | That's the default setup here for our chart.
| | 03:12 | So let's close this up,
it's going to take us back to our slide
| | 03:16 | and you can see the end result looks pretty nice.
We have our Ad Clicks.
| | 03:20 | You could see there labels across
the bottom for each of the Weeks.
| | 03:24 | We also have this Axis title.
| | 03:26 | The other thing that's happening though
that's very cool here in PowerPoint 2013
| | 03:29 | is we're getting these icons off to the right
where we can adjust things like Chart Elements.
| | 03:35 | Adding, removing, or changing any elements
like titles and legends and so on.
| | 03:40 | Next we have this Paintbrush icon
for adjusting Chart Styles
| | 03:44 | and the funnel for Filter options.
| | 03:46 | We're going through each of this now.
| | 03:48 | This helps us to create the exact chart we need
quickly and easily without having to go through the ribbon.
| | 03:54 | We still have all of our Design options up here on the ribbon,
| | 03:57 | our Formatting options if we click the format tab.
| | 03:59 | But we have quick access to many of these tools
right from our chart area.
| | 04:04 | So let's start with the Elements.
| | 04:06 | We'll click the plus sign and you'll see
check marks next to current elements
| | 04:10 | that are already appearing in our chart.
| | 04:12 | We have the Axis, we have our Chart Title,
which is Ad Clicks, you can see
| | 04:17 | we have Gridlines here and they're horizontal
going from left to right,
| | 04:21 | makes it a little bit easier to read the values
for each of the bars, and we also have
| | 04:25 | a Legend down at the bottom that
says Ad Clicks, maybe we don't need that
| | 04:29 | because it's really the same as our Title,
so we'll just deselect it by clicking the check mark.
| | 04:35 | Our Gridlines look good.
| | 04:37 | But any time you move to one of these
and see an arrow off to the right
| | 04:40 | means there might be other options
besides just turning it on or off.
| | 04:44 | So if we click the arrow, you can we have
Horizontal and Vertical options as well.
| | 04:49 | As we hover over these we see a live preview.
| | 04:52 | I don't know if it really makes sense to show
the Vertical whether they're major or minor.
| | 04:58 | I think what we have here with just the
Primary Major Horizontal is probably good enough.
| | 05:03 | If you wanted to add the Minor Horizontal,
go ahead and click that check box.
| | 05:06 | Makes it a little bit easier to read the finer details
for each of the bars and
| | 05:10 | get a feel for the values, as you move from left to right.
| | 05:13 | Okay, let's go back here.
| | 05:16 | As we go to Data Labels and start hovering
over these you could see a preview,
| | 05:20 | a live preview in the background.
| | 05:21 | The Data Table, I am kind of interested
in the Data Labels, because not only do
| | 05:28 | you see the bar but you see the actual figure
right above the bar, but it does
| | 05:31 | look a little bit crowded in there
with those numbers, so let's leave those off
| | 05:35 | and we'll go to the Axis Titles here.
| | 05:38 | Now we'll turn these on, but we'll figure out
exactly which titles we need,
| | 05:44 | I don't think we need one down the left,
it's just a number of Ad Clicks,
| | 05:48 | but across the bottom, those are the Weeks.
| | 05:49 | So let's go over to our little arrow
that appears next to Axis Titles here,
| | 05:54 | with it turned on, give it a click
and let's turn off for example, the Primary Vertical.
| | 06:02 | We don't need that one, we do want
to keep the one at the bottom,
| | 06:05 | which is our Primary Horizontal,
but we're going to change it, of course.
| | 06:08 | So go right in there, click and drag over the Axis Title
and type in a real title, which is Weeks.
| | 06:16 | Perfect. We'll click in the background now
and that looks pretty good.
| | 06:19 | Now this is an object we can adjust,
so let's give it a click, we'll go right to
| | 06:23 | the border and click again so we know
that everything is selected here,
| | 06:27 | let's just stretch it out a little bit to the right.
| | 06:30 | And we still have our buttons here on the right-hand side;
| | 06:32 | let's go now to our Chart Styles. Give it a click.
| | 06:35 | You'll see some styles that you can hover over
and see a live preview,
| | 06:41 | if there's something you like better,
you can select it like Style 3.
| | 06:44 | There are more that you can scroll down to,
if you need to, until you find
| | 06:48 | the one that suits your needs the most.
| | 06:50 | I like that third one.
| | 06:53 | As we hover over it you can see a label Style 3,
let's give it a click.
| | 06:58 | So that's locked in, we can also adjust color.
| | 07:01 | Now when we're only working with one
series of data really the Color style
| | 07:06 | that we're about to select will represent the
bars typically, and as we move down
| | 07:11 | you can see there's not a lot of variation here.
| | 07:14 | So I think we're okay.
| | 07:16 | this one here at the very top is a perfect match
for our table and the rest of our slide,
| | 07:21 | so let's just make sure it's still selected,
and we'll move on to filtering data now.
| | 07:26 | Maybe you don't need all of these bars,
maybe just every second Week would be fine.
| | 07:30 | Let's go to the filter icon give it a click
and now you could see some
| | 07:35 | filtering options showing up here.
| | 07:37 | For example, under Series we're looking
at all the series, that's great,
| | 07:41 | we do want to see all of our series,
there's only one and that's Ad Clicks.
| | 07:44 | But under categories you could see each
of the Weeks and they are all selected.
| | 07:48 | So if we click the check mark
next to Select All, they're deselected.
| | 07:52 | Maybe we just want to see every few weeks.
| | 07:55 | Let's go to 3, 6, scroll down to 9, and 12 and click Apply.
| | 08:05 | Now let's go back over here to our slide
and you can see it's a much simpler looking,
| | 08:09 | but we still get the trend that's happening here
over the various weeks.
| | 08:14 | Look at the Labels across the bottom
representing the one's that we checked off.
| | 08:18 | Just another way to change the look and feel
of our chart quickly and easily
| | 08:23 | with those tools, they're readily accessible next to our chart.
| | 08:27 | All you have to do is click the object to see
those tools pop up if you want to make any changes.
| | 08:32 | It's a nice improvement here in PowerPoint 2013
when working with charts.
| | Collapse this transcript |
| Positioning objects with various guides| 00:00 | Much like the Alignment Guides
we took a look at in the Word chapter,
| | 00:04 | here in PowerPoint 2013, there are alignment guides
that will pop up to help you align your objects
| | 00:08 | in relation to one another,
as well as in relation to the slide itself.
| | 00:14 | We're going to take a look at those now
as we continue to work with our
| | 00:16 | No Obstacles PowerPoint presentation.
| | 00:18 | We're actually going to Slide 3 over here on the left and click.
| | 00:22 | If you jumped to this lesson you can get all caught up
by going to the
| | 00:25 | No Obstacles PowerPoint3 presentation
in your exercise files.
| | 00:29 | Here in this slide we actually have three objects.
| | 00:31 | If we click inside the title you can see this is a text box.
| | 00:34 | There's another text box down below,
and we have our object which is a graphic
| | 00:40 | object at the very bottom, our sport logo.
| | 00:42 | So if we want to align these on our slide,
and get them lined up properly
| | 00:46 | in relation to one another, all you have to do
is start clicking and dragging them around.
| | 00:50 | The alignment guides will appear and they'll actually
have a little bit of magnetism to them.
| | 00:54 | In other words, as you're dragging them,
they will kind of stick to those guides temporarily
| | 00:58 | as you come across something.
| | 01:00 | Let's see what I'm talking about by going to the border here.
| | 01:03 | When you see the four sided arrow,
click and start dragging and when you move
| | 01:07 | to the center for example, of the slide, you're going to
see an alignment guide right down the middle.
| | 01:13 | As you move a little further to the right,
you can see it's lined up now on the left
| | 01:16 | with the other object down below.
| | 01:19 | As we move further on and down, you can
see it's actually lined up on the left,
| | 01:23 | and at the bottom you'll see an alignment guide
making sure that we don't
| | 01:28 | go past that and into the next object.
| | 01:30 | So now we're lined up not with the bullet itself,
but with the content that appears after the bullet,
| | 01:35 | lots of options here.
| | 01:37 | So let's it lined up in the center of our slide,
when you see the alignment guide at the center
| | 01:42 | and we want to move down until we see the alignment guide
| | 01:45 | going across the bottom, ensuring that we're lined up
properly in relation to the object below, release.
| | 01:52 | And now we're going to do the same
with our next object, another text box.
| | 01:55 | We'll go to the border, we want to make sure
that it also is centered and you
| | 02:00 | can see as soon as you click,
it's perfectly placed in the middle
| | 02:05 | and in relation to the object above and below,
it's spaced properly.
| | 02:09 | So we can release and now start to work
on our graphic logo down below.
| | 02:14 | So we'll click on that and let's just
drag it around a little bit until we see
| | 02:19 | it's centered and we want to see that
horizontal guide also across the top,
| | 02:24 | indicating that we're not going to be
going into the next object,
| | 02:29 | into its space where we shouldn't be.
| | 02:30 | So perfectly centered right there, and lined up
with the object above, release,
| | 02:36 | deselect by clicking anywhere on the slide
and that's how easy it is to get things lined up
| | 02:41 | on a slide using alignment guides.
| | 02:43 | It's a great feature that will save you some time
when you're trying to work with multiple objects on a slide.
| | Collapse this transcript |
| Exploring new transition effects| 00:00 | One of my favorite new enhancements
here in PowerPoint 2013 are the new
| | 00:04 | transition effects that you have available to you.
| | 00:07 | There are a number of new ones;
| | 00:08 | actually there are nine new ones,
since the customer preview even.
| | 00:11 | So we're going to look at them now and
we're going to continue working with our
| | 00:15 | No Obstacles PowerPoint presentation,
if you've been following along,
| | 00:17 | we're going to Slide 2 here on the left-hand side.
| | 00:20 | That'll allow us to see a live preview as we
select transitions from Slide 1 to Slide 2.
| | 00:26 | Now if you're getting caught up,
you can open up No Obstacles PowerPoint 4.
| | 00:30 | Next we'll go to the Transitions tab,
now from here you do see a partial list
| | 00:35 | and these are you're standard transitions
that you're probably already familiar with,
| | 00:39 | but click the drop down to see a number of new ones.
| | 00:42 | Like one of my favorite in the exciting category here,
Curtains, let's give it a click.
| | 00:48 | Now what you're going to see are
the Curtains opening up from Slide 1,
| | 00:52 | transitioning over to Slide 2, I like that one.
| | 00:56 | Let's try another one, now we see a
different partial list on the ribbon,
| | 01:00 | let's try Drape, very similar and you could see
it just drapes down over into the next slide.
| | 01:06 | How about Fall Over, kind of cool.
| | 01:11 | Some other new ones include Prestige
and Fracture, that's cool!
| | 01:19 | Add a sound effect and it's even cooler,
and how about Crush?
| | 01:24 | Crumpling up the paper and we transition to the next slide.
| | 01:27 | Now you will notice that some of these
have effect options, with Crush selected,
| | 01:31 | you can see the Effect Options button
is not available to us, that's the only
| | 01:35 | option available to you is what you see.
| | 01:37 | If we go to Fracture, same thing,
when we go over to Prestige or Wind,
| | 01:46 | finally we see that the Effect Option is available to us.
| | 01:49 | So if we click the dropdown, you can
actually change the direction of the wind,
| | 01:53 | either from the right or the left, let's try left, there we go,
everything is blown off to the left-hand side.
| | 02:00 | Let's click the dropdown now one more time and check out
another new one called Origami, kind of neat.
| | 02:09 | If we wanted to apply that to all of the slides
in our presentation,
| | 02:13 | we simply click the first slide over here
in the left-hand side in the navigation pane,
| | 02:18 | hold down Shift+Click the last one
and let's go up to our dropdown
| | 02:23 | for our Transitions and select our favorite.
| | 02:25 | So if yours is Origami, go ahead and select it,
I really like curtains, so I'm going to select that one.
| | 02:31 | Again, we get to see a preview of what
that looks like, and you'll notice now
| | 02:35 | over here in the navigation pane, we do
see transition icons next to each one,
| | 02:40 | representing the animations we just applied.
| | 02:43 | So those are some of the transitions,
experiment with them all to get a feel for
| | 02:48 | what you now have here available to you in PowerPoint 2013,
when transitioning from one slide to the next.
| | Collapse this transcript |
| Creating a custom shape| 00:00 | Inserting shapes into a slide in a PowerPoint
presentation is nothing new
| | 00:05 | but creating your own custom shapes
by merging two or more shapes is,
| | 00:09 | and that's what we're going to do right now
as we continue working with our
| | 00:13 | No Obstacles PowerPoint presentation.
| | 00:14 | Next we're going to scroll down the navigation pane
on the left and click Slide #5 to go there.
| | 00:21 | If you jumped to this lesson and you
need to get caught up, go ahead and open up
| | 00:24 | No Obstacles PowerPoint 5
from your exercise files to see what I see.
| | 00:28 | So we're going to add our own graphic here
something that just shows the trend here in our graph.
| | 00:34 | So let's use this white space to create our own
custom shape, we begin by inserting existing shapes.
| | 00:40 | So the Home tab needs to be selected
on the ribbon, over here in the drawing
| | 00:44 | section is where you find all of your shapes,
click the dropdown to see the full list,
| | 00:49 | and let's begin with a simple Basic Shape, the Oval.
| | 00:53 | When we click that we can now hold down our Shift key
as we click and drag to create a perfect circle.
| | 00:58 | So hold down shift on the keyboard, click and drag
diagonally until you get a nice sized circle.
| | 01:03 | Let go of your mouse button first and then
the shift key to maintain that perfect shape.
| | 01:09 | That's just a basic shape, but we're going to create
our own custom shape by combining it with another shape.
| | 01:14 | So let's go to that drop down again,
down to the Block Arrows and let's
| | 01:18 | choose this one here as we hover over it,
it says Stripped Right Arrow, give it a click.
| | 01:24 | And now in this white space we'll click and
drag across and down to create a nice fat arrow.
| | 01:30 | And when we release we can now do things
with this shape like rotate it.
| | 01:34 | Let's rotate it so it's facing up and down,
hold down your shift key if you want
| | 01:39 | to see it snap into position
and then let go of your mouse first again.
| | 01:43 | Now we're going to combine these two
and we're going to click and drag our arrow
| | 01:47 | over on top of our circle, and we see
them lined up in the middle with that
| | 01:51 | little guide line showing up,
you'll know you're in the right spot and we want
| | 01:56 | the stripped part of the arrow to fit inside the circle.
| | 01:59 | So we'll let go there and now we have
our two shapes, which we can merge
| | 02:03 | together using different options.
| | 02:06 | So with our arrow already selected, hold down your shift key
and click the circle, so they're both selected.
| | 02:12 | To create our custom shape, now all we
have to do is go up to the Format tab here
| | 02:16 | that appears whenever we select a shape
like this under Drawing tools.
| | 02:20 | Clicking it displays on the left-hand side
the Insert Shapes area
| | 02:25 | including the new part which is Merge Shapes,
click that dropdown to see the different options.
| | 02:31 | And what I really like is we don't have to
select each one this to see what's it
| | 02:35 | going to look like, we get a
live preview as we hover over them.
| | 02:38 | For example, as we hover over Union,
you can see what happens.
| | 02:41 | They're joined together as one shape,
and that's not bad, kind of cool,
| | 02:46 | we can rotate it around, let's go down
to Combine and see what happens.
| | 02:50 | Now as we hover over Combine, you can
see what's happening here, we actually see
| | 02:54 | the stripes and spaces made, so there's a gap between
the areas that are merged together and touching.
| | 03:00 | Move down to Fragment and we get the exact opposite.
| | 03:05 | All of the shapes will be separated into their own shapes
if we select Fragment, so you actually end up
| | 03:11 | with not just one shape, but multiple shapes,
we'll have our circle, we'll have our stripes,
| | 03:15 | we'll have our arrows and then we can move
those around together or separate them if we want.
| | 03:20 | Let's go down to Intersect,
in this case all we're going to get is a new shape
| | 03:24 | based on the intersecting points of our
two shapes, kind of a looks like burger.
| | 03:29 | And then down at the end we have Subtract,
this one's kind of cool, you could see that
| | 03:34 | the second shape we selected is going to be used to
subtract from the first shape, which was our arrow.
| | 03:39 | That's kind of interesting.
| | 03:41 | I like that so let's give it a click.
| | 03:43 | Now we're left with our Custom Shape
and of course we can do all the normal things
| | 03:48 | that we can do with any shape, like resize it,
let's stretch it out a little bit and let's rotate it,
| | 03:55 | there's the rotate handle if you wanted to.
| | 03:57 | We could recolor it all of the formatting options
available here on the format tab with a ribbon
| | 04:02 | are available to us with our custom shape.
| | 04:05 | I'm just going to squeeze it together
a little bit and now let's just drag it down
| | 04:09 | on top of our graph, so we can show
the trend for our Ad Clicks
| | 04:14 | as the Weeks go by, going in the right direction.
| | 04:17 | We'll just click off to the side here
to deselect it and there's our finished product,
| | 04:21 | using a brand new feature called Merge Shapes
to create our own custom shapes
| | 04:26 | from the existing shapes available to you here
in PowerPoint 2013.
| | Collapse this transcript |
| Playing an audio track across multiple slides| 00:00 | Playing an audio file across multiple slides in a presentation
was somewhat difficult in previous versions of PowerPoint,
| | 00:07 | here in PowerPoint 2013; it's become a whole lot easier.
| | 00:11 | That's what we're going to explore
as we continue to work with our
| | 00:15 | No Obstacles PowerPoint presentation
and we'll click on Slide 1 here,
| | 00:18 | because this is where we want to begin.
| | 00:20 | A typical scenario for playing an audio track in the
background across multiple slides is a kiosk environment.
| | 00:27 | And in that case we have a slide presentation
that's kind of playing on its own,
| | 00:30 | looping around when it gets to the end.
| | 00:33 | So that's the first thing we're going to set up
for our presentation here.
| | 00:36 | Let's go up to the Transitions tab.
| | 00:39 | We've already applied special effects,
the transition from one slide to a next.
| | 00:44 | But over here in the timing section
is where we want to turn off On Mouse Click,
| | 00:48 | so nobody needs to click a slide
to go from one to the next,
| | 00:52 | it's automatically going to happen after, however many
seconds we choose over here on the right-hand side.
| | 00:57 | So we click the check box for After,
we'll bump this up to say, 2 seconds,
| | 01:03 | which isn't realistic but it will allow us
to see the transition and hear our audio track
| | 01:07 | that we're going to insert momentarily
playing in the background.
| | 01:11 | Let's click Apply To All, now you'll notice
up here for sound that there is no
| | 01:16 | sound and that applies to the
transition itself, that's not what we want.
| | 01:20 | We actually want to insert an audio track
to play in the background,
| | 01:24 | and to do that we go to the Insert tab.
| | 01:27 | From here way off to the right you'll see
the Media section where, just like we saw in Word,
| | 01:31 | we could insert Online Video or video
that you already have located on your PC,
| | 01:37 | same thing for Audio when we click there.
| | 01:40 | We could go get audio that's online
and insert it into our presentation
| | 01:44 | or if we have the file on our PC, we can do that as well.
| | 01:47 | You can even record your own audio.
| | 01:49 | Let's choose Audio on my PC.
If you have the exercise files,
| | 01:54 | in the PowerPoint folder you'll find one.
There it is, the No Obstacles Theme.
| | 01:58 | Notice it's all audio files that are being shown here,
MP3 files, wav files for example.
| | 02:04 | We're going to select No Obstacles Theme
and we're going to click Insert.
| | 02:08 | Now when we do that we see the speaker icon,
which typically we need to click to play our music.
| | 02:14 | We have some controls that we have access to.
| | 02:17 | If we want it to pump up the volume or mute it
out if we needed to for example.
| | 02:21 | We could do all of that from the presentation itself.
| | 02:24 | But in a self playing presentation,
we want to make some changes,
| | 02:27 | we want this play in the background
and we want it to continue playing
| | 02:30 | across all of the slides in our presentation.
| | 02:33 | Now we could go into the Audio options with
the Playback tab selected here and start doing things;
| | 02:39 | changing it from On Click, choosing Play Across Slides
and Looping, but it just
| | 02:44 | got so much easier here in PowerPoint 2013.
There's one button that does all of this.
| | 02:49 | It's the Play in Background button.
When we click that look what happens.
| | 02:53 | It's going to start Automatically.
| | 02:56 | It's going to Play Across Slides;
| | 02:58 | it's going to Loop until it's Stopped.
| | 03:01 | Even the controls we see here in the
speaker icon will be hidden during the show.
| | 03:05 | All of this is done for you with one click
of the Play Background button.
| | 03:10 | That's the new feature that I really enjoy.
| | 03:13 | So we don't have to worry about moving this around,
getting out of the way, sizing it down, etcetera.
| | 03:18 | We won't even see it when we go to play our presentation.
| | 03:21 | So let's test it out. All of the other options
are still available to us here
| | 03:25 | that we are accustomed to. For example;
| | 03:27 | if we wanted to we could bump the Volume down a little bit,
so you can hear me talking over it.
| | 03:32 | I'm going to choose Low and now
it's time to play our presentation.
| | 03:36 | So if it was a kiosk environment,
we'd get it started knowing that it's going
| | 03:40 | to loop around through the slides
nd we should be hearing audio in the background
| | 03:44 | from one slide to the next.
| | 03:46 | Let's give it a try by using the View buttons
down at the bottom of the screen here,
| | 03:50 | we'll click the Slide Show button and sit back and relax.
| | 03:53 | When were done we'll just hit the Esc key
on the keyboard to come back.
| | 04:00 | (presentation playing)
| | 04:11 | So there's our Transitions, and notice the music
continues from one slide to the next, uninterrupted.
| | 04:17 | Let's press Esc to go back to our presentation
and that's how we add background music
| | 04:23 | to a presentation that will play across multiple slides.
It's so much easier here in PowerPoint 2013.
| | Collapse this transcript |
|
|
5. AccessExploring changes to the user interface| 00:00 | If you've installed Office 2013 Professional
or Professional Plus,
| | 00:04 | you'll have access to Microsoft Access 2013.
| | 00:08 | If you're using the Home & Student
or Home & Business versions,
| | 00:11 | you won't have access,
but you can get it with the cloud Editions.
| | 00:16 | Every single cloud editions of Office 365
include Microsoft Access.
| | 00:20 | We're going to take a look at it now.
There's not a whole lot new that's going on with Access,
| | 00:24 | but when we launch it, we will see that first new option
| | 00:28 | that we're used to seeing with
all of the programs in the Office Suite,
| | 00:32 | and this is this welcome or start screen.
| | 00:34 | Here on the left-hand side, you will see
Recent documents you've worked on.
| | 00:38 | You'll also have Access to Open your files
from here and you'll see a list of Templates,
| | 00:43 | which we'll talk about in the next lesson.
| | 00:46 | Also in the top right-hand corner,
you'll see your Current Login information
| | 00:51 | if you are logged in to your Microsoft Account
and at the top you'll see the Help option,
| | 00:56 | as well as your Minimize, Maximize and Closed buttons
for closing this up when you're done.
| | 01:03 | Now, all we're going to do to get started
is start a Blank desktop database.
| | 01:07 | One of the things you'll notice with the templates here
is that, the default is now a Custom web app.
| | 01:13 | So Access continues to move in the direction
of a web development application
| | 01:18 | as opposed to a database application,
but we're going to click the next option,
| | 01:22 | which is Blank desktop database,
we'll give it a name, let's call it,
| | 01:27 | No Obstacles Customer and click Create
and this takes us to a brand New Blank
| | 01:38 | database ready to start adding records.
| | 01:41 | We have all of the ribbon that
you're used to seeing across the top.
| | 01:44 | We have the File tab going back here.
| | 01:46 | This does look a little bit different from previous versions.
| | 01:49 | You'll see Info at the top.
| | 01:51 | You'll also see the new option,
which gets us back to those templates.
| | 01:55 | Here's where we go to Open, Save, Save As,
Print and if we wanted to close
| | 02:00 | any files we're working on,
in this case our brand new customer database,
| | 02:04 | we could close it from here.
| | 02:05 | We have access to our Account options and
other options from this Start screen as well.
| | 02:10 | Let's just go back.
| | 02:13 | Also on the ribbon you'll see your Home tabs,
Create External Data.
| | 02:18 | Over here in the right-hand side under Table tools
you'll notice this Field and Table highlighted
| | 02:22 | because that's what we're doing.
| | 02:24 | We're starting to create brand new fields in
our first table here in our New blank project.
| | 02:30 | Across the bottom, you'll see your
navigation buttons for moving through
| | 02:34 | the various records once you start to add them,
and there's our View buttons down on
| | 02:38 | the bottom right-hand corner.
| | 02:39 | Currently selected you'll see the data sheet view,
if we want to go to Design view,
| | 02:42 | we can click there, we'll have to give our table a name
if we want to do that,
| | 02:47 | so let's click Cancel and remain in data sheet view.
| | 02:51 | Again, we have this new flat look, so we
don't see the buttons on the ribbon
| | 02:56 | for example, with that 3D effect.
| | 02:58 | All of the tabs and the ribbons,
all flat against the background,
| | 03:02 | two-dimensional our Quick Access toolbar
in the top left corner as well.
| | 03:07 | Now, when we're done, we just simply
click the Close button.
| | 03:09 | We haven't actually done anything,
there's nothing to Save
| | 03:13 | and it will take usback to our old
desktop environment Access runs.
| | 03:16 | So in the next lesson we'll take a look
at some of the new templates
| | 03:19 | you have available to you here in Access 2013.
| | Collapse this transcript |
| Exploring the new Access templates| 00:00 | Like the other programs in Microsoft Office 2013,
Access offers some brand new templates to choose from.
| | 00:06 | Not just for creating databases, but for creating
web apps as well. Let's take a look.
| | 00:11 | When you launch Access 2013, of course
you're brought to this new start screen,
| | 00:16 | which does display a number of templates for you,
including the default which is a Custom web app.
| | 00:22 | Whenever you see this logo in the background,
the globe logo, you know you're
| | 00:26 | going to be creating one that is web enabled.
| | 00:29 | So as we go through this list, the default list,
you can see some of them
| | 00:33 | like Issue tracking, Contacts, they all
have that globe in the background.
| | 00:39 | Sometimes you'll see a similar icon,
but it'll say Desktop asset tracking, for example,
| | 00:44 | as opposed to Asset tracking,
which we see above with the globe symbol.
| | 00:49 | So there are desktop versions of these
apps that you can create, so you don't
| | 00:53 | need to be connected to SharePoint for example.
| | 00:56 | So all of these are fairly new,
but if you're not seeing what you're looking for,
| | 01:00 | notice there are some suggested searches.
| | 01:02 | You can search for Assets, Business,
Contacts, Employee, etcetera
| | 01:07 | or you can type in your own as well.
| | 01:08 | Let's type in Costumer for example.
| | 01:10 | When you hit Enter you'll notice it's
searching through thousands of online templates
| | 01:14 | and you're going to come up with a list.
| | 01:17 | Some will look familiar, some of the old templates
had access to in previous versions.
| | 01:22 | The newer ones will have this new look,
including the web apps and the desktop versions.
| | 01:26 | You'll also have categories over on the
right-hand side, so you can filter it out.
| | 01:31 | If you're only interested in business ones,
you can give that a click,
| | 01:35 | and you can see it's whittled down now.
| | 01:38 | You can also whittle it further down by
choosing something like small business.
| | 01:42 | Now you can see we're down to an even smaller
list and those two remain highlighted,
| | 01:46 | and if we don't want to include them any longer,
| | 01:51 | just click the Close button that appears next to them.
| | 01:52 | So once you've found what you're looking for
and let's go to Desktop contacts and give it a click.
| | 01:58 | It's going to launch and prompt you for some information.
| | 02:01 | In this case we're going to type in the name
of our brand new database.
| | 02:05 | So let's call it, NoObstaclesCustomerDatabase.
| | 02:13 | And you can choose the location.
You'll see the default location right below,
| | 02:17 | but click the folder icon if you want to change that
and then click Create.
| | 02:21 | It's going to prepare the template for you.
| | 02:23 | Open it up and you may have to enable
what I'm seeing here, the Getting Started screen.
| | 02:27 | In the background you might see
a Security Warning and if you wanted to
| | 02:32 | you can watch videos to help you get started.
| | 02:34 | Now there's Video Training, Browse Experts,
lot of help here, we'll close this up
| | 02:39 | and again, you might see the Security Warning
that there is content that's been disabled.
| | 02:45 | You can Enable that Content to give you full access.
| | 02:48 | This may reappear, we'll close it up
and we're now ready to start working
| | 02:52 | on our new Contact List.
| | 02:53 | Of course, we're taken directly to the
datasheet view, we could start inputting
| | 02:58 | records using the defaults, but at any time
with these templates they are really
| | 03:02 | meant to get you started.
| | 03:03 | You can go into Design view and start working
on the design, changing the Titles,
| | 03:08 | changing any of the components you see here.
| | 03:11 | For example, maybe you don't use the
Category field, we can remove that just
| | 03:16 | by clicking and dragging from the right to the left
or the left to the right, it doesn't matter,
| | 03:21 | once we've highlighted those objects,
hit your Delete key on the keyboard.
| | 03:25 | Everything is closed up nicely,
let's return to Datasheet view now,
| | 03:29 | and we could continue working with our new database,
based on the template that we chose,
| | 03:34 | from many, many more new templates in Access 2013.
| | Collapse this transcript |
|
|
6. PublisherInserting online pictures into a publication| 00:00 | Here in Publisher 2013, you won't notice
a whole slew of new features and functions,
| | 00:04 | but there are a few worth mentioning,
| | 00:07 | such as the ability to insert online pictures.
| | 00:10 | That is if you want to insert an image
into one of your publications and
| | 00:14 | that image exists online, could be at Office.com as clipart,
could be just a simple Bing Search,
| | 00:20 | it could be from your Flickr account.
| | 00:23 | Yes, we can connect to our Flickr accounts
and that's what we're going to talk about right now
| | 00:27 | using our No Obstacles Publication here.
| | 00:30 | Well, we're on Page 1, but let's scroll all the way down
on the left-hand side here to Page 7, the last page.
| | 00:36 | Let's say we want to insert an image
at the very end, passed our Color palette,
| | 00:39 | so we'll just click down there.
| | 00:42 | Next, we'll go to the Insert Tab and it's from here
where you'll see the new option,
| | 00:46 | which is to Insert Pictures, that is Online Pictures.
| | 00:50 | We'll give that a click to see our default options.
| | 00:54 | The first one is Office.com Clip Art.
Yes, you can type in keywords here
| | 00:59 | and search for clipart that is available to you royalty-free.
| | 01:03 | Also, we could run a Bing Search,
instead of going to a browser and doing our
| | 01:07 | search from there, we can stay right
inside Publisher here, searching the web
| | 01:12 | for images we might want to insert.
| | 01:15 | You're also connected to your SkyDrive account
by default if you're signed in already.
| | 01:20 | I am signed in to my Windows Live account,
and that's why my SkyDrive appears here.
| | 01:24 | It's a great to have access to images
that I might have stored on SkyDrive
| | 01:29 | from any location on any computer, but it's
down here in the bottom left-hand corner
| | 01:33 | where we see the Flickr logo.
| | 01:35 | We can also insert from our Flickr account if we have one.
| | 01:39 | So if you do and you want to be connected,
you have to come down here and click this logo.
| | 01:44 | Now it's just a matter of connecting
your current Windows Live account
| | 01:47 | to your Flickr account, by clicking Connect.
| | 01:50 | Now you'll be prompted to sign in, so all you need
is your Yahoo! ID and Password to do that,
| | 01:55 | I'm going to sign in now.
| | 02:03 | And once you are signed in, you'll
actually be connected to Flickr,
| | 02:07 | clicking Done will show you that
connection now on your list of options.
| | 02:11 | So instead of the icon in the bottom left-hand corner,
it now becomes one of
| | 02:15 | four options for inserting pictures from online sources.
| | 02:19 | You'll even see a quick preview of some of
your images, click See more and
| | 02:25 | you'll have access to those images,
you can scroll through them.
| | 02:28 | Find the one you want, I'm going to go
with my Sport logo here and click Insert.
| | 02:33 | So if you have your Flickr account,
you can use one of your own images if you like,
| | 02:37 | click the Insert button and just
like any other object that might be
| | 02:41 | on your computer or on a removable device
like USB drive you have access to that image
| | 02:47 | to move it around, resize it, and of course,
all of the formatting options
| | 02:52 | that appear on the ribbon are also available
to you here with your online picture.
| | 02:57 | That's brand new here in Publisher 2013,
the ability to insert pictures that exist online.
| | 03:04 | You don't have to leave Publisher to get access to them;
| | 03:07 | it's all accessible from the ribbon on the Insert tab.
| | Collapse this transcript |
| Using the scratch area for inserting images| 00:00 | I really like this next feature in Publisher 2013.
It's called the Scratch Area.
| | 00:04 | That is the area outside your page in a publication.
We can use this area.
| | 00:10 | Think of placing multiple objects in the scratch area
| | 00:13 | and then dragging them onto the
appropriate pages in your publication.
| | 00:17 | It works great with images for example.
| | 00:19 | Now, anything we place on the scratch area
will be invisible unless it's turned on.
| | 00:24 | So, let's go first to the View tab
as we continue to work with our
| | 00:28 | No Obstacles Publication.
| | 00:30 | From here, you'll see in the Show section a checkmark
in the check box by default next to Scratch Area.
| | 00:36 | That way, we'll be able to see the
objects that we place in this area.
| | 00:40 | Otherwise, with it deselected, they'll be invisible.
| | 00:42 | They'll still be there.
It's just we won't be able to see them.
| | 00:45 | It must be checked off.
| | 00:47 | Next, we're going to go to the Insert tab.
Let's go there and insert some pictures.
| | 00:52 | Click Pictures and if you have the exercise files,
go to the Publisher folder
| | 00:56 | where we do have a couple of logos.
| | 00:58 | We'll click the Home on first, hold down Shift and click
the Sport one to select them both, and click Insert.
| | 01:04 | Now, when we insert multiple objects, they
don't go on the page that we're looking at.
| | 01:09 | They actually go into the Scratch Area.
There they are, off to the right.
| | 01:12 | They are both selected, so let's just click
anywhere in the Scratch Area to deselect them.
| | 01:18 | Next, if you have the image that we inserted
in the previous movie on Page 7,
| | 01:22 | click it and hit the Delete key on your keyboard to remove it.
| | 01:26 | So, let's say we want to place these logos
in various locations in our publication.
| | 01:30 | For example, the Home logo goes here.
| | 01:32 | We can click and drag it and we'll move it onto the page.
| | 01:36 | But if you want a copy of it so that you
have access to this logo in the Scratch Area
| | 01:41 | on other pages, just hold down your Ctrl key,
you see the little plus sign next to your mouse pointer.
| | 01:47 | Let go first of the mouse, and then
your Ctrl key and now we can do things like
| | 01:51 | resize it and let's move it so that it's centered.
| | 01:55 | You'll see a guideline appear when you're right in the center.
| | 01:59 | There it is, I'll let go and that's a good spot for my logo.
| | 02:03 | Now, I'll click off in the Scratch Area here
to see what that looks like, deselected.
| | 02:07 | All right, let's go to Page 5 now.
| | 02:09 | Notice that we still have our Scratch Area here.
| | 02:11 | It's the same Scratch Area for every page
in our publication so it can place the Home logo here as well.
| | 02:17 | If we want a copy of it, again, we would use our Ctrl key.
| | 02:20 | If we don't need it, no problem, don't use your Ctrl key
just move it down towards the bottom, center and release.
| | 02:27 | All right, let's go back to Page 7;
we realized that should be the Sport logo.
| | 02:31 | Here's a handy feature using the Scratch Area
and it doesn't have to be in the Scratch Area,
| | 02:35 | but that's where our Sport logo is.
| | 02:37 | Let's click the Home logo on the page.
| | 02:39 | You may have noticed this little mountain icon in the center.
| | 02:42 | This is a swap feature.
| | 02:43 | If we click and drag from here,
we can swap this logo with any other image,
| | 02:48 | whether it'd be on the Page or in
the Scratch Area like our Sport logo.
| | 02:53 | So let's click from the mountain icon,
when we get to the Sport logo
| | 02:57 | and we're actually over it, we'll see
the border highlighted in that bright pink,
| | 03:01 | that means you can let go and the swap is complete.
| | 03:04 | Not only is it swapped, but you can see
the Sport logo now takes on the actual
| | 03:08 | size adjustment we made to the Home logo
and is placed perfectly on our page.
| | 03:14 | Realize that was a mistake, you can go back,
click, and swap again and release just like that.
| | 03:22 | So that's the Scratch Area here in Publisher 2013,
| | 03:25 | a very handy feature when working
with multiple objects on multiple pages.
| | Collapse this transcript |
| Creating JPEGs with the Save for Photo Printing option| 00:00 | Another new feature here in Publisher 2013
will let you take a publication
| | 00:04 | and save each individual page as a photo.
| | 00:08 | This is great if you wanted to, for example,
use photo printing or if you wanted to
| | 00:13 | create photo books from your publications.
| | 00:15 | Let's see how it's done here.
| | 00:17 | We'll continue to work with our NoObstacles_Publication.
| | 00:20 | Let's just go to page one.
| | 00:22 | You can see there are seven pages,
and each one will become its own JPEG
| | 00:25 | when we use the Export feature to photo printing.
| | 00:29 | We do that by going to the File tab.
| | 00:31 | Next, we'll select Export.
| | 00:34 | From here, you'll see an option under Pack and Go,
Save for Photo Printing. Give that a click.
| | 00:40 | Now, there is some information over here
under Save for Photo Printing.
| | 00:44 | Save your publication as a set of images
to print at a photo center for example.
| | 00:49 | Each page in the publication is saved as its own image.
| | 00:53 | They typically print from JPEG or TIFF files
and they can be saved at the best resolution
| | 00:58 | for photo printing using this feature.
| | 01:00 | So you'll notice there is a dropdown here,
JPEG Images for Photo Printing
| | 01:04 | create a folder containing one JPEG image for
each page in the publication, is the default.
| | 01:10 | Click the dropdown you can choose
that TIFF option if you prefer.
| | 01:15 | Now, all you have to do is click
Save Image Set, choose a location.
| | 01:19 | I'm going to go right to my Desktop,
select that folder and away it goes.
| | 01:30 | So as you can see, each page is becoming
its own graphic image titled page and then the number.
| | 01:36 | And if we were to minimize our program now and go to
our desktop, you're going to see a new folder.
| | 01:41 | In my case, it's called NoObstacles_Publication,
yours should be the same if you are using the same file I was.
| | 01:48 | Double-click that folder and you'll see
each of the images that was created
| | 01:52 | based on the pages in that publication.
| | 01:53 | So that's a great new feature here in Publisher 2013,
very convenient if you want to take your publications
| | 02:02 | and save them as images for photo printing,
| | 02:05 | even for creating things like photo books.
| | Collapse this transcript |
|
|
7. OneNoteExploring the new user interface| 00:00 | OneNote which is considered by many
to be the hidden gem of the Office Suite
| | 00:04 | sees a number of changes and enhancements
in OneNote 2013.
| | 00:08 | So let's take a look now by launching it
and we'll examine the user interface to begin.
| | 00:15 | It continues with this nice, clean, flat look
that we see in the other programs in the Office Suite.
| | 00:20 | But one thing you'll notice is, by default,
a brand new Notebook appears.
| | 00:25 | It should show your name if you're logged in.
| | 00:27 | I'm logged in to my Windows Live account
that's why we see in the top right-hand corner my name.
| | 00:33 | You'll see your own if you're logged in
to your Microsoft account,
| | 00:36 | and that's why you'll see the name of David's
Notebook here in the top left-hand corner for me.
| | 00:41 | You should be seeing your own name.
| | 00:43 | If this is your first time launching OneNote,
you might be prompted
| | 00:46 | to sign in to your Microsoft account again.
| | 00:49 | And if we look over to the right,
a couple of pages, the one we're looking at right now
| | 00:52 | is a little bit of information to help you get started.
| | 00:55 | For example, syncing to SkyDrive,
there's a 2-minute video, and as we scroll down,
| | 00:59 | I will show you how to Get Organized, Add pages etcetera.
| | 01:03 | Now, there's a second page.
| | 01:05 | We can select OneNote Basics to get
continued information and it should be
| | 01:10 | enough to help you get started
if you'd never used OneNote before.
| | 01:14 | Notice also in the top left-hand corner
that the ribbon is by default collapsed.
| | 01:19 | We are seeing the tabs.
| | 01:21 | We see the Home tab, Insert, Draw, etcetera.
| | 01:24 | When we click these tabs, the ribbon does
expand temporarily for us.
| | 01:28 | Click back in your page anywhere and you could see it
actually collapses revealing content in behind it.
| | 01:35 | So it's just a way to give you more space,
more real estate to work on
| | 01:39 | while working in OneNote on various notebooks,
sections and pages.
| | 01:44 | We're going to create a brand new notebook
and of course, we go to the File tab to do that.
| | 01:49 | So we'll click File and go down to New.
| | 01:52 | Now from here, you'll see a new default
and that is that SkyDrive is the location
| | 01:56 | for creating your new notebooks.
| | 01:58 | Of course, you can create them anywhere
on your own computer or if you have,
| | 02:01 | for example, USB drives plugged in,
you can select them and browse to them
| | 02:06 | via the Computer option.
| | 02:08 | Even add those places so they appear
on this list going forward.
| | 02:11 | But let's use our own SkyDrive account if you have one.
It's free.
| | 02:15 | You have a certain amount of free space.
| | 02:17 | So we'll type in the name of our notebook,
our new notebook.
| | 02:20 | We'll call it No Obstacles 2012,
and when we click Create Notebook,
| | 02:27 | the new notebook is created in that location.
| | 02:30 | You'll see a prompt where you can, if you want to at this time,
invite people to share that notebook.
| | 02:36 | It could be contacts in Outlook.
| | 02:37 | You could type in email addresses
or you can just wait to do that later
| | 02:42 | and select Not Now, which is what we are going to do.
| | 02:45 | And of course, we're going to see our new notebook.
| | 02:47 | We can see the name or title right up here
No Obstacles 2012.
| | 02:51 | There's one New Section, it's blank,
a new page which is also blank displaying
| | 02:56 | the current date and time.
| | 02:57 | So, all we have to do now is start adding
our content and let's go get some content
| | 03:02 | from one of our Microsoft Word documents.
| | 03:06 | So let's just type in Branding here
as our page title and then down below
| | 03:12 | is where we're going to insert content that already exists.
| | 03:15 | That means going to the Insert tab and
look at this option here called File Printout.
| | 03:21 | We can take a Word document.
| | 03:23 | Treat it like a document that's going to
be printed and the print results
| | 03:26 | will appear here in our notebook and
those printouts actually contain texts
| | 03:31 | that we can search through.
| | 03:32 | So let's choose File Printout.
| | 03:34 | Next, we'll navigate to the OneNote folder
of your exercise files where you'll
| | 03:38 | see Identity Branding and Style Guide and click Insert.
| | 03:42 | Now, the next thing that's going to happen,
you might see Word pop up
| | 03:48 | and that document needs to be open and starts to print.
| | 03:50 | That's not really going to a printer, it's actually going to
our OneNote notebooks like a printout.
| | 03:57 | So we can switch back now to OneNote
by clicking the icon on the Task Bar
| | 04:02 | and you'll notice our New Section now has a number of pages,
and they appear over here on the right-hand side.
| | 04:08 | So we can go through the pages and see that
it's an exact duplicate of our Word document.
| | 04:14 | So we have all of that content now here in our notebook.
| | 04:19 | So, that's just a quick look now at our user interface
here in OneNote 2013.
| | 04:24 | It's a little bit different, but there are
some enhanced features to look at,
| | 04:28 | so we'll do that next.
| | Collapse this transcript |
| Changing views| 00:00 | You know OneNote is one of those programs
you're likely to use throughout the day at various times,
| | 00:05 | sometimes in conjunction with other programs.
| | 00:09 | If you want to grab content from a Word document
and place it into your Notebook,
| | 00:12 | well in that case, some of the
different views you have access to
| | 00:16 | will come in handy in different scenarios.
| | 00:18 | So let's take a look at them now.
| | 00:19 | Now, in the previous lesson we created a brand new notebook
| | 00:23 | and if you weren't following along,
just create a new notebook and grab some information.
| | 00:27 | We grabbed this from a Word document.
| | 00:29 | You can see the name at the top,
Identity Branding and Style Guide,
| | 00:33 | that is the name of our brand new page here,
and as we scroll down, you can see
| | 00:38 | there are sub-pages and this is all the information
that came from a Word document.
| | 00:42 | We're looking at what's called the Normal View right now.
| | 00:45 | OneNote is taking up the entire screen.
| | 00:47 | We have access to our ribbon tabs
even though the ribbon is collapsed.
| | 00:51 | We see our contents down below and a
navigation pane over here on the right-hand side
| | 00:55 | where we can move through the pages,
even add new pages if we wanted to.
| | 01:00 | But let's go up to the View tab now,
and take a look at another View.
| | 01:04 | The three views up here over here on
the left-hand section called Views.
| | 01:08 | Let's go to Full Page View.
| | 01:09 | If you want even more real estate,
no tabs, no ribbon across the top,
| | 01:15 | you're simply working on your content,
you have access to it all here.
| | 01:18 | There are some options over here as you can see
for switching sections and pages in notebooks.
| | 01:24 | There's a button up here for switching back
to Normal View if you wanted to,
| | 01:28 | and then some navigation buttons here.
| | 01:30 | We have an Arrow pointing left, an arrow pointing
right for going through the various pages.
| | 01:35 | So, it just gives you an opportunity to see more
on your screen and have more content at your fingertips.
| | 01:41 | We can also go to the very top center
where we see the three dots.
| | 01:45 | Click there and you'll get temporarily
that information that disappeared
| | 01:49 | when we switched to Full Page View like your ribbon.
| | 01:52 | Including the View tab which we can click
and now we're going to explore
| | 01:56 | that third option which is Dock to Desktop.
| | 01:59 | And in this case, what's going to happen is,
you won't only be adjusting your OneNote window,
| | 02:03 | you'll be adjusting other windows
that you might be working in.
| | 02:06 | For example, if you wanted to work in Microsoft Word,
locate content and drag it over into OneNote, this is ideal.
| | 02:14 | Let's click Dock to Desktop.
| | 02:16 | As you could see OneNote is docked over here
on the right-hand side.
| | 02:19 | Anything else that's running in the background is also docked.
| | 02:22 | You can see it's resized so they are side-by-side.
| | 02:25 | I have Microsoft Word running.
| | 02:27 | You can launch Word if you like, it's going to look like this.
| | 02:29 | I have a file open called Identity Branding Alignment,
maybe there's something in here
| | 02:34 | that I want to take and drag over into OneNote.
| | 02:38 | So all I need to do is use my little navigation buttons
to get to the page.
| | 02:42 | There's Font Usage for example, and maybe I want
to take this note and drag it over there.
| | 02:47 | So, I'll click inside my Word document.
| | 02:49 | Click and drag over the paragraph.
| | 02:51 | Watch what happens when I click and drag
over to the other side, you'll see a little Plus (+) sign.
| | 02:57 | I'm about to copy it into my OneNote Notebook.
| | 03:00 | When I let go, see it takes a second and by default,
we get this message about Linked Note Taking.
| | 03:08 | So whenever it's docked,
what we're doing is linking to this document.
| | 03:11 | Now, if you don't want to see that message again,
you can click the checkbox next to it
| | 03:16 | or just leave it and click OK.
| | 03:18 | And now, we have a new note over here
in OneNote and we can adjust that.
| | 03:22 | We can size it for example.
| | 03:26 | And all we've done is we've linked to our word document
that's running simultaneously in this docked view.
| | 03:32 | So that's a cool option and you'll see the Link icon
that appears up here as well.
| | 03:36 | Linked Note Taking is enabled.
| | 03:38 | Click the dropdown if you wanted to Delete Links
on this page at any time.
| | 03:45 | All right. Let's switch back now.
| | 03:46 | We'll click the double diagonal arrow,
which will take us back to Normal View.
| | 03:50 | That's where we started, it is the default view.
| | 03:53 | So, what we're looking at now is OneNote
in a full screen window but we also
| | 03:58 | have quick access to our ribbon across
the top our Quick Access toolbar,
| | 04:02 | any of the tabs for the various sections in our Notebook
and our navigation pane down the right.
| | Collapse this transcript |
| Embedding files in a notebook| 00:00 | One nice improvement you'll find here in OneNote 2013
happens when you embed files into a notebook.
| | 00:07 | For example, Excel spreadsheets, even now Visio drawings.
| | 00:11 | You can embed a Visio file.
| | 00:12 | If you go into Visio to make changes to that drawing,
you'll see them updated here in your notebook.
| | 00:17 | Same thing goes for an Excel spreadsheet.
| | 00:19 | So, let's experiment with an Excel spreadsheet
here in our current notebook,
| | 00:23 | called No Obstacles 2012, that we created earlier on.
| | 00:26 | If you haven't been following along,
just create any old notebook and
| | 00:29 | we're going to create a new page for this as well.
| | 00:32 | We'll go over here to the right-hand side and click Add Page.
| | 00:35 | It becomes an Untitled Page at the bottom.
| | 00:38 | Our cursor is flashing in the top left corner,
let's type in a title for this page.
| | 00:42 | We'll call it, July 2012 Sales. There we go.
| | 00:48 | Now, we'll click down below the date and time
and this is where we want to insert our spreadsheet.
| | 00:53 | It could be an entire spreadsheet,
it could be parts of that spreadsheet.
| | 00:57 | Let's go to the Insert Tab to find out how.
| | 01:00 | From here, in the File section, you can
see we can get that File Printout
| | 01:03 | like we did earlier with our Word document.
| | 01:06 | We can Attach Files or we can go right
to Spreadsheet here, notice the Excel logo,
| | 01:10 | give it a click and this allows us
to create a New Excel spreadsheet,
| | 01:15 | which we can edit in Excel or Existing Excel
spreadsheet, one that we already have.
| | 01:20 | Let's click there, because in your exercise files,
in the OneNote folder you will
| | 01:24 | find, No Obstacles Sport
- July 2012 Sales Report.
| | 01:29 | Select it by clicking and click Insert.
| | 01:33 | Now, we have a few options here.
| | 01:35 | We can attach the file, which will simply attach it to the
page and we can double-click the attachment to get in.
| | 01:40 | We can insert the entire Spreadsheet or just
a part of it by picking a Chart or a Table.
| | 01:47 | Let's insert the entire spreadsheet
by clicking the middle option and it just
| | 01:51 | takes a moment now, and as we scroll through this,
momentarily, we'll be able to see that
| | 01:56 | actually more than one table was inserted.
| | 01:59 | The Scroll Bar on the right, you'll see what
came from the second tab or second sheet.
| | 02:04 | As we scroll further up that was from
our first sheet and we have access to all
| | 02:09 | of that information here in our notebook.
| | 02:11 | Of course, if we're in Excel working on this
and we make changes, they're going
| | 02:15 | to be updated automatically and dynamically
here in our OneNote Notebook.
| | 02:20 | We can also edit directly from here.
| | 02:22 | Notice the Edit symbol in the top left corner.
| | 02:25 | If you'd click that, you'll actually be able to go in
and edit this in Excel.
| | 02:30 | Notice an Excel window pops up now.
| | 02:32 | We can enable any disabled content and
just go down here and start making changes.
| | 02:37 | For example, if this SKU here had to be changed,
it's just a little bit too long,
| | 02:42 | you can go in, double-click, let's take out the 9 at
the end, it doesn't belong and press Enter.
| | 02:48 | It's going to update that now in our notebook.
| | 02:51 | So, let's look for 1070845 for our first SKU number
when we close this up.
| | 03:00 | Yes, we'll Save our changes and when we arrive
back here in OneNote, there it is,
| | 03:06 | updated dynamically right in front of us.
| | 03:10 | So, this is a nice new feature and as I mentioned,
it will also work with Visio files now.
| | 03:15 | So, if you do have a Visio drawing and you do
make changes to that Visio drawing in Visio,
| | 03:19 | those changes are updated dynamically
here in your OneNote notebooks as well.
| | 03:25 | Let's go back to our very first page, Identity Branding
and Style Guide and continue from here.
| | Collapse this transcript |
| Linking notes to your Outlook calendar| 00:00 | One cool new feature here in OneNote 2013
is the ability to link your Notes
| | 00:06 | to actual Appointments or Meetings
in an Outlook Calendar.
| | 00:10 | And that's great if you're going to be at
a meeting for example that's scheduled
| | 00:13 | on a certain date in your Outlook Calendar.
| | 00:15 | You can use OneNote to take Notes and even share
those Notes with anyone who has access to your Notebook.
| | 00:20 | Let's say we're sharing our No Obstacles 2012 Notebook here.
| | 00:24 | Let's just create a new section
by clicking the plus sign next to
| | 00:28 | the New Section 1 tab here and we'll give it a name.
| | 00:30 | Let's call this Board Meetings and
press Return or Enter on your keyboard.
| | 00:37 | So we have one untitled page at this point.
| | 00:40 | We'll just put in a date for our Board Meeting,
let's say it's going to be, December 14 Meeting, there we go.
| | 00:50 | And any notes we're going to take are
going to be down here, but we can link it
| | 00:54 | to our calendar so we can access the
notes from our calendar and vice versa.
| | 00:58 | So let's switch over to Outlook now.
| | 01:00 | Now, if you don't have Outlook already set up,
when you go to Launch Outlook 2013
| | 01:03 | you'll be prompted to connect to an email address.
| | 01:07 | It's very simple, you just type in the information
and you're set to go.
| | 01:11 | So, I'm using my calendar here.
| | 01:12 | You can see from the Home tab,
with calendar selected down the left-hand side,
| | 01:18 | I have the ability to create New Appointments,
Meetings well, I'm not going to
| | 01:22 | invite anybody at this time to the meeting.
| | 01:24 | I'm going to create a New Appointment
on December 14, so I'll make sure that's selected.
| | 01:29 | I'll choose my times, maybe it's going to be
from 10 a.m. to 12 p.m.
| | 01:35 | and the Subject up here will be Board Meeting.
| | 01:41 | The Location, Conference Room C
and then down below, any information
| | 01:52 | like about Lunch to Follow. Okay, that's good for now.
| | 01:55 | I'm going to click Save & Close.
| | 01:57 | Although, you'll notice our meeting notes are over here.
| | 02:00 | I first want to Save & Close just to show you,
you can apply this to existing
| | 02:04 | Appointments and Meetings that are already in your calendar.
| | 02:06 | You just go to them, make sure they're selected
and then up here on the ribbon,
| | 02:10 | you'll see the Appointment tab selected with Calendar tools
| | 02:14 | and there's Meeting Notes there.
| | 02:15 | So, we can access it from here as well.
| | 02:17 | Now, all we have to do is choose whether
we're going to Share notes with the meeting
| | 02:21 | or Take notes on our own.
| | 02:23 | Let's choose Share notes with the meeting.
| | 02:25 | And a list of your OneNote notebooks are going to
appear down below, these are your shared Notebooks.
| | 02:30 | I'm going to go to the No Obstacles,
plus sign, there's my Board Meeting section,
| | 02:37 | when I click that, plus sign to expand it.
| | 02:39 | There's my December 14 Meeting already there.
| | 02:43 | Now, up here, I can also use the Search field to find.
| | 02:45 | So, if you have Notebooks with many sections and pages,
this is a handy little feature up here.
| | 02:50 | We're able to select the actual section and page
where our notes are going to go and click OK.
| | 02:57 | Now, when we do that, you'll notice something
happens here in the Appointment calendar,
| | 03:00 | you've got View meeting notes.
| | 03:03 | So, you have a link directly to OneNote now
where you will be able to take your notes.
| | 03:07 | So if we click this link, we're going to switch back
to OneNote now,
| | 03:11 | here's our Board Meeting tab, and our new page
December 14 Meeting,
| | 03:15 | and notice there's already information here,
so we have our page with, looks like a header here
| | 03:21 | for the meeting Subject, the Dates, the Location.
| | 03:24 | We can expand and collapse the Invitation,
there is Lunch to Follow.
| | 03:28 | You can see the Participants and then down below,
is our area for adding Notes.
| | 03:33 | So, we simply take notes during the meeting,
this is all part of our calendar now in Outlook.
| | 03:39 | So that's brand new here in OneNote 2013.
| | 03:41 | A handy little feature to keep you
linked to your Board Meetings,
| | 03:44 | any type of meeting in Outlook, where you might want
to take notes and then eventually share those Notes.
| | 03:50 | If your Notebook is shared,
everyone who has access to this Notebook
| | 03:54 | has access to your Meeting Notes as well.
| | Collapse this transcript |
| Inserting a screenshot| 00:00 | Here's a cool new feature in OneNote 2013
that allows you to capture portions
| | 00:04 | of a screen that you might want to place
into a Notebook here in OneNote.
| | 00:10 | Let's go to a website, we're going to
go to a Flickr site here for No Obstacle Sport
| | 00:15 | and we do have some time items that
we might want captured here and added
| | 00:19 | to one of our Notebook pages.
| | 00:20 | Well, to do that all we need is a keyboard shortcut,
which is the Windows Key+N.
| | 00:26 | As soon as you do that, a little pop-up appears
at the bottom of your screen with three options.
| | 00:33 | Screen Clipping is the first, we can click it
or use the letter S on the keyboard,
| | 00:37 | you could also Send directly to OneNote the entire page
or create a New Quick Note from here.
| | 00:43 | So really, it doesn't matter what you're looking at.
| | 00:45 | What we want to do is capture
a portion of this screen, so we'll use
| | 00:49 | the Screen Clipping option the first one,
and we'll give it a click.
| | 00:53 | And you'll notice what happens to the page you're
looking at, it could be any page, any program.
| | 00:58 | It goes dim in the background and now
your mouse is a crosshair waiting for you
| | 01:02 | to click and drag over the area you wish to capture.
| | 01:05 | Let's say we want to get the cool red shoes,
so we click and drag across and down
| | 01:09 | until we've encompassed everything
we want saved, and when we release,
| | 01:15 | we now have the ability to pick a
section where we want to place this.
| | 01:18 | Now it could on a page in a Notebook,
if you have multiple sections and pages
| | 01:23 | you can use the search field to search
for the exact spot, or you can go down below,
| | 01:27 | look at your Notebooks and start expanding various sections.
| | 01:31 | So clicking the plus sign next to No Obstacles 2012
expands it to display the sections.
| | 01:36 | There's only one here, but when we click
the plus sign next to it, we see the pages.
| | 01:41 | Now we can select the page where we
want to go and to send our selection
| | 01:45 | to this particular spot in our Notebook,
we go down to the bottom and click,
| | 01:50 | Send to Selected Location.
| | 01:53 | As soon as we do that, it's actually been copied there.
| | 01:55 | Let's flip over to OneNote now and here on the branding page
you can see our screen clipping appears.
| | 02:03 | This is an object that we can move around on the page.
| | 02:06 | We can resize it if we wanted to and we
can start adding Notes to it as well.
| | 02:12 | So that's a handy new feature here in OneNote 2013
| | 02:14 | that allows you to capture any part of a screen
that you might be looking at
| | 02:18 | and add it to your OneNote Notebooks.
| | Collapse this transcript |
|
|
8. OutlookExploring the user interface and some sneak peeks| 00:00 | Let's take a moment now to explore the
new user interface here in Outlook 2013.
| | 00:04 | The very first time you go to launch Outlook,
| | 00:07 | you will be prompted to connect
to your existing email addresses.
| | 00:11 | So if you have any, whether they'd
be Exchange accounts, maybe IMAP,
| | 00:15 | or POP accounts like a Hotmail account,
all you need to do is type in your
| | 00:19 | email address and password and Outlook does
a really good job in getting you connected.
| | 00:24 | That's what I've done and here
I am now arriving at my mailbox.
| | 00:28 | So let's talk about what we see in front of us.
| | 00:31 | The flat clean look we saw in the other programs
in the Office Suite 2013, same thing here.
| | 00:37 | The ribbon is flat, the buttons are flat
it's a clean look and as we move over
| | 00:41 | to the left-hand side with the navigation pane collapsed,
notice that by default
| | 00:47 | the envelope icon is selected, representing your mailbox,
and it's broken up into separate boxes as well.
| | 00:53 | The Inbox is by default what is selected,
so you're looking at your Inbox and
| | 00:58 | any new messages that appear with
this blue bar down the left-hand side.
| | 01:03 | There's something called sneak peeks as well,
as you hover over messages you can see little tools popping up.
| | 01:08 | Maybe this is one you want to flag,
you can click the flag, maybe you find a
| | 01:12 | message that you no longer need,
you can click Delete right from there.
| | 01:16 | So it's very efficient the way it's organized here
helping you to work more efficiently with your mail items.
| | 01:22 | The same applies to other areas in Outlook.
| | 01:25 | Let's move over to the left-hand side and down,
don't click the calender icon,
| | 01:29 | just hover over it and you'll notice a
sneak peek that appears here as well.
| | 01:34 | Now as we move into the sneak peek area,
it appears for me at least that I have
| | 01:38 | nothing scheduled today, but as we click other days
we might see items that are scheduled,
| | 01:43 | like a Lunch and Learn.
| | 01:45 | If I go to the 14, look at that, I have a Board Meeting
and it'll show me the time.
| | 01:50 | If I want more details or I want to go
in there, I can double-click the item and
| | 01:54 | it opens it up in a separate window
where I can start editing my appointment.
| | 01:58 | Notice I haven't had to switch over to calender to do it.
| | 02:01 | When I'm done, I close it up and I'm still looking at my mailbox.
| | 02:05 | As we move down to our Contacts,
if you have any contacts you'll see your
| | 02:09 | Favorites are there as well, where you can right-click
a person to add them to your Favorites if you wanted to.
| | 02:14 | Same thing goes for any Tasks or To-do Lists
that you might have created and
| | 02:18 | there are Search fields as well, where you can go
to Search for Task, Create New Tasks, etcetera.
| | 02:22 | All right, let's go back to our Inbox now,
and move over to the right-hand side,
| | 02:28 | if you have a message in front of you, great.
| | 02:30 | I want you to see something new here.
| | 02:33 | Yes, we still have on the ribbon, on the Home tab,
Reply, Reply to All, etcetera.
| | 02:37 | But you also have those options at the very top
of the Message itself.
| | 02:41 | So if I wanted to reply to somebody who
sent me this message, I can click Reply,
| | 02:45 | automatically I am going to see
information at the top, who it's going to.
| | 02:49 | I can CC people, the Subject is the same,
and I can start typing in my reply.
| | 02:55 | Ready to send it, I click the Send button
and off it goes, didn't mean to Reply,
| | 03:00 | no problem, I can discard this.
| | 03:02 | Notice also there's Pop Out, so if you're
accustomed to working in a separate
| | 03:06 | window, click Pop Out, and your reply
will appear in a separate window and you
| | 03:10 | can then send it off from there and it'll close up.
| | 03:13 | But I kind of like the idea that I can
do everything right from here,
| | 03:17 | where I was looking, where I started in the first place.
| | 03:19 | Let's click Discard if we don't actually want to send that off.
| | 03:22 | So you'll see that across the top of all of your messages.
| | 03:26 | So these are just some of the nice changes
you'll find in the user interface
| | 03:30 | here in Outlook 2013 to help you work more efficiently.
| | Collapse this transcript |
| Using the Weather bar| 00:00 | You know sometimes when you're
scheduling meetings with others;
| | 00:03 | you need to take into consideration
what the weather might be.
| | 00:06 | Are they going to be able to make it to your location?
| | 00:09 | Well, in Outlook 2013 in the calendar view,
you do have access to the Weather for various locations.
| | 00:15 | We're going to take a look at it now
by going over to our folder pane here
| | 00:18 | on the left-hand side and click the calendar icon.
| | 00:21 | If your navigation pane is expanded, you'll find the
calendar icon at the bottom of your Outlook Window.
| | 00:26 | Now, from here right away you're going
to see your Current Location,
| | 00:31 | just up next to the Month and Year,
you'll see a location showing you a couple of days
| | 00:35 | worth of weather, and you can just hover over
those to get a little extra information.
| | 00:40 | Want to see more?
| | 00:41 | You can do so online by clicking a link to See more online.
| | 00:45 | It'll open up your default browser
and display some weather information.
| | 00:49 | Well, we do see updated information anyway here
for a couple of days at least on our calendar.
| | 00:55 | What we can also do though is add additional locations.
| | 00:58 | So maybe we have offices in two locations, click the
dropdown next to your location and click Add Location.
| | 01:05 | Now all you have to do is type in the location you want to add.
| | 01:09 | So I'm going to click in the search field here and type in
New York, NY and press Enter on my keyboard.
| | 01:20 | Now I get to choose one, it could be
Central Park or New York, NY,
| | 01:24 | I'm going to go with New York, NY, give it a click
and now I'm looking at that weather
| | 01:28 | information, click the dropdown to switch
back to my location, and again,
| | 01:33 | you can add as many locations as you like.
| | 01:35 | Just a neat little perk here in the
Calendar view in Outlook 2013,
| | 01:39 | for monitoring the weather if necessary.
| | Collapse this transcript |
| Connecting to social networks| 00:00 | Here in Outlook 2013, getting connected
to your social networking sites is very easy
| | 00:04 | and there are some advantages.
| | 00:07 | For example, if you're able to connect
to a Twitter, Facebook or LinkedIn account,
| | 00:11 | you'll have access to those contacts and their information,
| | 00:15 | which will appear here in Outlook by default, all you need
to do is get connected and here is how you do it.
| | 00:21 | So, there are a number of different ways
to get connected, one of them is to
| | 00:25 | use the View tab across the top on the ribbon.
| | 00:29 | From the View ribbon, you'll notice something
called the People Pane, give that a click
| | 00:33 | and you'll see some different views,
right now it's Minimized across
| | 00:37 | the bottom of your screen, you might
be seeing some icons down below
| | 00:40 | representing photos for example, and if there aren't
any photos showing up in those thumbnails,
| | 00:44 | it's because you're probably not connected
or they don't have a photo.
| | 00:48 | Click Normal if you want to be able to see
a little bit more of this information,
| | 00:52 | this guy named David Rivers, no photo,
you can hover over it, no real information there.
| | 00:59 | But go back to the People Pane now, dropdown
and choose Account Settings and
| | 01:03 | it's from here where you can connect
to various social networks.
| | 01:07 | You'll see 3 by default, Facebook,
LinkedIn and SharePoint, but there is also a
| | 01:11 | link to connect to other social networks as well.
| | 01:13 | Clicking that link lets you get more specific.
| | 01:16 | I'm going to experiment with LinkedIn,
I'll give it a click, and remember
| | 01:20 | I'm connecting to my own account, so if I'm
receiving emails from any contacts at LinkedIn,
| | 01:25 | I'm going to get some additional information
from this account.
| | 01:28 | So, I'm going to type in my own User Name here
and my own Password to get logged in,
| | 01:41 | and when I click Connect, you'll see a check mark here.
| | 01:45 | Here is where I go if I want to disconnect
at any time, so I can always go back
| | 01:49 | to the People Pane Account Settings and click
the black X to disconnect from this account,
| | 01:55 | I can connect to other accounts if I wanted to at this point
| | 01:59 | or just click Finish to continue on.
| | 02:01 | I will see a little dialog box pop open
congratulating me on my connection to LinkedIn.
| | 02:07 | To see what's going on, you can see LinkedIn updates
for your friends and colleagues,
| | 02:10 | they appear here in Office and I can also
control what I'm sharing with others.
| | 02:16 | So, let's just click Close here and see
that something has already happened,
| | 02:20 | the email message I was looking at from
this guy named David Rivers who is one of
| | 02:24 | my LinkedIn contacts, I now see a photo,
it appears down here in the People Pane
| | 02:29 | as well, and I can hover over that.
| | 02:32 | Notice I can see that it's a LinkedIn account,
came from LinkedIn.
| | 02:36 | I also see some additional information about this person.
| | 02:40 | So, a little bit of info is coming across from LinkedIn,
because I've made that connection
| | 02:44 | and it's so easy to do it from the View tab
and the People Pane dropdown under Account Settings.
| | Collapse this transcript |
|
|
ConclusionNext steps| 00:01 | Congratulations, you've reached the end
of Office 2013 New Features.
| | 00:05 | You should now be feeling comfortable
with the new and improved features
| | 00:08 | in each of the programs in this latest
version of the Microsoft Office Suite.
| | 00:12 | Of course, you can find the additional courses
at lynda.com for each of the programs
| | 00:15 | in Microsoft Office 2013.
| | 00:18 | So if you feel like you need to dive a
little deeper into any of these programs,
| | 00:22 | check out our extensive library.
| | 00:24 | Thanks for watching and I hope to see you again soon
in another title from lynda.com.
| | Collapse this transcript |
|
|
