Viewers: in countries Watching now:
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
If you're just getting started with Excel, you've probably asked yourself the question, "What is Excel used for?" Excel is usually described as a " spreadsheet package" and that it certainly is. For example, what we're seeing on the screen here perhaps is the budget, the sales, expenses for small operation, and of course, we could easily expand this to a much larger operation with a lot more detail. This is covering data for a whole year, nice quarterly totals that could easily be expanded into a five- year budget projection model. Excel also can be used for handling database like information.
Here's a list of our customers. We might want to sort this, we might want to do other things with it, it might have over a million rows even. We might keep track of our employees. Excel also has a table feature that facilitates treating this data as a unit, so that we can sort it and filter it quickly and easily. When it comes time to presenting information, Excel's charting capability allows us to quickly turn numbers like we're seeing here into attractive charts, like the one to the right. Excel has tons of analytical capability. It's got lots of formula capability, as well as over 400 built-in functions to ease your use of mathematical and statistical tools.
It's got a great future called Pivot Table that allows us to quickly analyze information like this transactional data to the left, into a compact table on the right that quickly gives us the big picture. If that were not enough, Excel has a number of visual tools as well. For example, the title the way we're seeing on the screen, the organization chart to the right. There are over 200 built-in similar tools here like Venn Diagrams and others that quickly allow you to create presentation tools. When it comes to using Excel, there are just so many different ways you can use this package.
It's just a giant grid of columns and rows and you can use it for a variety of applications.
There are currently no FAQs about Excel 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.