What's New in Office 2010 and Windows 7?
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
What's New in Microsoft Office 2010 And Windows 7? SONIC's training videos help you get used to the new Microsoft Office 2010 and Windows 7. The trainer explains the user interface and demonstrate the new functions and how to use them.
A selection of some of the important subjects:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: What's New in Office 2010 and Windows 7? - Overview|
|What’s new in Office 2010? Let’s take a quick look at the user interface to find out.|
|Section 2: Lesson One - What's New in Office 2010?|
|In all Office applications the key commands can be found on the ribbon, as they can in Word 2010. In this video you’ll learn about the ribbon and basic settings.|
|Execute commands such as “Open” and “Quick Print” even faster with the Quick Access toolbar.|
|Is the text too large or too small for you? Use the zoom settings to easily adjust the size.|
|Important information such as the word count and which page you are currently on is displayed on the status bar. In this video you’ll learn about the status bar.|
|“File”, (the Backstage view), offers countless useful functions such as “Open”, “Close”, “Print” and “Save As”. In this video you’ll learn about these useful functions.|
|Every data format has its own distinct features. Learn all you need to know about the new Office 2010 format.|
|PDF is a popular format. In this video you’ll learn how to export Word documents into a PDF.|
|The program options allow for even finer tuning of Office 2010 to suit user requirements. You can select the standard save format for your documents, for example.|
|Highlighted words can be edited even faster with the Mini Toolbar. In this video you’ll learn about the Mini Toolbar.|
|If you want to try out a font, Microsoft allows you to first view it in a live preview without any immediate changes being made.|
|Being “spoiled for choice” is a common problem when selecting the most appropriate fonts. Office 2010 helps narrow the selection with templates. Use the Design tab to apply ready-made fonts and effects.|
|Microsoft assists in various urgent queries. In this video you’ll learn about Office 2010's help resources.|
|Section 3: Lesson Two - New in Word 2010|
|The ruler is an extremely handy tool. For example, use the ruler to define accurate line spacing. In this video you’ll learn how to use the ruler function.|
|Word 2010 does not restrict you to one single view. In this video you’ll learn about the different views available in Word 2010.|
Numbering helps in the presentation of lists. Countless different number
symbols are available. In this video you’ll learn about the number
|Word allows you to mark words with minimal effort – as headings, for example. In this video you’ll learn how to use format templates.|
|Use the Navigation Pane to search for words or entire text passages and be redirected straight to the passage.|
|Whether for a job application or an essay, the appearance of all types of documents can be enhanced with a cover page. In this video you’ll learn how to create a cover page.|
|In this video you’ll learn how to insert a blank page between two existing pages of text.|
|Simple and ready-made tables can be created using Quick Tables.|
|Images can be inserted in Word 2010, they can also be resized and various effects can be applied.|
|Word 2010 allows you to take a picture (known as a screen shot) of your entire screen or just a small section of your screen.|
|Space can be found on the fullest of pages. At the top of the page is a header and, at the bottom, a footer. Headers and footers offer sufficient space for page numbers, footnotes or the current date.|
|Do you write the same text over and over? Word makes this extremely easy. Text can be saved and reused at any time using the Quick Parts function.|
|Use the mail merge function to print a standard form that can be replicated by using a ready-made address list. Word will automatically use the next address on the list every time it prints.|
|Word 2010 helps translate texts into other languages. Not only can Word translate the entire text, it can, when desired, also translate individual words.|
|Do you have a shopping list to manage and want to make life easier for yourself? Word 2010 can help with check boxes.|
|For example, use the “Check for Issues” command to check the compatibility of features with older versions of Word.|
|Word 2010 allows you to recover the last autosaved versions of your files.|
|Word allows you to mark a document as final so you can inform others that it is the final version.|
|Section 4: Lesson Three - New in Excel 2010|
|You’re not limited to working in one single view when editing an Excel file. Excel 2010's workbook views offer countless options.|
|Excel 2010 offers even bigger spreadsheets than previous versions: a total of up to 17 billion cells.|
|Regular Excel users must be able to work with several spreadsheets. In this video you’ll learn how to insert a new spreadsheet into an existing document.|
|Currency? Date? Excel converts numbers to suit your needs. In this video you’ll learn about the number formats.|
|Want to highlight specific cells or display icons? Excel 2010 can easily do so. Conditional formatting offers countless options.|
|Cell format templates allow you to format your cells with minimal effort.|
|Use PivotTables to present your data in a variety of different ways. In this video you’ll learn about PivotTables.|
|Sparklines offer you an interesting alternative to diagrams – they’re very simple and save space.|
|A large quantity of data can easily become overwhelming. In this video you’ll learn how to sort your data in this video.|
|Do you have a large quantity of data in a spreadsheet and only want to see specific information? No problem! The filters ensure that only entries matching your criteria are shown.|
|Excel 2010 allows you to easily remove duplicate entries.|
|Section 5: Lesson Four - New in PowerPoint 2010|
|In PowerPoint 2010, sheets can be viewed in various ways: for example, to select an on-screen presentation.|
|PowerPoint allows you to choose the layout to ensure optimal presentations.|
|PowerPoint allows you to return placeholders you have moved to their original position.|
|Graphics sometimes say more than words. According to this principle, SmartArt graphics help you create more sophisticated presentations.|
|Presentations can now be enhanced with videos by using the video tools feature.|
|A simple white background doesn’t make sense for every presentation. Use the Design tab to select from a range of design templates or create your own design.|
|Get things moving in your presentation! Animations are a good way to loosen things up or emphasize a particular process.|
|Before creating a multi-slide presentation, it’s useful to set some standards first. The Slide Master is an extremely helpful tool. In this video you will learn how to use the Slide Master to create a set of standards for a multi-slide presentation.|
|The more slides a presentation contains, the more space it requires. This can lead to longer loading times. PowerPoint helps you compress your presentations.|
|A PowerPoint presentation can be saved as a video and viewed on other computers that do not have PowerPoint software installed.|
|Section 6: Lesson Five - New in Outlook 2010|
|Outlook 2010 offers handy access to the most frequently-used commands. In this video you’ll learn about the interface.|
|In Outlook 2010, there are new features that allow you to further refine your standard view.|
|QuickSteps make working with Outlook even easier. Frequent actions and passages of text are readily available.|
|Use Outlook to set up Search Folders, which allow you to search for email items matching the criteria you have specified and store the emails into the designated folder.|
|Sometimes it’s useful to place multiple calendars side-by-side to be able to compare the data and times better. The planning view is the ideal tool for this. In this video you’ll learn about the planning view.|
|Group your calendars to enhance your overview by creating Calendar Groups.|
|Use Outlook 2010 to organize your daily tasks and set-up reminders for yourself and others in your work group.|
|Copying and inserting files from one program to another can, depending on their size, take minutes or even hours. Outlook 2010 offers a far quicker and more efficient way, which also helps reduce errors. Import the data from your Excel files easily.|
|Why not make things easy for yourself! Access other users' folders, or allow other users to access yours.|
|Want to use Outlook to read messages from all your email accounts? This is far easier than it sounds and made possible by managing your account settings.|
|Are you on holiday or unavailable to respond to an email? Let Outlook reply for you!|
|Sometimes there are a great many emails in the inbox. Outlook can assist you by deleting or archiving older messages.|
|Section 7: Lesson Six - New in Access 2010|
|It isn't always easy to find your way around databases. Focusing on the basic features first will help make things far easier. This video will help you navigate your way around Access 2010.|
|Basic commands can be found under the “Create” tab, which makes creating new tables far easier.|
|Section 8: Lesson Seven - New in Windows 7|
|Learning to use a new operating system can be a time-consuming affair. Allow me to save you some time with a brief overview.|
|Windows 7 allows you to add frequently used programs to either the start menu or the taskbar, enabling faster access.|
|If you can't find what you're looking for, or find it too time-consuming to click through lots of folders and subfolders, you may want to consider the Direct Search function.|
|Not only do open windows appear on the taskbar, other useful information such as the date and time and whether you are connected to the internet can also be displayed.|
|Recently opened files appear in the program's Jump List. Frequently used files can also be pinned.|
|Open or close a window, activate the full-screen mode, reduce the size of a window or move it is just a few of the window options in Windows 7.|
|Navigate the new Explorer with confidence and precision. It may seem unfamiliar, but it is extremely easy to use and very straightforward. A whole palette of new features are available.|
|Use the Library function to access all your files in one place. There's no need to click through countless folders; instead you can view the contents of multiple folders together in the Library.|
|Searching has become more targeted than previous versions of Windows. Windows Explorer even allows you to search for terms within files.|
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.