Google .  .   
 

 


Google    ,        .    ,             .     ,   ,    ,      .        ,    ?         ?          ,     .               蠖    .





 .  

Google .  .   



  .

                    .



  ,  , 2018

 .  ,  , 2018


* * *







Google    ,   (     ,    )       .        Excel,        .

     Google              Excel.    ,         .

   ,       Excel,            .                .

     20     堫,                2015__v2_  2015_FINAL_  11.02.2015   .

,     ,      ,        .

     Google         .   ,      ,  Excel    ,      ,     Google .

     ,   , ,   ,    ,    .

      (  )   ,  ,        .

     ?



 ,    Excel,  Google     ,      ,       .

 ,          Google  (   ).

   Excel ,                .



          -,  -,           .              .

,    -,            .    .

  Google        堖          -:



https://telegram.me/google_sheets (https://telegram.me/google_sheets)



       ,    Google     Google Apps.     Excel,    JavaScript.        Going GAS  OReilly.

   :



: renat@shagabutdinov.ru

: tr1kster@ya.ru



      .


   EXCEL

    .

  (     ,    ).

SQL-       QUERY.

    ().

      ,   , RSS-,   .

   ,  (   )   .

  ⠖      .        ,   .

   :        ( Excel    -,     ).


   EXCEL

      .

  .

        .

    .      ,  -  Google   .  ,             (      ,     - Excel).


 ǠEXCEL

     :








    ,                :








       ,    :








   ( )   ,   ( ()     ,                Excel.

      ,   .


  EXCEL

        Excel,   :



 ?   ? Microsoft Excel (XLSX)



     .








 ,    Excel   ,       IMAGE (.       (#litres_trial_promo)),    ,   Excel,    .  , ,  SPLIT, IMPORTRANGE     (IMPORTXML, IMPORTDATA, IMPORTHTML), UNIQUE COUNTUNIQUE, QUERY, REGEXEXTRACT, GOOGLEFINANCE.

 SPARKLINE     Excel.

 Excel      (IFERROR),         _xludf.DUMMYFUNCTION (),     Excel,     ࠖ  ,       .



=(__xludf.DUMMYFUNCTION("SPLIT(B21,"" "")");"")





     


      (   1000ꠖ        200,   800,      )   ().    Crop Sheet (https://chrome.google.com/webstore/detail/crop-sheet/aojcceglbipehndciapjedoomockgagl)    .

   (          ).

     (/VLOOKUP, /INDEX, /MATCH  ),      (      ). ,           VLOOKUP,     ,      .

  /   (     ).

,     ()   .

     .

 ,       .

,        .



:                ,     .  -        ,      :)

        .

      .

 Excel, ,            ,   砖    (, ,         XLS   XLSX, XLSM, XLSB).

:       ,    ,         20   IMPORTRANGE.    ,        ,        .

      :  ,       ,        .      ,    , ,   ,        堖    -.





    



  

 ,   Excel,    .

   ,      ,     ,      ( !A1).

    (     ),      .

       ,         ,        .         .


   (SUMIF),   ()    Ƞ

    ,        .      ,   ;   ;  ,     ;  ,       ;             .

    (SUMIF).

  https://goo.gl/1dIZMI (https://goo.gl/1dIZMI)  Google   ,    .   :

 ?  .

.

    ,       ,         (      堖   Excel,       ).

     .

,   2   .    =        ,       :








    (      ,     렖   ):








    .      ,    .      (   ,  ?  ).

             蠫   (    1:C7).       :  7  1;      ,    .

    ,   ,   .    -        ,  B1:B7  ,      ,     ( ,      ).








 ,      ,         .   ,    F4.      $,    젖  ,   ,   ,    .








(  F4 ,    ,   蠖  .)

   .     (;),        .      .

        2.     ,           ,   2 3.








   ,         .    .

:         ,        .

 ,      B2  3(     ,   2    ,     Ctrl+ C, Ctrl+ V):







,  Ƞ .   (INDIRECT)

 ,   Excel,     .

        F4        /   .

     ,          Excel     .

 蠖     A1, D10, AX127,            .      .   ,       ,   ,  N M  ,   . ,      B1



=A1


    A1,        ,     -1( )  0() .

       C4    :



=B4


  -      .

      .

,              ,      :








         ,      .

     .  ࠖ    $A$1 $B$5,      :








   ,  F4   (       ).   F4,     4 :



A1? $A$1? A$1? $A1? A1.



A$1$A1   ,        . ,           ,         ( )    (  A):








   ,     ,            , D:








    . ,       ,  -    20%,     $E$1, $E$2:








     .

    -  ,   A1   ,   INDIRECT ().     :



=INDIRECT("A1")

=("A1")







      ,       E2,   E1:







  A1ȠR1C1

  1.       ;  MSExcel,   Google     , 젖  .

  R1C1.     (ROW)   (COLUMN)  . , R3C2: 3-  2-   B3.

 Google     ,     (INDIRECT).          ,    A1 R1C1,     ,      .

  (INDIRECT)    :      .         R1C1,   0  .








   :







  A2:A

 ,            .

          ,    ()     (    ,    ),         A2:A,  A2:A100.        .

  / ,        :



A: A   A

3:3   3



,      12- :








    13-     :








      :








   (  )   C2:C,    C: C?    .

   ,   ( )    , , 2016:







 

  Excel,     .     ,  



=A7*$E$1


  



=*


   ,             (     ,    ,    ):








           :








         :







      Ƞ  

 ,     ,   .



   ,  >, <,=     (,   ,   <>  ):

,     








  ,  








        , ,     >=    ,   (&)




  .


   .

   ,     (https://www.litres.ru/evgeniy-namokonov/google-tablicy/)  .

      Visa, MasterCard, Maestro,    ,   ,     ,  PayPal, WebMoney, ., QIWI ,       .


