Skip to main content
  1. Data Science Courses/

Microsoft Excel

·228 words·2 mins· loading · ·
ML Courses Machine Learning ML Courses

On This Page

Table of Contents
Share with :

Microsoft Excel

Microsoft Excel
#

Introduction to Excel
#

Basic
#

  • Microsoft Excel Fundamentals
  • Introduction to Interface
  • Discovering Shortcuts
  • Entering and Editing Text and Formulas
  • Excel Data Validation
  • Excel List Functions
  • Slicing and Dicing Data – Sort and Filter
  • Cell Referencing and Text Functions
  • Passwords and Naming Files
  • Inserting Images and Shapes into an Excel Worksheet
  • Modifying an Excel Worksheet
  • Protecting Excel Worksheets and Workbooks

Working with Cells
#

  • Cell Referencing and Text Functions
  • Common Errors in Excel

Working with Formulae
#

  • Introduction to Formulae
  • Logical Formulae
  • Lookup Functions
  • Text Based Functions
  • Complex Functions
  • Conditional Functions

Working with Files
#

  • Importing and Exporting Data
  • Importing Data from Text Files
  • Delimited Files
  • Auditing an Excel Worksheet

Printing & Formatting
#

  • Formatting Data in an Excel Worksheet
  • Preparing Weekly Report
  • Printing an Excel Worksheet
  • Printing and Page Layout
  • Report Making II: Conditional Formatting
  • Report Making III: Advanced Formatting

Advance Excel
#

Charts
#

  • Types of Charts
  • Charts
  • Creating Basic Charts in Excel
  • Creating and Formatting Charts

Pivot
#

  • Creating a Pivot Table
  • Analyzing Data in a Pivot Table
  • Filtering Data in a Pivot Table

Automation
#

  • VBA
  • Automating Repetitive Tasks in Excel with Macros
  • Preparing and Cleaning Up Data with VBA

Analysis
#

  • Mastering Excel “What If?” Tools
  • Working with Large Sets of Excel Data
  • VLOOKUP-Linking Data from Multiple Files & Tables

Visualization and EDA in Excel
#

Limitations of Excel
#

Dr. Hari Thapliyaal's avatar

Dr. Hari Thapliyaal

Dr. Hari Thapliyal is a seasoned professional and prolific blogger with a multifaceted background that spans the realms of Data Science, Project Management, and Advait-Vedanta Philosophy. Holding a Doctorate in AI/NLP from SSBM (Geneva, Switzerland), Hari has earned Master's degrees in Computers, Business Management, Data Science, and Economics, reflecting his dedication to continuous learning and a diverse skill set. With over three decades of experience in management and leadership, Hari has proven expertise in training, consulting, and coaching within the technology sector. His extensive 16+ years in all phases of software product development are complemented by a decade-long focus on course design, training, coaching, and consulting in Project Management. In the dynamic field of Data Science, Hari stands out with more than three years of hands-on experience in software development, training course development, training, and mentoring professionals. His areas of specialization include Data Science, AI, Computer Vision, NLP, complex machine learning algorithms, statistical modeling, pattern identification, and extraction of valuable insights. Hari's professional journey showcases his diverse experience in planning and executing multiple types of projects. He excels in driving stakeholders to identify and resolve business problems, consistently delivering excellent results. Beyond the professional sphere, Hari finds solace in long meditation, often seeking secluded places or immersing himself in the embrace of nature.

Comments:

Share with :

Related

AI for Prospective Email Writing
·491 words·3 mins· loading
ML Courses TensorFlow Lite Android Development
AI for Prospective Email Writing # Course Objective # Equip participants with the skills to draft …
GenAI for Cybersecurity
·526 words·3 mins· loading
ML Courses TensorFlow Lite Android Development
GenAI for Cybersecurity # Course Overview: Here’s a simplified and enriched version of your course …
Train Tensorflow Lite Models for Android
·852 words·4 mins· loading
ML Courses TensorFlow Lite Android Development
Course Title: Developing Solutions with Agentic AI # Course Outline # Module 1: Introduction to …
AI Powered Account Management Strategies
·421 words·2 mins· loading
ML Courses Artificial Intelligence Account Management
Program Outline: AI Powered Account Management Strategies # Duration: # 2 Days Course Audience: # …
Generative AI for Client and Stakeholder Engagement
·412 words·2 mins· loading
ML Courses Generative AI Stakeholder Engagement
Program Outline: AI Powered Client and Stakeholder Engagement # Duration: # 2 Days Course Audience: …