13 Matching Annotations
  1. Aug 2021
    1. Heyyy!!! I am so happy to see that I am not the only one following a similar system. I have lots of books marked in the same way and also with notes (by the way when taking notes use black ink - blue reflects in light and tired mind - ) and then my solution. After reading it all and taking notes, I categorized all my notes and distribute around my Excel file as attaching. Using this way I can add it to different categories and use it every where.

      Example of person using Excel to keep a commonplace book.

  2. Mar 2021
  3. Feb 2021
  4. Jan 2021
    1. Did you know that everything you can do in VBA can also be done in Python? The Excel Object Model is what you use when writing VBA, but the same API is available in Python as well.See Python as a VBA Replacement from the PyXLL documentation for details of how this is possible.

      We can replace VBA with Python

    2. You can write Excel worksheet functions in your Jupyter notebook too. This is a really great way of trying out ideas without leaving Excel to go to a Python IDE.

      We can define functions in Python to later use in Excel

    3. Use the magic function “%xl_get” to get the current Excel selection in Python. Have a table of data in Excel? Select the top left corner (or the whole range) and type “%xl_get” in your Jupyter notebook and voila! the Excel table is now a pandas DataFrame.

      %xl_get lets us get the current Excel selection in Python

    4. to run Python code in Excel you need the PyXLL add-in. The PyXLL add-in is what lets us integrate Python into Excel and use Python instead of VBA

      PyXLL lets us use Python/Jupyter Notebooks in Excel

  5. Sep 2019
    1. XMATCH which has a similar signature to XLOOKUP but returns the index of the matching item. XMATCH is both easier to use and more capable than its predecessor MATCH.   XMATCH(lookup_value,lookup_array,[match_mode],[search_mode])

      XMATCH is another upcoming Excel function

    2. While VLOOKUP was widely used, it has several well-known limitations which XLOOKUP overcomes: 

      XLOOKUP overcomes 6 VLOOKUP's issues:

      1. Defaults to an "approximate" match.
      2. Does not support column insertions/deletions.
      3. Cannot look to the left.
      4. Cannot search from the back.
      5. Cannot search for next larger item.
      6. References more cells than necessary.
    3. XLOOKUP(lookup_value,lookup_array,return_array)   lookup_value: What you are looking for lookup_array: Where to find it return_array: What to return

      XLOOKUP will replace VLOOKUP and HLOOKUP excel functions used since 1985

  6. Dec 2018
    1. Manténte al tanto de tus ofertas con un sistema especializado de gestión y seguimiento de leads. Programa y registra tus intercambios, incluyendo llamadas, correos electrónicos y reuniones con recordatorios sincronizados automáticamente con tu calendario.

      Manténte al día con tus leads con un sistema de gestión y seguimiento de leads. Programa y registra tus intercambios, incluyendo llamadas, correos electrónicos y reuniones con recordatorios sincronizados automáticamente con tu calendario.

    2. noCRM.io es una Herramienta de Gestión de Pipeline Comercial diseñada para que vendedores gestionen leads de manera eficiente para cerrar mas ventas. PROBAR GRATIS

      noCRM.io es una Herramienta de Gestión de Pipeline Comercial diseñada para que los vendedores gestionen leads de manera mas eficiente y cierren mas ventas.

  7. Nov 2017
    1. I don’t want financial planning people spending their time importing and exporting and manipulating data, I want them to focus on what is the data telling us,

      reason for stopping using excel😲