Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Items in Cart: 0 items
Cart Total
Checkout
Filters Applied
  • Tag: MOS 2007 Certification
Reset All
Excel 2010 Intermediate Course

Excel 2010 Intermediate Course

In this course you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to create and format charts. You will work with templates, collaborate in workbooks and use the drawing tools to enhance and annotate spreadsheets. Instructor: Pam Conway Prerequisites: Excel 2010 Introduction or Equivalent Experience Video Length: 221 Minutes

Visited 2,166 times
$30.00
Excel 2010 Introduction Course

Excel 2010 Introduction Course

This course is designed to teach students the fundamentals of Excel. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks). Instructor: Pam Conway Prerequisites: Basic Computer Experience Video Length: 230 Minutes

Visited 3,413 times
$30.00
Excel 2007 VBA Course

Excel 2007 VBA Course

This course introduces the user to Excel macro programming using Microsoft’s Visual Basic for Application (VBA). The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them. To teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Learn to use proper variable declaration, control structure use, looping, and Userform creation. Prerequisites: Excel 2007 Advanced Video Length: 195 Minutes

Visited 1,493 times
$30.00
Excel 2007 Advanced Course

Excel 2007 Advanced Course

In this class students will work with advanced formulas, as well as lookup functions and manage their data. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about running and recording macros. Learn how to work with advanced formulas, as well as lookup functions and manage their data. Learn to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally,  learn about running and recording macros Prerequisites: Excel 2007 Intermediate or Equivalent Experience Video Length: 193 Minutes

Visited 2,355 times
$30.00
Excel 2007 Intermediate Course

Excel 2007 Intermediate Course

This class builds on the skills and concepts taught in Excel 2007 Introduction. Students will learn how to use multiple worksheets and workbooks efficiently. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques. Demonstrates use  of multiple worksheets and workbooks efficiently. Learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Learn to save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques. Prerequisites: Excel 2007 Introduction or Equivalent Experience Video Length: 145 Minutes

Visited 2,248 times
$30.00
Excel 2007 Introduction Course

Excel 2007 Introduction Course

This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. Help system,navigate worksheets and workbooks, edit text, values, formulas, and pictures, and save workbooks in various formats. Move and copy data, absolute and relative references, work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, create and modify charts, and learn how to manage large workbooks. Prerequisites: Basic computer experience Video Length: 136 Minutes

Visited 1,824 times
$30.00