Microsoft Excel Masterclass
Microsoft Excel for Beginners to Experts | A Comprehensive Guide to MS Excel
Office Productivity,Microsoft,Excel
Lectures -42
Resources -5
Duration -2 hours
Lifetime Access

Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Microsoft Excel is a versatile spreadsheet and data analysis tool with several features. Attending this course is an excellent approach to learning Excel quickly and efficiently.
Learning this course will boost your marketability. Attending this course can teach you more sophisticated Excel techniques that will help you stand out in the job market.
What you'll improve after learning this course.
You will obtain advanced Excel training that focuses on a variety of important abilities that may be applied and appreciated in practically every job within a business.
You will be able to learn:
Visualize, modify, and assess data.
Create equations that will help you to deliver additional information about critical corporate activities such as workflow, project efficiency, financial estimates and budgets, and even inventory levels and utilization.
Create an easy-to-read data collection that higher management may utilize to examine current initiatives or conditions in the firm.
Create spreadsheets that better organize data and offer a clearer view of the information entered.
Maintain, organize, and balance complex financial and inventory accounts.
Create tracking systems for different departments and operations, including various workflow processes.
Pivot Tables and charts will allow you to quickly identify trends in large datasets and inform business decisions.
Who this course is for:
- This masterclass is for Engineers, Data Scientists, Data Analysts, Students or Teachers, and Researchers.
- Anyone who works in NGOs, the Private Sectors, or the Government.
Goals
Learn Microsoft Excel from Beginner to Expert.
Learn how to Analyze Data for all types work in a profit or nonprofit.
Learn Data Visualization on Excel Charts to drive decision-making effectively.
Learn how to utilize Pivot Tables and Charts in data analysis skills.
Learn Formulas & Functions for project calculations for all career sectors.
Understand Formatting and Conditional formatting to highlight information.
Understand the Mathematical Functions to use in engineering careers.
Understand the Logical Functions for use in business careers.
Understand the Lookup Functions to quickly find correlated data.
Collaborate on Excel workbooks at the same time with co-authoring.
Prerequisites
You need to have a computer with Microsoft Excel installed.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction Video 01:19 01:19
Basic Formatting
8 Lectures
Creating Tables and Data Structure
5 Lectures
Formulas & functions for calculation
10 Lectures
Data Visualization on Excel Chart
8 Lectures
Analyzing Data on Pivot Table and PivotChart
10 Lectures
Instructor Details
Nhoeb Khan
I am Nhoeb Khan, a professional Monitoring and Evaluation Specialist,
15 year of experience in many development projects. I will develop fantastic courses for you to improve your career !
My Background
I have more than 12 years of experiences related to all sectors in NGO or INGO, particularly in the management, monitoring, and evaluation sectors in multiple programs. I have been working since 2006, from the bottom level of a position to the top level of a position. Please review my draft experiences from now to the past in the following:
• Worked as an M&E specialist for USAID at ECODIT LLC on the USAID CGFA project.
• Worked as Senior M&E, Data science and Research Specialist at USAID Tech for Green Cities
The Institute for Development Impact (I4DI) headquarters in Washington, DC, carried out the initiative.
• Worked as Regional M&E Manager at USAID CMEP implemented by University Research Co.,LLC
(URC) in Cambodia.
• Worked as a senior M&E officer at CARE Cambodia, based in Ratanakiri province in Cambodia.
• Worked as a regional M&E and program specialist at the Consortium of 4 NGOs in Battambang, Banteay Mean Chey and Pursat provinces in Cambodia.
• Worked as an M & E Assistant at USAID/Cambodia HARVEST for 4 years, USD 60 million project in Cambodia
around the Boeng Tonle Sap Lake region.
Contact Me
Please feel free you reach out to me via email: nhoebkhan@gmail.com or Linkedin: https://www.linkedin.com/in/nhoeb-khan/
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now