Intro to Microsoft Excel

    Work with numbers? Then you need to learn Excel. 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.

    View dates this course will be offered.

    Requirements:

    For this class, you will need Microsoft Excel 5.0, 95 or 97 or the Microsoft Office 95 or 97. You'll also need Internet access, e-mail, and the Microsoft Internet Explorer or Netscape Navigator web browser.

Syllabus

Week One
Lesson 1 Excel terminology; navigation and editing; constant values vs formulas
Lesson 2 Creating a worksheet: labels, values, formulas, and formatting
Week Two
Lesson 3 Time-savers: autofill, custom lists, advanced formatting, cut and paste
Lesson 4 Relative, absolute, and circular references
Week Three
Lesson 5 Sheet references: creating 3-dimensional workbooks; linking files
Lesson 6 Sorting and subtotaling
Week Four
Lesson 7 Creating graphs: the Chart Wizard
Lesson 8 Advanced graphing techniques
Week Five
Lesson 9 Statistics made easy: the Function Wizard
Lesson 10 Financial functions; amortization tables
Week Six
Lesson 11 Worksheet automation: creating macros and customizing toolbars
Lesson 12 Creating worksheets with decision-making capabilities

Other Microsoft Office Courses

Other Courses