You must use every tool at your disposal. You must use clear, concise and appro
You must use every tool at your disposal. You must use clear, concise and appropriate formulas. The first page should be a cover page with hyperlinks to the other pages and a picture in the background. The second page should be a dashboard (4+ charts on a sheet). Include relative, absolute and mixed cell reference use all the summary statistics (sum, average, min, max, count, etc.) use at least two different instances of date and time functions use at least three different formats such as number, date, custom etc. use at least three different instances of nested if functions use vlookup and index/match functions create and use range names and use them in formulas use at least three instances of conditional formatting, one of which needs to be custom formatted design at least 2 tables design at least 4 pivot tables freeze panes text boxes to explain name your sheets and give them colors sort the table at two levels or more use the subtotal function have at least four relevant pivot tables with at least two calculated fields (measures) and a calculated item have a slicer available for the pivot table create a variable data table.

Leave a Reply

Your email address will not be published.