Quantunet.com

 Excel QuickSkills

     

Basic Excel Click by Click

QuickSkills

Worksheets Knowledgebase Lessons & Tutorials Video Tutorials

 

 

The Excel Environment

Opening Excel

Creating a new Workbook

Opening a Workbook

Saving Workbooks

Closing Excel
Closing multiple workbooks
Zoomsettings in the spreadsheet

Using the help window
using undo
using redo

Lising shortcut keys

Editing a template

Using the vertical scroll bar

Using the horizontal scroll bar

 

 

 

 

 


Changing the tab color
Change the color of multiple tabs
Changing the column width
Changing the row height
Numericaly set the column width
Numerically set the row hight
Numerically set the size of a group of cells

Resizing  cells to fit contents
autofit cell height
autofilt cell width

Unmerge cells

Inserting & deleting rows
Inserting & deleting columns

Creating cell borders
Removing cell borders
Changing cell border colors
Drawing cell borders
Changing the cell background color
l

 

 

 

Clear cell contents
Copy and Paste Index

Copy and Paste I

Paste Special values & formulas

Copy here as values only

Copy & Paste formulas with $

Copy & Paste Comments

Copy and paste Labels Values & Formulas

Autofill Index

Using the autofill options icon

Autofill identical data

Autofill a patterned series

Autofill formula

Autofill days of the week

Quick autofill

Horizontal autofill

Advanced Autofill (the $ sign)

Moving Data-drag and drop

The "go to"tool
The "go to" special tool
The "Find" tool

The "Find and Replace" tool

 


 

Formatting cell Data

Formatting cells Index

Formatting to Decimals I
Decrease decimal places
Increase decimal places
F
ormatting to Fractions I

Formatting to
Percentages I
Formatting to Currency I
Using Commas I
Formatting to Dates I

Formatting dates to date values I

 


 

 

 

 

 

 

 

 

 

 

 

 


 

 

Intro to Charts

Embedding a Graph StepbyStep

 


 

 Formatting Charts

Formatting Charts Man Index
Formatting Line chart Index

Edit the chart title
Changing title color
Repositioning the title
Changing the title font
Changing the title text size

Changing the axis label font
Changing the axis label color
Changing the axis label size
Changing the axis label position
Changing the axis label orientation

Changing the axis color
Changing the axis tick marks
Changing the axis scale
Changing the axis scale font
Changing he axis scale color
Changing the axis scale size

Changing the legend text font
Changing the legent text color
Changing the legend text size
Changing the legend position
Changing the legend border
Removing the legend

Changing the line color

Changing the line style
Changing the line weight
Changing the line smoothness

Changing the point style
Changing the color of points
Changing the point sizeChanging the grid color
Removing the grid

Changing the background color
Changing the background to a gradient fill

Positioning the plot in the chart area
Resizing the plot in the chart area
Resizing the chart in the worksheet
Positioning the chart in the worksheet

 


 

Types of graphs

How to make a line chart

How to make a scatter plot

How to make a bar chart (vertical)

How to make a pie chart

 

 

 

Working with Images

Inserting Images

Resizing Images

Rotating Images

Aligning Images

 


 

Components

Inserting AutoShapes

Changing Autoshape properties

Inserting 3D Text

Changing auto text properties
Positioning components in the worksheet

 


 

Basic Tools

Setting editing permissions

Sending your workbook as an email
Researching words and phrases

Inserting a hyperlink

Removing a hyperlink

Convert to flash paper swf file

Convert to a pdf file

 

© 2006 Quantunet.com All Rights Reserved
 Terms of Use