#1
| |||
| |||
![]()
I am looking for the detail of the Excel Advanced Course in Philadelphia so please provide me with it?
|
#2
| |||
| |||
![]()
Here I am providing you with the detail of the Excel Advanced Course in Philadelphia from the ONLC Training Centers ONLC Training Centers are known to be the largest in USA for IT training Courses: Working with Advanced Functions Working with Functions Using the IF Function Nesting Functions Using Multiple Conditions with the IF Function Using Table Lookup Functions (HLookup and VLookup) Using Text Functions Analyzing Data Using Automatic Outlining Consolidating Information by Position or Category Inserting Subtotals Creating an Advanced Filter Using Database Functions Working with Data Importing Data from a Text File Exporting Data Converting Text to Columns Using Flash Fill Connecting to Data in an Access Database Creating a Web Query Importing Web Data using a Saved Query Working with Hypertext Links Creating and Working with PivotTables Understanding PivotTables Working with Recommended PivotTables Creating a PivotTable using Worksheet Data Creating a PivotTable using an External Data Connections Laying out a PivotTable on a Worksheet Modifying PivotTable Fields Using a Report Filter Refreshing a PivotTable Formatting a PivotTable Enhancing PivotTables Working with Summary Functions Sorting Items in a PivotTable Creating a Slicer Grouping Data Using a Timeline Applying Label and Value Filters Creating a Calculated Field Creating a Calculated Item Creating Charts from PivotTables Working with Macros Recording a Macro Saving a Macro-Enabled Workbook Executing a Macro Creating a Macro Button Working with Macro Buttons Working with Data Analysis Tools Creating Scenarios Working with Scenarios Using Goal Seek Using One-Input Data Tables Using Two-Input Data Tables Understanding Solver Defining a Problem Solving a Problem Generating a Report of Results and Alternate Solutions Contact detail:- ONLC Training Centers 1801 Market Street Suite 760, 7th Floor Philadelphia, Pennsylvania 19103 Map:- |