Are you a number cruncher or would you like to be? Then Excel is the app for you. In this video, learn how to create and save a workbook, enter and edit data, apply a number format, insert a chart, and use AutoSum and the Quick Analysis button.
- [Cecilia] Excel is the powerhouse of Office 365. … It's been the spreadsheet of choice … for as long as I can remember. … When we need to crunch numbers, … Excel is our go-to application. … And just like with Word and PowerPoint, … there are two versions of Excel that you can leverage: … the online or the desktop version. … For our demonstration today, … we're going to go ahead and work with the desktop version. … And as we've seen before, … we can select an existing template, … we can work on a previously opened file, … or we can create a new workbook. … Today, we're going to go ahead and create a new workbook. … I'm going to select Blank workbook. … Our spreadsheet today will have the guest rooms … and the rate per day for the week. … The first thing I'm going to do … is add in the days of the week. … This is a little boring and monotonous. … If I highlight Monday, Tuesday, … I can drag across and the columns … will populate automatically for me. … I'm also going to add a title to this spreadsheet. …
- Troubleshooting account and startup issues
- Repairing Office apps
- Working with Word, PowerPoint, Excel, and Power BI
- Creating diagrams with Visio
- Staying on top of tasks using Microsoft Project and Planner
- Configuring Outlook
- Communicating with Teams
- Working with OneDrive and SharePoint
- Sharing content with Sway and Stream
Skill Level Intermediate
1. Getting Users Started
4. Getting Things Done
6. Media Rich Apps
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.