HIGHLIGHTS
• Advanced Microsoft Excel 2013 Course.
• Course holds for three (3) days [3 Hours daily].
• Dates: Monday 2nd – Wednesday 4th February, 2015.
• Venue: 32 MBONU Street [opposite OldSpice Restaurant], D-Line, Port Harcourt, Rivers State.
• Certificates will be presented upon course completion.
• Course manual will be provided upon Registration
• Conducive learning environment.
• Certified & Experienced Tutors.
• Course Fee: N10,000

DETAILS
These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you become better at your job.

Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Our Advanced Microsoft Excel 2013 course will teach you basic to advanced features of Excel. The course also offers real, practical benefits in the general use of spreadsheets; making your spreadsheets more accurate, reliable and interactive.

We have thoughtfully designed the course to equip you with knowledge and techniques that you will be able to use over and over again to not only make your own spreadsheets better, but also to enable you to help your colleagues and solve their Excel problems.

Expected Course Participants:
• Accountants
• Data Analysts
• Financial Experts
• Book Keepers

COURSE CONTENT:
Getting Started with Microsoft Office Excel 2013
• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data

Modifying a Worksheet
• Insert, Delete, Hide and Adjust Cells, Columns, Rows and Worksheets
• Search for and Replace Data

Performing Calculations
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas

Formatting a Worksheet
• Modify Fonts
• Add Borders and Colors to Worksheets
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Printing Workbooks
• Preview and Print a Workbook
• Define the Page Layout

Managing Workbooks
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Creating Advanced Formulas
• Use Range Names in Formulas
• Use Specialized Functions
• Use Array Formulas

Analyzing Data with Functions & Conditional Formatting
• Analyze Data by Using Text and Logical Functions
• Apply Advanced Conditional Formatting

Organizing and Analyzing Datasets and Tables
• Create and Modify Tables
• Sort Data
• Filter Data
• Use SUBTOTAL and Database Functions

Visualizing Data with Basic Charts
• Create Charts
• Modify and Format Charts

Analyzing Data with PivotTables, Slicers & Pivot Charts
• Create a PivotTable
• Analyze PivotTable Data
• Present Data with Pivot Charts
• Filter Data by Using Slicers

Working with Multiple Worksheets and Workbooks Simultaneously
• Use 3-D References
• Use Links and External References
• Consolidate Data

Sharing and Protecting Workbooks
• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Automating Workbook Functionality
• Apply Data Validation
• Work with Forms and Controls
• Work with Macros

Applying Conditional Logic
• Use Lookup Functions
• Combine Functions
• Use Formulas and Functions to Apply Conditional Formatting

Auditing Worksheets
• Trace Cells
• Search for Invalid Data and Formulas with Errors Watch & Evaluate Formulas

Using Automated Analysis Tools
• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Activate and Use the Solver Tool
• Analyze Data with Analysis ToolPak Tools

Presenting Your Data Visually
• Use Advanced Chart Features
• Create Sparklines

Enquiries:
08037971139;
08091018746

Registration has already Commenced.
For more enquiries, please call: 08037971139; 08091018746

Registration is now ongoing.
For enquiries please call: 08037971139; 08091018746

When are you coming to Lagos?

NET1:
HIGHLIGHTS
• Advanced Microsoft Excel 2013 Course.
• Course holds for three (3) days [3 Hours daily].
• Dates: Monday 2nd – Wednesday 4th February, 2015.
• Venue: 32 MBONU Street [opposite OldSpice Restaurant], D-Line, Port Harcourt, Rivers State.
• Certificates will be presented upon course completion.
• Course manual will be provided upon Registration
• Conducive learning environment.
• Certified & Experienced Tutors.
• Course Fee: N10,000

DETAILS
These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you become better at your job.

Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Our Advanced Microsoft Excel 2013 course will teach you basic to advanced features of Excel. The course also offers real, practical benefits in the general use of spreadsheets; making your spreadsheets more accurate, reliable and interactive.

We have thoughtfully designed the course to equip you with knowledge and techniques that you will be able to use over and over again to not only make your own spreadsheets better, but also to enable you to help your colleagues and solve their Excel problems.

Expected Course Participants:
• Accountants
• Data Analysts
• Financial Experts
• Book Keepers

COURSE CONTENT:
Getting Started with Microsoft Office Excel 2013
• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data

Modifying a Worksheet
• Insert, Delete, Hide and Adjust Cells, Columns, Rows and Worksheets
• Search for and Replace Data

Performing Calculations
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas

Formatting a Worksheet
• Modify Fonts
• Add Borders and Colors to Worksheets
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Printing Workbooks
• Preview and Print a Workbook
• Define the Page Layout

Managing Workbooks
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Creating Advanced Formulas
• Use Range Names in Formulas
• Use Specialized Functions
• Use Array Formulas

Analyzing Data with Functions & Conditional Formatting
• Analyze Data by Using Text and Logical Functions
• Apply Advanced Conditional Formatting

Organizing and Analyzing Datasets and Tables
• Create and Modify Tables
• Sort Data
• Filter Data
• Use SUBTOTAL and Database Functions

Visualizing Data with Basic Charts
• Create Charts
• Modify and Format Charts

Analyzing Data with PivotTables, Slicers & Pivot Charts
• Create a PivotTable
• Analyze PivotTable Data
• Present Data with Pivot Charts
• Filter Data by Using Slicers

Working with Multiple Worksheets and Workbooks Simultaneously
• Use 3-D References
• Use Links and External References
• Consolidate Data

Sharing and Protecting Workbooks
• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Automating Workbook Functionality
• Apply Data Validation
• Work with Forms and Controls
• Work with Macros

Applying Conditional Logic
• Use Lookup Functions
• Combine Functions
• Use Formulas and Functions to Apply Conditional Formatting

Auditing Worksheets
• Trace Cells
• Search for Invalid Data and Formulas with Errors Watch & Evaluate Formulas

Using Automated Analysis Tools
• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Activate and Use the Solver Tool
• Analyze Data with Analysis ToolPak Tools

Presenting Your Data Visually
• Use Advanced Chart Features
• Create Sparklines

Enquiries:
08037971139;
08091018746