Excel 2010 Expert Start on Mar 08

[USA LaoTu Support Team]

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.php
Pre-request:  No

--Class syllabus--

Sharing and maintaining workbooks
Apply 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 functions
Audit 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 visually
Apply 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 forms
Create 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

[ingrid]

Hi,

Could you please activate Credit Card payment link.

Or, please let me know if I can pay via course registration - other balance.

Many thanks, Ingrid

[USA LaoTu Support Team]

Done as required.
You can make payment use credit card. Thanks.

[heather]

Which Excel class will be for core package 2014 student?

[USA LaoTu Support Team]

Excel course is NOT included in Core Package.

Thanks.

[songbird]

Hi,
will  this advanced Excel class teach Look up function?
Also after pay for this advanced class, can I watch the previous excel class that was just finished in January.

[USA LaoTu Support Team]

Yes will talk about many functions.
There is NO previous video of this class, this is the first time of the  Excel Expert class.
It is different as Excel Specialist class.

[lao9]

@Jane Dai
Yes, will teach Vlookup function and many advanced functions.
See the syllabus in the main post.

[USA LaoTu Support Team]

Will start this Saturday.  Thanks.

[USA LaoTu Support Team]

Schedule changed to March 08.

Time change:
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 17:00 to 20: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.php
Pre-request:  No

[Katie]

Morning, Laotu & Lao9Laoshi,

Just wondering if there is any materials or PPT we can download or preview before Excel 2010 Expert class starts.  Any response will be appreciated! Thanks a lot.

[lao9]

@Katie
Read the syllabus in the above post. It tells what's covered in the class.
More class materials will only be available to the students.

Will send some sample materials to you by private message. Check it out.

[USA LaoTu Support Team]

Schedule changed to March 08.

Time change:
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 17:00 to 20: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.php
Pre-request:  No