 . 100+     Excel (   Google )
 


 
    ,      Excel Google .

   100 , ,   ,      .  :   Excel  .



  :

   

   

,     :  ,  ,  

 :  ,   ,     ,   (,)

     LAMBDA

  

 Power Query

 : ,  (  ), 3D-

  Excel Google 

Ƞ  .

          .      ⠖   Excel,        .



 

  :   

  

       

     ,   Excel    Google 

  ,      



 

   Excel Google .

,     Excel Google ,         .

  ,    .





 

 . 100+    Excel ( Google )

2- , 



  



  .                .



 , 2023

.  ,  , 2024


* * *







     .

   


    Excel (Google ),  ,     .     ,         ,        .          ,     (, ,     ),   . Ƞ   .

 -  , ,   , ,  ,     .  ࠖ ,   100 1000 .      100  ,      ?

 ,  ,  , , Excel (Google )   ,   ,  .

      ,      .        .  ,     ,  ,     ,    ,   ,   .       ,      .

:       .      Excel .     .,    (   -  Excel).  ,     ,          ( ). Ѡ :)       .




  ?


,   蠖   Excel Google Spreadsheets ( 젖 ,    Excel,   ,     Google ,    ).

    Google Spreadsheets Excel    .






 Excel Google 

https://mif.to/0Irxx (https://mif.to/0Irxx)



,    ,          .




