Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn essential Excel functions and build practical business applications through this comprehensive 9-hour 53-minute course covering fundamental spreadsheet skills. Master core Excel functions including ADDRESS, COLUMN, COLUMNS, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, INDIRECT, LARGE, ROUND, ROUNDUP, ROUNDDOWN, ROW, ROWS, SMALL, SUBSTITUTE, AVERAGE, SUM, and SUMIF functions. Explore advanced techniques by combining LARGE and VLOOKUP functions, creating dropdown lists with VLOOKUP integration across different tabs, and using CHOOSE function to solve common VLOOKUP issues. Develop practical business solutions including inventory management systems with conditional formatting, complete invoicing systems with product lists, customer databases, invoice design and dashboard creation, and automated certificate generation systems. Practice real-world applications such as building a baker's recipe costing calculator, tracking sales data, calculating age formulas, and implementing weighted averages. Master data validation through dropdown list creation with error messaging, learn cell protection and formula hiding techniques, and apply conditional formatting based on text criteria across entire columns. Gain hands-on experience with SUMPRODUCT functions, OFFSET functions, and nested VLOOKUP techniques while building dynamic sentences and currency display formatting to create professional spreadsheet solutions for business environments.
