Basic Overall Training

Excel – Sharperlight Add-in Core ribbon functionality Manager, Table and Value
04:47
https://youtu.be/-unggnmi1EY?t=289

Excel – Tables
07:56
https://youtu.be/-unggnmi1EY?t=480

Query Builder Output Expressions
23:04
https://youtu.be/-unggnmi1EY?t=1385

Excel – Binding Charts and Pivots to Sharperlight Tables
26:31
https://youtu.be/-unggnmi1EY?t=1592

Excel – Inserting Rows and Columns and their effect on formulas
27:35
https://youtu.be/-unggnmi1EY?t=1656

Excel – Cross sheet cell referencing and named ranges
28:53
https://youtu.be/-unggnmi1EY?t=1734

Excel – Drilldown and Drill Through
30:06
https://youtu.be/-unggnmi1EY?t=1807

Excel – Value Formulas
36:18
https://youtu.be/-unggnmi1EY?t=2179

Excel – Cell references that use ranges or multiple values
39:28
https://youtu.be/-unggnmi1EY?t=2369

Excel – Changing filter criteria and parameters When to copy down formulas
41:51
https://youtu.be/-unggnmi1EY?t=2512

Excel – Dealing with filter errors
43:34
https://youtu.be/-unggnmi1EY?t=2614

Excel – Value formulas example Products by Period
45:48
https://youtu.be/-unggnmi1EY?t=2748

Excel – Using Value formulas in Reference mode to get labels and descriptions
49:38
https://youtu.be/-unggnmi1EY?t=2978

Excel – Delayed formulas: Controlling when calculation is done
53:23
https://youtu.be/-unggnmi1EY?t=3205

Excel – Creating refresh calculation buttons
55:57
https://youtu.be/-unggnmi1EY?t=3359

Excel – Splitter: Creating Worksheets based on filter combinations
58:19
https://youtu.be/-unggnmi1EY?t=3500

Excel – Distributiing Workbooks and detaching Formulas
1:04:43
https://youtu.be/-unggnmi1EY?t=3884

Excel – Use Cache: Improving calculation time over slow internet connections
1:06:38
https://youtu.be/-unggnmi1EY?t=3999

Data Writeback – Publisher examples
1:08:59
https://youtu.be/-unggnmi1EY?t=4140

Data Writeback – Excel examples
1:11:00
https://youtu.be/-unggnmi1EY

Excel – Data Writeback example using Validate and Execute Buttons
1:20:08
https://youtu.be/-unggnmi1EY

Sharperlight Web Site Resources
1:24:49
https://youtu.be/-unggnmi1EY?t=5090

Site Setup – Setting up Users and Permissions
1:29:59
https://youtu.be/-unggnmi1EY?t=5401

Site Setup – Product Settings
1:37:36
https://youtu.be/-unggnmi1EY?t=5857

Sharperlight Application Server Windows Service
1:40:46
https://youtu.be/-unggnmi1EY?t=6047

Publisher – Creating Reports and Dashboards for the Web Channel
1:42:10
https://youtu.be/-unggnmi1EY?t=6131

Publisher – Default Types: Table, Grid, Chart, Pivot, Menu and PDF
1:46:32
https://youtu.be/-unggnmi1EY?t=6393

Publisher – Using Split to create Tabs based on filter combinations
1:48:41
https://youtu.be/-unggnmi1EY?t=6522

Publisher – Clone, Restore, Export and Import menu
1:49:45
https://youtu.be/-unggnmi1EY?t=6590

Query Builder – Dynamic Outputs: Binding filter combinations to outputs
1:50:26
https://youtu.be/-unggnmi1EY?t=6626

Query Builder – Output Sub Queries
1:53:26
https://youtu.be/-unggnmi1EY?t=6808

Publisher – Creating a main landing page with menus
1:57:24
https://youtu.be/-unggnmi1EY?t=7044

Publisher – Themes, CSS styling and custom HTML
2:02:20
https://youtu.be/-unggnmi1EY?t=7341

Annotations – Binding annotations to Report filters and row values
2:04:24
https://youtu.be/-unggnmi1EY?t=7465

Publisher – Page Designer: Creating detailed report layouts for PDF and printing
2:07:57
https://youtu.be/-unggnmi1EY?t=7678

Query Builder – Sorting, Grouping and Sub Totals
2:09:46
https://youtu.be/-unggnmi1EY?t=7787

Excel – Using Sheet to show Sub Totals and Outlines
2:12:08
https://youtu.be/-unggnmi1EY?t=7930

Scheduler – Automation of tasks like Email busting, writebacks and intergration etc
2:15:52
https://youtu.be/-unggnmi1EY?t=8153

Reporting Rows – Design a report layout where each row has it’s own criteria or formulas
2:19:46
https://youtu.be/-unggnmi1EY?t=8387

Foundry – Development of Applications by just defining the data required and some rules
2:21:10
https://youtu.be/-unggnmi1EY?t=8471

Instance Management – Creating multiple instances of Sharperlight on the same computer
2:24:37
https://youtu.be/-unggnmi1EY?t=8679

Materialised Queries -Create your own agile Warehouse
2:25:56
https://youtu.be/-unggnmi1EY?t=8757

Installing Sharperlight
2:27:11
https://youtu.be/-unggnmi1EY?t=8834

Datamodel Installer

2:32:58

https://youtu.be/-unggnmi1EY?t=9160