?


 :   ,   ,    ,      (,          ,   ,   ).

  :  ,      ,      .    ,      .

    Excel ( 2021 ,  20222023): 젖     (#litres_trial_promo),  LET (#litres_trial_promo) LAMBDA (#litres_trial_promo),    (#litres_trial_promo).




    Excel?   ?


  :   Microsoft 365 Excel 2021.  2016 2019 ,     LAMBDA  . ,      Google        Google (Gmail), 2022   LAMBDA,  SORT, FILTER UNIQUE,  Excel 2021,   .

 Excel 2007, 2010 2013     ,     .

2003 ,.

Excel Online    ,       ,       (  ),   ,     .     ,     Google ,       Excel,  LAMBDA, LET, FILTER, SORT, UNIQUE,      .




   ?


          Excel .     ( ).






 :  . xlsx




 - Excel  https://mif.to/yU2bzV (https://mif.to/yU2bzV)



   ,    Excel.      ( )  ()  /.

  蠖   .

 ,        Excel.      Google ,    Excel,       .



,     Excel             ,    .


    Google  ,     .

    Google ,    (?  ).

 :        -   ,      蠫  -  Excel/ Google .




   ?


 Google   .



  (    ,   ,    Excel ).


  /.



  Windows (Mac).




. . 





 Excel  .  Excel


   Excel       2003 2007.       (   65 ;    ),     .

     2003 :








   Excel    ,     (  -  ,       ).    Microsoft 365 ().








     Excel. ,   Excel  - :   , ,  .

,   ,  ,      .   :

  (),   (    65)   ()  ( Excel)  Excel 2007;

  Power Pivot, Power Query  Excel 2010;

      Excel 2021    Microsoft 365 ,   LAMBDA (Microsoft 365,  Excel 2021),     .

      Google  ,       .






 Excel

https://mif.to/cfC9b (https://mif.to/cfC9b)



     Excel.








 ,    ,    ,    .

   , :

  ;

      ;

      Enter,   ;

 F5       .








  (  ):

  ;

  ( )  ,  Shift    ( ) ;

 F8 (Fn+F8)   ;     堖      ;

    ,    ();

     (   , ,  )  Ctrl      Shift+F8 (Fn+?+F8)      Ctrl;

Ctrl+Shift+ (^+?+)       ; ,       Ctrl+Shift+? (^+?+?),          .



    .

   ( Ctrl    , 砖  ).  Excel 2021/ Microsoft 365     :  Ctrl+Shift   . ,       ,      .

        ,  堖     .

      PgUp PgDn.

     Ctrl+.

      ,    Scroll Lock.      ,  .

         Tab (  ), Shift+Tab ( ), Enter ( ) Shift+Enter ( ).

Ctrl+    /.

     (   ,   - ),  Ctrl+End.   ,       ,  .




 Google 


  Google ?    ,     ,     ,    , : , ,  ,  ,  .








       .      Alt  ⠖ ,     . , Alt+D    (Data).

   (  )  ,  Ctrl+/.

       ,       ,         .









     Excel



 Ƞ 

      ,  Ctrl+F1     .

    :   .








  Excel  :   ,   ,  .

    ⠫ Excel       (Customize Ribbon).








   ,   .








  ,    ,    ,         > > (Add > >).

,  ,          ,  ,    .     .








     (Rename)      (Main Tabs),       ꠖ     .     - ,   ,   (All Commands). 젖   (   ,  ),    .








        ( ,    ,  ).








   ,    .   :

   ,   ,  ;

 ,       ,       (       ,    ,        , ).

.         :








   ,       :







  

   (Quick Access Toolbar, QAT)     .       ,        Excel.








    ,           (Add toQuick Access Toolbar).








     .

      Excel    ,      ( ,  ).








  ,   ,   Excel            (More Commands).








     绠   (Choose commands from All Commands).     Excel,       (,  ,         ).






 頖    ,    



,      .     堖     (Freeze Panes).            .








,       ,           .

  ,         ,        Excel          (Commands Not inthe Ribbon).








        ( Alt, /, F10    ).







    ߠ 

            Excel,   ,       ,      (Forall documents).








,        MS Office.      , , Power Point Outlook.



 Google     , ,.



 ʠ  Ƞ   Ѡ 

       ,  Alt, F10, / (,     Windows,  Mac).       ,    ࠖ .    :     ,     .








      , ,    ࠖ      . ,  ,       .     :         (View? FormulaBar).

         Alt+ (  ࠖ  ,     ,     ).








 Microsoft 365  2020     ࠖ       Alt  ,  , ,    .    ,     .



  

      2023   Office Insider (     Office 365    Excel,  2021  )    ,    (Personal Toolbar).        Excel 2003 ,    ,    .   Excel     .

  , ⠫,     .








           .

    廠   .     -  ,      .








      ,     ,      (Show command labels)   (  ).








        .     , .

    (Alt, F10, /+ /) ,  ()    .








       Alt, F10, /      .


 ʠ    Ƞ

   ,  ,   Excel    .     ,    .

, ,  ,        :








   ,   

    :








Ӡ    Excel   /?

     ,    Alt     .

    (  Ctrl+K).








       ,       Ctrl+ PgDn () Ctrl+ PgUp (, ).

  .     , Ctrl+Page Up  .









 


    .   /    蠖     .

Ctrl+Enter (^+Return)     (      /    );

Enter (Return)    ;

Tab  ;

Shift+Enter  ;

Shift+Tab  .

  ,      Enter,  Excel: ? ?        (Options? Advanced? After pressing Enter, move selection).








       ( Tab),   Enter,      ( ).     .








 Google  :       :

Enter ;

Shift+Enter ;

Tab ;

Shift+Tab .

        Tab   Enter,      ( ).

  Google      ,     . Ƞ  Enter       !     (, ),     .  ,      ,      .



 EXCEL ߠ  

 (AutoCorrect).      - , ,   ,        ⠫: ? ?   (Options? Proofing? AutoCorrect Options).








 ,      Microsoft Office!        , , Outlook.

 (Series).        ,        :








     .   ,    ,    (Columns).       ,    堖 .  .     ,              .








       01.01.2023 30.12.2025 .








    : ,     ,   .      .








,    ,     .








:








.     -  (,   10     ),           .








      ,         ,     .








   蠖     (  ).

Excel 2010      ,  :      ,   .

    Ctrl+ D  .        . , Ctrl+ R   .

P.S. Google            Ctrl+ Enter.   Ctrl+ D/ Ctrl+ R   .








.       , Excel     (  Enter, Tab     Shift,   ,  ).








  (Drop-down List). Alt+? (?+?)    蠫  (Pick from)  . Ƞ   ,     .







 




 :  . xlsx

  (Flash Fill)      Excel.    Excel 2013.       - :   -  ,      ( ),           ().

  ,     :

   (,  . ..);

   ,     ,     (,  . . .     );

    (,      ,         -  -  - );

  .

   ,      ,  ,  Excel   ,  Enter (   ),   Ctrl+E (^+E).

     ,     ,  Excel     .   Ctrl+E B2:








  Ctrl+E   .








     ,   堖 Excel    ( ).   Enter    ,   .








     .








  .

1.    ,    (       ,    ). Ƞ ,    ( )   .      ,       .








  Ctrl+E       :








2.   Excel    .      (,  ).      .

3.       . ,        








      :








-       ,       (     Р/ CONVERT,    ,  ,     ;   ,      ,   Ƞ/ IF,    ).








   ,      .       ,      ,     .




  Excel


  () Excel  ⠖       .

   ( ; ,  Excel Google    )   (       ;        F11 (Fn+F11),    ).           ,       Alt+F1 (Fn+ ?+F11)   (Insert) .

     .








   ,   ,      Ctrl+PgUp (Fn+ ^+?) Ctrl+PgDn (Fn+ ^+?)   .

Ӡ         ,        .     ,         .

      ,        (,  ;      ).



 Google     -,  :   (          ),   .      .






 Ƞ  Ƞ

   ,       (Insert).

    (Home)      /.








 Excel   /      (, 1048576  16384 ,  Excel 2007).

   .       (),       :

Microsoft Excel    ,        .     ,   ,    .    ,     ,   .



 Google       .  堖  ,     10 (      2 5,  10,    ,    ).    ,    .







       , Excel,    :   ,      .


 /

   ,      (      ).








        (Delete)  :








Ƞ   Ctrl+ (?+ ).      ,    ,   ,    ,     ,    ,    .








   .   

     ,  ,    . ,      ,     :








    .          ?    (Find andSelect? Go ToSpecial).








    ,      (    蠖 Blanks).








       :








  Ctrl+ (?+ )    (Entirerow).








  /    Excel

 ,     .

     (  ).     ,    堖   (Find&Select? Go ToSpecial? Blanks).








    Ctrl+ (  //). Ƞ .

P.S.           ,    ,   .   .


  

     ,     ,          ࠖ     ,         (  ,   ).








       .







   

 Excel         .    .   :

     ⠖    Ctrl   ;

    ,  ,   ,  Shift        .

      . ,      A1,       .








     ,   :      ,   ,     ,  , ,      .

               (Ungroup Sheets).









    Excel Google 


Ӡ Excel (Google )   .

堖  ,     ,   : , , , , . Ƞ,         .

 ,   ,  .

   ,  - ,   ,  堖  ,   , 堖 ,   .

   ,     ,    (   ),     ,     (    ,      ,   ,  ,    ).

   .  堖   , ,  ,  .   ,  :       ,  ,    , , ,    ,       .








   ,   .

 (,  )     -.      ,     .   ,   .    (,   )    .








     ,     . 堖    ,   (  ) .

   ,     ,    .   -.

       ( Delete),      ( / Clear   ).








 Google     ( ,  ,    ,   )   Ctrl+\.



 (   )     ,   .


  (Ctrl+V)  , .

     ,    Ctrl+Alt+V (?+ ^+V)     ǻ 蠫 (    ):

?  ()   ;

?  ()   .








:      Excel.      -  ,   ,      .

        蠖    Enter.

  :      ,       /    (Copy Here asValues Only/ Copy Here asFormats Only).

    (Ctrl+C),               .








 ,     (Ctrl+V)     -    .








      Google  (       Google)   Ctrl+ Shift+V





  .


   .

   ,     (https://www.litres.ru/book/renat-shagabutdinov/magiya-tablic-100-priemov-uskoreniya-raboty-v-excel-i-69463303/chitat-onlayn/)  .

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


