MICROSOFT EXCEL
4 STARTERS AND ALL
Are you new to Excel and want to grow your skills?
Let's build your confidence, one function at a time!
Do you need to refresh your skills for a new role?
Let's unlock your potential as a data analyst!
Look no further than Un4Scene Sites. We provide guidance using practical real world data examples. Build your skillset, one function at a time. Prepare for your next test, professional role, or analyze the overall health of your small business.
To schedule a consultation to discuss your needs,
please complete the form below for a follow up within 48hrs.
QUICK EXCEL FUNCTION REVIEWS
This video contains a recap of AUTOSUM and its related quick functions covered in our larger training sessions. (SUM, AVG, COUNT, MIN , MAX)
This video contains a recap of using the AUTOSUM shortcut to calculate totals within a table.
This video contains a recap of 4 quick text clean up functions covered in our larger training sessions. (UPPER, LOWER, PROPER, TRIM)
This video contains a recap of a few quick text clean up functions covered in our larger training sessions (CONCAT, LEFT, RIGHT).
COMMON FUNCTIONS EXPLAINED
Download VLOOKUP Exercise File for practice
Once file is downloaded, be sure to open the file with Microsoft Excel application.