This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
What you'll learn?
- Learn Microsoft Excel from Beginner to Expert
- Learn how to Analyze Data for all type works in profit or nonprofit
- Learn Data Visualization on Excel Charts to drive effectively decision making
- Learn how to utilize Pivot Tables and Charts in data analysis skill
- Learn Formulas & Functions for project calculations for all career sectors
- Understand Formatting and Conditional Format to highlight information
- Understand the Mathematical Functions to use in engineer careers
- Understand the Logical Functions for using in business careers
- Understand the Lookup Functions to quickly find correlate data
- Collaborate on Excel workbooks at the same time with co-authoring
Course Overview
Pre-requisites
- You need to have a computer with Microsoft Excel installed
Target Audience
- This masterclass is for Engineers, Data Scientists, Data Analysts, Students or Teachers and Researchers.
- Anyone who work in NGOs, Private Sectors or Government
Curriculum 46 Lectures 02:04:29
-
Section 1 : Introduction
-
Section 2 : Basic Formatting
- Lecture 1 :
- Available Number Format
- Lecture 2 :
- Use conditional formatting to highlight information
- Lecture 3 :
- Align or rotate text in a cell
- Lecture 4 :
- Change the format of a cell
- Lecture 5 :
- Copy cell formatting with the Format Painter
- Lecture 6 :
- Add a watermark in Excel
- Lecture 7 :
- Display or hide zero values
- Lecture 8 :
- Create or delete a custom number format
-
Section 3 : Creating Tables and Data Structure
- Lecture 1 :
- Create and format tables
- Lecture 2 :
- Sort data in a table
- Lecture 3 :
- Filter data in a range or table
- Lecture 4 :
- Total the data in an Excel table
- Lecture 5 :
- Use slicers to filter data
-
Section 4 : Using Formulas & functions for calculations
- Lecture 1 :
- Basic Formulas
- Lecture 2 :
- SUM function
- Lecture 3 :
- SUMIF and SUMIFS
- Lecture 4 :
- COUNTIF and COUNTIFS function
- Lecture 5 :
- IF statement
- Lecture 6 :
- VLOOKUP
- Lecture 7 :
- Date and Time
- Lecture 8 :
- Combine text from two or more cells into one cell
- Lecture 9 :
- Extract Text from Cell (Left and Right)
- Lecture 10 :
- Count number of Characters (Len)
- Lecture 11 :
- Function (Left, Right and Len)
- Lecture 12 :
- Min and Max
- Lecture 13 :
- Descriptive Analysis ( Statistic Formula)
-
Section 5 : Practice Data Visualization on Excel Chart
- Lecture 1 :
- Create a chart from start to finish
- Lecture 2 :
- Add or remove titles in a chart
- Lecture 3 :
- Format elements of a chart
- Lecture 4 :
- Show or hide a chart legend or data table
- Lecture 5 :
- Add a trend or moving average line to a chart
- Lecture 6 :
- Analyze your data instantly
- Lecture 7 :
- Update the data in an existing chart
- Lecture 8 :
- Use sparklines to show data trends
- Lecture 9 :
- Visualize Data on Map
-
Section 6 : Analyzing Data on Pivot Table and PivotChart
- Lecture 1 :
- Create a PivotTable from worksheet data
- Lecture 2 :
- Refresh PivotTables
- Lecture 3 :
- Work with PivotTable Values
- Lecture 4 :
- Work with calculating values in a PivotTable
- Lecture 5 :
- Create Calculated Fields
- Lecture 6 :
- Create a PivotChart
- Lecture 7 :
- Use slicers to filter PivotTable data
- Lecture 8 :
- Create a PivotTable timeline to filter dates
- Lecture 9 :
- Connecte PivotTables from other sources
- Lecture 10 :
- Change the source data for a PivotTable
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion. -
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
736 Course Views
4 Courses
I am Nhoeb Khan, a professional Monitoring and Evaluation Specialist,
15 year experiences 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 Management, Monitoring and Evaluation sector in multiple programs. I have started working since 2006 from the bottom level of position to the top level of position. Please check my draft experiences from the present down to the past, in the following:
• Worked as M&E specialist at ECODIT LLC for USAID Project title as USAID CGFA.
• Worked as Senior M&E, Data science and Research Specialist at USAID Tech for Green Cities
implemented by Institute for Development Impact (I4DI) owned HQ in Washington DC.
• Worked as Regional M&E Manager at USAID CMEP implemented by University Research Co.,LLC
(URC) in Cambodia.
• Worked as Senior M&E Officer at CARE Cambodia based in Ratanakiri province in Cambodia.
• Worked as 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.