0 Cart
  • Your cart is empty
Close result ESC

Deals Icon

    Business Icon

      Microsoft Excel Training  II&III | SGL
      • Microsoft Excel Training  II&III | SGL
      • Microsoft Excel Training  II&III | SGL
      • Microsoft Excel Training  II&III | SGL

      Microsoft Excel Training II&III | SGL

      ₦45,000 ₦35,000
      • Discount 22%
      • You save ₦10,000
      Limited Time Offer
      Seller rating 87
      Sold By: SGL Technologies


      • Microsoft Excel ( Expert  & Master Levels) -  Level II & III
      • Training Category: Individual and Promo Package
      • Type of Training: End User
      • Type of certificate to be issued
        • Certificate of completion
        • No mandatory exam to receive certificate
        • Cost of tuition does not include  the cost of certificate
        • Venue:
          • Lagos  10, Akinremi Street, Anifowoshe, off Awolowo Way, (Opp New Garage) Ikeja, Lagos
        • Duration: 4-days 
        • Dates:  (Weekday and Weekend options available)
          • Date: Register and call merchant to  fix a  date/ schedule for your training
          • Time : 9am – 4pm (Monday – Saturday)  Sundays 1.00pm - 6.00pm
      • Microsoft Office Excel: Level II (Specialist Level)
      • Course Objective: 
        • You can expand your knowledge of Microsoft excel greatly by registering for this Microsoft Excel Level 2 training provided by SGL Technologies in Lagos. Excel has many capabilities, and there are lots to learn, which many professionals who thought they knew much about Excel are not even aware of.  This is one among the professional courses that has direct relevance to almost all careers, and a training that you can actually receive in a day.
        • You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. 
      • 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 – 2days
        • 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
      • How To Redeem:
        • Purchase coupon on DealDey and contact merchant to schedule preferred training date
      • More Information on this Deal
        • Type of certificate to be issued
          • Certificate of completion
        • No mandatory exam to receive certificate
        • Cost of tuition does not include  the cost of certificate
      • 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
      • More InformationAbout The Deal
        • Participants are expected to come with their laptops
          • This can also be arranged for a group of staff either at our center or your office.
          • Free Courseware materials in soft copy
          • Venue:   SGL Training Center. Ikeja.
          • Facilitator: An Experienced  Microsoft   Certified Trainer and Microsoft Office Specialist
          • Highly Practically Intensive and Interactive
          • Course materials in soft copy,
        • Methodologies:
          • Hands-On
          • Lecture
          • One-on-One
          • Detailed Practical and One on One Attention

    • Coupon(s) valid until 2019-01-07 (unused Coupons after this date will not be honoured/refunded by Merchant/DealDey)
      • Multiple Coupons may be purchased
      • Coupons numbers or QR codes must be presented for redemption
      • Download Coupon for Merchant's details 
      • Reservation must be made before redemption
      • Please call 01-4609950 | 08094609951 for more payment enquiries 
    • Terms and conditions apply
    • Details

      SGL Technologies has the experience and team that can create a system for you and your business. Working hand-in-hand with our team gives our clients the tools to create an easily manageable workflow in an organization. Over the past years, SGL Technologies has continued to maintain and focus on the products and technologies from a customer's perspective, developing and delivering ICT cutting edge solutions and training for vendors and partners as Consultants and Training Specialists for different organizations irrespective of the industry sector. Our services include : Provision of top notch Business Support Information Technology Solutions, IT Training, Licensing of Computer Softwares, Networking, Data Protection and Storage Management Solutions, Video Conferencing, ICT Professional Certification Testing and Facilitate Internationally Recognized Professional Certificates in IT. We offer world class Information Technology Training to prepare you adequately for a global IT career.
      SGL Technologies
      10, Akinremi Street, Anifowoshe, Off Awolowo Way, Ikeja, Lagos
      Lagos Mainland, Lagos, Nigeria
      DealDey Helpline
      01-4609950, 08094609951

          View All Deals


          Amazing Deals at Your Fingertips

          • Stay in the loop! Be the first to benefit from exclusive deals.
          • Enjoy a faster and a convenient shopping experience with instant notifications on special deals.
          • Over 400 deals uploaded daily, take advantage of extra discounts EXCLUSIVE to the app.

          Download the free app now!

          Enter your phone number below and we'll send a download link directly to your mobile phone.

          You can also download the app here: