Advance Excel 2013 Workshop

MANAGING PROJECT WITH MS EXCEL 2013

 

Now in Nigeria, you can save yourself a lot of stress and drudgery at the work place by being a Guru in Excel. This 1-day practical hands-on workshop will accelerate your career tremendously and make you indispensable to your employer. By being remarkable, you will standout, command more attention and be sought after by headhunters in your chosen domain, which will spiral to the well being of your family.

 

 

 

 

 

Scope of Workshop

1. A Peek @ Excel 2013

1. New for Excel 2013 – All in the Cloud
2. Data-Driven Presentation in Excel 2013
3. Excel 2013 Power Short Cuts
4. Flash Fill – new in Excel 2013

 

2.  Statistics and Math Function

1. SUM, COUNT, MIN, And MAX
2. AVERAGE, MODE, MEAN, And MEDIAN
3. SUMIF For Selective Adding Up
4. COUNTIF For Selective Counting
5. AVERAGEIF For The Mean Of Selected Cells
6. Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
7. Area And Volume Calculations

 

3.  IF and Related Function

1. IF Syntax And Uses
2. Nesting The IF Statement
3. Use Of The AND Operator Within An IF
4. Use Of The OR Operator Within An IF
5. The NOT Operator Within AND And OR Statements
6. Display Cell Formulas In Another Cell

 

4. Lookup

1. VLOOKUP Syntax And Usage
2. VLOOKUP In Live Action
3. HLOOKUP Variation On A Theme
4. Using A Near Match In The Lookup
5. Dealing With Missing Data In A Lookup
6. Managing The Lookup Table
7. Lookups Nested Within Lookups

 

5. Sparkline

1. Creating A Sparkline
2. Altering The Design Of Sparklines
3. Dealing With Empty Cells
4. Comparing Sparklines Within A Sparkline Group
5. Removing Sparklines From A Worksheet

 

6. Time Function and Investment

1. Working With Time In Excel
2. Calculations Using Time
3. Useful Time And Date Functions
4.  Rounding Decimal Places
5.  MOD And INT Functions And Uses
6.  Generate And Use A Random Number
7. Loan And Investment Calculations
8. Loan Calculation Elements And Functions

 

7.  Outlines

1. Create An Outline Automatically
2. Adding An Outline Manually
3. Editing And Removing Outlining

 

8.  Scenarios

1. Setting Up A Set Of Scenarios
2. Displaying And Editing The Different Scenarios
3. How To Work Out Which Scenario You Are Displaying
4. Merging And Deleting Scenarios
5. Producing A Summary Of Scenarios

 

9. Custom Views

1. Custom Views Explained
2. Use Of Outlining To Help Setup Custom Views
3. Editing And Deleting Custom Views
4. Add Quick Access To Custom Views

 

10. Strings and Concatenation

1. LEFT And RIGHT Text Manipulation
2. LEN And TRIM String Extractions
3. FIND And MID Text Functions Working Together
4. CONCATENATE Building Strings From Multiple Cells
5. Changing Case Functions
6. REPLACE And SUBSTITUTE Two More String Manipulation Functions
7. Use Of CHAR Function For More Obscure Characters
8. Formatting Numeric And Date Values Using TEXT
9. Keeping The Values Created By String Manipulation

 

11.  Array Formula

1. Arrays And Creating A New Array Formula
2. Array Formulas With IF Statements
3. Conditional Evaluation With No Ifs
4. The Array-Only TRANSPOSE Function

 

12. MATCH and INDEX Function

1. Using The MATCH Function
2. How The INDEX Function Works
3. Handling Out Of Range Index Requests
4. The CHOOSE Lookup Function
5. MATCH And INDEX Functions Working Together

 

13. IS, OFFSET, INDIRECT and CELL Function

1. Introducing IS Functions
2. Error Checking Using ISERR, ISERROR, And IFERROR
3. OFFSET Function Syntax
4. OFFSET Function Creating A Dynamic Named Range
5. INDIRECT Function To Build Dynamic Formulas
6. Dealing With INDIRECT Errors
7. The CELL Function And Determining File Or Sheet Names

 

14.  Trace Arrows and Tracing

1. What Are Tracer Arrows
2. Adding And Removing Tracer Arrows
3. Auditing Tools Error Checking And Tracing
4. Step-By-Step Formula Processing
5. Using The Watch Window In Troubleshooting

 

15. Pivot Table

