,EXCEL ,KEYBO>D ,%ORTCUTS      #A

        ,FREGU5TLY US$ %ORTCUTS

7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,CLOSE A "WBOOK
  ,CTRL "6 ;,W
,OP5 A "WBOOK
  ,CTRL "6 ,O
,G TO ! ^1,HOME TAB
  ;,ALT "6 ;,H
,SAVE A "WBOOK
  ,CTRL "6 ;,S
,COPY
  ,CTRL "6 ;,C
,PA/E
  ,CTRL "6 ;,V
,UNDO
  ,CTRL "6 ;,Z
                                      #A
,REMOVE CELL 3T5TS                   A#A
  ,DELETE
,*OOSE A FILL COLOR
  ;,ALT "6 ;,H1 ;,H
,CUT
  ,CTRL "6 ;,X
,G TO ^1,9S]T TAB
  ;,ALT "6 ;,N
,BOLD
  ,CTRL "6 ;,B
,C5T] ALIGN CELL 3T5TS
  ;,ALT "6 ;,H1 ;,A1 ;,C
,G TO ^1,PAGE ^1,LAY\T TAB
  ;,ALT "6 ;,P
,G TO ^1,DATA TAB
  ;,ALT "6 ,A
,G TO ^1,VIEW TAB
  ;,ALT "6 ;,W
--------------------------------------#B
,OP5 3TEXT M5U
  ,%IFT "6 ,F#AJ1 OR ,3TEXT KEY
,ADD BORD]S
  ;,ALT "6 ;,H1 ;,B
,DELETE COLUMN
  ;,ALT "6 ;,H1 ;,D1 ;,C              #B
,G TO ^1,=MULA TAB                   A#B
  ;,ALT "6 ;,M
,HIDE ! SELECT$ R[S
  ,CTRL "6 #I
,HIDE ! SELECT$ COLUMNS
  ,CTRL "6 #J
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

    ,USE ! ,A3ESS KEYS = RI2ON TABS
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,MOVE TO ! ^1,TELL ^1ME OR ^1,SE>* FIELD
ON ! ,RI2ON & TYPE A SE>* T]M = ASSI/.E
OR ,HELP 3T5T4
  ;,ALT "6 ;,Q1 !N 5T] ! SE>* T]M4
,OP5 ! ^1,FILE PAGE & USE ,BACK/AGE
VIEW4
  ;,ALT "6 ;,F
,OP5 ! ^1,HOME TAB & =MAT TEXT & NUMB]S
& USE ! ,F9D TOOL4
  ;,ALT "6 ;,H                        #C
,OP5 ! ^1,9S]T TAB & 9S]T            B#B
,PIVOT,TABLES1 *>TS1 ADD-9S1 ,SP>KL9ES1
PICTURES1 %APES1 H1D]S1 OR TEXT BOXES4
  ;,ALT "6 ;,N
,OP5 ! ^1,PAGE ^1,LAY\T TAB & "W ) !MES1
PAGE SETUP1 SCALE1 & ALIGN;T4
  ;,ALT "6 ;,P
,OP5 ! ^1,=MULAS TAB & 9S]T1 TRACE1 &
CU/OMIZE FUNC;NS & CALCULA;NS4
  ;,ALT "6 ;,M
--------------------------------------#C
,OP5 ! ^1,DATA TAB & 3NECT TO1 SORT1
FILT]1 ANALYZE1 & "W ) DATA4
  ;,ALT "6 ,A
,OP5 ! ^1,REVIEW TAB & *ECK SPELL+1 ADD
NOTES & ?R1D$ COM;TS1 & PROTECT %EETS &
"WBOOKS4
  ;,ALT "6 ;,R
