Project Description
Microsoft Excel Customized
Total Course Duration: 18 Hours
Class Duration: Two Day Long
- Identify the Elements of the Excel Interface
- Create a Basic Worksheet
- Use the Help System
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
- Manipulate Data
- Insert, Manipulate, and Delete Cells, Columns, and Rows
- Search for and Replace Data
- Spell Check a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles
- Define the Basic Page Layout for a Workbook
- Refine the Page Layout and Apply Print Options
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
- Customize General and Language Options
- Customize Formula Options
- Customize Proofing and Save Options
- Customize the Ribbon and Quick Access Toolbar
- Customize the Functionality of Excel by
- Enabling Add-Ins
- Customize Advanced and Trust Center Options
- Apply Range Names
- Use Specialized Functions
- Leverage Questions and Testing to Write Formulas
- Use Logical and Lookup Functions to Find Answers to Questions
- Create and Modify Tables
- Sort and Filter Data
- Use Summary and Database Functions to Calculate Data
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
- Create a PivotTable
- Filter Data by Using Slicers
- Analyze Data by Using PivotCharts
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
- Update Workbook Properties
- Create and Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis ToolPak
- Create Interactive Data with Power View
- Consolidate Data
- Link Cells in Different Workbooks
- Merge Workbooks
- Export Excel Data
- Import a Delimited Text File
- Integrate Excel Data with the Web
- Create a Web Query

AUTHORIZATION


COURSE RESOURCE PERSON
Trainer Profile


Tanvir Islam
Senior Technical Trainer
SKILLS
Microsoft Office, Adobe After effect, Adobe Animation, 3Ds max , Vray, Adobe xd, Figma, Adobe Photoshop, Adobe illustrator, Adobe premiere Pro, Cinema 4D, Lumion.
ACADEMIC QUALIFICATION
B.sc in computer science and engineering.
PROFESSIONAL EXPERIENCE
New Vision Information Technology Limited
Sr. Technical Trainer
from 2016 to till now
Upwork
Freelancer
from 2010 to till now
TRAINING & CERTIFICATION
Graphic design from New Horizon Computer Learning Center.
Year 2010
Area of Interest
Design, Photography, Videography, VFX
Trainer Profile


Mohammad Shihab Uddin
Senior Technical Trainer
SKILLS
Programming Language: Java, Dart, C#, C, C++, Python, PHP, JavaScript, HTML, CSS Framework &
Library: Dot Net, Flutter, jQuery, Bootstrap
Modeling Language: UML Database Language: MSSQL, MYSQL, Oracle
Development Architecture: MVC, Repository pattern, Layered architecture, OOP. Reporting: Crystal Report, RDLC Report Networking: LAN, WAN, TCP/IP, Switching, Routing
Operating System: Windows XP/Vista/7/8/8.1/10/11, Linux kali / Ubuntu
Web Server: Apache, IIS Office Application: Microsoft Word, Excel, Access, Power point, Visio
ACADEMIC QUALIFICATION
B.Sc in Computer Sciences and Engineering
International Islamic University Chattogram.
PROFESSIONAL EXPERIENCE
New Vision Information Technology Ltd. Franchise owner of New Horizons CLC of Chattogram 110 CDA Avenue, Sholoshahar, Chattagram Sr Technical Trainer May 2, 2017 to present
Max Infrastructure Ltd, Max Group RAOWA Complex, level-11, VIP Road Mohakhali, Dhaka-1206. Executive in Information Technology October 4, 2016 to April 30, 2017
TRAINING & CERTIFICATION
Microsoft Certified Solutions Developer: App Builder -487-Developing Microsoft Azure and Web Services. -Certification number: G558-8885 Microsoft Certified Solutions Associate: Web Applications -486-Developing ASP.NET MVC Web Applications. -Certification number: G490-9397 Microsoft Certified Professional -480-Programming in HTML5 with JavaScript and CSS3 -Certification number: G244-6716
Mobile Application/Game Development (Cross Platform) based on Dart, Flutter, Firebase under Skills development for mobile game application from ICT division, Ministry of ICT, Gov’t of BD. Web Application Development- Dot Net based on C#, OOP Concept, MSSQL, HTML, CSS, JavaScript, jQuery, Ajax, ASP.Net Web Form, Layer Arch, MVC and Desktop Application under Skills for Employment Investment Program (SEIP) from BASIS institute of Technology & Management (BITM). Java Development Course based on Java (SE), OOP Concept, MYSQL from “Omni It Solution” in Chittagong. Website Development based on HTML, CSS, JavaScript, jQuery, Ajax, PHP, MYSQL from “Excel IT” in Chittagong. Line Following Robot based on Micro C and PIC from “TECHSHOP BD” in Dhaka. Leave Management System” based on C#, ASP.Net, MSSQL from “Chittagong New Horizons” in Chittagong. Basic Network & Introductory CCNA from “Talent Technology & Research” in Chittagong.
Trainer Profile


