Microsoft Excel Basic to Advanced
It is utilized to build text, number, and formula grids that aid in data
manipulation to track expenditures, financial outcomes, and other things.
The following list includes the topics discussed in the Microsoft Excel course
syllabus:
Excel tutorial
Text to Columns
Concatenate
The Concatenate Function
The Right Function with Concatenation
Absolute Cell References
Data Validation
Time and Date Calculations
Conditional Formatting
Exploring Styles
Clearing Formatting
Using Conditional Formatting to Hide Cells
Using the IF Function
Pivot Tables
Creating a Pivot Table
Specifying PivotTable Data
Changing a PivotTables Calculation
Filtering and Sorting a PivotTable
Creating a PivotChart
Grouping Items
Updating a PivotTable
Formatting a PivotTable
Using Slicers
Charts
Creating a Simple Chart
Charting Non-Adjacent Cells
Creating a Chart Using the Chart Wizard
Modifying Charts
Moving an Embedded Chart
Sizing an Embedded Chart
Changing the Chart Type
Chart Types
Changing the Way Data is Displayed
Moving the Legend
Formatting Charts
Adding Chart Items
Formatting All Text
Formatting and Aligning Numbers
Formatting the Plot Area
Formatting Data Markers
Pie Charts
Creating a Pie Chart
Moving the Pie Chart
Adding Data Labels
Exploding a Slice of a Pie Chart
Data Analysis − Overview
types of Data Analysis
Data Analysis Process
Working with Range Names
Copying Name using Formula Autocomplete
Range Name Syntax Rules
Creating Range Names
Creating Names for Constants
Managing Names
Scope of a Name
Editing Names
Applying Names
Using Names in a Formula
Viewing Names in a Workbook
Copying Formulas with Names
Difference between Tables and Ranges
Create Table
Table Name
Managing Names in a Table
Table Headers replacing Column Letters
Propagation of a Formula in a Table
Resize Table
Remove Duplicates
Convert to Range
Table Style Options
Table Styles
Cleaning Data with Text Functions
Removing Unwanted Characters from Text
Extracting Data Values from Text
Formatting Data with Text Functions
Date Formats
Conditional Formatting
Sorting
Filtering
Lookup Functions
Pivoting
Python
One may categorize Python as advanced object-oriented programming. With
its flexible binding, high-level built-in structures, and language, it is the
program that lends itself to developing the best. Packages and modules that
guarantee program modularity and programmability are supported.
The Subjects Covered by the Python Course Curriculum Are Listed
Below:
File operations using Python
Looping in Python
Python Syntax
Functions
Function Arguments, and Control Flow
Working with Lists
Python Modules
Decorators and generators
Using Dictionaries
Errors and Exception Handling
Comparisons and Operators
The print statement
Comments
Python Data Structures & Data Types
String Operations in Python
Simple Input & Output
Simple Output Formatting
Deep copy
Shallow copy
Operators in python
SQL
Databases may be contacted using a language called SQL, or Structured
Query Language. Utilizing the Relational Database Management System, aids
in the extraction, manipulation, and management of data (RDMS). This
programming language is supported by several different database systems,
including Oracle, MySQL, and others.
The Following List Includes the Subjects Taught in the SQL Course
Syllabus:
Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Use Sub-Queries to Solve Queries
The SET Operators
Data Manipulation Statements
Creating and Managing Tables Using DDL Statements
Other Schema Objects
Control User Access
Management of Schema Objects
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in Different Time Zones
Retrieve Data Using Sub-queries
Regular Expression Support
Power BI
Data extraction and visualization are both made possible by the cloud-based
analysis tool Power BI. To provide you with a complete picture of the
information assets in your firm, Power BI combines data from several
sources.
The Following List Includes the Subjects Taught in the Power Bi
Course Syllabus:
Module 1: Introduction to Power BI
Get Started with Power BI
Overview: Power BI concepts
Sign up for Power BI
Overview: Power BI data sources
Connect to a SaaS solution
Upload a local CSV file
Connect to Excel data
Connect to a sample
Create a Report with Visualizations
Explore the Power BI portal
Module 2: Viz and Tiles
Overview: Visualizations
Using visualizations
Create a new report
Create and arrange visualizations
Format a visualization
Create chart visualizations
Create a report using text, a map, and gauge visualizations.
Use a slicer to filter visualizations
Sort, copy, and paste visualizations
From the collection, save and utilize a unique image.
Module 3: Reports and Dashboards
Modify and Print a Report
Rename and delete report pages
Set visualization interactions
Print a report page
Send a report to PowerPoint
Create a Dashboard
Create and manage dashboards
Attach a report tile to a dashboard.
Pinning a dashboard’s live report page
An additional dashboard tile is pinned.
Attach an Excel component to a dashboard.
Manage pinned elements in Excel
Add a tile to a dashboard
Build a dashboard with Quick Insights
Set a Featured (default) dashboard
Ask Questions about Your Data
Ask a question with Power BI Q&A
Tweak your dataset for Q&A
Enable Cortana for Power BI
Module 4: Publishing Workbooks and Workspace
Share Data with Colleagues and Others
Publish a report to the web
Manage published reports
Share a dashboard
Create an app workspace and add users
Use an app workspace
Publish an app
Create a QR code
Embed a report in SharePoint Online
Module 5: Related Tables and Some other Power BI Components
Use Power BI Mobile Apps
Get Power BI for mobile
Use workspaces in the mobile app
Sharing from Power BI Mobile
Use Power BI Desktop
Install and launch Power BI Desktop
Get data
Reduce data
Transform data
Relate tables
Utilize the Power BI service to obtain Power BI Desktop data.
Publish a report to your desktop using the Power BI service.
Module 6: DAX functions
New Dax functions
Date and time functions
Time intelligence functions
Filter functions
Information functions
Logical functions
Math & trig functions
Parent and child functions
Text functions
