Foresight BI

1. Introduction & Pre-requisites

2. Creating Excel Charts with Alt+F1 Keyboard shortcut

3. Updating the data range in Excel charts

4. Using Data Tables as data source for charts to automate updates

5. Creating Excel charts from un-summarized datasets

6. Creating Excel charts from un-summarized datasets (part 2)

7. Editing Chart Axes

8. Changing chart types

9. Introduction to Excel Chart Elements

10. Introduction to formatting of Excel chart elements

11. Formatting chart area (changing fill color and text colors)

12. Formatting lines on a Line chart

13. Formatting chart numbers and display units

14. Using Combo charts and editing column gap widths

15. Formatting chart tittles, gridlines and Legends

16. Formatting Data Labels and using Pie Charts

17. Intro to Pivot table reporting & workbook structuring

18. Data Structuring rules for Pivot Tables

19. Creating Pivot Tables in New Excel Worksheets

20. Creating Pivot Tables on existing worksheets and renaming Pivot table headings

21. Using Pivot Table Fields Row Bucket and changing design layout

22. Using Pivot Table Fields - Columns and Filters Bucket

23. Using Pivot Tables Fields - Values Bucket and changing Values Field Settings

24. Filtering and Sorting Pivot Tables Report Data

25. Showing Pivot Table Values as different calculations

26. Updating Data Source for Pivot Table and Refreshing Pivots

27. Working with Date Columns in Pivot Tables

28. Creating addition Pivot Tables

29. Creating additional Pivot Tables (part 2)

30. Working with Slicers

31. Building our Excel Dashboard (part 1)

32. Building our Excel Dashboard (part 2)

33. Building our Excel Dashboard (part 3)

34. Building our Excel Dashboard (part 4)

35. Building our Excel Dashboard (final part)