Skip to content
Trainings, consultancy, tutorialsTrainings, consultancy, tutorials
Trainings, consultancy, tutorials
Understand it right now!
  • Home
  • For corporations
  • Individually
  • Consultancy
  • References
  • Pricing
  • Tutorials
  • Contact
  • Where
  • EN
    • CZ
    • SK
    • EN

  • Registrace
  • Přihlášení
 0
  • No products in the cart.

Subtotal: 0 Kč

View Cart Checkout

 
  • Home
  • For corporations
  • Individually
  • Consultancy
  • References
  • Pricing
  • Tutorials
  • Contact
  • Where
  • EN
    • CZ
    • SK
    • EN

Tutorials

You are here:
  1. Home
  2. Tutorials
  3. Functions

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
  • IF function in detail
  • IFS – select from multiple options
  • Merging of selected strings – something like CONCATENATEIFS, if it existed
  • NOW – automatically updated time
  • Percentages and their calculation in Excel
  • VLOOKUP – function to connect two tables
    • Comparison of two lists and finding differences

Leave a Reply

Your email address will not be published.

CAPTCHA
Refresh

*

clear formPost comment

Did you know we have a LinkedIn page?
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
Recent Comments
  • Dan Paul on SUMMARIZE – groupping in data models (DAX – Power Pivot, Power BI)
  • Haider on LOOKUPVALUE – assigning of values from other table without relation (DAX – Power Pivot, Power BI)
  • namereunused on Remove filter in visuals
  • Anonymous on SUMX vs SUM – key differences very briefly (DAX – Power Pivot, Power BI)
  • jo on SELECTCOLUMNS – select some columns from table (DAX – Power Pivot, Power BI)

ExcelTown - Contact

+420 602 274 999
info@Exceltown.com

Hot news

  • Office Script – how to record script very simply
  • Values ​​/ measures in an Excel pivot table below each other instead of next to each other
  • Keep sorted table for Group By, using Table.Buffer

© exceltown.com / 2020 Vyrobilo studio bARTvisions s.r.o.