Advanced Excel
Mr. Sunam

Mr. Sunam

Advanced Excel (2nd Batch)

TK 5000

Start Date : 2018-12-14  

Total Class : 8   Total Hours: 24

Location : Dhanmondi

Friday : 9.30 AM - 12.30 PM

Enroll Now

Course Content

Day-01

Art in Excel

  • Interface and Saving Property
  • Basic Calculations
  • Fill and Auto Fill
  • Case Change & Join Text
  • Text Apart
  • Picture & Screen Short
  • Shapes, SmartArt

Day-02

Formatting Data

  • Format Painter
  • Function And Formula in Excel
  • Formatting Cell by Alignment
  • Formatting Cell by data type
  • Formatting Cell by Fill and Border

Day-03

Orientation with Excel

  • Cell References (Relative, Mixed, Absolute)
  • Freeze Panes
  • Hyperlink
  • Managing Multiple Windows
  • Paste Specials
  • Selecting, Moving & Resizing
  • Structure of Excel Function(fx)

Day-04

Advance Functions

  • IF Function (Basic & Advanced)
  • IF Functions (sum, count, average)
  • IFS Function (sum, count, average)
  • IF Function (Basic & Advanced)
  • LOOKUP

Day-05

Advance Tools

  • Consolidating
  • Data Validation
  • Subtotal
  • Index and Match Functions
  • Vlookup, Hlookup Functions

Day-06

Big Data Management

  • Manage Duplicate Data
  • Managing Data by Group
  • Table ,Slicer
  • Sort and filtering
  • Formatting by Formula

Day-07

Data Review Automation by Excel

  • Formula Auditing
  • Managing Comments in Excel
  • Protect Sheet and Workbook
  • Financial Functions
  • Loan Calculation and financial formulas
  • Dynamic Name Range

Day-08

  • Advanced Charts
  • Privot Table, Privot Chart
  • Printing Document Perfectly

Analysis Tools

  • Data Table
  • Analyze Performance Factor
  • Goal Seek
  • Consolidate
  • Macro Concept
  • Tips
  • Shortcuts
  • Practical Project
  • Practice Test