How to Ace that Business Analyst Interview.

What Will You Learn?

• Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
• Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
• Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
• Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).
• Create and format a table of data in a spreadsheet
• Use formulae and functions to derive knowledge from raw data
• Use conditional formatting to provide better readability to tables