Mari Belajar Microsoft Office Excel

What Excel are for
Interfacing
Starting to use
Formatting & Conditional Formatting
Formulas & Functions
Handling large data worksheet
Printing Documents
Collaboration with others
Project and Application


MANIPULATING EXCEL 2007 DATA, & NAMED RANGES
• Paste Special
• Transposing data
• Importing text and delimiting by space, comma or tab
• What does naming a cell range mean?
• Rules for naming cells and ranges
• Naming cell range(s) in a worksheet
• Named ranges within formulas
• Navigating through workbooks using named ranges
• Creating named ranges automatically based on cell values
• Deleting named cells/ranges
• Creating subtotals
• Removing subtotals in Excel 2007
EXCEL 2007 TEMPLATES
• Using templates
• Creating templates
• Opening and editing templates
FORMATTING & DISPLAY TECHNIQUES
• Formatting tables
• Formatting tables using table styles
• Formatting cell ranges using conditional formatting
• Creating custom number formats
• Freezing the top row
• Freezing the first column
• Freezing the top row and the first column at the same time
• Hiding and un-hiding rows
• Hiding and un-hiding columns
• Hiding and un-hiding worksheets
SORTING AND QUERYING DATA
• Sorting internal Excel databases
• Custom sort options
• Using AutoFilter to query data
• Multiple queries
• Removing filters
• Top 10 AutoFilter
• Filtering unique records
• Advanced Filter



LINKING & CONSOLIDATING DATA
• Linking individual cells within a worksheet
• Linking charts to data within a worksheet
• Linking a cell range on one worksheet to another worksheet (within the same workbook)
• Linking data on one worksheet to a chart in another worksheet (within the same workbook)
• Linking data from one workbook to another
• Linking a chart from one workbook to another
• Copying data from Excel into a Word document
• Linking data from Excel into a Word document
• Copying a chart from Excel into a Word document
• Linking a chart from Excel into a Word document
• Consolidating data over several worksheets or worksheet pages
EXCEL 2007 CHARTS FORMATTING TECHNIQUES
• Changing the angle of pie chart slices
• Formatting the chart axis fonts
• Formatting the chart axis scales
• Formatting the chart axis text orientation
• Creating and positioning a chart title
• Re-positioning a chart legend
• Re-positioning chart data labels
• Exploding the segments within a pie chart
• Deleting a data series within a chart
• Adding a data series to a chart
• Modifying the chart type for a defined data series
• Widening the gap between columns / bars within a 2-D chart
• Inserting an image into a 2D chart (as a background)
• Inserting an image into a 2D chart (to format a column or bar of data)
PROTECTION AND SECURITY
• Specifying a password for opening a workbook
• Using the “read-only recommended” option
• Removing a password from an Excel workbook
• Protecting a worksheet or worksheet elements
• Removing workbook protection
• Allowing selective editing of a protected worksheet within Excel 2007

EXCEL 2007 FUNCTIONS
• Excel 2007 Functions
• Getting help about using a particular function
• TODAY https://www.dropbox.com/s/64m4piq23jyz5o0/Fungsi Today.xlsx
• DAY
• MONTH
• YEAR
• SUMIF
• ROUND
• COUNT
• COUNTA
• COUNTIF
• PROPER
• UPPER
• LOWER
• CONCATENATE
• FV
• NPV
• PMT
• PV
• RATE
• HLOOKUP
• VLOOKUP
• IF
• AND
• OR
• ISERROR
• DSUM
• DMIN
• DMAX
• DCOUNT
• Nested functions
USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES
• Using a one input Data Table command
• Using a two input data table command
A FIRST LOOK AT EXCEL2007 PIVOT TABLES
• Creating a PivotTable
• Dropping data into the Pivot Table
• Modifying data and refreshing the Pivot Table
• Grouping data within a Pivot table

SCENARIOS
• Scenario Manager – an example
• Showing a scenario
• Viewing an alternative scenario
• Create a scenario summary
AUDITING
• Tracing precedent cells
• Tracing the dependants of a cell
• Displaying all formulas within a worksheet
• Adding comments
• Displaying comments
• Removing comments
• Editing comments
MACROS
• Displaying the Developer tab
• Recording and running macros
• Lowering your macro security level
• Customizing the Quick Access Toolbar
• Changing the Quick Toolbar Macro icon
• Removing a macro icon from the quick access toolbar
• Raising your macro security level

Click to expand...

mohdsyafiq2913 said:

xpandai sgt excel ni tt.. tp slalu guna utk buat pengiraan autosum, divide, tolak, tambah dan lain2 je.. itu yg thu pun.. hehe

Click to expand...

jejantas said:

Aik excel nih dah hampir 20 tahun baru nak belajar?

Click to expand...