1. What Is A PivotTable
2. The New Recommended PivotTable Route
3. Creating Your Own PivotTables
4. Changing The Formatting And Formulas In PivotTable Summaries
5. Creating Multiple PivotTables On The Same Dataset
6. Moving And Deleting PivotTables
7. Making Use Of The Report Filter Options
8. Sorting The PivotTable Columns
9. Refreshing A PivotTable
10. Drilling Down Behind The Pivot Numbers
11. Multiple Fields In Row, Column, Or Data Sections
12. Controlling Grand Totals And Subtotals
13. Dealing With Empty Cells And Other Additional Options
14. PivotTable Styles
15. Creating Your Own PivotTable Styles
16. Creating And Using Calculated Fields
17. Using The New Timeline Filter Option
18. Adding And Using The Data Slicer
19. Using Data From An SQL Server In A PivotTable
20. Managing The External Connection To SQL Server

 

16. Pivot Chart

1. Creating A PivotChart
2. Changing The Fields Used In A PivotChart
3. Formatting The PivotChart
4. Changing The PivotChart Type
5. Filtering A PivotChart
6. Hiding The PivotChart Buttons
7. Moving And Deleting PivotCharts

 

17. What-If

1. What-If Analysis Using Goal Seek
2. Activating an Add-In
3. Using the Add-In To Complete A What-If
4. Adding Constraints To the Add-In

 

18. Macros

1. What Is A Macro
2. Creating And Running Your First Macro
3. Saving Workbooks With Macros
4. Macro Security Settings For Workbooks With Macros
5. The Personal Macro Workbook
6. Deleting Macros
7. Use Of Relative Or Absolute Referencing
8. Trigger A Macro With A Keyboard Shortcut
9. Formatting With A Macro
10. Switch Scenarios And Views With Macros
11. Use Of Worksheet Buttons To Trigger Macros
12. Customizing Form Buttons And Other Shape Triggers
13. Assigning Macros To Ribbon Icons
14. Create Your Own Ribbon.
15. View And Edit Macro Code
16. Add An Are You Sure Box To Macros

 

 

_____________________________________________________________________________________ 

 

Cost and Schedule

TRAINING FEE: N25, 000

 

Month	Date	Venue	Time
DECEMBER 2013	21st	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
JANUARY 2014	18th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
FEBRUARY 2014	15th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
MARCH 2014	15th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
APRIL 2014	19th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
MAY 2014	17th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
JUNE 2014	21st	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
JULY 2014	19th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
AUGUST 2014	16th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
SEPTEMBER 2014	20th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
OCTOBER 2014	18th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
NOVEMBER 2014	15th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm
DECEMBER 2014	20th	POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.	8am – 6pm

 

ONLY 4 SEATS AVAILABLE –  TO BOOK FOR A SEAT, YOU HAVE TO PAY A MINIMUM OF N10, 000 OUT OF THE N25, 000 FEE TO BOOK SEAT. ALL PAYMENT MUST BE MADE BEFORE THE CLASS STARTS. PLS, SEE PAYMENT INFO BELOW:

________________________________________________________________________________________

PAYMENT INFORMATION: Monies can be paid to:

Access Bank

Poet Solvers Limited

0006551542

OR

UBA

Poet Solvers Ventures

1005870878

Those that paid to the bank should please, send their teller number to this email address (support [at] pmtutor [dot] org).

N/B: For security reasons, we may not collect payments in our office or at the date of training. All payments must be settled via the means above. 

_________________________________________________________________________________________

You can Install 60-days trial Office 2013 by using Technet Link HERE

_________________________________________________________________________________________

More on PMtutor Menu

1. Faculties, Testimonies and Pictures of Events. Click PMtutor HERE
2. PMP & CAPM Certification Training, Click PMP and CAPM HERE
3. PRINCE2 Certification Training, Click PRINCE2 HERE
4. SAP Project Systems Training, Click SAP HERE
5. Lean Six Sigma Certification & Minitab Training, Click Six Sigma HERE
6. Business Analyst & MS Visio Practical Training, Click Business Analyst HERE
7. Primavera P6 Practical Training, Click Primavera P6 HERE
8. Microsoft Project 2013 Practical Training, Click MSP 2013 HERE
9. Online Training for PMI courses, Click Online PMI HERE
10. Cloud Computing, Click Cloud HERE
11. Discounts and Scholarships, Click Discounts and Scholarships HERE