Microsoft Excel in Sinhala (සිංහල): From Basic to Pro

Begin the course with an introduction that outlines the motivation and the first lesson's focus, guiding learners through the main training structure.

Understand the Excel grid by exploring columns, rows, and cells, including column headers and row headers, and learn to select and address cells using column letters and row numbers.

Explore active cells and ranges in Excel, learn to use the name box to set a range like AC3, and manage rows, columns, and headers.

Understand basic data types in Excel, from integers and decimals to percentages, dates, times, and emails, and create a basic staff table with formatting like highlight fill and bold.

Learn to change data in a cell in Excel by editing values, using double-click, and applying highlight color to salary entries.

Learn how to move between cells and select data in Excel using arrows, tab, enter, and shift, while combining keyboard and mouse techniques for efficient data entry.

Practice moving between cells in Excel using arrow keys, enter, and tab, including shift-tab and shift-enter.

Learn data selection in Excel using keyboard shortcuts like shift and ctrl, along with arrow keys, to select cells, ranges, columns, rows, and extend selections across a sheet.

Master data selection in Excel using the go to and find and select tools to identify blank or empty cells, highlight ranges, and prepare data for calculations.

Learn how to use the search bar in Excel to access features and insert a pie chart, including modifying it and exploring related options.

Explore the name box and name manager in Excel to create and manage named ranges, and use cell references in formulas.

Master the Excel formula bar to create and edit formulas, use functions within text and numeric calculations, and double-click to edit formulas and see results.

Master tabs, groups, sliders, and the zoom bar in Excel, and customize the quick access toolbar. Learn ribbon navigation, formatting options, and essential features from basic to pro.

Begin your journey with an introduction to Excel in Sinhala. Explore functions, motivation, and a strong mindset as you set up the main section.

Master simple copy, cut, and drag operations in Excel to duplicate data, move cells, and paste with options. Learn formatting impacts such as font, color, borders, and basic formulas.

Learn essential Excel skills for copying, cutting, pasting, and dragging data within a cell range, including applying borders, formatting, and basic formula workflows to manage values efficiently.

Learn practical drag-and-drop techniques and keyboard shortcuts in Excel, including shifting, highlighting, copying, and replacing data with precise, efficient actions.

Learn to use the fill handle in Excel to create sequences, copy patterns, and perform basic calculations with formulas, including date and weekday automation.

Master inserting and deleting rows and columns in Excel using right-click options and keyboard shortcuts, including ctrl+z undo and ctrl+plus/ctrl+minus for quick edits.

adjust rows and columns in excel using autofit to quickly set row heights and column widths, format data, and improve readability.

Master hiding and unhiding rows, columns, and sheets in Excel, using right-click menus, renaming sheets, and applying tab colors for quick organization.

Master up, down, right, and left fill options in Excel using the fill handle and shortcuts. Apply fills, copy data, highlight cells, and work with unit prices and products.

Explore simple formulas and functions in Excel to calculate total sales, gross profit, net profit, and profit margin, and learn basic calculations.

Explore Excel basics with shortcuts and core functions, focusing on math and statistical functions, as an introduction to mastering Excel from basic to pro.

Explore the clipboard in detail, mastering copy and paste, formatting tools like format painter, and basic data formatting within Excel workbooks and sheets.

Explore how to format text in Excel's font group, applying bold, italic, underline, font size, colors, fills, borders, and highlights.

Explore calculations, formulas, and functions in Excel, including how to use the equal sign, cell references, and nested functions to calculate profit and margin percentages.

Learn to use the sum function to calculate totals in Excel, inserting the function and selecting ranges like B3 to B16 for revenue and sales.

Explore how to use excel's min, max, average, large, and small functions to analyze data, compute margins and revenues, format numbers, and highlight key values.

Master Excel's number formats, including general, decimal places, thousand separators, and negative numbers in parentheses, plus currency, accounting, date and time, percentage, fraction, scientific notation, and text formatting.

