All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
7 days left at this price!

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
Get Unlimited Learning Access
$29
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to 11,000+ Courses
  • Ads free experience Courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Direct Support
  • Email & Chat Support
  • Cancel Anytime
$29
$29
$29
  • 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

Why learn this course
 
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.

  • You need to have a computer with Microsoft Excel installed
  • This masterclass is for Engineers, Data Scientists, Data Analysts, Students or Teachers and Researchers.
  • Anyone who work in NGOs, Private Sectors or Government
View More...
  • Section 1 : Introduction 1 Lectures 00:01:19

    • Lecture 1 :
  • Section 2 : Basic Formatting 8 Lectures 00:25:40

    • 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 5 Lectures 00:13:26

    • 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 13 Lectures 00:49:38

    • 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 9 Lectures 00:15:17

    • 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 10 Lectures 00:19:09

    • 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
  • 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?

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.

View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.