top of page

Excel AND Business Intelligence 

Faculty : Durgapasad V, Fee : 1500/-, Duration : 30 days daily 1 hour Class

COURCE CONTENT
Excel + BI

1. Get familiar with Excel
Up to speed with Excel 2007 
Get to know Excel 2007: Create your first workbook 
Get to know Excel 2007: Enter formulas 
Learn how to figure out dates using formulas in Excel 2007 

2. Create charts in Excel
Charts I: How to create a chart in Excel 2007 
3. Create PivotTable reports
PivotTable I: Get started with PivotTable reports in Excel 2007 
PivotTable II: Filter PivotTable report data in Excel 2007 
PivotTable III: Calculate data in PivotTable reports in Excel 2007 

4. Share data with other people
Share Excel data with others by exporting it to a SharePoint site 
Excel Services I: The basics 
Excel Services II: Requirements, recommendations, and permissions 
Excel Services III: Control what people see 
Excel Services IV: Allow user input 

5. Learn general Office skills
Keyboard shortcuts in the 2007 Office system 
Security I: How the 2007 Office system helps you to stay safer 
Security II: Turn off the Message Bar and run code safely 
Security III: Sign your own macros for stronger security 
Office Open XML I: Exploring the Office Open XML Formats 
Open XML II: Editing Documents in the XML

CONTACTS

DeviSTC, opposite Vigneswara temple, Bridge down, Ganapavaram Village, Ganapavaram mandal. West Godavari Dist, Andhara Pradesh. India. Pin 534198

 

Ph: 9866014509

Mail:devistc.gnp@gmail.com

  • w-facebook
  • Twitter Clean
  • w-googleplus
bottom of page