Excel is used to meet a variety of record-keeping, data management, and analysis needs across a wide range of disciplines throughout the world. Learn the essentials of Excel in this course.
- [Instructor] What's Excel all about? What is it used for? If you've been using Excel for a bit, you've probably asked yourself that question, or maybe you're brand new with Excel. One way of looking at Excel is, it's just a giant grid of columns and rows. But more likely Excel's being described as a spreadsheet package. And that it is. It's a lot more though. Here's a spreadsheet. We can do a lot with this. We can keep track of a budget. We can extend this over a year. Maybe we've got a budget looks like this. Or maybe we simply use Excel to use the column and row layout to keep track of our customers.
Or we could just as easily be keeping track of our sales, our transactions, our employees, like we see on the next sheet over here. Excel is used for a variety of reasons. Microsoft estimates that at least 70% of Excel users use it to maintain lists of one kind or another. Excel has tools for working with this list to make it easier to find information as well. There's a great charting capability also. We can easily take those boring numbers and display them for the meeting as a colorful chart like the one we see here.
And there's a great feature called a pivot table. We've got tons and tons of data, for example here, furniture sales over a two year period, a 1,000 rows or so. Gives us the big picture. A pivot table can easily and without formulas give us summary information. And we can manipulate that data in a lotta different ways too. Excel also has some great visual tools as well. There's a feature called smart art. We can also put in special titles like we see here or build an organization chart. And there's some 200 variations on different chart types like we're seeing off to the right.
So we've taken a quick look at some of the many different ways that we can use this powerful and flexible tool. Excel is used throughout the world for any number of different applications.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros