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