MS EXCEL
Introduction
Introduction to Microsoft Excel
How to Add, Subtract, Multiply, Divide in Excel
Excel Data Validation, Filters, Grouping
Introduction to formulas and functions in Excel
Logical functions (operators) and conditions in Excel
Visualizing data using charts in Excel
Advance Excel:
Import CSV Data (Text) into Excel
Import MS Access Data into Excel
Import SQL Database Data into Excel
Pivot Tables in Excel
Creating Advanced Charts in Excel
Excel in the cloud: Office 365
CSV vs Excel (.xls)
Excel VLOOKUP
Excel HLOOKUP
Excel ISBLANK
SUM,SUMIF,COUNT,COUNTIF,INDEX, MATCH,
Sparkline in Excel with EXAMPLES
Functions in EXCEL
Import XML Data into Excel
OUR COURSES
SQL SERVER
SQL is one of the most popular RDBMS (Relational Database Management System) due to its stability, features, robustness, scalability, security and platform
POWER BI
Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can cre...
MSBI(SSIS,SSAS,SSRS)
Business Intelligence or BI is nothing but its process of converting data into information. Data and information meaning look similar but both are different, data is a technical format.
MS EXCEL
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programm....