USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on February 04, 2014, 10:01:47 AM
-
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
-
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
-
Done as required.
You can make payment use credit card. Thanks.
-
Which Excel class will be for core package 2014 student?
-
Excel course is NOT included in Core Package.
Thanks.
-
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.
-
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.
-
@Jane Dai
Yes, will teach Vlookup function and many advanced functions.
See the syllabus in the main post.
-
Will start this Saturday. Thanks.
-
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
-
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.
-
@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.
-
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