Skip to content
ExcelTown - kurzy přesně pro VásExcelTown - kurzy přesně pro Vás
ExcelTown – kurzy přesně pro Vás
Přijďte na školení a zrychlete svoji práci!
  • 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
  • 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 Cancel 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
  • 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)
  • Mick on SUMX vs SUM – key differences very briefly (DAX – Power Pivot, Power BI)
  • Kennethnum on Getting data from Excel to R-script, using Windows clipboard
  • Anonymous on SELECTCOLUMNS – select some columns from table (DAX – Power Pivot, Power BI)

ExcelTown - Contact

+420 602 274 999
info@Exceltown.com

Hot news

  • Power Automate – flow checking tomorrow´s weather and, if nice, asking for holiday
  • Display collections in app
  • Add and show Power Apps collection

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