SAS /
SAS Excel

SAS Excel

SAS Excel Online Training:

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Any Functional/technical background consultants are eligible to learn SAS Excel Online Training.

  • 1

    History of Excel , diff. versions

    00:00
  • 2

    Excel Features , Application Window

    00:00
  • 3

    Understanding Workbook Structure

    00:00
  • 4

    Managing diff. workbooks and worksheets

    00:00
  • 5

    Entering Data in Excel, Copying & Moving Data between cells and worksheets

    00:00
  • 1

    Formatting data with Shortcut keys and Format menu

    00:00
  • 3

    Page layouts, Printing in Excel

    00:00
  • 4

    Workbook Views and Custom views

    00:00
  • 1

    Diff. between Formulas and Functions

    00:00
  • 2

    Creating Formulas in Excel , BEDMAS rule

    00:00
  • 3

    Using Excel Built-in Functions (Sum, Count, Min, Max, Average, Product)

    00:00
  • 4

    References – Absolute , Relative and Mixed

    00:00
  • 5

    Using Auto sum & Formula Tab

    00:00
  • 6

    Working with Formula Auditing Group ( Circular References, Evaluation Formula, Tracing Precedents & Dependents , Controlling Calculation Options)

    00:00
  • 1

    Creating & Applying Styles

    00:00
  • 3

    Applying & Editing Conditional Format Rules

    00:00
  • 4

    Working with Filters, Advance filters, Sorting in Excel

    00:00
  • 2

    Working with Charts Design , Layout and Format

    00:00
  • 3

    Saving & Using a Chart Template

    00:00
  • 4

    Trend lines in Charts, Secondary Axes Chart

    00:00
  • 5

    Creating Pareto Chart , Pie Chart, Combo Chart

    00:00
  • 1

    Text Functions– Upper, Lower, Proper, Len, Trim, Char, Code, Clean, Concatenate, Left, Right, Mid, Find and Substitute

    00:00
  • 2

    Date & Time Functions – Today, Now, Day, Month, Year, Date, Weekday, Weeknum, Datedif, Networkdays, Workday, Networkdays.intl, Workday.intl , Datevalue

    00:00
  • 3

    Logical Functions – IF, And, Or, Not, Iferror, Iserror, Istext, Isnumber, Isblank

    00:00
  • 4

    Lookup Functions – Vlookup, Hlookup, Index, Match, Offset, Indirect, Address

    00:00
  • 5

    Mathematical & Statistical Functions- Sumif, Sumifs, Counta, Countblank, Countif, Countifs, Averagea, Averageif, Averageifs, Round, Roundup, Roundown, Large, Small, Mod, Sumproduct, Subtotal, Fact

    00:00
  • 6

    Other Functions – Choose, Transpose

    00:00
  • 2

    Creating Names from Selections

    00:00
  • 4

    Using Names in diff. Formulas

    00:00
  • 5

    Managing & Displaying Names

    00:00
  • 1

    Introduction to Data Validation, Rules in Data Validation

    00:00
  • 2

    Creating ListBox, Multiple List Boxes

    00:00
  • 3

    Working with Multiple Pivot Tables with Slicer , Getpivotdata Function

    00:00
  • 3

    Workbook and Worksheet Security

    00:00
  • 1

    Goalseek, Scenario Manager, Data Table

    00:00
  • 1

    New Features in Excel 2013

    00:00
  • 2

    Excel 2013 User Interface

    00:00
NA