Can I read Excel Functions and Dashboard Analysis Guide on EtoBox?

Excel Functions and Dashboard Analysis Guide by Shantanu Narain is a document available to read on EtoBox.

What is Excel Functions and Dashboard Analysis Guide about?

1. The document discusses various Excel functions and tools including SUM, AVG, MAX, MIN, conditional formatting, VLOOKUP, IF, IFNA, IFERROR, INDIRECT, SUMIF, COUNTIF, flash fill, and data validation. 2. Key Excel functions for analysis are discussed including decision making functions like IF, IF(OR), IF(AND), and tools for dashboard creation and data visualization including pivot tables, charts, slicers, and Google Data Studio. 3. Examples of dashboard analysis discussed include sales trend, salespers

Author

Shantanu Narain

Language

EN