Integrity Training – Microsoft Office 2016 Excel Intermediate

•  
  Start

  Analyzing Data (0:43)

•  
  Start

  Topic A: Create and Modify Tables (0:41)

•  
  Start

  Tables (0:52)

•  
  Start

  Table Components (1:18)

•  
  Start

  The Create Table Dialog Box (0:32)

•  
  Start

  The Table Tools Design Contextual Tab (0:52)

•  
  Start

  Table Styles and Quick Styles (0:23)

•  
  Start

  The New Table Style Dialog Box (0:45)

•  
  Start

  Quick Analysis (1:08)

•  
  Start

  Demo – Creating and Modifying Tables (5:00)

•  
  Start

  Demo – Using Summary Functions in Tables (3:27)

•  
  Start

  Topic B: Apply Intermediate Conditional Formatting (0:22)

•  
  Start

  The New Formatting Rule Dialog Box (1:42)

•  
  Start

  The Conditional Formatting Rules Manager Dialog Box (0:36)

•  
  Start

  Rule Precedence (0:24)

•  
  Start

  Demo – Applying Intermediate Conditional Formatting (3:44)

•  
  Start

  Topic C: Apply Advanced Conditional Formatting (0:20)

•  
  Start

  The Use a Formula to Determine Which Cells to Format Rule (1:08)

•  
  Start

  Demo – Using Logical Functions to Apply Conditional Formatting (3:19)

•  
  Start

  Chapter 03 Review (0:53)

•  
  Start

  Chapter 03 Quiz

•  
  Start

  Visualizing Data with Charts (1:07)

•  
  Start

  Topic A: Create Charts (0:32)

•  
  Start

  Charts (1:02)

•  
  Start

  Chart Basics (1:45)

•  
  Start

  Chart Types (2:08)

•  
  Start

  Recommended Charts (0:40)

•  
  Start

  The Insert Chart Dialog Box (0:39)

•  
  Start

  Demo – Creating Charts (5:21)

•  
  Start

  Topic B: Modify and Format Charts (0:41)

•  
  Start

  Chart Modifications (0:49)

•  
  Start

  Chart Formatting (0:32)

•  
  Start

  Chart Elements (1:38)

•  
  Start

  The Design Tab (1:09)

•  
  Start

  The Format Tab (0:38)

•  
  Start

  The Format Task Pane (1:08)

•  
  Start

  The Chart Tools Buttons (0:49)

•  
  Start

  The Select Data Source Dialog Box (0:33)

•  
  Start

  Demo – Modifying and Formatting Charts (4:14)

•  
  Start

  Topic C: Use Advanced Chart Features (1:04)

•  
  Start

  Dual-Axis Charts (1:08)

•  
  Start

  Trendlines (1:24)

•  
  Start

  The Format Trendline Task Pane (0:43)

•  
  Start

  Demo – Creating a Dual-Axis Chart (4:08)

•  
  Start

  Chart Templates (0:57)

•  
  Start

  Demo – Creating a Chart Template (1:52)

•  
  Start

  Chapter 04 Review (1:10)

•  
  Start

  Chapter 04 Quiz

•  
  Start

  Using PivotTables and PivotCharts (1:28)

•  
  Start

  Topic A: Create a PivotTable (0:28)

•  
  Start

  Pivoting (2:18)

•  
  Start

  PivotTables (1:32)

•  
  Start

  Transactional Data (1:10)

•  
  Start

  The Create PivotTable Dialog Box (0:33)

•  
  Start

  The PivotTable Fields Task Pane (1:27)

•  
  Start

  Demo – Creating a PivotTable (4:29)

•  
  Start

  Topic B: Analyze PivotTable Data (0:04)

•  
  Start

  The Analyze Tab (3:13)

•  
  Start

  The Design Tab (0:25)

•  
  Start

  The Value Field Settings Dialog Box (0:48)

•  
  Start

  SUM Function Only (0:41)

•  
  Start

  Percentage of Total (0:28)

•  
  Start

  Difference From Option (0:40)

•  
  Start

  The GETPIVOTDATA Function (1:29)

•  
  Start

  Demo – Analyzing PivotTable Data (4:07)

•  
  Start

  Topic C: Present Data with PivotCharts (0:05)

•  
  Start

  PivotCharts (0:44)

•  
  Start

  The PivotChart Fields Task Pane (0:31)

•  
  Start

  PivotChart Filters (0:36)

•  
  Start

  Demo – Presenting Data with PivotCharts (5:38)

•  
  Start

  Topic D: Filter Data by Using Timelines and Slicers (0:05)

•  
  Start

  Slicers (2:04)

•  
  Start

  The Insert Slicers Dialog Box (0:21)

•  
  Start

  The Slicer Tools Contextual Tab (0:56)

•  
  Start

  The Report Connections Dialog Box (0:51)

•  
  Start

  Timelines (0:34)

•  
  Start

  The Insert Timelines Dialog Box (0:18)

•  
  Start

  The Timeline Tools Contextual Tab (0:35)

•  
  Start

  Demo – Filtering Data by Using Slicers and Timelines (3:26)

•  
  Start

  Chapter 05 Review (0:40)

•  
  Start

  Chapter 05 Quiz

•  
  Start

  Course Closure (1:28)

Forex Trading – Foreign Exchange Course

Want to learn about Forex?

Foreign exchange, or forex, is the conversion of one country’s currency into another.
In a free economy, a country’s currency is valued according to the laws of supply and demand.
In other words, a currency’s value can be pegged to another country’s currency, such as the U.S. dollar, or even to a basket of currencies.
A country’s currency value may also be set by the country’s government.
However, most countries float their currencies freely against those of other countries, which keeps them in constant fluctuation.