♦ About Excel 2007
♦ Inserting A Worksheet
♦ Renaming a Worksheet
♦ Deleting a Worksheet
♦ Changing Font & Size
♦ Creating Borders for cells
♦ Creating background colors for Selection
♦ Text color
♦ Hiding and Un-hiding Columns
♦ Hiding and un-Hiding Sheets
♦ Changing Default Font or size for new worksheets
♦ Freeze or lock rows and columns
♦ Split panes to lock rows/columns
♦ Inserting formulas
♦ Copying and Pasting Cells
♦ Using if condition and producing text labels
♦ Text Alignment/Wrapping
♦ Formatting Numbers
♦ Conditional Formatting
♦ Highlight Cell Rules
♦ Top/Bottom Rules
♦ Data Bars
♦ Color scales
♦ Icon Sets
♦ Formatting cells with table style
♦ Formatting with Cell Styles
♦ Inserting Cells/Sheet Rows/Columns
♦ Deleting Cells/Sheet Rows/Columns
♦ Setting Cells Height/Width
♦ Changing the Tab Color of the sheet
♦ Protecting Cells
♦ Auto summing the values
♦ Creating Average of Values
♦ Counting Number of values
♦ Finding Max/Min of values
♦ Filling cells with a given value
♦ Filling Cells with Series
♦ Pay Roll Development with Excel Sheet
♦ Conditions are
♦ Clearing Formats/contents/Comments
♦ Sorting Cells
♦ Filtering Cells
♦ Find/Replace Cells
♦ Show current Date and Time
♦ Prepare Electric Billing Sheet
♦ Using Pivot Tables in Excel
♦ What if Analysis using a Table
♦ Inserting Picture, Clip Art, shapes, Smart Art
♦ Inserting Charts
♦ Inserting Hyperlink
♦ Inserting Text Box, Header & Footer, WordArt, Signature Line, Object, Symbol
♦ Inserting themes, Colors, Fonts, Effects
♦ Adjusting Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles
♦ Grouping graphic images, wrapping text
♦ Types of functions
♦ Using names instead of cell range
♦ Creating names & using in formulas
♦ Watching Formulas
♦ Trace Precedents
♦ Trace Dependents
♦ Trace Errors
♦ Evaluating Formula
♦ Auto Configuring Calculations
♦ Accessing External Database
♦ Converting text into columns
♦ Filtering Duplicates
♦ Data Validation
♦ Consolidating Data sheets
♦ Grouping Cells
♦ Goal Seek
♦ Scenario Manager
♦ Working with comments
♦ Protecting Cells, sheets and sharing
♦ Working with views
♦ Zooming
♦ Opening new window with same document
♦ Arranging Open windows

SIGN UP FOR NEWSLETTER

Sign up to received our free newsletter!
Name:
E-mail ID:

MOST READ

Views: 5241 Times
Combo box with description READ MORE
Views: 2718 Times
Google fights to save 3,054 dying languages READ MORE
Views: 3048 Times
Attack code published for 'critical' IE flaw; Patch your browser now READ MORE
Views: 5262 Times
How to disable/enable the usage of USB storage devices? READ MORE
Views: 7215 Times
PHP: Create Your Own MVC (Part 3) READ MORE

Home|IT News|Computer Tips|Video Tutorials|Download Softwares|Subjects|Contact Us
Copyright © 2018. Jumbo Education (Information Technology). All rights reserved.
Free counter and web stats

Large Visitor Globe