,OP5 ! ^1,VIEW TAB & PREVIEW PAGE BR1KS
& LAY\TS1 %[ & HIDE GRIDL9ES & H1D+S1
SET ZOOM MAGNIFICA;N1 MANAGE W9D[S &
PANES1 & VIEW MACROS4
  ;,ALT "6 ;,W
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
                                      #D
    ,"W 9 ! RI2ON ) ! KEYBO>D        A#C
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,SELECT ! ACTIVE TAB ON ! RI2ON1 &
ACTIVATE ! A3ESS KEYS4
  ;,ALT OR ,F#AJ4 ,TO MOVE TO A DI6]5T
  TAB1 USE A3ESS KEYS OR ! >R[ KEYS4
,MOVE ! FOCUS TO COMM&S ON ! RI2ON4
  ,TAB KEY OR ,%IFT "6 ,TAB
,MOVE D[N1 UP1 LEFT1 OR "R1
RESPECTIVELY1 AM;G ! ITEMS ON ! ,RI2ON4
  ,>R[ KEYS
,ACTIVATE A SELECT$ BUTTON4
  ,SPACEB> OR ,5T]
,OP5 ! LI/ = A SELECT$ COMM&4
  ,D[N >R[ KEY
,OP5 ! M5U = A SELECT$ BUTTON4
  ;,ALT "6 ,D[N >R[ KEY
,:5 A M5U OR SUBM5U IS OP51 MOVE TO !
NEXT COMM&4
  ,D[N >R[ KEY                        #E
,EXP& OR COLLAPSE ! RI2ON4           B#C
  ,CTRL "6 ,F#A
--------------------------------------#D
,OP5 A 3TEXT M5U4
  ,%IFT "6 ,F#AJ ,OR1 ON A ,W9D[S
  KEYBO>D1 ! ,3TEXT KEY "<2T ! "R ;,ALT
  & "R ,CTRL KEYS">
,MOVE TO ! SUBM5U :5 A MA9 M5U IS OP5 OR
SELECT$4
  ,LEFT >R[ KEY
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

    ,KEYBO>D %ORTCUTS = NAVIGAT+ 9 CELLS
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,MOVE TO ! PREVI\S CELL 9 A "W%EET OR !
PREVI\S OP;N 9 A DIALOG4
  ,%IFT "6 ,TAB
,MOVE "O CELL UP 9 A "W%EET4
  ,UP >R[ KEY
                                      #F
,MOVE "O CELL D[N 9 A "W%EET4        A#D
  ,D[N >R[ KEY
,MOVE "O CELL LEFT 9 A "W%EET4
  ,LEFT >R[ KEY
,MOVE "O CELL "R 9 A "W%EET4
  ,"R >R[ KEY
,MOVE TO ! $GE ( ! CURR5T DATA REGION 9
A "W%EET4
  ,CTRL "6 ,>R[ KEY
,5T] ! ,5D MODE1 MOVE TO ! NEXT NONBLANK
CELL 9 ! SAME COLUMN OR R[ Z ! ACTIVE
CELL1 & TURN (F ,5D MODE4 ,IF ! CELLS >E
BLANK1 MOVE TO ! LA/ CELL 9 ! R[ OR
COLUMN4
  ,5D1 ,>R[ KEY
--------------------------------------#E
,MOVE TO ! LA/ CELL ON A "W%EET1 TO !
L[E/ US$ R[ ( ! "RMO/ US$ COLUMN4
  ,CTRL "6 ,5D
,EXT5D ! SELEC;N ( CELLS TO ! LA/ US$
CELL ON ! "W%EET "<L[]-"R CORN]">4
  ,CTRL "6 ,%IFT "6 ,5D
,MOVE TO ! CELL 9 ! UPP]-LEFT CORN] ( !
W9D[ :5 ,SCROLL ,LOCK IS TURN$ ON4
  ,HOME "6 ,SCROLL ,LOCK              #G
,MOVE TO ! 2G9N+ ( A "W%EET4         A#E
  ,CTRL "6 ,HOME
,MOVE "O SCRE5 D[N 9 A "W%EET4
  ,PAGE ,D[N
,MOVE TO ! NEXT %EET 9 A "WBOOK4
  ,CTRL "6 ,PAGE ,D[N
,MOVE "O SCRE5 TO ! "R 9 A "W%EET4
  ;,ALT "6 ,PAGE ,D[N
,MOVE "O SCRE5 UP 9 A "W%EET4
  ,PAGE ,UP
,MOVE "O SCRE5 TO ! LEFT 9 A "W%EET4
  ;,ALT "6 ,PAGE ,UP
,MOVE TO ! PREVI\S %EET 9 A "WBOOK4
  ,CTRL "6 ,PAGE ,UP
,MOVE "O CELL TO ! "R 9 A "W%EET4 ,OR1 9
A PROTECT$ "W%EET1 MOVE 2T UNLOCK$
CELLS4
  ,TAB KEY
,OP5 ! LI/ ( VALIDA;N *OICES ON A CELL T
HAS DATA VALIDA;N OP;N APPLI$ TO X4
  ;,ALT "6 ,D[N >R[ KEY
,CYCLE "? FLOAT+ %APES1 S* Z TEXT BOXES
OR IMAGES4
  ,CTRL "6 ;,ALT "6 #E1 !N ! ,TAB KEY
  REP1T$LY                            #H
,EXIT ! FLOAT+ %APE NAVIGA;N &       B#E
RETURN TO ! NORMAL NAVIGA;N4
  ,ESC
--------------------------------------#F
,SCROLL HORIZONTALLY4
  ,CTRL "6 ,%IFT1 !N SCROLL YR M\SE :EEL
  UP TO G LEFT1 D[N TO G "R
,ZOOM IN4
  ,,CTRL "6 ;,,ALT "6 "7
,ZOOM \4
  ,,CTRL "6 ;,,ALT "6 -
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

    ,KEYBO>D %ORTCUTS = =MATT+ CELLS
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,OP5 ! ,=MAT ,CELLS DIALOG4
  ,CTRL "6 #A
,=MAT FONTS 9 ! ,=MAT ,CELLS DIALOG4
  ,CTRL "6 ,%IFT "6 ;,F OR ,CTRL "6
  ,%IFT "6 ;,P                        #I
,$IT ! ACTIVE CELL & PUT ! 9S];N     A#F
PO9T AT ! 5D ( XS 3T5TS4 ,OR1 IF $IT+ IS
TURN$ (F = ! CELL1 MOVE ! 9S];N PO9T 9TO
! =MULA B>4 ,IF $IT+ A =MULA1 TO7LE
,PO9T MODE (F OR ON S Y C USE >R[ KEYS
TO CR1TE A REF];E4
  ,F#B
,9S]T A NOTE
  ,%IFT "6 ,F#B
,OP5 & $IT A CELL NOTE
  ,%IFT "6 ,F#B
,9S]T A ?R1D$ COM;T
  ,CTRL "6 ,%IFT "6 ,F#B
,OP5 & REPLY TO A ?R1D$ COM;T
  ,CTRL "6 ,%IFT "6 ,F#B
--------------------------------------#G
,OP5 ! ,9S]T DIALOG TO 9S]T BLANK CELLS4
  ,CTRL "6 ,%IFT "6 ,PLUS SIGN "<"6">
,OP5 ! ,DELETE DIALOG TO DELETE SELECT$
CELLS4
  ,CTRL "6 ,M9US SIGN "<-">
,5T] ! CURR5T "T4
  ,CTRL "6 ,%IFT "6 COLON "<3">
,5T] ! CURR5T DATE4
  ,CTRL "6 SEMI-COLON "<;2">         #AJ
,SWIT* 2T 4PLAY+ CELL VALUES OR      A#G
=MULAS 9 ! "W%EET4
  ,CTRL "6 GRAVE A35T "<'">
,COPY A =MULA F ! CELL ABV ! ACTIVE CELL
9TO ! CELL OR ! ,=MULA ,B>4
  ,CTRL "6 APO/ROPHE "<'">
,MOVE ! SELECT$ CELLS4
  ,CTRL "6 ;,X
,COPY ! SELECT$ CELLS4
  ,CTRL "6 ;,C
,PA/E 3T5T AT ! 9S];N PO9T1 REPLAC+ ANY
SELEC;N4
  ,CTRL "6 ;,V
,OP5 ! ,PA/E ,SPECIAL DIALOG4
  ,CTRL "6 ;,ALT "6 ;,V
,ITALICIZE TEXT OR REMOVE ITALIC =MATT+4
  ,CTRL "6 ,I OR ,CTRL "6 #C
,BOLD TEXT OR REMOVE BOLD =MATT+4
  ,CTRL "6 ;,B OR ,CTRL "6 #B
,"UL9E TEXT OR REMOVE "UL9E4
  ,CTRL "6 ;,U OR ,CTRL "6 #D
,APPLY OR REMOVE /RIKE "? =MATT+4
  ,CTRL "6 #E

                                     #AA
,SWIT* 2T HID+ OBJECTS1 4PLAY+       B#G
OBJECTS1 & 4PLAY+ PLACEHOLD]S = OBJECTS4
  ,CTRL "6 #F
,APPLY AN \TL9E BORD] TO ! SELECT$
CELLS4
  ,CTRL "6 ,%IFT "6 AMP]S& "<@&">
,REMOVE ! \TL9E BORD] F ! SELECT$ CELLS4
  ,CTRL "6 ,%IFT "6 "UL9E "<.-">
--------------------------------------#H
,4PLAY OR HIDE ! \TL9E SYMBOLS4
  ,CTRL "6 #H
,USE ! ,FILL ,D[N COMM& TO COPY ! 3T5TS
& =MAT ( ! TOPMO/ CELL ( A SELECT$ RANGE
9TO ! CELLS 2L4
  ,CTRL "6 ,D
,APPLY ! ,G5]AL NUMB] =MAT4
  ,CTRL "6 ,%IFT "6 TILDE SIGN "<@9">
,APPLY ! ,CURR5CY =MAT ) TWO DECIMAL
PLACES "<NEGATIVE NUMB]S 9 P>5!SES">4
  ,CTRL "6 ,%IFT "6 DOLL> SIGN "<@S">
,APPLY ! ,P]C5TAGE =MAT ) NO DECIMAL
PLACES4
  ,CTRL "6 ,%IFT "6 P]C5T SIGN "<.0">

                                     #AB
,APPLY ! ,SCI5TIFIC NUMB] =MAT )     A#H
TWO DECIMAL PLACES4
  ,CTRL "6 ,%IFT "6 C>ET SIGN "<@5">
,APPLY ! ,DATE =MAT ) ! "D1 MON?1 & YE>4
  ,CTRL "6 ,%IFT "6 NUMB] SIGN "<_?">
,APPLY ! ,"T =MAT ) ! H\R & M9UTE1 &
,,AM OR ,,PM4
  ,CTRL "6 ,%IFT "6 AT SIGN "<@A">
,APPLY ! ,NUMB] =MAT ) TWO DECIMAL
PLACES1 ?\S&S SEP>ATOR1 & M9US SIGN
"<-"> = NEGATIVE VALUES4
  ,CTRL "6 ,%IFT "6 EXCLAMA;N PO9T "<6">
,OP5 ! ,9S]T HYP]L9K DIALOG4
  ,CTRL "6 ;,K
,*ECK SPELL+ 9 ! ACTIVE "W%EET OR
SELECT$ RANGE4
  ,F#G
,4PLAY ! ,QK ,ANALYSIS OP;NS = SELECT$
CELLS T 3TA9 DATA4
  ,CTRL "6 ;,Q
,4PLAY ! ,CR1TE ,TABLE DIALOG4
  ,CTRL "6 ;,L OR ,CTRL "6 ;,T
,OP5 ! ,"WBOOK ,/ATI/ICS DIALOG4
  ,CTRL "6 ,%IFT "6 ;,G
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG   #AC
    ,KEYBO>D %ORTCUTS = MAK+          #I
    SELEC;NS & P]=M+ AC;NS
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,SELECT ! 5TIRE "W%EET4
  ,CTRL "6 ,A OR ,CTRL "6 ,%IFT "6
  ,SPACEB>
,SELECT ! CURR5T & NEXT %EET 9 A "WBOOK4
  ,CTRL "6 ,%IFT "6 ,PAGE ,D[N
,SELECT ! CURR5T & PREVI\S %EET 9 A
"WBOOK4
  ,CTRL "6 ,%IFT "6 ,PAGE ,UP
,EXT5D ! SELEC;N ( CELLS BY "O CELL4
  ,%IFT "6 ,>R[ KEY
,EXT5D ! SELEC;N ( CELLS TO ! LA/
NONBLANK CELL 9 ! SAME COLUMN OR R[ Z !
ACTIVE CELL1 OR IF ! NEXT CELL IS BLANK1
TO ! NEXT NONBLANK CELL4
  ,CTRL "6 ,%IFT "6 ,>R[ KEY

                                     #AD
,TURN EXT5D MODE ON & USE ! >R[      A#I
KEYS TO EXT5D A SELEC;N4 ,PRESS AG TO
TURN (F4
  ,F#H
,ADD A NON-ADJAC5T CELL OR RANGE TO A
SELEC;N ( CELLS BY US+ ! >R[ KEYS4
  ,%IFT "6 ,F#H
,/>T A NEW L9E 9 ! SAME CELL4
  ;,ALT "6 ,5T]
,FILL ! SELECT$ CELL RANGE ) ! CURR5T
5TRY4
  ,CTRL "6 ,5T]
,COMPLETE A CELL 5TRY & SELECT ! CELL
ABV4
  ,%IFT "6 ,5T]
,SELECT AN 5TIRE COLUMN 9 A "W%EET4
  ,CTRL "6 ,SPACEB>
,SELECT AN 5TIRE R[ 9 A "W%EET4
  ,%IFT "6 ,SPACEB>
,SELECT ALL OBJECTS ON A "W%EET :5 AN
OBJECT IS SELECT$4
  ,CTRL "6 ,%IFT "6 ,SPACEB>
,EXT5D ! SELEC;N ( CELLS TO ! 2G9N+ ( !
"W%EET4
  ,CTRL "6 ,%IFT "6 ,HOME            #AE
,SELECT ! CURR5T REGION IF !         #AJ
"W%EET 3TA9S DATA4 ,PRESS A SECOND "T TO
SELECT ! CURR5T REGION & XS SUMM>Y R[S4
,PRESS A ?IRD "T TO SELECT ! 5TIRE
"W%EET4
  ,CTRL "6 ,A OR ,CTRL "6 ,%IFT "6
  ,SPACEB>
,SELECT ! CURR5T REGION >.D ! ACTIVE
CELL4
  ,CTRL "6 ,%IFT "6 ,A/]ISK "<"9">
,SELECT ! F/ COMM& ON ! M5U :5 A M5U OR
SUBM5U IS VISIBLE4
  ,HOME
,REP1T ! LA/ COMM& OR AC;N1 IF POSSIBLE4
  ,CTRL "6 ;,Y
,UNDO ! LA/ AC;N4
  ,CTRL "6 ;,Z
,EXP& GR\P$ R[S OR COLUMNS4
  ,:ILE HOV]+ OV] ! COLLAPS$ ITEMS1 HOLD
  ,,%IFT & SCROLL D[N4
,COLLAPSE GR\P$ R[S OR COLUMNS4
  ,:ILE HOV]+ OV] ! EXP&$ ITEMS1 HOLD
  ,,%IFT & SCROLL UP4
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
                                     #AF
    ,KEYBO>D %ORTCUTS = "W+ )       A#AJ
    DATA1 FUNC;NS1 & ! =MULA B>
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,$IT ! ACTIVE CELL & PUT ! 9S];N PO9T AT
! 5D ( XS 3T5TS4 ,OR1 IF $IT+ IS TURN$
(F = ! CELL1 MOVE ! 9S];N PO9T 9TO !
=MULA B>4 ,IF $IT+ A =MULA1 TO7LE ,PO9T
MODE (F OR ON S Y C USE >R[ KEYS TO
CR1TE A REF];E4
  ,F#B
,EXP& OR COLLAPSE ! =MULA B>4
  ,CTRL "6 ,%IFT "6 ;,U
-------------------------------------#AA
,C.EL AN 5TRY 9 ! CELL OR ,=MULA ,B>4
  ,ESC
,COMPLETE AN 5TRY 9 ! =MULA B> & SELECT
! CELL 2L4
  ,5T]

                                     #AG
,MOVE ! CURSOR TO ! 5D ( ! TEXT     A#AA
:5 9 ! =MULA B>4
  ,CTRL "6 ,5D
,SELECT ALL TEXT 9 ! =MULA B> F ! CURSOR
POSI;N TO ! 5D4
  ,CTRL "6 ,%IFT "6 ,5D
,CALCULATE ALL "W%EETS 9 ALL OP5
"WBOOKS4
  ,F#I
,CALCULATE ! ACTIVE "W%EET4
  ,%IFT "6 ,F#I
,CALCULATE ALL "W%EETS 9 ALL OP5
"WBOOKS1 REG>D.S ( :E!R !Y H *ANG$ S9CE
! LA/ CALCULA;N4
  ,CTRL "6 ;,ALT "6 ,F#I
,*ECK DEP5D5T =MULAS1 & !N CALCULATE ALL
CELLS 9 ALL OP5 "WBOOKS1 9CLUD+ CELLS N
M>K$ Z NE$+ TO 2 CALCULAT$4
  ,CTRL "6 ;,ALT "6 ,%IFT "6 ,F#I
,4PLAY ! M5U OR MESSAGE = AN ,]ROR
,*ECK+ BUTTON4
  ;,ALT "6 ,%IFT "6 ,F#AJ


                                     #AH
,4PLAY ! ,FUNC;N ,>GU;TS DIALOG     B#AA
:5 ! 9S];N PO9T IS TO ! "R ( A FUNC;N "N
9 A =MULA4
  ,CTRL "6 ,A
,9S]T >GU;T "NS & P>5!SES :5 ! 9S];N
PO9T IS TO ! "R ( A FUNC;N "N 9 A =MULA4
  ,CTRL "6 ,%IFT "6 ,A
,9S]T ! ,AUTO,SUM =MULA
  ;,ALT "6 "7
,9VOKE _1,FLA% _1,FILL TO AUTOMATICALLY
RECOGNIZE PATT]NS 9 ADJAC5T COLUMNS &
FILL ! CURR5T COLUMN
  ,CTRL "6 ;,E
,CYCLE "? ALL COMB9A;NS ( ABSOLUTE &
RELATIVE REF];ES 9 A =MULA IF A CELL
REF];E OR RANGE IS SELECT$4
  ,F#D
,9S]T A FUNC;N4
  ,%IFT "6 ,F#C
-------------------------------------#AB
,COPY ! VALUE F ! CELL ABV ! ACTIVE CELL
9TO ! CELL OR ! =MULA B>4
  ,CTRL "6 ,%IFT "6 ,/RAI<T QUOTA;N M>K
  "<;0">
                                     #AI
,CR1TE AN EMB$D$ *>T ( ! DATA 9 !   A#AB
CURR5T RANGE4
  ;,ALT "6 ,F#A
,CR1TE A *>T ( ! DATA 9 ! CURR5T RANGE 9
A SEP>ATE ,*>T %EET4
  ,F#AA
,DEF9E A "N TO USE 9 REF];ES4
  ;,ALT "6 ;,M1 ;,M1 ;,D
,PA/E A "N F ! ,PA/E ,"N DIALOG "<IF "NS
H BE5 DEF9$ 9 ! "WBOOK4
  ,F#C
,MOVE TO ! F/ FIELD 9 ! NEXT RECORD ( A
DATA =M4
  ,5T]
,CR1TE1 RUN1 $IT1 OR DELETE A MACRO4
  ;,ALT "6 ,F#H
,OP5 ! ,MICROS(T ,VISUAL ,BASIC ,=
,APPLICA;NS ,$ITOR4
  ;,ALT "6 ,F#AA
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

    ,KEYBO>D %ORTCUTS = REFRE%+ EXT]NAL
    DATA
  ,USE ! FOLL[+ KEYS TO REFRE% DATA F
EXT]NAL DATA S\RCES4                 #BJ
777777777777777777777777777777777   B#AB
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,/OP A REFRE% OP]A;N
  ,ESC
,REFRE% DATA 9 ! CURR5T "W%EET
  ,CTRL "6 ,F#E
,REFRE% ALL DATA 9 ! "WBOOK
  ,CTRL "6 ;,ALT "6 ,F#E
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
-------------------------------------#AC

      ,P[] ,PIVOT KEYBO>D %ORTCUTS

  ,USE ! FOLL[+ %ORTCUTS KEYBO>D
%ORTCUTS ) ,P[] ,PIVOT 9 ,MICROS(T #CFE1
,EXCEL #BJAI1 ,EXCEL #BJAF1 & ,EXCEL
#BJAC4



                                     #BA
777777777777777777777777777777777   A#AC
      @.<,TABLE *ANG$ Z FOLL[S3

,KEY COMB9A;N
  ,DESCRIP;N@.>

,"R-CLICK
  ,OP5 ! 3TEXT M5U = ! SELECT$ CELL1
  COLUMN1 OR R[4
,CTRL "6 ,A
  ,SELECT ! 5TIRE TABLE4
,CTRL "6 ;,C
  ,COPY SELECT$ DATA4
,CTRL "6 ;,D
  ,DELETE ! TABLE4
,CTRL "6 ;,M
  ,MOVE ! TABLE4
,CTRL "6 ;,R
  ,RE"N ! TABLE4
,CTRL "6 ;,S
  ,SAVE ! FILE4
,CTRL "6 ;,Y
  ,R$O ! LA/ AC;N4
,CTRL "6 ;,Z
  ,UNDO ! LA/ AC;N4                  #BB
,CTRL "6 ,SPACEB>                   B#AC
  ,SELECT ! CURR5T COLUMN4
,%IFT "6 ,SPACEB>
  ,SELECT ! CURR5T R[4
,%IFT "6 ,PAGE ,UP
  ,SELECT ALL CELLS F ! CURR5T LOCA;N TO
  ! LA/ CELL ( ! COLUMN4
-------------------------------------#AD
,%IFT "6 ,PAGE ,D[N
  ,SELECT ALL CELLS F ! CURR5T LOCA;N TO
  ! F/ CELL ( ! COLUMN4
,%IFT "6 ,5D
  ,SELECT ALL CELLS F ! CURR5T LOCA;N TO
  ! LA/ CELL ( ! R[4
,%IFT "6 ,HOME
  ,SELECT ALL CELLS F ! CURR5T LOCA;N TO
  ! F/ CELL ( ! R[4
,CTRL "6 ,PAGE ,UP
  ,MOVE TO ! PREVI\S TABLE4
,CTRL "6 ,PAGE ,D[N
  ,MOVE TO ! NEXT TABLE4
,CTRL "6 ,HOME
  ,MOVE TO ! F/ CELL 9 ! UPP] LEFT CORN]
  ( SELECT$ TABLE4
                                     #BC
,CTRL "6 ,5D                        A#AD
  ,MOVE TO ! LA/ CELL 9 ! L[] "R CORN] (
  SELECT$ TABLE "<! LA/ R[ ( ! ,ADD
  ,COLUMN">4
,CTRL "6 ,LEFT >R[
  ,MOVE TO ! F/ CELL ( SELECT$ R[4
,CTRL "6 ,"R >R[
  ,MOVE TO ! LA/ CELL ( SELECT$ R[4
,CTRL "6 ,UP >R[
  ,MOVE TO ! F/ CELL ( SELECT$ COLUMN4
,CTRL "6 ,D[N >R[
  ,MOVE TO ! LA/ CELL ( SELECT$ COLUMN4
,CTRL "6 ,ESC
  ,CLOSE A DIALOG OR C.EL A PROCESS1 S*
  Z A PA/E OP]A;N4
;,ALT "6 ,D[N >R[
  ,OP5 ! ,AUTO,FILT] ,M5U DIALOG4
-------------------------------------#AE
,F#E
  ,OP5 ! ,G ,TO DIALOG4
,F#I
  ,RECALCULATE ALL =MULAS 9 ! ,P[]
  ,PIVOT W9D[4 ,= M 9=MA;N1 SEE
  ,RECALCULATE ,=MULAS 9 ,P[] ,PIVOT4
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG   #BD
    ,KEYBO>D %ORTCUTS 9 ,(FICE      A#AE
    ,ADD-9S TASK PANES
  ,! FOLL[+ %ORTCUTS APPLY TO "W+ 9 AN
,(FICE ,ADD-9 TASK PANE4

7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,TO D ?
  ,PRESS@.>

,OP5 ! 3TEXT M5U4
  ,CTRL "6 ,%IFT "6 ,F#AJ
,OP5 ! TASK PANE OP;NS M5U4
  ,CTRL "6 ,SPACEB>
,CLOSE ! TASK PANE4
  ,CTRL "6 ,SPACEB>1 !N SELECT ^1,CLOSE
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

      ,FUNC;N KEYS
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,KEY
  ,DESCRIP;N@.>                      #BE
,F#A                                B#AE
  _4 ,F#A AL"O3 4PLAYS ! ^1,EXCEL
    ^1,HELP TASK PANE4
  _4 ,CTRL "6 ,F#A3 4PLAYS OR HIDES !
    RI2ON4
  _4 ;,ALT "6 ,F#A3 CR1TES AN EMB$D$ *>T
    ( ! DATA 9 ! CURR5T RANGE4
  _4 ;,ALT "6 ,%IFT "6 ,F#A3 9S]TS A NEW
    "W%EET4
-------------------------------------#AF
,F#B
  _4 ,F#B AL"O3 $IT ! ACTIVE CELL & PUT
    ! 9S];N PO9T AT ! 5D ( XS 3T5TS4
    ,OR1 IF $IT+ IS TURN$ (F = ! CELL1
    MOVE ! 9S];N PO9T 9TO ! =MULA B>4
    ,IF $IT+ A =MULA1 TO7LE ,PO9T MODE
    (F OR ON S Y C USE >R[ KEYS TO CR1TE
    A REF];E4
  _4 ,%IFT "6 ,F#B3 ADDS OR $ITS A CELL
    NOTE4
  _4 ,CTRL "6 ,F#B3 4PLAYS ! PR9T
    PREVIEW >EA ON ! ^1,PR9T TAB 9 !
    ,BACK/AGE VIEW4
,F#C
  _4 ,F#C AL"O3 4PLAYS ! ^1,PA/E     #BF
    ^1,"N DIALOG4 ,AVAILABLE ONLY   A#AF
    IF "NS H BE5 DEF9$ 9 ! "WBOOK4
  _4 ,%IFT "6 ,F#C3 4PLAYS ! ^1,9S]T
    ^1,FUNC;N DIALOG4
,F#D
  _4 ,F#D AL"O3 REP1TS ! LA/ COMM& OR
    AC;N1 IF POSSIBLE4 ,:5 A CELL REF];E
    OR RANGE IS SELECT$ 9 A =MULA1 ,F#D
    CYCLES "? ALL ! V>I\S COMB9A;NS (
    ABSOLUTE & RELATIVE REF];ES4
  _4 ,CTRL "6 ,F#D3 CLOSES ! SELECT$
    "WBOOK W9D[4
  _4 ;,ALT "6 ,F#D3 CLOSES ,EXCEL4
,F#E
  _4 ,F#E AL"O3 4PLAYS ! ^1,G ^1,TO
    DIALOG4
  _4 ,CTRL "6 ,F#E3 RE/ORES ! W9D[ SIZE
    ( ! SELECT$ "WBOOK W9D[4
-------------------------------------#AG
,F#F
  _4 ,F#F AL"O3 SWIT*ES 2T ! "W%EET1
    RI2ON1 TASK PANE1 & ,ZOOM 3TROLS4 ,9
    A "W%EET T HAS BE5 SPLIT 1 ,F#F
    9CLUDES ! SPLIT PANES :5 SWIT*+ 2T
    PANES & ! RI2ON >EA4             #BG
  _4 ,%IFT "6 ,F#F3 SWIT*ES 2T !    A#AG
    "W%EET1 ,ZOOM 3TROLS1 TASK PANE1 &
    RI2ON4
  _4 ,CTRL "6 ,F#F3 SWIT*ES 2T #B ,EXCEL
    W9D[S4
  _4 ,CTRL "6 ,%IFT "6 ,F#F3 SWIT*ES 2T
    ALL ,EXCEL W9D[S4
,F#G
  _4 ,F#G AL"O3 ,OP5S ! ^1,SPELL+ DIALOG
    TO *ECK SPELL+ 9 ! ACTIVE "W%EET OR
    SELECT$ RANGE4
  _4 ,CTRL "6 ,F#G3 P]=MS ! ^1,MOVE
    COMM& ON ! "WBOOK W9D[ :5 X IS N
    MAXIMIZ$4 ,USE ! >R[ KEYS TO MOVE !
    W9D[1 & :5 F9I%$ PRESS ,5T]1 OR ,ESC
    TO C.EL4
,F#H
  _4 ,F#H AL"O3 TURNS EXT5D MODE ON OR
    (F4 ,9 EXT5D MODE1 ^1,EXT5D$
    ^1,SELEC;N APPE>S 9 ! /ATUS L9E1 & !
    >R[ KEYS EXT5D ! SELEC;N4
  _4 ,%IFT "6 ,F#H3 5ABLES Y TO ADD A
    NON-ADJAC5T CELL OR RANGE TO A
    SELEC;N ( CELLS BY US+ ! >R[ KEYS4
  _4 ,CTRL "6 ,F#H3 P]=MS ! ,SIZE    #BH
    COMM& :5 A "WBOOK IS N          B#AG
    MAXIMIZ$4
  _4 ;,ALT "6 ,F#H3 4PLAYS ! ,MACRO
    DIALOG TO CR1TE1 RUN1 $IT1 OR
    DELETE A MACRO4
-------------------------------------#AH
,F#I
  _4 ,F#I AL"O3 CALCULATES ALL "W%EETS 9
    ALL OP5 "WBOOKS4
  _4 ,%IFT "6 ,F#I3 CALCULATES ! ACTIVE
    "W%EET4
  _4 ,CTRL "6 ;,ALT "6 ,F#I3 CALCULATES
    ALL "W%EETS 9 ALL OP5 "WBOOKS1
    REG>D.S ( :E!R !Y H *ANG$ S9CE ! LA/
    CALCULA;N4
  _4 ,CTRL "6 ;,ALT "6 ,%IFT "6 ,F#I3
    RE*ECKS DEP5D5T =MULAS1 & !N
    CALCULATES ALL CELLS 9 ALL OP5
    "WBOOKS1 9CLUD+ CELLS N M>K$ Z NE$+
    TO 2 CALCULAT$4
  _4 ,CTRL "6 ,F#I3 M9IMIZES A "WBOOK
    W9D[ TO AN ICON4
,F#AJ
  _4 ,F#AJ AL"O3 ,TURNS KEY TIPS ON OR
    (F4 "<,PRESS+ ;,ALT DOES !       #BI
    SAME ?+4">                      A#AH
  _4 ,%IFT "6 ,F#AJ3 4PLAYS ! %ORTCUT
    M5U = A SELECT$ ITEM4
  _4 ;,ALT "6 ,%IFT "6 ,F#AJ3 4PLAYS !
    M5U OR MESSAGE = AN ,]ROR ,*ECK+
    BUTTON4
  _4 ,CTRL "6 ,F#AJ3 MAXIMIZES OR
    RE/ORES ! SELECT$ "WBOOK W9D[4
,F#AA
  _4 ,F#AA AL"O3 ,CR1TES A *>T ( ! DATA
    9 ! CURR5T RANGE 9 A SEP>ATE ,*>T
    %EET4
  _4 ,%IFT "6 ,F#AA3 9S]TS A NEW "W%EET4
  _4 ;,ALT "6 ,F#AA3 OP5S ! ,MICROS(T
    ,VISUAL ,BASIC ,= ,APPLICA;NS
    ,$ITOR1 9 : Y C CR1TE A MACRO BY US+
    ,VISUAL ,BASIC = ,APPLICA;NS
    "<,,VBA">4
,F#AB
  _4 ,F#AB AL"O3 4PLAYS ! ^1,SAVE ^1,Z
    DIALOG4
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG


                                     #CJ
    ,O!R USE;L %ORTCUT KEYS          #AI
7777777777777777777777777777777777777777
      @.<,TABLE *ANG$ Z FOLL[S3

,KEY
  ,DESCRIP;N@.>

;,ALT
  _4 ,4PLAYS ! ,KEY ,TIPS "<NEW
    %ORTCUTS"> ON ! RI2ON4 ,= EXAMPLE1
  _4 ;,ALT1 ;,W1 ;,P SWIT*ES ! "W%EET TO
    ,PAGE ,LAY\T VIEW4
  _4 ;,ALT1 ;,W1 ;,L SWIT*ES ! "W%EET TO
    ,NORMAL VIEW4
  _4 ;,ALT1 ;,W1 ,I SWIT*ES ! "W%EET TO
    ,PAGE ,BR1K ,PREVIEW VIEW4
,>R[ KEYS
  _4 ,MOVE "O CELL UP1 D[N1 LEFT1 OR "R
    9 A "W%EET4
  _4 ,CTRL "6 ,>R[ KEY MOVES TO ! $GE (
    ! CURR5T DATA REGION 9 A "W%EET4
  _4 ,%IFT "6 ,>R[ KEY EXT5DS ! SELEC;N
    ( CELLS BY "O CELL4
  _4 ,CTRL "6 ,%IFT "6 ,>R[ KEY EXT5DS !
    SELEC;N ( CELLS TO ! LA/         #CA
    NONBLANK CELL 9 ! SAME COLUMN   A#AI
    OR R[ Z ! ACTIVE CELL1 OR IF ! NEXT
    CELL IS BLANK1 EXT5DS ! SELEC;N TO !
    NEXT NONBLANK CELL4
  _4 ,LEFT OR ,"R >R[ KEY SELECTS ! TAB
    TO ! LEFT OR "R :5 ! RI2ON IS
    SELECT$4 ,:5 A SUBM5U IS OP5 OR
    SELECT$1 ^! >R[ KEYS SWIT* 2T ! MA9
    M5U & ! SUBM5U4 ,:5 A RI2ON TAB IS
    SELECT$1 ^! KEYS NAVIGATE ! TAB
    BUTTONS4
  _4 ,D[N OR ,UP >R[ KEY SELECTS ! NEXT
    OR PREVI\S COMM& :5 A M5U OR SUBM5U
    IS OP54 ,:5 A RI2ON TAB IS SELECT$1
    ^! KEYS NAVIGATE UP OR D[N ! TAB
    GR\P4
  _4 ,9 A DIALOG1 >R[ KEYS MOVE 2T OP;NS
    9 AN OP5 DROP-D[N LI/1 OR 2T OP;NS 9
    A GR\P ( OP;NS4
  _4 ,D[N OR ;,ALT "6 ,D[N >R[ KEY OP5S
    A SELECT$ DROP-D[N LI/4
-------------------------------------#BJ
,BACKSPACE
  _4 ,DELETES "O "* TO ! LEFT 9 ! ,=MULA
    ,B>4                             #CB
  _4 ,AL CLE>S ! 3T5T ( ! ACTIVE    A#BJ
    CELL4
  _4 ,9 CELL $IT+ MODE1 X DELETES ! "*
    TO ! LEFT ( ! 9S];N PO9T4
,DELETE
  _4 ,REMOVES ! CELL 3T5TS "<DATA &
    =MULAS"> F SELECT$ CELLS )\T A6ECT+
    CELL =MATS1 ?R1D$ COM;TS OR NOTES4
  _4 ,9 CELL $IT+ MODE1 X DELETES ! "*
    TO ! "R ( ! 9S];N PO9T4
,5D
  _4 ,5D TURNS ,5D MODE ON OR (F4 ,9 ,5D
    MODE1 Y C PRESS AN >R[ KEY TO MOVE
    TO ! NEXT NONBLANK CELL 9 ! SAME
    COLUMN OR R[ Z ! ACTIVE CELL4 ,5D
    MODE TURNS (F AUTOMATICALLY AF
    PRESS+ ! >R[ KEY4 ,MAKE SURE TO
    PRESS ,5D AG 2F PRESS+ ! NEXT >R[
    KEY4 ,5D MODE IS %[N 9 ! /ATUS B> :5
    X IS ON4
  _4 ,IF ! CELLS >E BLANK1 PRESS+ ,5D
    FOLL[$ BY AN >R[ KEY MOVES TO ! LA/
    CELL 9 ! R[ OR COLUMN4
  _4 ,5D AL SELECTS ! LA/ COMM& ON ! M5U
    :5 A M5U OR SUBM5U IS VISIBLE4   #CC
  _4 ,CTRL "6 ,5D MOVES TO ! LA/    B#BJ
    CELL ON A "W%EET1 TO ! L[E/ US$ R[ (
    ! "RMO/ US$ COLUMN4 ,IF ! CURSOR IS
    9 ! =MULA B>1 ,CTRL "6 ,5D MOVES !
    CURSOR TO ! 5D ( ! TEXT4
  _4 ,CTRL "6 ,%IFT "6 ,5D EXT5DS !
    SELEC;N ( CELLS TO ! LA/ US$ CELL ON
    ! "W%EET "<L[]-"R CORN]">4 ,IF !
    CURSOR IS 9 ! =MULA B>1 ,CTRL "6
    ,%IFT "6 ,5D SELECTS ALL TEXT 9 !
    =MULA B> F ! CURSOR POSI;N TO !
    5D",-? DOES N A6ECT ! HEI<T ( !
    =MULA B>4
-------------------------------------#BA
,5T]
  _4 ,COMPLETES A CELL 5TRY F ! CELL OR
    ! ,=MULA ,B>1 & SELECTS ! CELL 2L
    "<BY DEFAULT">4
  _4 ,9 A DATA =M1 X MOVES TO ! F/ FIELD
    9 ! NEXT RECORD4 ,OP5S A SELECT$ M5U
    "<PRESS ,F#AJ TO ACTIVATE ! M5U B>">
    OR P]=MS ! AC;N = A SELECT$ COMM&4
  _4 ,9 A DIALOG1 X P]=MS ! AC;N = !
    DEFAULT COMM& BUTTON 9 ! DIALOG "<!
    BUTTON ) ! BOLD \TL9E1 (T5 !     #CD
    ^1,,OK BUTTON">4                A#BA
  _4 ;,ALT "6 ,5T] />TS A NEW L9E 9 !
    SAME CELL4
  _4 ,CTRL "6 ,5T] FILLS ! SELECT$ CELL
    RANGE ) ! CURR5T 5TRY4
  _4 ,%IFT "6 ,5T] COMPLETES A CELL 5TRY
    & SELECTS ! CELL ABV4
,ESC
  _4 ,C.ELS AN 5TRY 9 ! CELL OR ,=MULA
    ,B>4
  _4 ,CLOSES AN OP5 M5U OR SUBM5U1
    DIALOG1 OR MESSAGE W9D[4
  _4 ,X AL CLOSES FULL SCRE5 MODE :5 ?
    MODE HAS BE5 APPLI$1 & RETURNS TO
    NORMAL SCRE5 MODE TO 4PLAY ! RI2ON &
    /ATUS B> AG4
,HOME
  _4 ,MOVES TO ! 2G9N+ ( A R[ 9 A
    "W%EET4
  _4 ,MOVES TO ! CELL 9 ! UPP]-LEFT
    CORN] ( ! W9D[ :5 ,SCROLL ,LOCK IS
    TURN$ ON4
  _4 ,SELECTS ! F/ COMM& ON ! M5U :5 A
    M5U OR SUBM5U IS VISIBLE4
  _4 ,CTRL "6 ,HOME MOVES TO !       #CE
    2G9N+ ( A "W%EET4               B#BA
  _4 ,CTRL "6 ,%IFT "6 ,HOME EXT5DS !
    SELEC;N ( CELLS TO ! 2G9N+ ( !
    "W%EET4
-------------------------------------#BB
,PAGE ,D[N
  _4 ,MOVES "O SCRE5 D[N 9 A "W%EET4
  _4 ;,ALT "6 ,PAGE ,D[N MOVES "O SCRE5
    TO ! "R 9 A "W%EET4
  _4 ,CTRL "6 ,PAGE ,D[N MOVES TO ! NEXT
    %EET 9 A "WBOOK4
  _4 ,CTRL "6 ,%IFT "6 ,PAGE ,D[N
    SELECTS ! CURR5T & NEXT %EET 9 A
    "WBOOK4
,PAGE ,UP
  _4 ,MOVES "O SCRE5 UP 9 A "W%EET4
  _4 ;,ALT "6 ,PAGE ,UP MOVES "O SCRE5
    TO ! LEFT 9 A "W%EET4
  _4 ,CTRL "6 ,PAGE ,UP MOVES TO !
    PREVI\S %EET 9 A "WBOOK4
  _4 ,CTRL "6 ,%IFT "6 ,PAGE ,UP SELECTS
    ! CURR5T & PREVI\S %EET 9 A "WBOOK4
,%IFT
  _4 ,HOLD ! ,%IFT KEY :ILE Y DRAG A
    SELECT$ R[1 COLUMN1 OR SELECT$   #CF
    CELLS TO MOVE ! SELECT$ CELLS   A#BB
    & DROP TO 9S]T !M 9 A NEW LOCA;N4
,SPACEB>
  _4 ,9 A DIALOG1 P]=MS ! AC;N = !
    SELECT$ BUTTON1 OR SELECTS OR CLE>S
    A *ECK BOX4
  _4 ,CTRL "6 ,SPACEB> SELECTS AN 5TIRE
    COLUMN 9 A "W%EET4
  _4 ,%IFT "6 ,SPACEB> SELECTS AN 5TIRE
    R[ 9 A "W%EET4
  _4 ,CTRL "6 ,%IFT "6 ,SPACEB> SELECTS
    ! 5TIRE "W%EET4
  _4 ,IF ! "W%EET 3TA9S DATA1 ,CTRL "6
    ,%IFT "6 ,SPACEB> SELECTS ! CURR5T
    REGION4 ,PRESS+ ,CTRL "6 ,%IFT "6
    ,SPACEB> A SECOND "T SELECTS !
    CURR5T REGION & XS SUMM>Y R[S4
    ,PRESS+ ,CTRL "6 ,%IFT "6 ,SPACEB> A
    ?IRD "T SELECTS ! 5TIRE "W%EET4
  _4 ,:5 AN OBJECT IS SELECT$1 ,CTRL "6
    ,%IFT "6 ,SPACEB> SELECTS ALL
    OBJECTS ON A "W%EET4
  _4 ;,ALT "6 ,SPACEB> 4PLAYS ! ^1,3TROL
    M5U = ! ,EXCEL W9D[4
                                     #CG
,TAB KEY                             #BC
  _4 ,MOVES "O CELL TO ! "R 9 A "W%EET4
  _4 ,MOVES 2T UNLOCK$ CELLS 9 A
    PROTECT$ "W%EET4
  _4 ,MOVES TO ! NEXT OP;N OR OP;N GR\P
    9 A DIALOG4
  _4 ,%IFT "6 ,TAB MOVES TO ! PREVI\S
    CELL 9 A "W%EET OR ! PREVI\S OP;N 9
    A DIALOG4
  _4 ,CTRL "6 ,TAB SWIT*ES TO ! NEXT TAB
    9 A DIALOG1 OR "<IF NO DIALOG IS
    OP5"> SWIT*ES 2T #B ,EXCEL W9D[S4
  _4 ,CTRL "6 ,%IFT "6 ,TAB SWIT*ES TO !
    PREVI\S TAB 9 A DIALOG1 OR "<IF NO
    DIALOG IS OP5"> SWIT*ES 2T ALL
    ,EXCEL W9D[S4
GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

              @.<,! ,5D@.>





                                     #CH