Advanced use of Excel 

• Rehearsing the basics. Cell formating, calculating with excel and absolute references. 
• Importing updating information from different sources. PowerQuery and Queries 
• How to handle information in and between cells. Dividing information into cells and combining them with a formula. 
• Go to special – feature. Conditional selection of cells.  

Advanced calculating  

• Format as a table in calculating.  
• Conditional calculation with functions. If and Sumifs. 
• Fetching and connecting information with functions like Lookup, Vlookup and new Xlookup.  
• Combining functions: Sort/Unique and Iferror/AverageIfs 

Keywords 

Excel, advanced, advance, table calculus, importing of data, PowerQuery, Csv, Reference, cell reference, Function, Vlookup, XLookup, If, Calculation, calculus, condition