Introduction to Microsoft Excel
Work with numbers? Then you need to learn Excel 2007. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons.
Microsoft Excel 2007 in the Classroom
the basics of Microsoft Excel 2007 in this professional development course for
teachers, and get the training every teacher needs for using and teaching this
powerful program effectively in the classroom. This unique online workshop is
packed full of tips, shortcuts, and lesson plan ideas.
First, we'll cover all the important Excel fundamentals: Using tabs, formatting cells and worksheets, inserting formulas for addition, subtraction, multiplication, and division, and creating colorful charts and graphs. Then we'll move on to more advanced Excel features such as sorting and analyzing student test data for differentiated instruction, writing powerful mathematical formulas, and using Excel to automatically calculate student averages and other statistics. You'll finish the course by creating a customizable grade book that you can use in your own classroom.
Throughout the course, we'll explore standards-based lesson plans and activities that allow you to pass your Excel knowledge on to your students, no matter what grade level you teach. By the end, you'll have a solid understanding of Excel, and a wealth of ideas for integrating this technology into your lesson plans across your curriculum.
Intermediate Microsoft Excel 2003
Have you been using Excel 2003 to its fullest potential? Learn how to work faster and more productively. Discover how the Pivot Table and AutoFilter can help you rapidly create reports and analyses. Learn advanced graphing techniques and how to use functions to get Excel 2003 to perform complex math, make decisions, and look up values in a table.
Advanced Microsoft Excel 2003
proficient Microsoft Excel user will agree that Excel is a very powerful
analytical tool. Wouldn't it be great to learn how to effectively use every
Excel tool at your disposal? In this course, you'll learn how to maximize
Excel's analytical and functional capabilities.
Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more of a value to your organization. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead to better decision-making.
In this practical and information-packed course, you'll learn how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced pivot table techniques, like creating calculated fields and calculated items. You'll become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. And you'll become proficient at nesting functions within other functions to accomplish just about anything Microsoft Excel has to offer.