EXCEL Online Training

 >>  EXCEL Online Training

EXCEL Online Training


 (5) | 1800 Ratings


Introduction


EXCEL Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 25 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Module 1 : Introduction to Excel

Topics : Spreadsheet Basics, Exploring Excel Features, Graphically Representing Data, Reporting and Charts, Analyzing Data, Formatting Worksheets, Using the Ribbon, Moving Around the Worksheet, Creating, Editing, Saving and Printing Spreadsheets, Working with Functions & Formulae

Module 2 : Streamlining Workflow

Topics : Create a Macro, Edit A Macro, Update Workbook Properties, Apply Conditional Formatting, Add Data Validation Criteria

Module 3 : Formula Knowledge

Topics : Basic Statistics, Formula Anatomy, Cell Referencing, Math Functions, Logic Functions, Understanding Time, Function Anatomy, Text Functions, External Links, Lookup Methods, Temporal Functions

Module 4 : Collaborating with Other Users

Topics : Set Revision Tracking, Review Tracked Revisions, Administer Digital Signatures, Protect Files, Merge Workbooks, Restrict Document Access, Share a Workbook

Module 5 : Optimizing Data

Topics : Sorting, Filtering, Contigious Data, Excel Tables, Recording Macros, Naming Ranges

Module 6 : Analyzing Data

Topics : Creating PivotTables, Perform a What-if-Analysis, Create Sparklines, Formatting PivotTables, Use Analysis ToolPak for analyzing Statistical Analysis, Create a Trendline, Create Scenarios

Module 7 : Working with Multiple Workbooks

Topics : Edit Links, Consolidate Data, Link Cells in Different Workbooks, Create a Workspace

Module 8 : Presenting and Reporting

Topics : Cell Formatting, Custom Number Formats, Conditional Formats with Custom Rules, Outlining, Conditional Formats with Built-In Rules, Building Line Charts, Building Bar Charts, Building Combination Line and Area Charts, Building Pie Charts

Module 9 : Integrating Excel Data with the Web

Topics : Import Data from the Web, Create a Web Query, Publish a Worksheet to the Web

Module 10 : Special Operations

Topics : Validating and Updating, Preparing to Deploy, Structuring XML Workbooks, Graphical operations, Link worksheets, Import and link from other Applications, Use AutoFormat, Print features, Use multiple windows, Consolidate worksheets

 

Exam & Certification

0

Course Review

(5)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Module 1 : Introduction to Excel

Topics : Spreadsheet Basics, Exploring Excel Features, Graphically Representing Data, Reporting and Charts, Analyzing Data, Formatting Worksheets, Using the Ribbon, Moving Around the Worksheet, Creating, Editing, Saving and Printing Spreadsheets, Working with Functions & Formulae

Module 2 : Streamlining Workflow

Topics : Create a Macro, Edit A Macro, Update Workbook Properties, Apply Conditional Formatting, Add Data Validation Criteria

Module 3 : Formula Knowledge

Topics : Basic Statistics, Formula Anatomy, Cell Referencing, Math Functions, Logic Functions, Understanding Time, Function Anatomy, Text Functions, External Links, Lookup Methods, Temporal Functions

Module 4 : Collaborating with Other Users

Topics : Set Revision Tracking, Review Tracked Revisions, Administer Digital Signatures, Protect Files, Merge Workbooks, Restrict Document Access, Share a Workbook

Module 5 : Optimizing Data

Topics : Sorting, Filtering, Contigious Data, Excel Tables, Recording Macros, Naming Ranges

Module 6 : Analyzing Data

Topics : Creating PivotTables, Perform a What-if-Analysis, Create Sparklines, Formatting PivotTables, Use Analysis ToolPak for analyzing Statistical Analysis, Create a Trendline, Create Scenarios

Module 7 : Working with Multiple Workbooks

Topics : Edit Links, Consolidate Data, Link Cells in Different Workbooks, Create a Workspace

Module 8 : Presenting and Reporting

Topics : Cell Formatting, Custom Number Formats, Conditional Formats with Custom Rules, Outlining, Conditional Formats with Built-In Rules, Building Line Charts, Building Bar Charts, Building Combination Line and Area Charts, Building Pie Charts

Module 9 : Integrating Excel Data with the Web

Topics : Import Data from the Web, Create a Web Query, Publish a Worksheet to the Web

Module 10 : Special Operations

Topics : Validating and Updating, Preparing to Deploy, Structuring XML Workbooks, Graphical operations, Link worksheets, Import and link from other Applications, Use AutoFormat, Print features, Use multiple windows, Consolidate worksheets

 

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry