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.
Enroll or learn more about Introduction to Excel 2003
Enroll or learn more about Introduction to Excel 2007
Microsoft Excel 2007 in the Classroom
Learn
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.
Enroll or learn more about Microsoft Excel 2007 in the Classroom
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.
Enroll or learn more about Intermediate Microsoft Excel 2003
Advanced Microsoft Excel 2003
Any
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.
