Course Details

Advance Microsoft Excel Training (210 )

Advance Microsoft Excel Training will be easy to do a lot of hard work everyday. Learn the hard work of operating important software like Microsoft Excel at home. So register today to improve your skills in Excel. There is no substitute for Excel to easily and accurately complete various hassles related to data in your daily life. Excel is widely used around the world to create accurate charts based on various data.& nbsp Knowing how Excel works will save you a lot of time. So that you can rest assured. Our training center is giving you a golden opportunity to learn Excel at home. In other words, all the functions of Excel that are mandatory to know as an employee.

Course Details

  • Batch No : 04
  • No Of Sessions : 0
  • Start Date : Upcoming
  • Course Medium : Online Zoom
  • Class Duration :
  • Class Schedule :
  • Class Size : 50 Seats
  • Payment Deadline : 24-10-2023
  • Completed Courses : 187 Persons
  • Price : TK 550.00
  • (Including VAT & TAX)
  • Apply Now
  • Call Now : +880 1727-546514
Advance-Microsoft-Excel-Training

Course Outline

This Introduction to MS Excel course will help you develop a thorough understanding of MS Excel and explore its abundant features. You will learn how to write functions; sort, filter, and import data and much more. Learn MS Excel and explore various functions and formulas that you can leverage on MS Excel to track and manage and track data-driven projects.


The Excel Screen 

  • Rows, Columns, Cells
  • Scroll Bar
  • Tabs
  • Ribbon
  • Quick Access Toolbar
  • Name box
  • Formula bar
  • Zoom
  • Sheets
  • File Name
  • Moving Around the Workbook
  • Workbook vs Worksheet
  • Simple Data Entry
  • Selecting Ranges
  • Saving Workbook Formats

Copy and Filling

  • Copy
  • Paste
  • Paste Special
  • Copying Cell(s) to one/Many cells
  • Copying to different worksheet
  • Using Fill for Quick Coping

Formatting in Excel

  •  Font
  • Bold
  • Italic
  • Underline
  • Border
  • Background color
  • Font Color
  • Fonts
  • Alignment
  • Number
  • File Manu all program
     

Define Names Range

  •  Creating Name Range
  • Rename Name Range
  • Create From Selection
  • Deleting Name Range
  • Use Name Tangle In Workbook
  • Working with Functions
  • Sum
  • Minimum (MIN)
  • Average (MAX)
  • Count
  • Count
  • Count blank
  • Small
  • Large
  • Function
  • TODAY
  • NOW
  • DAY
  • MONTH
  • YEAR
  • DATE
  • Home Manu all program


Date functions

  •  Network Days, Network Days. into
  • Date Vs Days
  • Dated if
  • Date of Birth
  • Total Years
  • Total Months
  • Total Days
  • Years
  • Months
  • Days

OPERATOR

  •  Addition
  • Subtraction
  • Multiplication
  • Division
  • Percentage
  • All menu discuses

Formula

  •  Result Formula
  • Discount Formula
  • Commission Formula
  • Over time Formula
  • Elective Bill Formula
  • Rate and Quantity
  • Salary Sheet
  • Blank Interest
  • Largest Formula

Pivot Table & Chart

  •  Pivot Table
  • Pivot Chart
  • VLOOKUP
  • Hookup
  • Functions
  • Macro
  • Turn on Developer Tab
  • Command Button
  • Assign a Macro
  • Record a Macro

    And other Ticks & Tips Etc.

This Introduction to MS Excel course will help you develop a thorough understanding of MS Excel and explore its abundant features. You will learn how to write functions; sort, filter, and import data and much more. Learn MS Excel and explore various functions and formulas that you can leverage on MS Excel to track a....

About Advance Microsoft Excel Training

Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. This Excel for beginners course will help you learn Excel basics.

Certificate

CERTIFICATE OF ACHIEVEMENT .jpg

FAQ

  • Question: What is excel? 
    Answer: Microsoft Excel is a spreadsheet or a computer application that allows the storage of data in the form of a table. Excel was developed by Microsoft and can be used on various operating systems such as Windows, macOS, IOS and Android.
  • Question: What is Excel used for?
    Answer: Excel is used to store, analyze, and report on large amounts of data. It is often used by accounting teams for financial analysis, but can be used by any professional to manage long and unwieldy datasets. Examples of Excel applications include balance sheets, budgets, or editorial calendars.
  • Question: What does basic Excel course include? 
    Answer: These basic Excel skills are – familiarity with Excel ribbons & UI, ability to enter and format data, calculate totals & summaries thru formulas, highlight data that meets certain conditions, creating simple reports & charts, understanding the importance of keyboard shortcuts & productivity tricks.
  • Question: What is the best way to learn Excel?
    Answer: If you're just starting out using Excel, an introductory course can help get you up to speed. These courses may explore how to set up an Excel sheet, perform basic calculations, use advanced formulas, and create data visualizations with charts and graphs.

Meet The Instructor

...
Rajan Kumer Debnath
Consultant

What you'll learn

  • Excel Sort and Filter
  • Excel Dashboard
  • Functions in Excel
  • Conditional formatting
  • Data Validation
  • Pivot Tables and Charts
  • Data Analysis in Excel
  • Macros and VBA

Course Materials

  • REVIEW CLASS AVAILABLE
  • SOURCE FILE PSD
  • LECTURE SHEET
  • VIDEO
  • CERTIFICATE (PDF)

Participant Qualification

  • Freshers
  • Sales Professionals
  • Marketing Professionals
  • Strategists
  • Business Executives
  • Data Professionals

Apply Now

Related Courses

Newsletter

Please Sign Up, Self Development Technical Training Academy (SDTTA).

latest News

Contact Us