About this Course
This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.
On completion of this module each candidate will be able to:
Work with spreadsheets and save them in different file formats
Choose built-in options such as the Help function within the application to enhance productivity
Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
Create mathematical and logical formulas using standard spreadsheet functions. Use good practice
in formula creation and recognize error values in formulasFormat numbers and text content in a spreadsheet
Choose, create and format charts to communicate information meaningfully
Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets
Course Outline :
Section 1 : Introducing Excel 2013- Starting Excel Interface
- Excel Screen
- Navigating
- Ribbon
- Worksheet Window
- Getting Help
- Set Preferences
- Workbook Open & Close
- Opening Multiple Workbooks
- Create & Save a New Workbook
- Save in Different Formats
- Template
- Save & Share Files Online
- Enter Labels, Numbers
- Enter Formulas
- Autosum
- Check for Errors
- Check Spelling
- Multiple Worksheets, Rename
- Copy, Move, Insert, Delete
- Switch Workbooks
- Edit, Delete, Undo, Redo
- Ranges
- Fill Handles
- Flash Fill
- Copy & Move Cells
- Finding & Replacing Text
- Sorting & Filtering
- Printing In Excel
- Page Setup - Size, Orientation, Layout
- Setting Margins
- Printing Selections - Setting a Print Area
- Setting Headers & Footers
- Printing Titles
- Preview Prints
- Apply Formatting
- Fonts, Font Size, Font Styles
- Number Formatting
- Formatting Dates & Times
- Adding Cell Colours & Borders
- Alignment & Rotation
- Zoom & Freeze Panes
- Inserting & Deleting Sheets
- Changing Column Width & Row Height
- Inserting & Deleting Rows & Columns
- Introduction to Excel Calculations
- Writing Formulas
- Order of Operations
- Relative & Absolute Cell Addressing
- Troubleshoot Errors
- Writing Functions
- Autosum
- Count Numbers
- Average & Round
- Maximum & Minimum
- Logical Function - IF
- Introducing Charts
- Chart Recommendation
- Creating Charts
- Moving Charts Between Worksheets
- Chart Types
- Copy, Move & Resize Charts
- Formatting Charts
- Setting Charts Options
Course Duration : 17 Hours
Target Audience
For beginner and professional who in need of Excel in order to produce charts and data analysis.
Pre-requistics
Need to possess the knowledge of Basic PC
Certification
Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.
Course Pathway
ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2013)
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider GENETIC COMPUTER SCHOOL PTE LTD
- Course Category Technology
- Course Price $360
Comments