Advance Excel MIS

Best Tally 

training in noida 4.5 out of 5 based on 875 ratings. 5 user reviews.

(MS office) Excel 2013 with Advance Excel Training (2 Months)

Topic 1 - Make a Start with Excel

  • A first look at Excel 2013
  • Excel Rows and Columns
  • Enter text and numbers in a Cell
  • How to edit text in a Cell
  • How to Centre text and numbers
  • Font Formatting in Excel 2013
  • How to change the color of a Cell
  • How to save your work in Excel
  • Currency Symbols in Excel 2013
  • How to Merge & Center
  • Review Number One
  • Use Auto Correct Option
  • Use Format painter
  • Use All Shortcut & Trikes

Topic 3 - Excel 2013 Charts

  • How to Sort Data in Excel
  • Create an Excel Chart
  • Move and Resize your Chart
  • Chart Styles and Layouts
  • Chart Titles and Series Titles
  • Chart Layout Panel in Excel 2013
  • The Format Chart Panel
  • Create a Pie Chart in Excel
  • Add Labels to a Pie Chart
  • Format Pie Chart Segments
  • Create a 2D Line Chart in Excel
  • Format your Axis Titles
  • Predict the future with a Trend line Chart
  • Sparkline Charts

Topic 5 - Functions in Excel 2013

  • The Average Function
  • The Date Function
  • Time Functions in Excel
  • A Time Table Project
  • Financial Functions
  • The Student Averages Project
  • Use Maximum & Minimum Formula
  • Use Product Formula
  • Use Mod for Reminder
  • Mathematics Formula

Topic 7 - Processing Data in Excel

  • Data Tables in Excel 2013
  • A Second Data Table
  • Excel Scenarios
  • Goal Seek
  • Absolute Cell References
  • Named Ranges in Excel 2013
  • Create a Custom Name in Excel
  • Excel Pivot Tables
  • Pivot Tables, Part Two
  • Reference other Worksheets
  • The LOOKUP Function
  • The VLOOKUP Function in Excel
  • Create a Business Invoice, Part One
  • Excel Business Invoice, Part Two
  • Business Invoice, Part Three

Topic 9 – MIS Report in Excel 2013

  • Use Concatenate Condition Option
  • Merge First name last name
  • first name with Left & Find Condition
  • LEN and FIND Condition
  • How to change (UPPER, LOWER, PROPER)
  • Insert Date & Time Formula & Shortcut
  • Change Roman Counting
  • Learn Formula (MATCH, CHOOSE, WEEKDAY FUNCTION, TEXT, NETWORK DAYS, WORKDAY,TRIM, VALUE, LEN)

Topic 2 - A more complex spreadsheet

  • Page Layout
  • How to use AutoFill in Excel 2013
  • Entering Simple Addition Formula
  • The SUM Function in Excel
  • The SUM Function Continued
  • Copy and Paste
  • How to use Paste Special
  • How to Multiply in Excel 2013
  • Finishing your spreadsheet for this section
  • How to Add a Comment to a Cell
  • Review Number Two

Topic 4 - Formulas in Excel 2013

  • The SUM Function
  • How to Multiply in Excel
  • Subtract and Divide
  • Combining the Arithmetic Operators
  • A Budget Spreadsheet
  • Balance Sheet, Salary Sheet
  • Employee Sheet
  • Bookmark & Create Hyperlink
  • Set Print area

Topic6- Conditional Logic in Excel

  • The IF Function
  • Conditional Formatting in Excel 2013
  • COUNTIF, SUMIF, DMAX, DMIN,
  • DCOUNTA, DSUM Use for Stock Table

Topic 8 - Advanced Excel 2013

  • How to Create an Excel Template
  • Data Forms in Excel 2013
  • Drop Down Lists in Excel
  • Add your own Error Messages
  • Excel and Web Integration
  • Hyperlinks in Excel
  • Object Linking and Embedding
  • Insert Drawing Objects
  • Bookmarks & Hyperlink
  • Use DATA Validation Tools
  • USE Goal Seek & Data Table
  • Use Short option For Series
  • What if Analysis option
  • Consolidate Function
  • How to Protect Excel Sheet
  • How to Protect Excel Data
  • How to Protect Excel Workbook
  • How to Enable Double Password
  • How to Use Pivot Table