Spreadsheets are used to keep count of simple stock, budgets, project tracking, information database, addresses, or even responses from forms. Use the power of formulas to format text, do statistical analysis, calculate percentages and means, truncate or concatenate text, filter data and assign different cells actions and colours.
With this knowledge you’ll be able to:
Understand Excel’s full capabilities
Learn how to import, clean and organize data effectively
Build a payroll calculator using formulas
Create a simple project tracker in Excel
Learn how to send a newsletter from a spreadsheet
Connect multiple sheets via references
Prerequisites and requirements:
Digital Literacy course
Basic understanding of the English language
Computer with an internet connection (you can learn this course on mobile but only simple procedures can be completed)