Learn to create sparklines and column charts in Excel by inserting data ranges and visualizing monthly performance across maths, science, English, history, and ICT.

Explore rounding concepts in Excel, including round, round up, round down, and integer and absolute functions, with practical examples.

Explore the Excel product function for simple multiplication, using unit price and units to calculate volumes, and apply length, width, and height.

Learn how to use the SumProduct function in Excel to multiply arrays and sum results for total sales, with practical examples of unit price and quantity.

Explore subtotal and filter in Excel to summarize data and apply conditional formatting, highlighting top profits and low values with visual cues.

Explore how to apply excel data filters in detail, including subtotal filters activated by conditional formatting, filtering by color, selected cells, or text and number criteria, with shortcuts like ctrl+shift+l.

Explore how to apply the Excel filter function to a dataset, selecting rows by conditions such as department, product, or quantity, and view complete or filtered results.

Convert your data into a table with headers, apply filters and a total row, and use slicers to dynamically filter by department such as sales 2024.

Learn to use the quotient and mode functions in Excel to work with numerators and denominators and perform mathematical and statistical tasks in a sheet.

Explore absolute and relative cell references in Excel, learn how to lock cells with dollar signs and the F4 toggle, and apply to addresses like A2 and B2.

Explore the Excel rank function and how it ranks student scores, handles equal ranks with the average option, and uses references to produce clean results.

Master the absolute function in Excel to compute absolute values, compare deviations from a target, and use related rounding techniques to enhance precision.

Explore Excel basics to pro concepts by examining math and statistical functions and text functions, and learn how text data analysis relates to large language models.

Explore right function, flash fill, and text to column to extract and split data by delimiter, creating invoice numbers, quarters, and employee identifiers.

Explore the left function in Excel to extract leftmost characters and use text to column with a dash delimiter, supported by flash fill.

Explore the mid function in Excel alongside left and right text functions to extract department names, use text to column with delimiters, and apply flash fill for clean data columns.

Explore how the Len function in Excel measures text length, counting characters and spaces, with practical examples from hello world text.

Explore how to apply len, left, and right functions in Excel to measure text length and extract substrings, then use text to column with delimiters like spaces and dashes.

Master the text to column option in detail, using delimiters and separators to split data into columns, apply flash fill, and format dates while extracting names and invoice numbers.

Master flash fill and auto fill in Excel to recognize patterns, apply custom lists, and automatically populate fields such as first name, last name, emails, and invoice numbers.

Master concat and text join to combine text, choose delimiters, manage spaces, and ignore empty cells for clean, flexible data in Excel.

Explore how the trim function cleans text by removing extra spaces. Learn to use the text function with trim to tidy values and manage leading, trailing, and internal spaces.

Learn how to use the Excel choose function with lookup and text functions to categorize items, assign colors, and map index numbers to options.

Explore Excel case functions: upper, lower, and proper, applied to text to transform case, with examples of related text functions in worksheets.

Learn how to use Excel's find and search text functions to locate text, define starting positions, handle case sensitivity, and apply wildcards for flexible matching.

Explore the substitute function in Excel to replace text within strings, using optional arguments, and manage case sensitivity with practical text transformations.

Explore the Excel replace function and other text functions to modify strings, mask numbers like last four digits, and control starting characters and positions for data manipulation.

Discover how the rept function in Excel repeats text to build patterns and characters, including stars, while integrating with other text functions like left for versatile formatting.

Learn to use the Excel text function to format dates, month names, numbers, and currency—including INR—with custom patterns like 0000 for IDs and invoices.

Explore introductory Excel concepts with a focus on text functions and date and time functions to build a solid foundation for proficient spreadsheet work.

Master Excel's date and time functions to recognize dates, convert them to serial numbers, and apply hour, minute, and second formats with standard and custom formats.

Learn to format dates in Excel, applying short and long date formats and creating custom date formats to display day, month, and year with highlight options.

