This course will explain helpful ways you can improve the integrity of your spreadsheets. It leads off with disaster recovery techniques, followed by using lookup functions such as VLOOKUP, MATCH/INDEX, XLOOKUP and using Power Query to automate report clean-up and analysis.
schedule2 hours on-demand video
signal_cellular_altBeginner level
task_altNo preparation required
calendar_todayPublished At May 24, 2023
workspace_premiumCertificate of completion
calendar_todayUpdated At Jan 22, 2025