Advanced Microsoft Excel 2010,2013 and 2016 Training for Professionals: Bankers, Accountants, Statisticians in Abuja, Lagos, Portharcourt

SOUTECH Web Consults – (a smart and budding Information Technology (IT) firm with innovative, intelligent, knowledgeable and experienced consultants, trainers and developers.

To be efficient in IT service delivery and management you need core practical training from SOUTECH Web Consults to help you in:

• Critical thinking and problem solving skills
• Communication skills
• Collaboration skills
• Creativity and innovation skills

We look forward to training you in the following courses( This is the best ever Excel Training Course in Nigeria).

Advanced Microsoft Excel 2016 Course

In this advanced training course for Microsoft Excel 2013, this course takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.

You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. We proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Aalso covers some basic Macro operations within Excel for optimizing your workflow.

By the completion of this Microsoft Excel 2013 training program, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.

• A Practical Excel Training Course That Teaches Real World Skills
• Concise, informative Advanced Microsoft Excel 2013 training modules.
• A quick grasp of even the most complex Advanced Microsoft Excel 2013 subjects because they’re broken into simple, easy to follow guides

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Advanced Microsoft Excel 2013 training, guide,  tutorial, online or offline… so you’ll know the exact steps for your own projects.

Course Highlights

1. Getting Started
2. Area And Volume Calculations
3. Using A Near Match In The Lookup
4. Creating A Sparkline
5. Loan And Investment Calculations
6. Add Quick Access To Custom Views
7. CONCATENATE: Building Strings From Multiple Cells
8. Arrays And Creating A New Array Formula
9. What Are Tracer Arrows
10. What Is A PivotTable?
11. Creating A PivotChart
12. Use Of Worksheet Buttons To Trigger Macros

Details

1. Getting Started

• Will I Be Able To Keep Up?
• Using The Included Files
• New For 2013: Its All In The Cloud
• The Very Clever Flash Fill
• Using Mathematical Functions
• The Basic 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

2. Area And Volume Calculations

• IF Functionality
• 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
• Performing Data Lookups
• VLOOKUP: Syntax And Usage
• VLOOKUP In Live Action
• HLOOKUP: Variation On A Theme

3. Using A Near Match In The Lookup

• Dealing With Missing Data In A Lookup
• Managing The Lookup Table
• Lookups Nested Within Lookups

4. Sparklines

• Creating A Sparkline
• Altering The Design Of Sparklines
• Dealing With Empty Cells
• Comparing Sparklines Within A Sparkline Group
• Removing Sparklines From A Worksheet
• Further Mathematical Functions
• 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

5. Loan And Investment Calculations

• Loan Calculation Elements And Functions
• Outlining
• Create An Outline Automatically
• Adding An Outline Manually
• Editing And Removing Outlining
• 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

6. Custom Views

• Custom Views Explained
• Use Of Outlining To Help Setup Custom Views
• Editing And Deleting Custom Views
• Add Quick Access To Custom Views
• Functions For Manipulating Text
• LEFT And RIGHT: Text Manipulation
• LEN And TRIM: String Extractions
• FIND And MID: Text Functions Working Together

7. 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

8. Arrays

• Arrays And Creating A New Array Formula
• Array Formulas With IF Statements
• Conditional Evaluation With No IFs
• The Array-Only TRANSPOSE Function
• Useful Data Functions
• 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
• Some Other Useful Functions
• 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
• Auditing And Troubleshooting Formulas

9. 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

10. PivotTables for banking, accounting and statistics experts

• 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

11. PivotCharts

• 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
• Goal Seek And Solver
• What-If Analysis Using Goal Seek
• Activating The Solver Add-In
• Using Solver To Complete A What-If
• Adding Constraints To Solver

12. 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

Summary

Venue: 

SOUTECH VENTURES

Abuja 1.
SOUTECH Web Consults.
67 Block 1A, Guest House, Kano Street After Shehu Shagari Mosque,900241
Area 1, Abuja
Contact: +234( 0803 412 1380)
Web: www.soutechventures.com
Email: [email protected]

Click Here for Google Map Navigation

Learning Conditions

• Real-life application and understanding
• Conducive learning environment
• Participants get a Certificate of Training
• Restricted and interactive classes
• Service comes with all necessary softwares
• Soft copy training(Videos and eBooks) materials will be available
• Qualified and experienced facilitators
• Get a full Audio recording of the training (No need for refresher class)
• Customized soft copy of training materials will be provided
• Organized and efficient training process
• Tea/Cofee Breaks and Snacks to be provided
• Conducive air conditioned learning environment and Parking Space

SOME OF OUR SATISFIED CLIENTS

Cost: N40,000( Fourty Thousand Naira only or $120)

Duration: 4 Contacts of 3 Hours Each( Weekdays or WeekEnds Options Available)

Registration Procedures