Blog

Microsoft Excel – Excel from Beginner to Advanced

DICS Innovatives

MS Excel and Advanced Excel Training Course is planned by a master group of information examiner. This, progressed dominate preparing is encouraged to fresher’s to proficient who are searching for incredible profession in examination. Students who need to begin as a Data Analyst/MIS Analyst/Business Analyst as a fresher or with some accomplished, progressed dominate course is outstandingly proposed. Progressed Excel preparing incorporates not many significant points like Mathematical, Statistical Lookup and Reference, Logical Functions, Power Pivot Table, Data Collection Method, Advanced Dashboard for Data perception, Report Development , Visual Analytics, and so forth, so join best advance excel Institute in Pitampura Location.

Advance Excel Training Course is right now accessible at Pitampura Center in non-weekend days or ends of the week. According to monstrous request of student’s we have begun Advanced Excel Training course in pitampura also. We Guarantee 100% Interview after successful completion of the 70% of Advanced Excel course.  All interviews / placement will get done in Delhi, Noida, Gurgaon, Faridabad, Ghaziabad NCR location with mid level to MNC organization.

Introducing Microsoft Excel

  • Working With Excel
  • Worksheets and Workbook
  • Understanding the User Interface
  • Quick Access Toolbar
  • Ribbon
  • Formula Bar
  • Worksheet Area
  • Worksheet Tab
  • Status Bar
  • The Backstage View
  • Saving Excel Workbook
  • Creating New Excel Workbook
  • Opening Existing Excel Workbook

Customizing Common Options in Excel

  • File location
  • Number of sheets, Alignment Of row & Column
  • Cursor movement
  • Font face and size
  • Startup folder
  • File format, Enable text wrap
  • Advance Filter, Advance Sorting
  • Maintain Track Changes
  • Hide ,Unhide Row & Column
  • Merge & Unmerge
  • Insert Header & Footer In Excel
  • Insert Shape ,Picture ,Smart Art Etc..

Entering Data

  • Concept of Tabular Data
  • Cell Nomenclature
  • Editing Workbook
  • Editing Worksheet
  • Entering Data
  • Renaiming Sheet

Working With Numbers

  • Excel Data Types: Number ,Date,Time Etc..
  • Moving Data
  • Organizing Data in Excel Tables
  • Creating Simple Formulas.
  • Arithmatic& Comparison Operator
  • Relative vs. Absolute References
  • Using Functions
  • Using Math Functions:
  • Round,Power,SQRT,RoundUp,
  • Using Statistical Functions
  • Average If,Count,Countif
  • Averageif,Min,Max ,Sumif,Countif Etc..
  • Using Financial Functions: Etc..
  • FV,INTRATE,IPMT,Rate,NPER,PPMT

Formatting Data

  • Common Font Formatting,
  • Font Type ,Size,Color,Style, Text Orientation
  • Cell Border, Fill Colour
  • Cell Alignment, Text Alignment
  • Text Indentation, Text Wrapping,
  • Formatting Numbers, Merging Cells
  • Number – Format, Currency Format
  • Accounting Format, Format As Percent
  • Decimal Formatting, Applying Styles
  • Additional Cell Formatting Features,
  • Conditional Formatting
  • Using Format Painter

Managing Your Data in Excel

  • Setting Named Range
  • Finding and Replacing Data
  • Inserting Cut or Copied Cells,Paste Special
  • Sorting Worksheet Data
  • Filtering Worksheet Data,Color Filter Etc.
  • Formula Auditing, Adding, Displaying.
  • Editing, and Removing Comments
  • Trace Dependents,Formula Auditing

Working with Text and Date

  • Text Functions: concatenate, Left Function
  • Trim,Find,Replace,Exact,Search
  • Using Date & Time : Today ,Days360,Networkdays,Now
  • Formatting Date: Hour,Yearfrac,Minut,Month,Time,Weekday
  • Formatting Time in Different Format

Manipulating Data

  • Relative & Absolute Referencing
  • Transposing Rows Into Columns
  • LOOKUP Functions : Vlookup,Hlookup
  • Lookup_value,Table_Array,Range_Lookup
  • Manipulating Data

Working with Charts

  • Charts in Excel :Column,Line,Pie,Bar,Area,Scatter
  • Chart Tools Tabs: The Anatomy Of Chart
  • Chart Area,Label,Grid Lines
  • Creating Charts
  • Changing Chart Type
  • Editing Charts
  • Changing Data Source
  • Changing Chart Style / Appearance
  • Resizing Charts
  • Moving Charts
  • Changing Chart Layout
  • Managing Chart Labels
  • Managing Axes Layout
  • Adding a Trendline to Chart
  • Naming Your Chart
  • Formatting Chart Area and Labels

Working with PivotTable

  • Creating PivotTable
  • PivotTable Tools Tabs
  • PivotTable Field List Task Pane
  • Report Filter,Axis Field
  • Legend Field & Values
  • Applying Style to PivotTable
  • Applying Filters and Slicers
  • Applying Filter , Applying Slicer
  • Filtering Data and Creating PivotCharts

What If Analysis

  • Using Goal Seek
  • Using Scenario Manager
  • Recording Macro
  • Managing Macro Security Level in Excel
  • Recording Macros
  • Running Macros

Printing Excel Files

  • Page Layout
  • Setting Up Your Page
  • Printing Your Worksheet
  • Applying Background
  • Printing Headers
  • Printing Data

Managing Excel Files

  • Saving Files
  • Excel Workbook
  • Excel Macro-Enabled Workbook
  • Excel 97-2003 Workbook
  • Web Page,csv,pdf
  • Emailing Workbooks

Grouping and Outlining Data

  • Grouping Your Data ,Outline Your Data
  • Adding Subtotal
  • Adding Outline ,Automatic Style,
  • Linking and Protecting Worksheets

Working With Reports

  • Convert data to tables
  • Finding the related data
  • Creating Subtotal
  • Multiple-level subtotals
  • Formatting and Customizing Pivot Tables
  • Using data Consolidation feature to consolidate data
  • Freeze Pane
  • Setting of row & column (height & width)
Microsoft Excel – Excel from Beginner to Advanced

Leave a Reply

Your email address will not be published. Required fields are marked *