Excel Essentials

Excel Essentials

"Microsoft Excel" is one of the most widely used software in the workplaces on Regular Basis. The course " Excel Essential” is focused on building strong foundations of Excel for the Professionals.

course at a glance

  • Date : 12 Nov - 28 Nov 2019
  • No. of Classes/ Sessions : 8
  • Total Hours : 24
  • Last Date of Registration : 11 Nov 2019
  • Class Schedule :
    • Sunday - 6:00pm - 9:00pm
    • Tuesday - 6:00pm - 9:00pm
    • Thursday - 6:00pm - 9:00pm
  • venue : PencilBox Training Institute, EDB Trade Centre, 5th Floor, 93 Kazi Nazrul Islam Avenue, Kawran Bazar,Dhaka-1215

Price: TK. 5,000
(Excluding VAT & TAX)

This training is jointly organized by BITM & Pencilbox Training & Consultancy, A Training wing of bitBirds Solutions

Training will be held in Pencilbox Training & Consultancy.


How Participant will be Benefited: 
Microsoft Excel allows you to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses Microsoft Excel gives you the right tools to enable you to accomplish all your needs.

Methodology: Hands on Training with Practical using of different tools with real life example.

 

Contents of Training:

  1. Introduction: The Basics (Excels)
    1. Basic of Excel
    2. Copy and move a worksheet
    3. Input Data
    4. Edit, Find, Replace Data
    5. Auto Fill
    6. Keyboard Navigation
    7. Navigate in worksheets and workbooks 
    8. Search for data within a workbook
    9. Insert and remove hyperlinks
  2. Formatting a Worksheet.
    1. Create worksheets and workbooks
    2. Navigate one sheet to another sheet 
    3. Add a worksheet to an existing workbook
    4. Change worksheet tab color 
    5. Rename a worksheet 
    6. Change worksheet order 
    7. Modify page setup 
    8. Insert and delete columns or rows 
    9. Adjust row height and column width 
    10. Insert headers and footers 
  3. Managing a Workbooks
    1. Create a workbook
    2. Change workbook themes 
    3. Hide or unhide worksheets
    4. Hide or unhide columns and rows 
    5. Customize the Quick Access Toolbar 
    6. Change workbook views, Change window views 
    7. Modify document properties 
    8. Change magnification by using zoom tools 
    9. Display formulas 
  4. Editing a Workbooks
    1. Set a print area 
    2. Save workbooks in alternative file formats 
    3. Print all or part of a workbook 
    4. Set print scaling 
    5. Display repeating row and column titles on multi page worksheets 
    6. Inspect a workbook for hidden properties or personal information 
    7. Inspect a workbook for accessibility issues 
    8. Inspect a workbook for compatibility issues 
  5. Formulas
    1. Using the SUM function 
    2. Using MIN and MAX functions 
    3. Using the COUNT function 
    4. Using the AVERAGE function 
    5. Using the IF function 
    6. Using the SUMIF /SUMIFS function 
    7. Using the AVERAGEIF / IFS function 
    8. Using the COUNTIF / IFS function
  6. Data Table
    • Creating a usable Data Table from Spreadsheet
    • Data Analysis
    • Pivot Table
  7. Working with the forms menu
    1. Create Developer Menu
    2. Create Forms Menu
    3. Specials tips for Working with forms menu
  8. Creating & Working with Charts
    1. Create a new chart 
    2. Add additional data series 
    3. Switch between rows and columns in source data 
    4. Analyze data by using Quick Analysis 
    5. Resize charts 
    6. Add and modify chart elements 
    7. Apply chart layouts and styles 
    8. Move charts to a chart sheet 
  9. Summarize and organize data 
    1. Data Validation
    2. Conditional Formatting
    3. Insert Sparkline's 
  10. Functions
    1. LOOKUP
    2. VLOOKUP
    3. HLOOKUP
  11. Using logical Function
    1. If
    2. Nested if
    3. And
    4. Or
  12. Protection
    1. Protection in Workbook
    2. Protection in Worksheet
    3. Protection in Individual Cell
  13. Print
    1. Excel Page setup
    2. Page Layout
    3. Print Selected Data in Worksheet
    4. Print a Worksheet
    5. Print Full Workbook
  14. 50 Special Tips & Tricks.
  15. Excel Shortcut Key

      & Many Special Tips for First Work.

    16. Question & Answer

  •  Question & Answer Session 
  • Any other topics requested by the Participants

    17. Certifications

Curriculum

Training Excel Essential 24 Hrs

Tentative Class Start

12th November, 2019

Available Seat

10 / 20

who can join

This course is very useful for anyone who works in Excel. The target audiences are
the Managers, Executives, Students, Teachers, Developers, and Researchers. It will give you job, make you
essential at your job and bring you tremendous career success.

Meet the Instructor