Explore Excel's current date and time functions, including the now function, and learn shortcuts like ctrl+; and ctrl+shift+; to insert date and time.

Master Excel date and time functions by constructing dates from day, month, year and times from hour, minute, second, using current or manual inputs.

Explore deconstructing date and time with Excel functions, introducing day, month, year, current month, end of year, and text functions for date handling and formatting.

Explore the datedif function in detail, learning to set start and end dates, calculate year, month, and date differences, and apply related date functions for accurate calculations.

Explore date and time functions in Excel, including end-of-month calculations, starting and end dates, and net work days, with attention to holidays and week numbers for accurate scheduling.

Explore Microsoft Excel basics in Sinhala, focusing on financial functions for personal finances, company accounts, owner scenarios, bank calculations, and other essential Excel features.

Explore how to calculate loan amortization in Excel, using PMT to compute principal and interest and create an amortization schedule with present value and rate.

Discover how to use Excel's pv and fv functions to calculate present value and future value for loans, investments, and retirement plans, using rate, periods, and payments, including monthly compounding.

Explore NPV, IRR, and rate functions in Excel to analyze cash flows, discount rates, and investment projects.

Explore information functions in Excel, including true, false, logical checks, and handling blanks and errors. Apply conditional formatting rules to highlight cells matching specific criteria like true values or errors.

Explore the unique function in Excel, including creating unique values from first names and last names, leveraging arrays and data tables for automatic updates.

Master sorting data with sort and sortby functions in Excel to arrange records in ascending or descending order, using sort keys and index-based shortcuts across columns.

Learn to use excel's sequence function to generate numbering sequences across rows and columns, with options for start, step, and range.

Master Excel random functions using rand and randbetween to generate numbers between 0 and 1 or within any range, produce decimals by scaling, and even create random dates or colors.

Explore analytical functions and logical functions in the Excel training program, and learn their motivation and real-world use in the medical section.

learn to use the simple if function in excel to run a logical test. apply true/false outcomes, value if true, value if false, and conditional formatting to highlight results.

Master absolute cell reference in Excel by using dollar signs and the F4 toggle to fix a cell in formulas, enabling consistent calculations for commissions and pricing.

Explore and, or, and ifs functions to build logical tests in Excel, using true/false outcomes to evaluate sales conditions, customers, and commissions.

Learn to use if, and, or and the ifs function in Excel to build logical tests that calculate commissions from sales numbers and sales value, guided by rating.

Master sumif, sumifs, averageif, and averageifs to compute total sales and commissions by sales rep and location, using criteria ranges and conditional calculations.

Learn how to use the count, counta, and countblank functions in Excel to count numbers, non-empty cells, and blanks, and see how spaces and dates affect results.

Explore how to use Countif and Countifs functions in Excel to count cells meeting specific criteria, using ranges, criteria ranges, and quotes within a data set.

Explore the if error function in Excel as part of the logical functions section, and learn how to handle calculation errors to keep your spreadsheets robust.

learn how the not function in excel inverts true and false, and apply it within if statements and other logical tests.

Explore the basics of Excel lookup functions in this introductory module, guiding you through lookup techniques, workbook and worksheet structure, and essential function usage.

Master the vlookup function in Excel to retrieve data from a table by matching a lookup value in the first column, with true or false options.

Learn how to use Vlookup to retrieve selling prices by barcode, apply discounts, and manage a master price table with absolute references in Excel.

practice a vlookup exercise solution in excel, using the item master and barcode data to pull selling price, unit cost, total cost, and profit.

Explore how to use simple xlookup to replace vlookup, covering lookup values, return arrays, optional arguments, and default and custom not found messages in Excel.

Explore Xlookup in detail, compare it with Vlookup, and learn to retrieve selling prices from the item masters using barcode data and absolute cell references.

Master Xlookup and Vlookup through an exercise that retrieves selling price, unit cost, and unit price from a barcode item master to calculate total cost.

