(+64) 9 425 40 99| Contact Us| FAQ's | Dealer Login

Cart (0)
Shopping cart (0)
Total 0

Course detail

Home Course Office 2019 Excel P2

1590971137-excel-2019.jpg

Share with your friend

Office 2019 Excel P2

0 rate

0 purchased SKU: SKU_NWQJN74311


Available ONLY TO SMART TRAINER USERS

To Purchase this Product you must be a customer BUY A SMART TRAINER

10 USD Become a customer

Course Outline

  Chapter 01 - Working with Functions
  Topic A: Work with Ranges
  Cell and Range Names
  Names and the Name Box
  The Create from Selection Command
  The Name Manager Dialog Box
  Demo - Naming and Editing Ranges
  Cell and Range Names in Formulas
  The Use in Formula Command Method
  The Formula AutoComplete Method
  Demo - Using Defined Names in a Formula
  Topic B: Use Specialized Functions
  The Excel Function Reference
  Function Syntax
  Demo - Locating and Using Specialized Functions
  Topic C: Work with Logical Functions
  Comparison Operators
  The IF Function
  The AND Function
  The OR Function
  The NOT Function
  Demo - Working with Logical Functions
  Nesting
  Nested Function Syntax
  Demo - Combining Functions
  The TODAY Function
  The NOW Function
  The DATE Function
  The NETWORKDAYS Function
  The WEEKDAY Function
  The WORKDAY Function
  The ISOWEEKNUM Function
  Topic E: Work with Text Functions
  The LEFT Function
  The RIGHT Function
  Convert Text to Columns Wizard
  The MID Function
  Text Concatenation with the Ampersand
  The UPPER Function
  The LOWER Function
  The PROPER Function
  Demo - Working with Text Functions
  The New Name Dialog Box
  Criteria Argument Syntax
  Logical Values
  Guidelines for Combining Functions
  Topic D: Work with Date and Time Functions
  Demo - Working with Date and Time Functions
  The FIND Function
  The CONCAT Function
  Chapter 02 - Working with Lists
  Sorting
  Filtering
  Outlines
  The Sort Dialog Box
  Topic A: Sort Data
  Multiple Column/Row Sorting
  Quick Sorts
  The Sort Options Dialog Box
  Demo - Sorting Data
  Topic B: Filter Data
  AutoFilters
  The Custom AutoFilter Dialog Box
  Advanced Filtering
  The Criteria Range
  Demo - Filtering Data
  Topic C: Query Data with Database Functions
  Database Functions
  Database Function Syntax
  Demo - Using Database Functions
  Topic D: Outline and Subtotal Data
  The SUBTOTAL Function
  The Subtotals Feature
  The Subtotal Dialog Box
  Demo - Using Subtotals to Summarize Data
  Chapter 03 - Analyzing Data
  Tables
  Topic A: Create and Modify Tables
  Table Components
  The Create Table Dialog Box
  The Table Tools Design Contextual Tab
  Table Styles and Quick Styles
  The New Table Style Dialog Box
  Quick Analysis
  Demo - Creating and Modifying Tables
  Demo - Using Summary Functions in Tables
  Topic B: Apply Intermediate Conditional Formatting
  The New Formatting Rule Dialog Box
  The Conditional Formatting Rules Manager Dialog Box
  Rule Precedence
  Demo - Applying Intermediate Conditional Formatting
  Topic C: Apply Advanced Conditional Formatting
  The Use a Formula to Determine Which Cells to Format Rule
  Demo - Using Logical Functions to Apply Conditional Formatting
  Cell References and Conditional Formatting
  Guidelines for Applying Conditional Formatting to Cells Based on Values in Other Cells
  Chapter 04 - Visualizing Data with Charts
  Chart Types
  The Format Tab
  Charts
  Topic A: Create Charts
  Chart Basics
  Recommended Charts
  Demo - Creating Charts
  Topic B: Modify and Format Charts
  Chart Modifications
  Chart Formatting
  Chart Elements
  The Format Task Pane
  The Chart Tools Buttons
  The Select Data Source Dialog Box
  Demo - Modifying and Formatting Charts
  Topic C: Use Advanced Chart Features
  Dual-Axis Charts
  Trendlines
  The Format Trendline Task Pane
  Chart Templates
  Demo - Creating a Chart Template
  Chart Insertion Methods
  Guidelines for Modifying Chart Elements
  Forecasting
  Demo - Creating a Dual-Axis Chart with a Trendline
  Chapter 05 - Using PivotTables and PivotCharts
  The Design Tab
  Topic A: Create a PivotTable
  Pivoting
  PivotTables
  Transactional Data
  The Create PivotTable Dialog Box
  The PivotTable Fields Task Pane
  Demo - Creating a PivotTable
  Topic B: Analyze PivotTable Data
  The Analyze Tab
  The Value Field Settings Dialog Box
  SUM Function Only
  Percentage of Total
  Difference From Option
  The GETPIVOTDATA Function
  Demo - Analyzing PivotTable Data
  Topic C: Present Data with PivotCharts
  PivotCharts
  The PivotChart Fields Task Pane
  PivotChart Filters
  Demo - Presenting Data with PivotCharts
  Topic D: Filter Data by Using Timelines and Slicers
  Slicers
  The Insert Slicers Dialog Box
  The Slicer Tools Contextual Tab
  The Report Connections Dialog Box
  Timelines
  The Insert Timelines Dialog Box
  The Timeline Tools Contextual Tab
  Demo - Filtering Data by Using Slicers and Timelines
  Start with Questions, End with Structure
  Chapter 06 - Working with Graphical Objects
  WordArt
  SmartArt Graphics
  The Choose a SmartArt Graphic Dialog Box
  The Text Pane
  The SmartArt Tools Contextual Tab
  Text Boxes
  Shapes
  Topic A: Insert Graphical Objects
  Graphical Objects
  The Insert Picture Dialog Box
  The Insert Online Pictures Window
  Icons
  3D Models
  Screenshots
  Topic B: Modify Graphical Objects
  The Picture Tools Contextual Tab
  The Image Editor
  The Drawing Tools Contextual Tab
  The Graphics Tools Contextual Tab
  The 3D Model Tools Contextual Tab
  The Selection Task Pane
  The Format Task Panes
  Object Properties
  Topic C: Work with SmartArt
  SmartArt Shapes
  Chapter 07 - Using Array Formulas
  Topic A: Use Array Formulas
  Arrays
  Array Formulas
  Single-Cell Array Formula
  Array Constants
  Array Formula Syntax
  Array Formula with Data Ranges
  Array Formula Rules
  Demo - Using Array Formulas

Additional Information

author

Author

Administrator

Lessons

level

Level

Beginner

Related Courses

1590971093-excel-2019.jpg
Office 2019 Excel P1
0 rate

0 purchased

10

1590971161-excel-2019.jpg
Office 2019 Excel P3
0 rate

0 purchased

10

1590971257-office-2019-new-feature.jpg
Office 2019 New Features
0 rate

0 purchased

10

1590971402-word-2019.jpg
Office 2019 Word P1
0 rate

0 purchased

10