Suman Chakraborty
Senior Technical Trainer
SKILLS
ACADEMIC QUALIFICATION
B.com
PROFESSIONAL EXPERIENCE
Rainbow systems
System/Network engineer
Jan 2012-dec 2015
New Vision Information Technology Ltd.
Senior Technical Trainer
2016 to till date
TRAINING & CERTIFICATION
Cisco Certified Network Associate Routing And Switching (CCNA)
Cisco ID (CISCO): CSCO13110414
MikroTik Certified Network Associate (MTCNA)
MTCNA ID: 1904NA0655
MikroTik Certified Routing Engineer (MTCRE)
MTCRE ID: 1905RE2742
ComTia A+
Microsoft Certified IT Professional – Server Administrator on Server® 2008 (MCITP)
4Microsoft Certified IT Professional – Enterprise Administrator on Server® 2008 (MCITP)
Microsoft Certified Solution Associate – Windows Server 2012 (MCSA)
Microsoft Certified Solution Expert – Windows Server 2012 (MCSA)
Red hat enterprise Linux
Microsoft office 2003,2008.2010,2013,2019
Area of Interest
Computer Networking Technology
Trainer Profile


Rasel Ahmed
Trainer
SKILLS
APPLICATION: Microsoft Office, Adobe Photoshop, Adobe Illustrator.
OPERATING SYSTEM: Windows, Linux (Red Hat, Centos, Ubuntu, Kali)
NETWORKING: A+, N+(Data Communication), MCSA (Windows Server 2012 R2) CCNA, Linux
ACADEMIC QUALIFICATION
Diploma In Computer Network Technology
MBA (Management)
BBA (Management)
PROFESSIONAL EXPERIENCE
Dainik-Azadi (Newspaper)
Web Admin
From 2014 To 2017
Cloud One
Support Engineer
From 2019 To 2020
New Vision Information Technology Limited
Technical Trainer
From 2020 To till Now.
TRAINING & CERTIFICATION
MS OFFICE (BTEB)
NETWORKING TECHNILOGY (NT)
MCSA (Microsoft Certified Solution Associate)
MS ID: MS0618485038
Area of Interest
NETWORKING, CYBER-SECURITY
Trainer Profile


Md Tawhidul Alam
Senior Technical Trainer
SKILLS
HTML5, CSS3, JavaScript, jQuey, Bootstrap, PHP, MYSQL, Laravel, CodeIgniter, WordPress (Theme Customization and Development).
ACADEMIC QUALIFICATION
M.B.A In Human Resource Management
Southern University, Chattogram Bangladesh.
PROFESSIONAL EXPERIENCE
New Vision Information Technology Limited
Technical Trainer
From September 2017 to till date
TRAINING & CERTIFICATION
Microsoft Certified Professional Certification Number: F984-3814
Microsoft Specialist: Programming in HTML5 with JavaScript and CSS3
Certification Number: F984-3820
Diploma in Web-Presence Solutions & Implementations (WPSI) with PHP Frameworks.
Area of Interest
Web Design and Development
Trainer Profile


Md. Foysal Wahid
Senior Technical Trainer
SKILLS
Computer Fundamentals, Programming with C# .NET, Python, R, SQL Server Data-base, HTML5, CSS3, JavaScript, O-O Systems analysis and design with UML, XML, ADO.NET, Angular JS, Angular, ASP.NET, SignalR, ASP.NET MVC Web Applications, Windows Communication Foundation (WCF), Windows Azure and Web Services, Machine Learning, Data Science.
ACADEMIC QUALIFICATION
B.Sc (Hons.) & MS In Physics
University of Chattogram
PROFESSIONAL EXPERIENCE
Technical Trainer(.NET) [ IsDB-BISEW IT Scholarship Programme] Software Development
TRAINING & CERTIFICATION
View my profile in Microsoft exams certification on the following link
https://mcp.microsoft.com/Anonymous//Transcript/Validate
Tran-script ID: 1129371
Access Code: FoysalCU87
Area of Interest
Machine Learning, Data Science, Artificial Intelligence, Digital Transformation
Trainer Profile


Md. Shariful Islam
Senior Technical Trainer
SKILLS
HTML5, Bootstrap3, AngularJS, ReactJS, PHP, MySQL, CodeIgniter, CakePHP,Yii, Laravel, WordPress, Joomla, Magento, JavaScript, jQuery, AJAX, , CSS3, XML
ACADEMIC QUALIFICATION
Master’s Degree, English Literature
PROFESSIONAL EXPERIENCE
Technical Trainer(.NET) [ IsDB-BISEW IT Scholarship Programme] Software Development
TRAINING & CERTIFICATION
IT Professional Diploma, Web-presence Solutions & Implementations, 2014 – 2015
Area of Interest
Web design and application development
Trainer Profile


Muntasir Mostafa Jamal
Technical Trainer
SKILLS
Computer Programming and Software Development
ACADEMIC QUALIFICATION
B.Sc in Computer Sciences and Engineering
International Islamic University of Chattogram
PROFESSIONAL EXPERIENCE
New Vision Information Technology Limited
Technical Trainer
From 2018 to till date
TRAINING & CERTIFICATION
C# and ASP.net from BITM
Android Apps Development From New Horizons CLC Chattogram
Area of Interest
Problem solving, Software Development, AI