I.T. Training courses
Records 1 to 10 of 17
This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example:- Create pivot tables and charts.
- Learn to trace precedents and dependents.
- Convert text and validate and consolidate data.
- Collaborate with others by protecting worksheets and workbooks.
- Create, use, edit, and manage macros.
- Import and export data.
This course is ideal for individuals who wish to enhance their current knowledge of Excel by understand how to use the application's more complex features. You will learn how to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional looking format.
This course is ideal for individuals who wish to enhance their current knowledge of Excel by understand how to use the application's more complex features. You will learn how to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional looking format.
Upon successful completion of this course, students will be able to:
- Explore the Excel 2016 environment.
- Work with an Excel worksheet by entering and selecting the data in it. You will also save the Data in the worksheet.
- Modify a worksheet.
- Perform calculations.
- Format a worksheet.
- Develop a workbook.
- Print workbook contents.
- Customise the layout of the Excel application window.
- Create charts.
- Create customized presentations with templates.
- Add special effects.
- Use the slide, notes, and handout masters.
- Create, edit, and import charts.
- Manage hyperlinks.
- Create custom shows.
- Secure and share presentations.
- Course details
- Course Outline
- Start and end a PowerPoint session.
- Edit a presentation.
- Create different types of slides.
- Use the Outline tab.
- Add Clipart to a slide.
- Format slides and use templates.
- Use the Slide Sorter to reorganize a presentation.
- Apply Tables and Charts to a presentation.
- Print various components of a presentation.
- Run a slide show.
Records 1 to 10 of 17