Excell

15

Years of
Experience

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365

Overview of this course | Introduction to AI | How to create basic AI application (Chat bot using DialogFlow)
How to install Python & Libraries | Basics of python Programming for AI.

Intro to Excel
Creating Tables
Filter & Sort Data

Data Cleaning
Merging multiple sheets into one

IF condition
Lookup Formulas Array Formulas
Conditional Formula
Text analysis
Sentiment analysis
Exploratory data analysis
Date formulas
Error Handling

Creating Pivot table
Multiple Pivot relationships
Calculations in Pivot
Data Slicing Adv.
Pivot table

Choosing charts
Formatting charts
Conditional Chart
Interactive charts

Data validation
Creating templates
Publishing to the web
Form controls
Custom ribbons

Excel VBA Object Model
Why Collections are a VBA Essential
VBA versus Worksheet Functions
Table of Contents(TOC) in one click
Sales regional reporting Tool
Invoice generation tool

Introduction to Dashboard
Process of Different Dashboards for all types of data {Sales Dashboard, Employee Dashboard, etc.}

Pivot table for consolidation of bulk data with some conditions
Multiple Google Forms data to Single Master Sheet for bulk data
Displaying Sheet data on the website with filers & Search

Overview of BI Tools to analyze data effectively
How to handle sheets from the Python program
Integration of Excel for various business purposes

FOR MORE INFORMTION CALL US 24/7

Thank you for reaching out to NGCC Software Technologies ! Please fill the form right. Our team will contact you shortly.