Basic Excel Course + Lookup Function

Excel made easy for everyone

Created byMKCL India

Last updated 2/2019

English

English [Auto],

What you'll learn

The students will learn the basics which are needed to work on excel

Course content

1 section • 25 lectures • 1h 41m total length

Creating a Loan Calculator-18:38
Learn to build a loan calculator in a spreadsheet with Excel, using formulas to compute monthly payments and interest, format data, and create loan-specific worksheets.
Creating a Loan Calculator-28:19
Learn to build a loan calculator in Excel by inserting data, pictures, shapes, symbols, and formulas, formatting cells, creating charts, and calculating totals and payments.
Creating a Loan Calculator-33:15
Apply conditional formatting, rename and color sheets, and copy and paste worksheets to build a loan calculator workflow in Excel.
Function Basics5:12
Define function and its parts, learn how to insert functions and construct arguments using cell references, and explore categories and syntax in Excel for calculations.
Logical Functions18:31
Learn to use Excel logical functions including if, not, and, or with nested ifs. Apply sum, average, auto sum, and sumifs to analyze orders and inventory.
Mathematical Functions12:20
Master essential Excel functions for mathematics, including average, mode, median, area and volume calculations, and rounding, plus mod, int and rand between.
Lookup and Reference Functions9:34
Master Excel lookup and reference functions by using choose, index, and match for flexible outputs across a ranked candidate table with written test scores.
LOOKUP, VLOOKUP, and HLOOKUP Functions19:03
Explore essential Excel lookup and reference functions, including vlookup, hlookup, and lookup, plus the cell function, isblank, iserror, iferror, offset, indirect, and dynamic named ranges to build dynamic formulas.
Introduction to Advanced charts1:38
Learn how to create advanced charts in Excel and apply the lookup function within a free basic Excel course.
Line chart0:52
Explore line charts in Excel to display data meaningfully and show trends over time, including revenues across regions over five years.
Column chart0:26
Master column charts to compare revenues across regions for a specific period and to contrast a single data category among multiple sub items.
Pie chart0:30
Explore how a pie chart shows distribution and proportion, with each region’s contribution to the total revenue represented in the overall pie.
Area Chart0:47
Learn how area charts in Excel extend line charts by shading the area below the plot line to reveal trends over time and how totals summarize parts to a whole.
Converting area chart into line chart0:38
Convert a line chart to an area chart by selecting the chart, opening the design tab, choosing change chart type, selecting area, and confirming the change.
What is regression analysis ?1:01
Explore regression analysis in Excel to study the association between two value sets, such as advertising expenditures and sales; start with a scatter plot using an x or y chart.
What are chart templates0:52
Learn how chart templates reuse a customized chart by applying a template when creating a chart, and how to change an existing chart’s type using templates stored in charts folder.
What are sparklines0:23
Explore sparklines, tiny charts embedded in worksheet cells that visually represent data. Learn how these line charts are background elements, not separate objects, and enhance data insight.
Sparklines vs charts1:15
Compare sparklines and charts to visualize large data sets; place sparklines next to each row to reveal relationships and trends, while charts offer greater detail and cross-series comparisons.
Data in hidden rows and columns0:22
Learn to display data from hidden rows and columns in Excel using the show data in hidden rows and columns option and the empty cell settings window for spark lines.
Introduction to Pivot chart and tables0:36
Explore how pivot charts and pivot tables transform data into interactive insights in Excel. Learn to use the lookup function within Excel to efficiently retrieve data.
Creating pivot charts1:04
Create pivot charts from a pivot table to visualize monthly totals by sales person, using a slicer, select chart type, insert the chart, and drag to position.
Creating pivot table1:06
Analyze employee data with a pivot table in Excel by selecting the range and inserting it into a new worksheet, organizing fields like resignation date and program.
Multiple fields in row, column or data section2:22
Learn to build a pivot table that counts months served by gender, placing gender in columns and employee codes in values, using value field settings to count.
Creating pivot charts1:03
Create pivot charts to present data with various chart formats, enabling analysis of attrition patterns and counts of resignations, such as the 11th month peak.
Creating and using calculated fields2:04
Create and use calculated fields in pivot tables to count resignations by program, adjust field settings, and present results with charts.

Requirements

Interest to Learn
Microsoft Excel Installed in their computers or laptop

Description

Microsoft Excel is one of the world's most widely used spreadsheet applications, designed to help users organize, analyze, calculate, and visualize data efficiently. It uses a grid of cells arranged in numbered rows and lettered columns, making it easy to enter, manage, and manipulate data. Excel offers a rich collection of built-in functions and formulas to perform arithmetic, statistical, logical, financial, engineering, and text-based calculations. It also enables users to present data through charts, graphs, histograms, and basic three-dimensional visualizations, making information easier to understand and communicate. Advanced features such as PivotTables allow users to summarize, analyze, and explore large datasets from multiple perspectives, helping them identify trends, patterns, and valuable business insights.

This course is designed to provide learners with a strong foundation in Microsoft Excel by covering the essential concepts and features required for everyday professional use. Through practical, hands-on exercises and real-world examples, learners will gain confidence in creating worksheets, formatting data, using formulas and functions, sorting and filtering information, generating charts, and working with PivotTables. Since Microsoft Excel is one of the most essential productivity tools used across almost every industry, mastering its fundamentals is a valuable skill. By the end of this course, learners will be well-equipped to use Excel effectively for academic, personal, and workplace tasks, laying a strong foundation for more advanced data analysis and reporting.

Who this course is for:

Anyone who wants to learn working with Excel