| Course Code: |
MSEXLL1 |
| Course Dates: |
|
| Course Objectives: |
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format namely Microsoft Excel.
In this course, you will use Microsoft® Office Excel 2007 to:
- Create a basic worksheet in Excel.
- Modify a worksheet in Excel.
- Use Excel to perform calculations.
- Format an Excel worksheet.
- Develop a workbook in Excel from scratch.
- Print the contents of a workbook.
- Customize the layout of the Excel window.
You will create and edit basic Microsoft® Office Excel 2007 worksheets and workbooks. |
| Course Duration: |
1 Day |
| No of Students: |
6 |
| Cost |
R 800 |
| Who should attend? |
This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2007 worksheets. |
Office: (012) 348 1747
Contact us now!
| Course Code: |
MSEXLL2 |
| Course Dates: |
|
| Course Objectives: |
In Microsoft® Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to use Excel to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this Excel course, you will use Microsoft® Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
In this course, you will use Microsoft® Office Excel 2007 to:
- Create and apply templates in Excel.
- Use Excel to create and modify charts.
- Work with graphic objects in Excel.
- Utilise Excel to calculate with advanced formulas.
- Sort and filter data using Excel.
- Use Excel with the Web.
|
| Course Duration: |
1 Day |
| No of Students: |
6 |
| Cost |
R 860 |
| Who should attend? |
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. |
Office: (012) 348 1747
Contact us now!
| Course Code: |
MSEXLL3 |
| Course Dates: |
|
| Course Objectives: |
You have used Microsoft® Office Excel 2007 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks in Excel, apply advanced analysis techniques to more complex data sets in Excel, collaborate on worksheets with others using Excel, and share Excel data with other applications.
In this course, you will use Microsoft® Office Excel 2007 to:
- Customize workbooks in Excel.
- Collaborate with others using Excel workbooks.
- Use Excel to audit worksheets.
- Analyze data with Excel.
- Use Excel to work with multiple workbooks.
- Import and export data in Excel.
- Structure workbooks with XML in Excel.
|
| Course Duration: |
1 Day |
| No of Students: |
6 |
| Cost |
R 860 |
| Who should attend? |
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2007 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. |
Office: (012) 348 1747
Contact us now!
|
