Microsoft Office Excel : Level II & III Course

Microsoft Office Excel : Level II & III Course - Nigeria
Microsoft Office Excel : Level II & III Course - Nigeria
Microsoft Office Excel : Level II & III Course - Nigeria
  • Microsoft Office Excel : Level II & III Course - Nigeria
  • Microsoft Office Excel : Level II & III Course - Nigeria
  • Microsoft Office Excel : Level II & III Course - Nigeria
Description :

• Microsoft Office Excel : Level II & III (Intermediate & Advance) -4 days• Program Type: I
• (I=Individual, C=Corporate)
• Training Method: Workshop/Demonstration (Highly Intensive Practical)
• Cost: N25,000,00 (Promo Offer)
• Duration: 4 days
• Time: 9.00am – 4.00pm
• June 17 – 20, 2019
• Venue:
• Lagos: SGL Training Center. 10, Akinremi Street, Anifowoshe, off Awolowo Way, Ikeja, Lagos.
• Course Objectives
• In this course, you will apply visual elements and advanced formulas to a worksheet to display data in various formats.

• You will:
• ● calculate with advanced formulas.
• ● organize worksheet and table data using various techniques.
• ● create and modify charts.
• ● analyze data using PivotTables and PivotCharts.
• ● insert graphic objects.
• ● customize and enhance workbooks and the Microsoft® Office Excel® environment.
• Course Content
• Lesson 1: Calculating Data with Advanced Formulas
• Topic 1A: Apply Cell and Range Names
• Topic 1B: Calculate Data Across Worksheets
• Topic 1C: Use Specialized Functions
• Topic 1D: Analyze Data with Logical and Lookup Functions
• Lesson 2: Organizing Worksheet and Table Data
• Topic 2A: Create and Modify Tables
• Topic 2B: Format Tables
• Topic 2C: Sort or Filter Data
• Topic 2D: Use Functions to Calculate Data
• Lesson 3: Presenting Data Using Charts
• Topic 3A: Create a Chart
• Topic 3B: Modify Charts
• Topic 3C: Format Charts
• Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
• Topic 4A: Create a PivotTable Report
• Topic 4B: Filter Data Using Slicers
• Topic 4C: Analyze Data Using PivotCharts
• Lesson 5: Inserting Graphic Objects
• Topic 5A: Insert and Modify Pictures and ClipArt
• Topic 5B: Draw and Modify Shapes
• Topic 5C: Illustrate Workflow Using SmartArt Graphics
• Topic 5D: Layer and Group Graphic Objects
• Lesson 6: Customizing and Enhancing the Excel Environment
• Topic 6A: Customize the Excel Environment
• Topic 6B: Customize Workbooks
• Topic 6C: Manage Themes
• Topic 6D: Create and Use Templates

• Microsoft Office Excel Level III (Advanced) - Master Level
• Course Objective:
• The Microsoft Excel Level 2 course will extend your basic knowledge of Excel, and develop more skills and knowledge that you need to produce worksheets as you require them. This training will expose you fully to the intermediate and advanced level of Microsoft Excel, giving you the features and concepts that you will find to be relevant and beneficial to your career.
• You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
• This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data
Course Content
Lesson 1: Streamlining Workflow
• Topic 1A: Update Workbook Properties
• Topic 1B: Create a Macro
• Topic 1C: Edit a Macro
• Topic 1D: Apply Conditional Formatting
• Topic 1E: Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
• Topic 2A: Protect Files
• Topic 2B: Share a Workbook
• Topic 2C: Set Revision Tracking
• Topic 2D: Review Tracked Revisions
• Topic 2E: Merge Workbooks
• Topic 2F: Administer Digital Signatures
• Topic 2G: Restrict Document Access
Lesson 3: Auditing Worksheets
• Topic 3A: Trace Cells
• Topic 3B: Troubleshoot Invalid Data and Formula Errors
• Topic 3C: Watch and Evaluate Formulas
• Topic 3D: Create a Data List Outline
Lesson 4: Analyzing Data
• Topic 4A: Create a Trendline
• Topic 4B: Create Sparklines
• Topic 4C: Create Scenarios
• Topic 4D: Perform a What-If Analysis
• Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
• Topic 5A: Create a Workspace
• Topic 5B: Consolidate Data
• Topic 5C: Link Cells in Different Workbooks
• Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
• Topic 6A: Export Excel Data
• Topic 6B: Import a Delimited Text File
• Topic 6C: Import and Export XML Data
Lesson 7: Integrating Excel Data with the Web
• Topic 7A: Publish a Worksheet to the Web
• Topic 7B: Import Data from the Web
• Topic 7C: Create a Web Query

Our safety tips

  • Listings with a "Shop" tag means that the publisher was curated by Jumia Deals.
  • At all costs, avoid paying before seeing the item.
  • Avoid sending money through untraceable methods such as Western Union or Mobile Money.
  • Thoroughly check the item to make sure it's matches the assumed condition.
  • If the seller doesn't have a shop, meet with him in a public place (Mall, Gas station, workplace ...).
  • Do not give personal details (bank details, credit card numbers ...).
  • Beware of offers that are too good to be true.

What do you have to sell?

Sell everything for free on Jumia Deals

Post a Free Ad Now!
Processing data