Scope of Workshop
1. A Peek @ Excel 2013
- New for Excel 2013 – All in the Cloud
- Data-Driven Presentation in Excel 2013
- Excel 2013 Power Short Cuts
- Flash Fill – new in Excel 2013
2. Statistics and Math Function
- SUM, COUNT, MIN, And MAX
- AVERAGE, MODE, MEAN, And MEDIAN
- SUMIF For Selective Adding Up
- COUNTIF For Selective Counting
- AVERAGEIF For The Mean Of Selected Cells
- Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
- Area And Volume Calculations
3. IF and Related Function
- IF Syntax And Uses
- Nesting The IF Statement
- Use Of The AND Operator Within An IF
- Use Of The OR Operator Within An IF
- The NOT Operator Within AND And OR Statements
- Display Cell Formulas In Another Cell
4. Lookup
- VLOOKUP Syntax And Usage
- VLOOKUP In Live Action
- HLOOKUP Variation On A Theme
- Using A Near Match In The Lookup
- Dealing With Missing Data In A Lookup
- Managing The Lookup Table
- Lookups Nested Within Lookups
5. Sparkline
- Creating A Sparkline
- Altering The Design Of Sparklines
- Dealing With Empty Cells
- Comparing Sparklines Within A Sparkline Group
- Removing Sparklines From A Worksheet
6. Time Function and Investment
- Working With Time In Excel
- Calculations Using Time
- Useful Time And Date Functions
- Rounding Decimal Places
- MOD And INT Functions And Uses
- Generate And Use A Random Number
- Loan And Investment Calculations
- Loan Calculation Elements And Functions
7. Outlines
- Create An Outline Automatically
- Adding An Outline Manually
- Editing And Removing Outlining
8. Scenarios
- Setting Up A Set Of Scenarios
- Displaying And Editing The Different Scenarios
- How To Work Out Which Scenario You Are Displaying
- Merging And Deleting Scenarios
- Producing A Summary Of Scenarios
9. Custom Views
- Custom Views Explained
- Use Of Outlining To Help Setup Custom Views
- Editing And Deleting Custom Views
- Add Quick Access To Custom Views
10. Strings and Concatenation
- LEFT And RIGHT Text Manipulation
- LEN And TRIM String Extractions
- FIND And MID Text Functions Working Together
- CONCATENATE Building Strings From Multiple Cells
- Changing Case Functions
- REPLACE And SUBSTITUTE Two More String Manipulation Functions
- Use Of CHAR Function For More Obscure Characters
- Formatting Numeric And Date Values Using TEXT
- Keeping The Values Created By String Manipulation
11. Array Formula
- Arrays And Creating A New Array Formula
- Array Formulas With IF Statements
- Conditional Evaluation With No Ifs
- The Array-Only TRANSPOSE Function
12. MATCH and INDEX Function
- Using The MATCH Function
- How The INDEX Function Works
- Handling Out Of Range Index Requests
- The CHOOSE Lookup Function
- MATCH And INDEX Functions Working Together
13. IS, OFFSET, INDIRECT and CELL Function
- Introducing IS Functions
- Error Checking Using ISERR, ISERROR, And IFERROR
- OFFSET Function Syntax
- OFFSET Function Creating A Dynamic Named Range
- INDIRECT Function To Build Dynamic Formulas
- Dealing With INDIRECT Errors
- The CELL Function And Determining File Or Sheet Names
14. Trace Arrows and Tracing
- What Are Tracer Arrows
- Adding And Removing Tracer Arrows
- Auditing Tools Error Checking And Tracing
- Step-By-Step Formula Processing
- Using The Watch Window In Troubleshooting
15. Pivot Table
- What Is A PivotTable
- The New Recommended PivotTable Route
- Creating Your Own PivotTables
- Changing The Formatting And Formulas In PivotTable Summaries
- Creating Multiple PivotTables On The Same Dataset
- Moving And Deleting PivotTables
- Making Use Of The Report Filter Options
- Sorting The PivotTable Columns
- Refreshing A PivotTable
- Drilling Down Behind The Pivot Numbers
- Multiple Fields In Row, Column, Or Data Sections
- Controlling Grand Totals And Subtotals
- Dealing With Empty Cells And Other Additional Options
- PivotTable Styles
- Creating Your Own PivotTable Styles
- Creating And Using Calculated Fields
- Using The New Timeline Filter Option
- Adding And Using The Data Slicer
- Using Data From An SQL Server In A PivotTable
- Managing The External Connection To SQL Server
16. Pivot Chart
- Creating A PivotChart
- Changing The Fields Used In A PivotChart
- Formatting The PivotChart
- Changing The PivotChart Type
- Filtering A PivotChart
- Hiding The PivotChart Buttons
- Moving And Deleting PivotCharts
17. What-If
- What-If Analysis Using Goal Seek
- Activating an Add-In
- Using the Add-In To Complete A What-If
- Adding Constraints To the Add-In
18. Macros
- What Is A Macro
- Creating And Running Your First Macro
- Saving Workbooks With Macros
- Macro Security Settings For Workbooks With Macros
- The Personal Macro Workbook
- Deleting Macros
- Use Of Relative Or Absolute Referencing
- Trigger A Macro With A Keyboard Shortcut
- Formatting With A Macro
- Switch Scenarios And Views With Macros
- Use Of Worksheet Buttons To Trigger Macros
- Customizing Form Buttons And Other Shape Triggers
- Assigning Macros To Ribbon Icons
- Create Your Own Ribbon.
- View And Edit Macro Code
- Add An Are You Sure Box To Macros
Schedule
Date: 21st and 22nd of December 2013
Time: 9am to 6pm Daily
Venue: 125A Apapa Road behind Skye Bank, Costain Bus Stop, Lagos State
Budget
Workshop Fee: N50, 000
Discounted Fee: N25, 000 (for ONLY the first 3 payments)
Maximum Seats Available: 8 Delegates
Payment Point: Access Bank, 0006551542, POeT Solvers Ltd
N/B: A minimum of 10K out of the full amount may be used to secure a seat.
PREREQUISITE: A basic knowledge of Excel 2007 and laptop installed with Excel 2013 trial version.
You can Install 60-days trial Office 2013 by using Technet Link HERE