skip to main
|
skip to sidebar
Zee Tutorials World
Social Icons
Pages
home
Window
CV Designs
Photoshop Brushes
CSS Menu
Creative Design
PSD Projects
Monday, 12 August 2013
Section One - Make a Start with Excel
1 A first look at Excel 2007/2010
2 Excel Rows and Columns
3 Enter text and numbers in a Cell
4 How to Edit text in a Cell
5 How to Centre text and numbers
6 Font Formatting in Excel 2007/2010
7 How to change the colour of a Cell
8 How to Save your work in Excel
9 Currency Symbols in Excel 2007/2010
10 How to Merge Cells
11 Review Number One
Section Two - A more complex spreadsheet
1 Introduction to Section Two
2 How to use AutoFill in Excel 2007/2010
3 Entering Simple Addition Formula
4 The SUM Function in Excel
5 The SUM Function Continued
6 Copy and Paste
7 How to use Paste Special
8 How to Multiply in Excel 2007/2010
9 Finishing your spreadsheet for this section
10 How to Add a Comment to a Cell
11 Review Number Two
Section Three - Excel 2007/2010 Charts
1 How to Sort Data in Excel
2 Create an Excel Chart
3 Move and Resize your Chart
4 Chart Styles and Layouts
5 Chart Titles and Series Titles
6 Chart Layout Panel in Excel 2007/2010
7 The Format Chart Panel
8 Create a Pie Chart in Excel
9 Add Labels to a Pie Chart
10 Format Pie Chart Segments
11 Create a 2D Line Chart in Excel
12 Format your Axis Titles
Section Four - Formulas in Excel 2007/2010
1 The SUM Function
2 How to Multiply in Excel
3 Subtract and Divide
4 Combining the Arithmetic Operators
5 A Budget Spreadsheet
Section Five - Functions in Excel 2007/2010
1 The Average Function
2 The Date Function
3 Time Functions in Excel
4 A TimeTable Project
5 Financial Functions
6 The Student Averages Project
Section Six - Conditional Logic in Excel
1 The IF Function
2 Conditional Formatting in Excel 2007/2010
3 CountIF
4 SumIF
Section Seven - Processing Data in Excel
1 Data Tables in Excel 2007/2010
2 A Second Data Table
3 Excel Scenarios
4 Goal Seek
5 Absolute Cell References
6 Named Ranges in Excel 2007/2010
7 Create a Custom Name in Excel
8 Excel Pivot Tables
9 Pivot Tables, Part Two
10 Reference other Worksheets
11 The LOOKUP Function
12 The VLOOKUP Function in Excel
13 Create a Business Invoice, Part One
14 Excel Business Invoice, Part Two
15 Business Invoice, Part Three
Section Eight - Advanced Excel 2007/2010
1 How to Create an Excel Template
2 Data Forms in Excel 2007/2010
3 Drop Down Lists in Excel
4 Add your own Error Messages
5 Excel and Web Integration
6 Hyperlinks in Excel
7 Object Linking and Embedding
8 Insert Drawing Objects
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Pakistani Girls
Powered by
Blogger
.
Social Icons
Social Icons
Catagory
3D MAX TRAINING
ADOBE AFTER EFFECT
ADOBE DREAMWEAVER CS4
ADOBE FREEHAND
ADOBE ILLUSTRATOR
ADOBE PHOTOSHOP CS3
ADOBE PREMIERE
AUTOCAD TRAINING
BILLBOARD
BLOGGER TRAINING
CORAL DRAW
COREL VIDEO STUDIO
EDIUS 5.0 TRAINING
FLASH MAX
FRONTPAGE
HTML TRAINING
Inpage
JAVA TRAINING
JOOMLA TRAINING
MAYA 3D TRAINING
MICROSOFT ACCESS
MICROSOFT EXCEL
MICROSOFT WORD
PEACHTREE TRAINING
PHP & MYSQL TRAINING
POWER POINT
PROSHOW GOLD
QUICKBOOKS TRAINING
SEO TRAINING
SWISH MAX
TALLY URDU TARINING
VISUAL BASIC
WIN CUSTOMIZATION
WORDPRESS TRAINING
XARA 3D TRAINING
Total Pageviews
About Me
ZESHAN
View my complete profile
Visitors
No comments:
Post a Comment