Microsoft Excel for Professionals Part-1
COURSE PLAN
- Basic Concept About MS Excel
- Link Worksheet and workbook
- Visualizing Data with Charts
- Working with Multiple Workbook o Consolidate Data o Link Cell in different workbook o Merge Workbook
- Picture Lookup
- Dynamic Table
- Data Validation
- Common Financial Function (Say PMT)
- Conditional Formatting
- Data Entry Form Create (Without Macro)
- Dashboard
- Combo Box Create (Without Macro)
- Analyzing and Presenting Data
- Sparklines
- Scenarios
- What‐If Analysis
- Analysis‐Tool Pick
- Power View Add‐In
- Pivot Tables
- Pivot Charts
- Slicers
- Auditing Worksheet o Scenarios
- Sub‐Total
- Grand‐Total
- Export and Import Data
- Excel File Backup
- Project o Result Sheet o Electric Bill o Manual Attendance Sheet o Sales Report
- Age Calculator
COURSE DURATION
Total Course Duration: 30 Hours
Per Class Duration: 3 Hours
RELATED COURSES
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
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
