Scan QR
Learn Microsoft EXCEL from basic to advanced.
Group or individual classes
Home Visit
Excel අමාරුද? සරලව මුල සිට, ඔබගෙ අවශ්යතාව අනුවම.
අදම කතාකරන්න.
Contents
• Basic Formulas
• Filtering
• Vlookup, Hlookup, Index
• Working with forms
• Add data labels
• Apply data validation to cells
• Assign a macro to an object, graphic, or control
• Basic Numeric Information
• Change the layout of chart elements manually
• Conditional Formatting
• Conditional Functions
• Create a chart from start to finish
• Create a macro by using Microsoft Visual Basic
• Create a Power View report
• Data table basics
�...
Scan QR
Learn Microsoft EXCEL from basic to advanced.
Group or individual classes
Home Visit
Excel අමාරුද? සරලව මුල සිට, ඔබගෙ අවශ්යතාව අනුවම.
අදම කතාකරන්න.
Contents
• Basic Formulas
• Filtering
• Vlookup, Hlookup, Index
• Working with forms
• Add data labels
• Apply data validation to cells
• Assign a macro to an object, graphic, or control
• Basic Numeric Information
• Change the layout of chart elements manually
• Conditional Formatting
• Conditional Functions
• Create a chart from start to finish
• Create a macro by using Microsoft Visual Basic
• Create a Power View report
• Data table basics
• Define and solve a problem by using Solver
• Filtering Information
• Handle empty cells or zero values
• Information Functions
• Insert subtotals in a list of data in a worksheet
• PivotTable data analysis using a Data Model
• Protect a worksheet with or without a password
• Record a macro
• Scenario basics
• Share workbook , Merging copies of a shared workbook
• Show or hide data markers
• Sorting
• Sparkline
• Speed up calculation on a worksheet that contains data tables
• Statistical Functions
• Switch between various sets of values by using scenarios
• Text Functions
• Use Goal Seek to find the result you want by adjusting an in
• Using Common Built-In Functions
• Using Hyperlinks
• Working with Named Ranges
• Many more...