Module 1: Introduction
1.1 Course Outline
1.2 Introducing Excel
1.3 The Excel Interface
Module 2: Basic File Commands and Operations
2.1 Creating, Saving and Closing Workbooks
2.2 Personalizing Files and Opening Workbooks
2.3 Viewing Existing Workbooks and Applying Templates
Module 3: Creating, Managing and Navigating the Worksheets
3.1 Creating and Managing Worksheets
3.2 Navigating the Worksheets
Module 4: Entering and Managing Worksheet Data
4.1 Worksheet Basics and Cell Range Selection
4.2 Entering Cell Content and Multiple Cells
4.3 AutoContent and Undo, Redo and Repeat
4.4 Updating and Clearing Cell Content
4.5 Inserting and Deleting, Rows and Columns
4.6 Copying, Cutting, Pasting and Moving Contents
4.7 Keyboard Shortcuts
4.8 Section Review
Module 5: Formatting Cells and Worksheets
5.1 Formatting Cells and Applying Formats
5.2 Alignment
5.3 Merging Cells and Cell Styles
5.4 Numbers
5.5 Apply and Modify Formats
5.6 Using Table Features
5.7 Keyboard Shortcuts
5.8 Section Review
Module 6: Applying Formulas and Functions
6.1 Creating Formulas
6.2 Using Cell References
6.3 Managing and Updating Formulas
6.4 Creating Functions
6.5 Conditional Statements
Module 7: Analyzing and Organizing Data
7.1 Find and Replace
7.2 Sorting
7.3 Filtering
Module 8: Naming and Hyperlinks
8.1 Naming Cells and Ranges
8.2 Hyperlinks
Module 9: Displaying Data Visually Using Charts
9.1 Charting
9.2 Layout Chart Element Options and Format
Module 10: Preparing to Print and Printing
10.1 Preparing to Print with Page Layouts
10.2 Section Review
Module 11: Including Illustrations and Graphics in a Workbook
12.1 Inserting and Formatting Pictures
12.2 Inserting and Formatting Clip Art
12.3 Inserting and Formatting Shapes, Word Art and Text Boxes
12.4 Inserting and Formatting Smart Art
Total Fees: 16,000/=
Total Duration: 16 Hours (2 hours x 8 Classes)
Training Mode: Individual Training, your own timetable
Live Online Classes or Face to Face Direct Classes with our expert trainers.
Call +94 (0) 722000999 / +94 (0) 755123111 www.iss.lk. Medium : සිංහල / தமிழ் / English