Course:

Business Spreadsheet management using Advance Microsoft Excel.

Course Duration:

Class room training: 20 hours
Online training:         10 hours

Fee Details:

Course Fee: ₹ 3000

  FREE Microsoft Excel Course

  FREE Placement Registration

* Conditions Apply.

  Sinet Certification
      ISO 9001 2015 logo embossed
      with Online reference.
      Cost: Free

      Show Model

  Office Works
  Spreadsheet Manager
  Microsoft Excel Works

For more information contact now

8086 800 700
8086 800 700
sinetlimited@gmail.com

+91 9946 668 186
+91 04933 227 816
info@sinet.in

Sinet Microsoft Advance Excel Course Contents

1. Introduction and Formatting of Excel work book

Introduction to Excel interface, Understanding rows and columns, Naming Cells, Working with Excel workbook and sheets, New, Open, Close, Save, Save As, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline, Wrap text, Merge and Centre, Currency, Accounting and other formats, Modifying Columns, Rows & Cells

2. Introduction to Excel Calculations

Creating simple formulas, Setting up your own formula, Date and Time Functions, Financial Function

3. Perform Calculations with Excel Functions

Logical Functions, Lookup and Reference Functions Mathematical Functions, Statistical Functions, Text Functions.

4. Sort and Filter Data in Excel

Sort and filtering data, Using number filter, Text filter, Custom filtering, Removing filters from columns, Conditional formatting

5. Create Effective Excel Charts to Present Data Visually

Inserting Column, Pie chart etc., Create an effective chart with Chart Tool Design, Format, and Layout options , Adding chart title , Changing layouts, Chart styles, Editing chart data range, Editing data series, Changing chart

6. Analyse Data Using Excel PivotTables and Pivot Charts

Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Create Pivot Chart from pivot Table. , Inserting slicer, Creating Calculated fields

7. Use Excel Scenarios

Use What-If Analysis Tools , Create Scenarios , Merge Scenarios , Create Scenario Summaries , Use Data Tables , Create Advanced Charts , Basic Excel Charts , Use Area, Scatter & Stock Charts , Use Surface, Radar & Combination Charts , Create Custom Chart Templates , Work with Sparkline’s

8. Protecting and Sharing the Excel Work Book

Protecting a workbook with a password, Allow user to edit ranges, Track changes, Working with Comments, Insert Excel Objects and Charts in Word Document and Power point Presentation

9. Advance Formulae and Functions in Excel

Create advanced formulae , Functions , Apply functions in formulae , Mathematical Functions , Financial functions , Useful Data Functions , Some Other Useful Functions , Look up data by using functions , Apply advanced date and time functions , Functions for Manipulating Text , Arrays

10. Apply Custom Formats and Layouts to Excel Work Sheets

Apply Custom Data Formats , Use Advanced Fill Options , Apply Advanced Conditional Formatting and Filtering , Apply Custom Styles and Templates , Use Form Controls , Prepare Workbooks for Internationalization , Use Outlines , Use Custom Views

11. Advance features in Microsoft Excel

Creating and Recording Macros, Assigning Macros to the work sheets, Saving Macro enabled workbook, Page setup, Setting print area, Print titles Inserting custom Header and Footer , Inserting objects in the header and footer, Page Setup, Setting margins, Print Preview, Print, Enable back ground error checking , Setting AutoCorrect Options

12. Advanced Excel Function implementation Project

Two-Way Lookup, Using Dropdown Lists as Lookup Values, Three-way Lookup, Getting the Last Value from a List, Partial Lookup using Wildcard Characters and VLOOKUP, VLOOKUP Returning an Error despite a Match in Lookup Value, Doing a Case Sensitive Lookup, Using VLOOKUP with Multiple Criteria, Handling Errors while Using the VLOOKUP Function

13. Manage and Share Excel Workbooks

Manage Workbook Versions, Copy Styles within Workbooks, Copy Macros within Workbooks, Use Track Changes and Comments, Merge Workbooks, Protect Workbooks for Sharing, Connect To External Data

* Each Session include:
Faculty training, Lab Practice, Lab Exercises and Portal based assignments.
* Sinet Education reserved the right to alter the course contents, offers, price, certificates etc.