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.

1 minute read

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

Updated:

Leave a comment

You may also enjoy