Skip to content
Trainings, consultancy, tutorialsTrainings, consultancy, tutorials
Trainings, consultancy, tutorials
Understand it right now!
  • For corporations
  • Individually
  • Consultancy
  • Tutorials
  • Contact
  • Where
    Můj účet
    • Registrace
    • Přihlášení
     0
    • No products in the cart.

    Subtotal: 0 Kč

    View Cart Checkout

     
    MENU
    • For corporations
    • Individually
    • Consultancy
    • Tutorials
    • Contact
    • Where
    You are here:
    1. Home
    2. Tutorials
    3. Functions

    Tutorials

    Functions

    • CUBEVALUE – get directly values from Power Pivot data model
    • Extract text after the last instance of some character
    • How to merge texts in Excel
    • IF – one IF nested in another IF
    • Merging of selected strings – something like CONCATENATEIFS, if it existed
    • NOW – automatically updated time
    • The FILTER function using something like “IN” operator – selection of items presented in some list
    • IF function in detail
    • VLOOKUP – function to connect two tables
      • Comparison of two lists and finding differences
    • IFS – select from multiple options
    • Percentages and their calculation in Excel

    Did you know we have a LinkedIn page?

    A nedal by se Váš kurz zaplatit z dotací?

    Určitě ano. Cenu kurzu Vám mohou dotace zaplatit buď celou nebo z 82%.

    Úhrada se liší podle toho, jestli jste jednotlivec nebo firma.

    • Dotace pro firmy
    • Dotace pro jednotlivce
    For companies
    Interested in company training?
    Excel trainings from beginners to experts. And other Microsoft Office applications as well.
    MORE INFORMATION
    Individually
    • Consultancy for complex spreadsheets creation
    • Preparation for your new job
    • Preparation for job interview
    MORE INFORMATION
    Spreadsheet development
    VBA - Power BI
    • Development of corporate databases
    • Reports, visualizations, plans, pricelists, budgets...
    • Merging of databases, cleaning, exports
    MORE INFORMATION

    Našimi kurzy prošlo více než 10 000+ účastníků

    2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami

    Potřebujete se na něco zeptat?

    Jsme tu pro vás každý den

    +420 602 274 999

    info@exceltown.com

    Pište kdykoliv. Odpovíme do 24h

    ExcelTown na LinkedInu

    Sledujte nás

    Excelujte s
    ExcelTownem

    ExcelTown.cz
    • Contact
    Naše služby
      Návody
        Návody

          © exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.