Explore the differences between xlookup and vlookup in Excel, and learn how to group data and apply exact and approximate matches for efficient lookups.

Explore index and match fundamentals, learn to combine index and match for lookups, compare with xlookup, and apply to commissions using array and lookup concepts.

Explore how the offset function in Excel shifts references across rows and columns to build ranges, and apply it with functions like sum, average, and count to analyze data.

Explore transpose and paste in excel, using the transpose function, copy-paste workflows, and paste special, with lookups (xlookup, vlookup, index, match), offset concepts, and Colombo and February figures.

Master row and column functions, lookup functions, and cell and range references to manage positions and formulas across rows and columns in Excel.

Explore the address function in excel, mastering absolute and relative references, how to fix row or column positions like B3 and G13, and using indirect to reference current items.

Explore how the indirect function converts text to valid references, enabling dynamic lookups and address references in Excel. Learn practical examples and the role of absolute references.

Explore how to create and customize hyperlinks in Excel using the hyperlink function and indirect function addresses, linking to websites, files, PDFs, and in-sheet actions for practical navigation.

Explore Microsoft Excel basics to pro levels in Sinhala, focusing on key features and functions. Discover essential sections and simple explanations of Excel capabilities.

Master conditional formatting in Excel with highlight rules, color fills, data bars, and color scales to analyze revenue across 2024 and 2023 using top, bottom, and date rules.

Master conditional formatting in Excel to automatically border cells, apply highlight colors, and use absolute references across rows and columns.

Learn to create column, pie, and line charts in Excel to visualize revenue, cost of goods sold, and operating expenses on an income statement, with chart customization.

Learn to create a simple pivot table in Excel, converting data into a summarized view of sales, locations, products, and profits, and update or filter it for quick insights.

Learn to create a pivot table from a range or a table, insert and position it in your worksheet, and refresh or convert data to a table for analysis.

Explore building dashboards from pivot tables in Excel, create pivot charts, and design data-driven visuals with slicers and charts to analyze sales, profit, and regional performance.

Insert shapes, pictures, and icons in Excel. Create circles, ovals, squares, and rectangles; adjust fill, text fill, outlines, and transparency.

Explore how to use SmartArt in Excel to visualize processes, hierarchies, and the budgeting cycle, including inserting diagrams, designing layouts, and building organizational charts.

Insert sparklines to visualize win or loss trends in sales data, highlight highs and lows from January to June, and apply color cues to improve interpretation.

Learn to create and configure slicers for pivot tables and tables in Excel, including inserting slicers, adjusting size and color, and managing slicer items by region and product.

Learn to set print titles to repeat header rows, adjust layout and margins, choose orientation, and manage print area for Excel worksheets.

Explore how to get data from different sources, including PDF, websites, CSV and text files, and import it into Excel as tables and data connectors.

Learn to identify and remove duplicate values in Excel using conditional formatting to highlight duplicates and the Remove Duplicates tool, selecting columns and finalizing with the OK button.

Learn to apply data validation in Excel to restrict inputs, create drop-down lists, and enforce rules for numbers, dates, times, text length, and dependent lists.

Explore data validation in Excel by building dropdown lists and dependent dropdowns, using named ranges and the indirect function to drive showroom type and color selections.

Learn to consolidate data across sheets in Excel using the consolidate feature, link source data, and align top row and left column headings for monthly sales and commissions.

Apply what-if analysis and goal seek to explore profit, revenue, and break-even by adjusting units, unit prices, and costs, using data table options.

Explore what-if analysis and data tables in Excel, including how to use data table with row and column inputs to model scenarios like monthly payments and future value.

Learn to group and ungroup data in Excel, hide and collapse rows, and highlight totals and first-quarter revenue for clear data organization.

Learn how to use freeze pane to freeze the top row or first column while scrolling through data.

Explore formula auditing in Excel by tracing dependents and precedents, evaluating formulas, and validating calculations for sales value, unit amounts, and profit formulas.