Guest blogger Emily Warn is co-owner of Two Pens, which provides blogging services and teaches business how to write content that grows a social media following.
My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number. I know that is only the first rung of Excel Geek-dom, and unlike my compatriots, I aspire to climb into the ranks of those who know how to create snazzy charts and perform other formatting feats. Perhaps I'll be able to brand myself as a writer who plays with numbers.
www.office.com/setup Blogs: If you are still using Microsoft Office 2003, you should be aware that Official support has long ended. If you are using Office 2007, support is due to end in 2 short years. Microsoft Office 2016, the latest Windows-based version of the major technology company's application suite, is scheduled for a release sometime in spring, 2015. However, we already know quite a bit about the product, thanks to a preview and testing program that Microsoft has been running.
Here are 6 details to look forward to, ahead of the product's mainstream release:
1. Better Security
Microsoft Office 2016 will emphasize the value of better security parameters. In addition to a file-level encryption functionality, new data loss protection tools inside of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint will warn users when they attempt to save confidential files to unsafe locations. Microsoft Outlook will also be more secure, thanks to a multi-factor authentication feature.
Similarly, the application suite will have stronger information rights management tools that let you limit what people can do with your documents or emails after you've shared access with them. For example, you can allow access to a certain document to expire after a set period of time, and prevent it from being forwarded. These tools will also stop people from copying and pasting information out of Microsoft Office 2016 applications.
2. Business Intelligence Features
Microsoft Excel lives up to its name in Microsoft Office 2016. The latest version of this application features a built-in business intelligence tool called Power Query. This tool can dramatically change the way that you approach your data.
Using it, you can quickly combine your own numbers with figures from public databases like Data.gov and Microsoft Azure Marketplace. After doing this, the application has another tool that lets you create detailed visualizations of the combined data.
The data analysis tool
As governments strive to become more responsive and transparent, it's important for them to make public information easily accessible to citizens. At the same time, it's critical that they protect confidential data.
A key reason why governments choose Microsoft Office 365 is Microsoft's leadership in the industry when it comes to privacy, security, and compliance practices. In short, governments know they can trust Microsoft to help protect their data.
So how does Microsoft demonstrate leadership and why exactly do governments trust Office 365 to help protect their data? Here are four reasons:
We respect your privacy. Google is under criticism for its privacy practices. Office 365 does not build advertising products out of customer data, unlike other companies. Nor do we scan your email or documents for building analytics, data mining, or advertising, or to improve the service. What's more, you own your data. Office 365 customer data belongs to the customer. Customers can remove their data whenever they choose.
Office 365 is independently verified. Office 365 is compliant with many world-class industry standards, and it is verified by third parties. For example, Office 365 is the first major business productivity public cloud service to have implemented the rigorous set of physical, logical, process, and management controls defined by ISO 27001, one of the best security benchmarks available in the world. In addition, Office 365 is the first major business productivity public cloud service provider to sign the standard contractual clauses created by the European Union ("EU Model Clauses") with all customers. Office 365 also implements security processes that adhere to the Federal Information Security Management Act (FISMA) required by U.S. federal agencies and to the Health Insurance Portability and Accountability Act (HIPAA).
With Office 365, you know where your data is located. Office 365 customers know where major Office 365 datacenters are located
SmartArt allows you to communicate information with graphics instead of just using text. There are a variety of styles to choose from, which you can use to illustrate different types of ideas.
Watch the video below to learn more about working with SmartArt.
TO INSERT A SMARTART GRAPHIC:
Select the slide where you want the SmartArt graphic to appear.
From the Insert tab, select the SmartArt command in the Illustrations group.
selecting the SmartArt command on the Insert tab - www.office.com/setup
A dialog box will appear. Select a category on the left, choose the desired SmartArt graphic, then click OK.
choosing a SmartArt graphic - www.office.com/setup
The SmartArt graphic will appear on the current slide.
the inserted smartart - www.office.com/setup
You can also click the Insert a SmartArt Graphic command in a placeholder to add SmartArt.
Inserting a SmartArt Graphic from a placeholder - www.office.com/setup
TO ADD TEXT TO A SMARTART GRAPHIC:
Select the SmartArt graphic. The text pane will appear to the left
Enter text next to each bullet in the text pane. The text will appear in the corresponding shape. It will be resized automatically to fit inside the shape.
adding text to the SmartArt graphic - www.office.com/setup
You can also add text by clicking the desired shape and then typing. This works well if you only need to add text to a few shapes. However, for more complex SmartArt graphics, working in the text pane is often quicker and easier.
adding text directly in the shapes of the SmartArt instead of the text pane - www.office.com/setup
TO REORDER, ADD, AND DELETE SHAPES:
It's easy to add new shapes, change their order, and even delete shapes from your SmartArt graphic. You can do all of this in the text pane, and it's a lot like creating an outline with a multilevel list. For more information on multilevel lists, you may want to review our Lists lesson.
To demote a shape, select the desired bullet, then press the Tab key. The bullet will move to the
www.office.com/setup Blogs: PowerPoint allows you to insert a video onto a slide and play it during your presentation. This is a great way to make your presentation more engaging for your audience.
You can even edit the video within PowerPoint and customize its appearance. For example, you can trim the video's length, add a fade in, and much more.
Optional: Download our practice presentation.
Watch the video below to learn more about inserting videos in PowerPoint.
TO INSERT A VIDEO FROM A FILE:
In our example, we'll insert a video from a file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example video and save it to your computer.
From the Insert tab, click the Video drop-down arrow, then select Video on My PC.
Inserting a video from a file - www.office.com/setup
Locate and select the desired video file, then click Insert.
Selecting a video to insert - www.office.com/setup
The video will be added to the slide.
The inserted video - www.office.com/setup
With the Screen Recording feature on the Insert tab, you can create a video of anything you are doing on your computer and insert it into a slide.
the Screen Recording button on the Insert tab - www.office.com/setup
TO INSERT AN ONLINE VIDEO:
Some websites-like YouTube-allow you to embed videos into your slides. An embedded video will still be hosted on its original website, meaning the video itself won't be added to your file. Embedding can be a convenient way to reduce the file size of your presentation, but you'll also need to be connected to the Internet for the video to play.
Inserting an online video - www.office.com/setup
WORKING WITH VIDEOS
TO PREVIEW A VIDEO:
Click a video to select it.
Click the Play/Pause button below the video. The video will begin playing, and the timeline next to the Play/Pause button will advance.
The Play/Pause button and the timeline - www.office.com/setup
To jump to a different part of the video, click anywhe
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them.
In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.
Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example.
Watch the video below to learn more about working with tables in Access.
TABLE BASICS
TO OPEN AN EXISTING TABLE:
Open your database, and locate the Navigation pane.
In the Navigation pane, locate the table you want to open.
Double-click the desired table.
Opening a table - www.office.com/setup
The table will open and appear as a tab in the Document Tabs bar.
The open table - www.office.com/setup
UNDERSTANDING TABLES
All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields.
A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table.
Fields and field names - www.office.com/setup
A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table.
Records and record ID numbers - www.office.com/setu
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent.
This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones.
Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example.
Watch the video below to learn more about working with forms in Access.
WHY USE FORMS?
Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it.
Illustration of a paper form - www.office.com/setup
This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table.
The Customer ID field links to the Customers table - www.office.com/setup
In fact, in order to see the entire
WWW.OFFICE.COM/SETUP BLOGS: POWERPOINT MIGHT BE INCLUDED IN OFFICE 2016, BUT EVERYONE KNOWS IT'S SO PASSĆ.
as easy as drag and drop - www.office.com/setupwww.office.com/setup Blogs: These days it's all about Sway - the first of many native apps to be rolled out to Microsoft Office 365 subscribers.
To put it simply, Sway is a web browser-based storytelling app. It allows anyone with the most basic computing knowledge to create beautiful-looking websites and presentations with images, text, tweets, videos or whatever other media you want to include. It works a bit like Word and Powerpoint combined - and finished products can be used on websites to display family photos, or in a beautiful work presentation.
"The interface is based around a storyline, which allows users to bring in raw content such as PDFs, spreadsheets, graphs, photos, video and text," a spokesman for Microsoft told news.com.au.
When creating a new presentation, users begin with a blank page containing nothing more than a title card. From there, add raw content, such as photos or text, and either place it all where desired or use a template that does the work for you.
"It is as simple as clicking and dragging the content the user wants to add the presentation," the spokesman said.
An impressive feature that sets this application apart from the likes of Powerpoint is its integration with popular social media networking sites.
Users can import pictures from Facebook, YouTube videos, tweets and other content without having to leave the app.
Once happy with the content included, users can tweak its appearance by using the "Remix" feature.
This will cycle the appearance of the presentation through the many templates available in the app.
Microsoft has completely embraced the cloud with Sway, with work available to view through a web browser on any device the moment its finished. The work can then be shared on social media or even embedded on other websites. Best of all, itā
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends.
Optional: Download our practice presentation for this lesson.
Watch the video below to learn more about using charts in PowerPoint.
TYPES OF CHARTS
PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used.
Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint.
Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint.
Slide 1 - www.office.com/setup
Slide 1 - www.office.com/setup
Slide 1 - www.office.com/setup
Slide 1 - www.office.com/setup
Slide 1 - www.office.com/setup
IDENTIFYING THE PARTS OF A CHART
In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data.
Click the buttons in the interactive below to learn about the different parts of a chart.
Book sales chart - www.office.com/setup
LEGEND
The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart.
INSERTING CHARTS
PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson.
TO INSERT A CHART:
Select the Insert tab, then click the Chart command in the Illustrations group.
- www.office.com/setup
A dialog box will appear. Select a category from the left pane, an
www.office.com/setup Blogs: The shrouded veil of secrecy has been lifted from the latest edition of Microsoft Office. Excitement for Office 2016 is still lagging behind the Windows 10 enthusiasm camp, but following the July 29 release of Windows 10, attention will return to the world's most popular productivity suite.When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview? When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview?Windows 10 is coming soon. Still confused about how the upgrade will work and wondering about the timeline? We have some answers, although more questions remain.READ MORE
Office 2016, like Windows 10, has been re-designed within a revised Microsoft ethos. Office 2016 has been built from the ground-up with mobile and cloud users in mind, slotting in with the ever expanding fleet of Microsoft productivity applications. Office is, in general, a different set of tools from days gone by. We aren't confined to the five-or-so core products, and we can expand the functionality of the Office ecosystem using a massive range of add-ins and templates.
Office 2016 logo - www.office.com/setup
I'm using VirtualBox to preview Office 2016. Microsoft strongly suggested uninstalling Office 2013, which isn't currently viable due to work commitments. Using a virtual machine, however is a great way to explore different Office products alongside each other, without having to uninstall your current suite. I've also had a look at Office 2016 on Windows 10 Build 10130. Verdict: good times.How To Use VirtualBox: User's Guide How To Use VirtualBox: User's GuideLearn to use VirtualBox. Get virtual computers up and running inside your computer, without having to buy any new hardware.READ MORE
Anyway, enough of that. Let's look at Office 2016.
NEW OVERVIEW
Much akin to the extended and inclusive testing phase of Windows 10, the Office 2016 preview has now accumulated over 1 million users,
WWW.OFFICE.COM/SETUP BLOGS: GO TEAM! THAT'S WHAT OFFICE 2016 IS BUILT TO ENCOURAGE, WITH NEW COLLABORATIVE TOOLS AND OTHER WAYS TO TIE WORKERS AND CONTENT TOGETHER.
pcw office primary 2 - www.office.com/setupwww.office.com/setup Blogs: Office 2016 is a major upgrade, but not in the way you'd first suppose. Just as Windows 10 ties notebooks, desktops, phones and tablets together, and adds a layer of intelligence, Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along.
I tested the client-facing portion of Office 2016. Microsoft released the trial version of Office 2016 in March as a developer preview with a focus on administrative features (data loss protection, multi-factor authentication and more) that we didn't test. I've been using it since the consumer preview release in May. Microsoft seeded reviewers with a Microsoft Surface 3 with the "final code" upon it. That's a slight misnomer, as the Office 2016 apps upon it used the same version that Microsoft had tested with the public, with a few exceptions: Outlook was pre-populated with links and contacts of a virtual company to give reviewers the look and feel of Delve, Outlook's new Groups feature, and more.
Office 2013 users can rest easy about one thing: Office 2016's applications are almost indistinguishable from their previous versions in look and feature set. To the basic Office apps, Microsoft has added its Sway app for light content creation, and the enterprise information aggregator, Delve.
Collaboration in the cloud is the real difference with Office 2016. Office now encourages you to share documents online, in a collaborative workspace. Printing out a document and marking it up with a pen? Medieval. Even emailing copies back and forth is now tacitly discouraged.
office 2016 review powerpoint demo shot - www.office.com/setupMicrosoft
Microsoft says its new collaborative workflow reflects how people do things now, from study groups
www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016.
Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite.
HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS?
Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords.
Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files.
click browse to import office files - www.office.com/setup
Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation.
1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery.
2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc.
3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover.
choose attack type - www.office.com/setup
Step3. Finally, click "Recov
WWW.OFFICE.COM/SETUP BLOGS: OFFICE 2016 OFFERS MANY ENHANCEMENTS THAT INTEGRATE MORE TIGHTLY WITH SHAREPOINT AND ONEDRIVE. IT CAN BE CONFUSING TO KEEP TRACK OF ALL THE FEATURES, SO WE PICK 10 YOU ARE SURE TO LOVE. Collaboration is the key to Microsoft's still-ubiquitous productivity suite. To the casual user, the applications that make upOffice 2016 - Word, Excel, PowerPoint and Outlook are the anchor tenants, of course, rounded out by OneNote, Access and Publisher - will be indistinguishable from their predecessors. But make no mistake about it; Microsoft's reboot of its flagship software suite is a major update, offering a wealth of collaboration capabilities that integrate more tightly with SharePoint and OneDrive than before. The many tweaks and enhancements across the board can be confusing though, and we peek under the hood to highlight the features that matter most. 1. REAL-TIME CO-AUTHORING The capability to work on the same document simultaneously with your colleagues comes to the desktop version of the productivity suite in Office 2016. Colleagues can work on the same Word documents and PowerPoint presentations that are saved on SharePoint or OneDrive without overwriting each other's changes. Note that the "real-time typing" feature in which you can see your colleagues working on the same document is only available in Word for now. PowerPoint supports co-authoring, but without real-time typing. 2. SIMPLIFIED DOCUMENT SHARING You can now easily share your documents in Office 2016, courtesy of a prominent "Share" button in the Ribbon. Available across Word, Excel and PowerPoint, the Share button lets you share access to a document to your team members, and serves as a one-stop location to review access permissions or see who is currently working on the document. As with co-authoring, the files must be saved in either SharePoint or OneDrive in order to be shared. 3. CAPABILITY TO SEND LARGE FILES USING ONEDRIVE While the ability to sha
www.office.com/setup Blogs: Last year, we released Microsoft Bookings to customers in the U.S. and Canada, introducing an easy way for small businesses to schedule and manage appointments with their customers. Today, we are pleased to announce that we're beginning to roll out the service to Office 365 Business Premium subscribers worldwide. Based on your feedback, we are bringing several new features to Bookings:
Add your Office 365 calendar to Bookings-Connect your Office 365 calendar to Bookings, so that the times you are busy will automatically be blocked in your public Booking page.
Add buffer time before and after your appointments-Do you need prep time before or after an appointment? Adding buffer time to a service automatically blocks that time in your Booking page too.
Bookings apps for your iOS and Android phone-Now you can book an appointment, contact a customer or check a staff member's appointments while away from the office.
Customize your Booking page-We added more color customization options, so you can better personalize your Booking page.
These new capabilities will start showing up automatically in Bookings in the coming weeks. Let's take a detailed look at what's new.
ADD YOUR OFFICE 365 CALENDAR TO BOOKINGS
One of the top pieces of feedback we've heard is that you want to be able to add events from your Office 365 calendar to Bookings. So, we added integration between these calendars to help you avoid booking customer meetings during the time you've set aside for personal appointments, staff and partner meetings or other aspects of running your business.
To add Office 365 calendars to Bookings, click the Staff tab on the left navigation panel. On the Staff details page, select the Events on Office 365 calendar affect availability checkbox.
www.office.com/setup
Add Office 365 calendar events to Bookings.
Once you activate this option, the system automatically blocks busy times on the Bookings calendar and on the self-ser
www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016.
Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite.
HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS?
Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords.
Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files.
click browse to import office files - www.office.com/setup
Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation.
1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery.
2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc.
3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover.
choose attack type - www.office.com/setup
Step3. Finally, click "Recov
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: Many of the features in Office are geared toward saving and sharing files online. OneDrive is Microsoft's online storage space that you can use to save, edit, and share your presentations and other files. You can access OneDrive from your computer, smartphone, or any of the devices you use.
To get started with OneDrive, all you need to do is set up a free Microsoft account if you don't already have one.
If you don't already have a Microsoft account, you can go to the Creating a Microsoft Account lesson in our Microsoft Account tutorial.
Once you have a Microsoft account, you'll be able to sign in to Office. Just click Sign in in the upper-right corner of the PowerPoint window.
signing in to OneDrive - www.office.com/setup
BENEFITS OF USING ONEDRIVE
Once you're signed in to your Microsoft account, here are a few of the things you'll be able to do with OneDrive:
Access your files anywhere: When you save your files to OneDrive, you'll be able to access them from any computer, tablet, or smartphone that has an Internet connection. You'll also be able to create new presentations from OneDrive.
Back up your files: Saving files to OneDrive gives them an extra layer of protection. Even if something happens to your computer, OneDrive will keep your files safe and accessible.
Share files: It's easy to share your OneDrive files with friends and coworkers. You can choose whether they can edit or simply read files. This option is great for collaboration because multiple people can edit a presentation at the same time (also known as co-authoring).
SAVING AND OPENING FILES
When you're signed in to your Microsoft account, OneDrive will appear as an option whenever you save or open a file. You still have the option of saving files to your computer. However, saving files to your OneDrive allows you to access them from any other computer, and it also allows you to share files with friends and co
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.
Watch the video below to learn more about Excel.
GETTING TO KNOW EXCEL
If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface.
THE EXCEL INTERFACE
When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks.
From the Excel Start Screen, locate and select Blank workbook to access the Excel interface.
The Excel Start screen - www.office.com/setup
Click the buttons in the interactive below to become familiar with the Excel interface.
- www.office.com/setup
WORKING WITH THE EXCEL ENVIRONMENT
The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document.
THE RIBBON
Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.
Each tab will have one or more groups.
Groups on the ribbon - www.office.com/setup
Some groups will have an arrow you can click for more options.
Some groups have a menu for more options - www.office.com/setup
Click a tab to see more commands.
Tabs on the ribbon - www.office.c
What is Microsoft Visio used for? Diagrams. That's what Microsoft Visio does, and it does it better than any other app I've seen yet. From flow charts to floor plans, there isn't much it can't handle. Now, being honest, I didn't know much about Visio until recently. But that changed when I decided to take it for a test drive - right out of the latest Microsoft Office.
Visio Templates Office 2013 - www.office.com/setup
Microsoft Visio can be used to create simple or complicated diagrams. It offers a wide variety of built-in shapes, objects, and stencils to work with. You can also make your own shapes and import them if you're willing to do all that extra work. The driving idea behind Visio is to make diagramming as easy as possible for the user. I think Visio is on the right track for that!
Note: Click images below to open them at Full Size.
The Visio 2013 welcome screen features a dozen different templates to get you started. Each template equips you with the appropriate menu and objects already open and ready for use. Even more templates can be found in specific categories within the application, or from Visio's online download page.
visio welcome screen - www.office.com/setup
Visio's primary clientele have been Enterprise users at the corporate level. If you think about it, it's not too often that the home user needs to write up professional diagrams. Usually, a paper and pen will suffice because a home user's diagram isn't being sent out to an entire department. That's why Visio has always been considered a program for "serious" diagrams. But it doesn't have to be.
table chart with live data - www.office.com/setup
Visio can be used to create 3D map diagrams, though the built-in tools for this are limited. It works well for simple maps that you might print on a brochure or campus directory.
visio map - www.office.com/setup
Another thing Visio can do is pull in live information from an external source, such as an Excel shee
Microsoft Forms is a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. When you create a quiz or form, you can invite others to respond to it using any web browser, even on mobile devices. As results are submitted, you can use built-in analytics to evaluate responses. Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading.