|
|
|
Introduction to Microsoft Excel 2003
|
| Price: |
$99.00 |
| Business Focus: |
Computer Applications |
| Instructor: |
Craig Power |
| Course Code: |
ix3 |
| Delivery Method: |
Instructor-led Online Course |
| Frequently Asked Questions |
|
|
| Course Overview: |
| Work with numbers? Then you need to learn Excel 2003. 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. |
| Instructor Biography: |
| Craig Power is a UCLA graduate who created custom accounting software for government agencies and developed an online course delivery and marketing platform used by more than 1000 colleges and universities around the world. He served as the science department chair at a Los Angeles high school, wrote and co-directed an interactive cellular biology video for the Los Angeles Unified School District, taught technology courses for a San Diego college, started a nationwide training network, and has worked in adult continuing education for more than fifteen years. He currently serves as an Executive Vice President for a large and well-known academic publisher that specializes in the areas of technology, law, science, health, and finance. |
| Course Syllabus: |
| Lesson 1 Syllabus |
Excel Terminology; Navigation and Editing; Constant Values vs. Formulas |
| Lesson 2 Syllabus |
Creating a Worksheet: Labels, Values, Formulas, and Formatting |
| Lesson 3 Syllabus |
Time-Savers |
| Lesson 4 Syllabus |
Relative, Absolute, and Circular References |
| Lesson 5 Syllabus |
Sheet References; Creating 3-Dimensional Workbooks; Linking Files |
| Lesson 6 Syllabus |
Sorting and Subtotaling |
| Lesson 7 Syllabus |
Creating Graphs: The Chart Wizard |
| Lesson 8 Syllabus |
Advanced Graphing Techniques |
| Lesson 9 Syllabus |
Statistics Made Easy: The Function Wizard |
| Lesson 10 Syllabus |
Financial Functions; Amortization |
| Lesson 11 Syllabus |
Worksheet Automation: Creating Macros and Customizing Toolbars |
| Lesson 12 Syllabus |
Creating Worksheets with Decision-Making Capabilities |