Publication Details

Intermediate Microsoft Excel 2003
Price: $99.00
Business Focus: Computer Applications
Instructor: CraigPower
Course Code: nx3
Delivery Method: Instructor-led Online Course
Frequently Asked Questions
     
Course Overview:
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.
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 Charting Fundamentals
Lesson 2 Syllabus Advanced Charting
Lesson 3 Syllabus Data Management
Lesson 4 Syllabus AutoFilter; Goal Seeking
Lesson 5 Syllabus The Pivot Table: Part 1
Lesson 6 Syllabus The Pivot Table: Part 2
Lesson 7 Syllabus The Solver: Part 1
Lesson 8 Syllabus The Solver: Part 2
Lesson 9 Syllabus Macros
Lesson 10 Syllabus Text Functions
Lesson 11 Syllabus Math Functions
Lesson 12 Syllabus Lookup Functions