Intermediate Microsoft Excel 2016 New Horizons Computer Learning Center
Price: AED 1,638

Course details

Students will learn how to use multiple worksheets and workbooks efficiently, start working with more advanced formatting options including styles, themes, and backgrounds, learn how to create outlines and subtotals, work with tables and add hyperlinks.

Course Outline
1 - Using multiple worksheets and workbooks
Using multiple workbooks Linking worksheets with 3-D formulas Linking workbooks Managing workbooks
2 - Advanced formatting
Using special number formats Using functions to format text Working with styles Working with themes Other advanced formatting
3 - Outlining and subtotals
Outlining and consolidating data Creating subtotals
4 - Cell and range names
Creating and using names Managing names
5 - Tables
Sorting and filtering data Advanced filtering Working with tables
6 - Web and sharing features
Saving workbooks as Web pages Using hyperlinks Sharing workbooks
7 - Advanced charting
Chart formatting options Combination charts Graphical elements
8 - Documenting and auditing
Auditing features Comments in cells and workbooks Protection Workgroup collaboration
9 - Templates and settings
Changing application settings Using built-in templates Creating and managing templates
10 - PivotTables and PivotCharts
Working with PivotTables Rearranging PivotTables Formatting PivotTables Using PivotCharts Updated on 24 October, 2017

About New Horizons Computer Learning Center

New Horizons is the world’s largest training provider with a global footprint of more than 300 locations in over 70 countries.They have more combined global training experience than any other training provider in the world as an industry leading training provider.   The institute has been awarded more times
by major vendors than any other training organisation in the world.Their customers have a dedicated account manager who provides advice and guidance regarding training solutions and manages the relationship end-to-end.
        

See all New Horizons Computer Learning Center courses
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or