[youtube]http://www.youtube.com/watch?v=SWOXJBTLaBo[/youtube]
Learn office 2013 with templates, macros, editing document & formatting basics. Complete Guide on how to use word 2013 for dummies . Microsoft Word tips and tutorials for beginners.
NEXT TUTORIAL: http://youtu.be/bG1lbTNgYNA
----------------------------
Subscribe to our channel here - http://www.youtube.com/user/vwayrocks
To Spread Education Please ---- Rate - Share - Comment ----
Essential training course for excel assessment test and students includes presentation and project files.
For any help contact me.. thanks
Free excel tutorial | advanced excel | online excel training | learn spreadsheet | excel for interviews | windows excel
In This VIDEO ("Excel Tutorial for Beginners") -- Launching Word And Touring The Interface
Transcript
00:00 Before we can dive into the many powerful features and functions of Word 2013,
00:05 we first need to launch the program, and get comfortable in our environment,
00:08 so let's explore the user interface by first launching Word 2013.
00:12 If you're in Windows 8, and logged in already, that will give you a nice head start.
00:17 If you are in Windows 7, you can launch Word 2013 from there as well.
00:22 Now, what you see at the very beginning here is different from previous
00:25 versions of Word 2013.
00:27 This is our start screen,
00:28 and down on the left-hand side, you will see a color-coded area, a panel on the
00:32 left; for Word it's blue, Excel it's green, Power Point is orange, and so on.
00:37 And you'll see a list of your recently worked on files, so you have quick access
00:41 to them if you want to go back.
00:43 You also have a link to open other documents, allowing you to browse your
00:47 computer and online.
00:48 To the right, we have a number of templates, including the default template,
00:51 which is our blank document.
00:53 If you're looking for a template that does not show up here on this initial
00:57 screen, you can search for templates online,
01:00 and there are thousands to search through.
01:02 There are also some suggested searches to help you get started as well.
01:05 If you are logged in already to your Microsoft account, you'll see that
01:09 information here in the top right corner.
01:11 You can switch to another account if you have another account, or perhaps you
01:15 share this computer with others, and they'll want to switch to their own accounts.
01:19 Also, in the top right corner, you'll see a button for getting help -- F1 is still
01:23 the keyboard shortcut --
01:25 a minimize button, maximize, and a close button to close Word 2013 altogether.
01:31 Now, the default template is a blank document.
01:33 So, let's go there and just simply click once.
01:36 Now, this launches Word to the initial user interface that you will see once you
01:41 get past that start screen.
01:43 Over here on the left-hand side is our Navigation pane.
01:46 So, if your document has Headings, you want to go through Pages, or Results, you
01:51 can search quickly using this Navigation pane.
01:54 It can also be closed up using the Close button, and you can view it at any time
01:58 from the View tab on the ribbon.
02:00 Let's move up to the top of the screen.
02:02 We still have the quick access toolbar.
02:04 You will see some buttons there by default, like the Save, Undo, and you'll also
02:08 see a little repeat option here as well, and then the dropdown where you can
02:13 pick and choose what's going to show up on your Quick Access Toolbar.
02:16 Anything with a checkmark is already showing.
02:19 You can remove them by clicking them, or you can add items as well.
02:23 We'll go back to that in a later lesson.
02:26 Right below that is our ribbon, of course,
02:28 and you'll notice the very first tab,
02:29 the File tab, is actually going to take us to our backstage view.
02:34 So, let's go there now.
02:36 This takes us to a different view with a list of options down the left-hand
02:39 side, for opening, saving, creating new documents, printing, exporting, etcetera.
02:44 We can also access our Word options down here at the very bottom.
02:48 We can go back to recent documents, go to your SkyDrive account,
02:53 and with your Windows account, you do get some free space there, and of course,
02:57 you could purchase more if you needed to.
02:59 But it's a great way to save your documents to the cloud, so you have anytime,
03:02 anywhere access to them.
03:04 You can also browse your computer to open files there;
03:07 even add places, little shortcuts that will take you directly to other
03:11 locations if you wanted to.
03:13 There is also a Back button up here.
03:15 So, we can click the Back button to go back where we started before we clicked the File tab.
03:20 Next is the ribbon, and you'll see the Home tab is highlighted or selected by
03:24 default. So, we're looking at various sections here;
03:26 the Clipboard, Font Sections.
03:28 Notice that many of these have a little arrow icon in the bottom right corner,
03:32 so you can actually expand these, and get full dialog boxes that you might be
03:36 used to from previous versions in Microsoft Word.
03:40 You have quick access to Styles, but you can also go to the full Styles dialog
03:44 by clicking the arrow in the bottom right corner of that section.
03:48 Let's just quickly go through some of the tabs.
03:50 If you need to insert objects into your document, go to the Insert tab.
03:53 And again, it's broken up into categories;
03:55 so Pages, Tables, Illustrations, etcetera.
03:59 Under Design, we have a number of design options, and here's where you can get
04:03 into various document formatting options, and color schemes, etcetera.
04:08 Page Layout, References, Mailings, Review, and View at the very end; the View
04:13 Tab is going to show you your default view, which is our Print Layout view.
04:17 We'll be talking about the different views in an upcoming lesson,
04:20 but for now, just notice that the Print Layout is the default view, and
04:24 that's the default view you might be used to from previous versions of
04:27 Microsoft Word as well.
04:29 I will go back to the Home tab.
04:31 Also, if you have long documents, you're going to see scrollbars over here on
04:35 the right-hand side, so you can scroll through your pages.
04:38 If your document is too wide, the scrollbar will appear across the bottom; a horizontal one.
04:43 And then down at the very bottom, we have on the status bar some information.
04:46 You can see we're at Page 1 of 1;
04:49 0 words so far, so there is a Word count that shows up there.
04:52 And also, on the right-hand side, those View modes we just saw from the View tab
04:57 are available to us here.
04:58 So, we have Read Mode, the one that's selected, Print Layout, as well as Web Layout.
05:02 And then, we have our Zoom slider.
05:05 So, we can use the minus sign and the plus sign to zoom in and zoom out of our
05:10 documents, or we can click and drag the slider, and we'll always see the number
05:14 in a percent off to the right.
05:16 To bring it right back to the middle, or 100%, we just drag the slider, or use
05:21 the plus or minus signs to get there.
05:23 So, that's a quick tour of our user interface here in Word 2013.
05:27 Now that we are comfortable in our environment, it's time to do a little more
05:31 exploring, and start getting into some of the features and functions available
05:34 to us here in Word 2013.
Learn office 2013 with templates, macros, editing document & formatting basics. Complete Guide on how to use word 2013 for dummies . Microsoft Word tips and tutorials for beginners.
NEXT TUTORIAL: http://youtu.be/bG1lbTNgYNA
----------------------------
Subscribe to our channel here - http://www.youtube.com/user/vwayrocks
To Spread Education Please ---- Rate - Share - Comment ----
Essential training course for excel assessment test and students includes presentation and project files.
For any help contact me.. thanks
Free excel tutorial | advanced excel | online excel training | learn spreadsheet | excel for interviews | windows excel
In This VIDEO ("Excel Tutorial for Beginners") -- Launching Word And Touring The Interface
Transcript
00:00 Before we can dive into the many powerful features and functions of Word 2013,
00:05 we first need to launch the program, and get comfortable in our environment,
00:08 so let's explore the user interface by first launching Word 2013.
00:12 If you're in Windows 8, and logged in already, that will give you a nice head start.
00:17 If you are in Windows 7, you can launch Word 2013 from there as well.
00:22 Now, what you see at the very beginning here is different from previous
00:25 versions of Word 2013.
00:27 This is our start screen,
00:28 and down on the left-hand side, you will see a color-coded area, a panel on the
00:32 left; for Word it's blue, Excel it's green, Power Point is orange, and so on.
00:37 And you'll see a list of your recently worked on files, so you have quick access
00:41 to them if you want to go back.
00:43 You also have a link to open other documents, allowing you to browse your
00:47 computer and online.
00:48 To the right, we have a number of templates, including the default template,
00:51 which is our blank document.
00:53 If you're looking for a template that does not show up here on this initial
00:57 screen, you can search for templates online,
01:00 and there are thousands to search through.
01:02 There are also some suggested searches to help you get started as well.
01:05 If you are logged in already to your Microsoft account, you'll see that
01:09 information here in the top right corner.
01:11 You can switch to another account if you have another account, or perhaps you
01:15 share this computer with others, and they'll want to switch to their own accounts.
01:19 Also, in the top right corner, you'll see a button for getting help -- F1 is still
01:23 the keyboard shortcut --
01:25 a minimize button, maximize, and a close button to close Word 2013 altogether.
01:31 Now, the default template is a blank document.
01:33 So, let's go there and just simply click once.
01:36 Now, this launches Word to the initial user interface that you will see once you
01:41 get past that start screen.
01:43 Over here on the left-hand side is our Navigation pane.
01:46 So, if your document has Headings, you want to go through Pages, or Results, you
01:51 can search quickly using this Navigation pane.
01:54 It can also be closed up using the Close button, and you can view it at any time
01:58 from the View tab on the ribbon.
02:00 Let's move up to the top of the screen.
02:02 We still have the quick access toolbar.
02:04 You will see some buttons there by default, like the Save, Undo, and you'll also
02:08 see a little repeat option here as well, and then the dropdown where you can
02:13 pick and choose what's going to show up on your Quick Access Toolbar.
02:16 Anything with a checkmark is already showing.
02:19 You can remove them by clicking them, or you can add items as well.
02:23 We'll go back to that in a later lesson.
02:26 Right below that is our ribbon, of course,
02:28 and you'll notice the very first tab,
02:29 the File tab, is actually going to take us to our backstage view.
02:34 So, let's go there now.
02:36 This takes us to a different view with a list of options down the left-hand
02:39 side, for opening, saving, creating new documents, printing, exporting, etcetera.
02:44 We can also access our Word options down here at the very bottom.
02:48 We can go back to recent documents, go to your SkyDrive account,
02:53 and with your Windows account, you do get some free space there, and of course,
02:57 you could purchase more if you needed to.
02:59 But it's a great way to save your documents to the cloud, so you have anytime,
03:02 anywhere access to them.
03:04 You can also browse your computer to open files there;
03:07 even add places, little shortcuts that will take you directly to other
03:11 locations if you wanted to.
03:13 There is also a Back button up here.
03:15 So, we can click the Back button to go back where we started before we clicked the File tab.
03:20 Next is the ribbon, and you'll see the Home tab is highlighted or selected by
03:24 default. So, we're looking at various sections here;
03:26 the Clipboard, Font Sections.
03:28 Notice that many of these have a little arrow icon in the bottom right corner,
03:32 so you can actually expand these, and get full dialog boxes that you might be
03:36 used to from previous versions in Microsoft Word.
03:40 You have quick access to Styles, but you can also go to the full Styles dialog
03:44 by clicking the arrow in the bottom right corner of that section.
03:48 Let's just quickly go through some of the tabs.
03:50 If you need to insert objects into your document, go to the Insert tab.
03:53 And again, it's broken up into categories;
03:55 so Pages, Tables, Illustrations, etcetera.
03:59 Under Design, we have a number of design options, and here's where you can get
04:03 into various document formatting options, and color schemes, etcetera.
04:08 Page Layout, References, Mailings, Review, and View at the very end; the View
04:13 Tab is going to show you your default view, which is our Print Layout view.
04:17 We'll be talking about the different views in an upcoming lesson,
04:20 but for now, just notice that the Print Layout is the default view, and
04:24 that's the default view you might be used to from previous versions of
04:27 Microsoft Word as well.
04:29 I will go back to the Home tab.
04:31 Also, if you have long documents, you're going to see scrollbars over here on
04:35 the right-hand side, so you can scroll through your pages.
04:38 If your document is too wide, the scrollbar will appear across the bottom; a horizontal one.
04:43 And then down at the very bottom, we have on the status bar some information.
04:46 You can see we're at Page 1 of 1;
04:49 0 words so far, so there is a Word count that shows up there.
04:52 And also, on the right-hand side, those View modes we just saw from the View tab
04:57 are available to us here.
04:58 So, we have Read Mode, the one that's selected, Print Layout, as well as Web Layout.
05:02 And then, we have our Zoom slider.
05:05 So, we can use the minus sign and the plus sign to zoom in and zoom out of our
05:10 documents, or we can click and drag the slider, and we'll always see the number
05:14 in a percent off to the right.
05:16 To bring it right back to the middle, or 100%, we just drag the slider, or use
05:21 the plus or minus signs to get there.
05:23 So, that's a quick tour of our user interface here in Word 2013.
05:27 Now that we are comfortable in our environment, it's time to do a little more
05:31 exploring, and start getting into some of the features and functions available
05:34 to us here in Word 2013.
[youtube]http://www.youtube.com/watch?v=FGILAJwf9K0[/youtube]
Chapter 1 - GETTING COMFORTABLE WITH EXCEL
Free Microsoft Excel Tutorials - Understanding how to create spreadsheets and
workbooks in Microsoft Excel is an important skill to acquire. ... and chart data
with the new innovations in Microsoft's latest spreadsheet software Excel 2010.
Chapter 1 - GETTING COMFORTABLE WITH EXCEL
Free Microsoft Excel Tutorials - Understanding how to create spreadsheets and
workbooks in Microsoft Excel is an important skill to acquire. ... and chart data
with the new innovations in Microsoft's latest spreadsheet software Excel 2010.
[youtube]http://www.youtube.com/watch?v=rVEBJW0-HIQ[/youtube]
Chapter 1 - GETTING COMFORTABLE WITH EXCEL
The Excel Web App interface is different from the traditional Excel application in that the web app runs within your web browser. The Ribbon at the top of the Excel Web App interface screen contains tabs, such as Home and Insert.
The Home tab contains common functionality in groupings, such as Clipboard, Font, Alignment, Number, Tables, Cells, Data, and Office.
The Insert tab allows you to insert a table or hyperlink into your
Excel Web App document. A table allows you to manipulate data with
functionality, such as sorting the data in ascending or descending order
or filtering the data based on specific criteria. A hyperlink allows
you to create clickable text that, when clicked, opens up a new website.
For example, you can create a hyperlink with text that says “Learn More” that takes anyone viewing the Excel Web App document to a news article.
In addition to the Ribbon tabs, the interface also includes a File
menu. The File menu allows you to perform functionality, such as saving
the document as a different name, opening the document in the
traditional Excel application located on your computer, downloading a
snapshot of the document, or downloading a copy of the document.
Course Info:
This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!
Highlights
Chapter 1 - GETTING COMFORTABLE WITH EXCEL
The Excel Web App interface is different from the traditional Excel application in that the web app runs within your web browser. The Ribbon at the top of the Excel Web App interface screen contains tabs, such as Home and Insert.
The Home tab contains common functionality in groupings, such as Clipboard, Font, Alignment, Number, Tables, Cells, Data, and Office.
| Home Tab Section | Description |
|---|---|
| Clipboard | Allows you to cut, copy, and paste data between cells within the spreadsheet |
| Font | Allows you to adjust the font size and style |
| Alignment | Set the alignment of the data in the cells and allow text to wrap |
| Number | Change the formatting of numeric data |
| Tables | Sort and filter tables or access the table options |
| Cells | Insert or delete cells in the spreadsheet |
| Data | Find data in the spreadsheet or refresh any connections to external data |
| Office | Open the spreadsheet in Excel located on your local computer |
For example, you can create a hyperlink with text that says “Learn More” that takes anyone viewing the Excel Web App document to a news article.
In addition to the Ribbon tabs, the interface also includes a File
menu. The File menu allows you to perform functionality, such as saving
the document as a different name, opening the document in the
traditional Excel application located on your computer, downloading a
snapshot of the document, or downloading a copy of the document.Course Info:
This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!
Highlights
- Break down Excel into its component parts to make it more manageable and less overwhelming
- Use common, understandable names to replace confusing cell references
- Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate
- Truly understand how formulas and functions work, no matter how seemingly simple or complex
- Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate
- Embrace the power of tables to sort, filter and manage data more easily
- Create charts with just one click
[youtube]http://www.youtube.com/watch?v=GsZgZYNf-SE[/youtube]
Chapter 1 - GETTING COMFORTABLE WITH EXCEL
This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!
Highlights
Chapter 1 - GETTING COMFORTABLE WITH EXCEL
This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!
Highlights
- Break down Excel into its component parts to make it more manageable and less overwhelming
- Use common, understandable names to replace confusing cell references
- Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate
- Truly understand how formulas and functions work, no matter how seemingly simple or complex
- Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate
- Embrace the power of tables to sort, filter and manage data more easily
- Create charts with just one click
Subscribe to:
Posts (Atom)