Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
Microsoft Excel 2010 Notes
Computer Education Center
O level , ADCA, DCA, CCC etc
...
2
Home
...
13
Page layout
...
25
Data
...
28
View
...
Page 1
Computer Education Center
Create By-Rajaneesh Sir
...
Page 3
Computer Education Center
Create By-Rajaneesh Sir
...
Page 5
Computer Education Center
Home
Tab
1
...
Font
3
...
Number
5
...
Cells
7
...
Clipboard:Cut ( Ctrl + X) :-
Option
Use Select
Matter
Cut
Copy (Ctrl +C ) :-
Option
Use Select
Matter
Copy
Paste (Ctrl + V ) :-
Option
Use Cut , Copy
Format Painter (Ctrl + Shift + C) :Matter
2
...
Use Select
Option
Use Select
Modify
Matter
Font
Matter
Page 6
Computer Education Center
Grow Font (Ctrl + Shift + >) :Size
Option
Use Select
Matter
Bold (Ctrl + B) :-
Option
Use Select
Matter
Bold
Italic (Ctrl + I ) :-
Option
Use Select
Matter
Italic
Underline (Ctrl + U) :-
Option
Use Select
Matter
Bottom Border :-
Option
Use Paragraph
Border Set
Font Color :-
Option
Use Select
Matter
Create By-Rajaneesh Sir
...
Alignment :Top Align :-
Option
Use Cell
Middle Align :-
Option
Use Cell
Bottom Align :-
Option
Use Cell
Left Align :-
Option
Create By-Rajaneesh Sir
...
Number :Use
cell
Number
Exp:- Percent,Doller, Euro,etc
...
Page 9
Computer Education Center
5
...
data
Page 10
Computer Education Center
Format as Table:-
Cell style:-
option
Option
Create By-Rajaneesh Sir
...
Cell :Insert:-
Option
row
Use
Excel Sheet
Sheet
Insert
Delete:-
Option
Use Cell Column Row
Format:-
Option
Use
Set
Sheet
Cell ,Colum,
Sheet
Row
Delete
Colum
7
...
Cell
Sheet
Formulaa set
Matter
Cell
Formet Contents
Page 12
Computer Education Center
Comment Hyper link
Sort & Filter:Option
Use Select
A
Filter
Find & Select:-
Option
Clear
Matter
Use Sheet
A TO Z
Z TO
Matter
Insert
Tab
1
...
Charts
5
...
Text
2
...
Sparklines
6
...
Symbols
Tables :Pivot Table :-
Option
Create By-Rajaneesh Sir
...
Page 14
Computer Education Center
Table :-
Option
Use Select cell
table
3
...
Use Page
Use Page
Use Page
Picture Insert
Clip Art Insert
Shapes Insert
Page 15
Computer Education Center
Smart Art :-
Screen Sort :-
Option
Option
Use Page
Style
Diagram Insert
Use Screen Sort
4
...
Create By-Rajaneesh Sir
...
Sparklines :Line :-
Option
Column :-
Option
Column
Win / Loss :-
Use
cell
Use
Option
Line
cell
Use Win /Loss
cell
6
...
Use
Insert
File
File
Link
Page 17
Computer Education Center
7
...
Use Header
Style
Use
Option
Use Page
Signature Line Insert
Use M
...
Word Program
Program
Page 18
Computer Education Center
8
...
Symbol Insert
Page 19
Computer Education Center
Page layout
Tab
1
...
3
...
5
...
Themes :Themes :-
Option
Create By-Rajaneesh Sir
...
Use Themes
Color Change
Page 21
Computer Education Center
Fonts :-
Option
Use Page
Effect :-
Option
Use Page
Matter
Insert
Font Change
Shapes
Effect
2
...
Use Page
Margins Set
Page 22
Computer Education Center
Orientation :-
Size :-
Option
Option
Print Area :Breaks :-
Print Titles :-
Use page
Option
Option
Background :-
Use Page
Use Print
Use Page
Option
Option
Create By-Rajaneesh Sir
...
Scale to fit :Width :-
Option
set
Use work sheet
matter
width
Height :-
Option
Use work sheet
set
matter
Height
Scale :-
Option
Use work sheet
Percentage set
matter
Height
with
4
...
Arrange :Bring Forward :-
Option
Use
Send Backward :-
Option
Use
Selection Pane :-
Option
Create By-Rajaneesh Sir
...
Function Library
2
...
Formula Auditing
4
...
Function Library
Insert Function :-
Option
Use Function Insert
option
use
-
Formulas Insert
2
...
Use Rename cell dh fLFkfr ns[kus vkSj New , Edit
Use cell dks Rename vkSj comment nsus
Use Rename cell dks Formula es ç;ksx
Page 25
Computer Education Center
3
...
Get External Data
2
...
Sort & Filter
4
...
Outline
1
...
Use Access es cuk;s x;s Data dks sheet ij Insert djkus
Page 26
Computer Education Center
Web Form :-
Option
Use Internet ls fdlh Data dks Impart
From Text :-
Option
Use Notepad
From Other Sources :-
Option
Data dks Impart
Use Other File
Data dks Impart
As :- XML Data , micro query etc
...
Connection :Refresh All :-
Connections :-
Option
Use Import fd;s x;s Data dks update
Option
Use Import fd;s x;s Data ds Connection dks ns[k ldrs
gSA vkSj Remove vkSj All dj ldrs gSA
3
...
Page 27
Computer Education Center
Review
Tab
1
...
Language
3
...
Changes
1
...
Language :Language :-
Option
Use Language Change
3
...
Option
Use Select
Matter
Comment
Page 28
Computer Education Center
Delete :-
Option
Previous :-
Next :-
Use Insert
Option
Option
Comment
Use Set
Use Insert
Comment
Comment
Delete
One Step Back
Next Comment
Show/ Hide comment :- bl Option dk Use comment dks show vkSj Hide djus ds
Show All comment :-
Option
Use sheet ij fn;s x;s iqjs comment dks show
djus
4
...
Workbook Views
2
...
Zoom
4
...
Macros
1
...
Page 29
Computer Education Center
Normal :-
Option
Page Layout :-
Use Sheet
Option
Page Break Preview :Custom Views :Full Screen :-
Use Sheet
Option
Option
Option
Normal Mode
Page Layout Mode
Use Sheet
Use Select Cell
Use Sheet
Page Break Preview Mode
Custom views
Add
Full Screen Mode
2
...
Zoom :Zoom :100 % :-
Option
Use vius sheet dks vko”;drkuqlkj Zoom djus
Option
Zoom to selection :-
Use vius sheet dks 100% Normal made es ns[kus
Option
Use select cell dks Zoom dj ds ns[kus
4
...
Page 30
Computer Education Center
New Window :Arrange All :-
Option
Use New Window Open
Split :-
Option
Use Open
Window
Screen
Use vius Window sheet dks nks Hkkxks es ckVus
Hide :-
Option
Use vius sheet dks Hide djus
Unhide :-
Option
Option
Use Hide fd;s x;s sheet dks Unhide djus
Synchronous Scrolling :djus
Option
Use nksuks Window dks ,d lkFk Scroll
Reset Window Position :Option
Use View side by side es dh x;h
Mortify (Arrange) dks Reset djus
Switch Windows :-
Option
setp
Use Open
Window
Setp by
5
...
Page 31