Creating Reports
- Introduction to the Task Pane
- Introduction to Cosmos Functions
- Working with Range Lists
- Creating Rows Range Lists
- Creating Columns Range Lists
- How to Nest Range Lists to Create Grouping Reports
- Working with Range List Regions
- Creating Sheet Lists
- Working with Child Sheets
- How to Create a Field Lookup Function
- How to Create a Sum Function
- How to Count the Number of Records
- How to Count Unique Values
- Working with Filters
- How to Add Report Options
- How to Sort Data
- How to Limit the Number of Results Being Returned
- Working with Dates
- Working with Custom Lists
- How to Modify and Delete Existing Functions
- How to Format Reports
- Adding Sums and Subtotals to a Report
- Working with Charts and Graphs
- Inserting or Deleting Rows and Columns in Existing Range Lists
- How to Preview a Report When Editing
- Working with the Cosmos Excel Add-In Settings
- How to Reverse the Sign of a Sum Function
- Editing Reports Using Excel Desktop
- How to Add Excel Filters to a Report
- How to Add Month-to-Date (MTD) or Year-to-Date (YTD) Calculations into a Report