Excel 2010 Expert Start on Mar 08.
Excel advanced skills is used every where.
(This course is not part of Core Package).
The class time is 14:00 to 17:00 Saturday USA PST (California time)
03/08/2014 3hr 03/15/2014 3hr 03/22/2014 3hr 03/29/2014 3hr
Price: $480 ($420 for Core Package 2013 Student)
Click here make payment with a Credit Card:
http://student.usalaotu.com/make_payment.phpPre-request: No
--
Class syllabus--
Sharing and maintaining workbooksApply workbook settings, properties, and data options
Setting advanced properties; saving a workbook as a template; importing and exporting XML data
Apply protection and sharing properties to workbooks and worksheets
Protecting the current sheet; protecting the workbook structure; restricting permissions; requiring a password to open a workbook
Maintain shared workbooks
Merging workbooks; setting Track Changes options
Preparation resources
Use a shared workbook to collaborate
Password protect worksheet or workbook elements
Track changes in a shared workbook
Applying formulas and functionsAudit formulas
Tracing formula precedents, dependents, and errors; locating invalid data or formulas; correcting errors in formulas
Manipulate formula options
Setting iterative calculation options; enabling or disabling automatic workbook calculation
Perform data summary tasks
Using an array formula; using a SUMIFS function
Apply functions in formulas
Finding and correcting errors in functions; applying arrays to functions; using Statistical, Date and Time, Financial, Text, and Cube functions
Preparation resources
Display the relationships between formulas and cells
Change formula recalculation, iteration, or precision
Excel functions (by category)
Presenting data visuallyApply advanced chart features
Using Trend lines, Dual axes, chart templates, and Sparklines
Apply data analysis
Using automated analysis tools; performing What-If analysis
Apply and manipulate PivotTables
Manipulating PivotTable data; using the slicer to filter and segment your PivotTable data in multiple layers
Apply and manipulate PivotCharts
Creating, manipulating, and analyzing PivotChart data
Demonstrate how to use the slicer
Choosing data sets from external data connections
Preparation resources
Use sparklines to show data trends
Calculate multiple results by using a data table
Use slicers to filter PivotTable data
Working with macros and formsCreate and manipulate macros
Running a macro; running a macro when a workbook is opened; running a macro when a button is clicked; recording an action macro; assigning a macro to a command button; creating a custom macro button on the Quick Access Toolbar; applying modifications to a macro
Insert and manipulate form controls
Inserting form controls; setting form properties
Preparation resources
Quick start: Create a macro
Add a button and assign a macro to it in a worksheet