Learn Excel by Macromedia Flash

Posted: มกราคม 28, 2007 in Computers and Internet

มาเรียนรู้โปรแกรม Excel ด้วยแฟลชกันดีกว่า

CONTENT

Basic Excel Concepts
– Using "Paste Special"
– Using Text to Columns
– Tips on Filtering with "AutoFilter"
– Using Goal Seek
– Data Validation in Excel
– About Conditional Formatting
– Basics of Protecting a Worksheet
– Basics of Using Subtotals
– Basics of Print Setup Options
– Formatting Tricks
– Grouping Tabs to Save Time
– Conditional Format with Four Conditions

All About Pivot Tables
– Create a Basic Pivot Table
– Sorting in a Pivot Table
– Create a Drill Down Effect with a Pivot Table
– Adding a Calculated Field in a Pivot Table
– Grouping in a Pivot Table
– Creating Pivot Charts
– Using Pivot Table Advanced Options

All About Charts
– Formatting Charts
– Combo Charts and Formatting Data Points
– Create Dynamic Chart Labels
– Create a Histogram Chart
– Create a Basic Water Fall Chart
– Using the Bar to Pie Chart
– Add Average Line to a Chart
– Invert Negatives in a Chart
– Get Graphical without Charts?
– Use Excel Charts in PowerPoint Without Bloat
– Quick and Easy Organizational Chart

Advanced Excel Functions
– Alternate Shading with Conditional Formatting
– VLOOKUP formulas made easy
– Matrix Lookup Formula (Index and Match)
– Cell Information Functions
– Text and String Functions
– Using IF(AND()) & IF(OR())
– Using the SumProduct() Function
– Using the COUNTIF() to Find Duplicates
– Set Duplicates Warning with Data Validation
– Basics of Nested Formulas
– Conditional Sums and Array Formulas
– Formula to convert your dates to quarters
– Using the SUBTOTALS Function

Building Excel Applications
– All About Recording Macros
– Fun Spreadsheet that does Magic Tricks

Link

http://www.datapigtechnologies.com/flashfiles/addavgline.swf
http://www.datapigtechnologies.com/flashfiles/alternateshading.swf
http://www.datapigtechnologies.com/flashfiles/autofilter.swf
http://www.datapigtechnologies.com/flashfiles/bartopiechart.swf
http://www.datapigtechnologies.com/flashfiles/chartstopwrpoint.swf
http://www.datapigtechnologies.com/flashfiles/combocharts.swf
http://www.datapigtechnologies.com/flashfiles/conditionalformatexcel.swf
http://www.datapigtechnologies.com/flashfiles/conditionalsum.swf
http://www.datapigtechnologies.com/flashfiles/countiffunction.swf
http://www.datapigtechnologies.com/flashfiles/CreateOrgChart.swf
http://www.datapigtechnologies.com/flashfiles/datavalidation.swf
http://www.datapigtechnologies.com/flashfiles/datetoqtr.swf
http://www.datapigtechnologies.com/flashfiles/dupswarning.swf
http://www.datapigtechnologies.com/flashfiles/dynamicchartlabel.swf
http://www.datapigtechnologies.com/flashfiles/excelfrmtngtricks.swf
http://www.datapigtechnologies.com/flashfiles/formatcharts.swf
http://www.datapigtechnologies.com/flashfiles/fourcondtlformats.swf
http://www.datapigtechnologies.com/flashfiles/goalseek.swf
http://www.datapigtechnologies.com/flashfiles/groupingtabs.swf
http://www.datapigtechnologies.com/flashfiles/histogram.swf
http://www.datapigtechnologies.com/flashfiles/ifandifor.swf
http://www.datapigtechnologies.com/flashfiles/infofunction.swf
http://www.datapigtechnologies.com/flashfiles/invertnegatives.swf
http://www.datapigtechnologies.com/flashfiles/matrixlookup.swf
http://www.datapigtechnologies.com/flashfiles/nestedformulas.swf
http://www.datapigtechnologies.com/flashfiles/nonchartcharts.swf
http://www.datapigtechnologies.com/flashfiles/pagesetup.swf
http://www.datapigtechnologies.com/flashfiles/pastespecial.swf
http://www.datapigtechnologies.com/flashfiles/pivot1.swf
http://www.datapigtechnologies.com/flashfiles/Pivot2.swf
http://www.datapigtechnologies.com/flashfiles/pivot3.swf
http://www.datapigtechnologies.com/flashfiles/pivot4.swf
http://www.datapigtechnologies.com/flashfiles/pivot5.swf
http://www.datapigtechnologies.com/flashfiles/pivot6.swf
http://www.datapigtechnologies.com/flashfiles/pivot7.swf
http://www.datapigtechnologies.com/flashfiles/protectsheet.swf
http://www.datapigtechnologies.com/flashfiles/recordmacros.swf
http://www.datapigtechnologies.com/flashfiles/subtotalfunction.swf
http://www.datapigtechnologies.com/flashfiles/subtotals.swf
http://www.datapigtechnologies.com/flashfiles/sumproduct.swf
http://www.datapigtechnologies.com/flashfiles/textfunctions.swf
http://www.datapigtechnologies.com/flashfiles/texttocolumn.swf
http://www.datapigtechnologies.com/flashfiles/vlookup.swf
http://www.datapigtechnologies.com/flashfiles/waterfallchart.swf

ความเห็น

ใส่ความเห็น

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / เปลี่ยนแปลง )

Twitter picture

You are commenting using your Twitter account. Log Out / เปลี่ยนแปลง )

Facebook photo

You are commenting using your Facebook account. Log Out / เปลี่ยนแปลง )

Google+ photo

You are commenting using your Google+ account. Log Out / เปลี่ยนแปลง )

Connecting to %s