Statology
  • About
  • Course
  • Basic Stats
  • Machine Learning
  • Software Tutorials
    • Excel
    • Google Sheets
    • MongoDB
    • MySQL
    • Power BI
    • PySpark
    • Python
    • R
    • SAS
    • SPSS
    • Stata
    • TI-84
    • VBA
  • Tools
    • Calculators
    • Critical Value Tables
    • Glossary
Shamima Sultana

Shamima Sultana is a technical content specialist and data analyst with a B.Sc. in Computer Science and Engineering, currently pursuing an M.Sc. in Computational Engineering at FAU Erlangen-Nürnberg, Germany. She specializes in Excel, Power BI, Power Query, VBA, and Google Sheets, and has written over 400 technical articles and reviewed more than 1,500 as a team leader and project manager. Her work focuses on dashboards, reporting, data analysis, and automation.

www.linkedin.com/in/shamima-sultana-306899199/
How to Use Google Sheets’ REGEXEXTRACT Function (Versus Excel’s Text Functions)
Google Sheets

How to Use Google Sheets’ REGEXEXTRACT Function (Versus Excel’s Text Functions)

Posted on September 26, 2024September 26, 2024 by Shamima Sultana

Google Sheets’ REGEXTRACT is a powerful and robust function that extracts matching substrings from a string/text. Excel offers multiple text functions to extract specific text…

Mastering Google Sheets’ IMPORTHTML Function (Versus Excel’s Web Scraping Techniques)
Google Sheets

Mastering Google Sheets’ IMPORTHTML Function (Versus Excel’s Web Scraping Techniques)

Posted on September 25, 2024 by Shamima Sultana

Google Sheets offers multiple functions for web scraping. IMPORTHTML function is the most useful and straightforward function to import data. This function imports an entire…

How to Use Google Sheets’ GOOGLEFINANCE Function (Versus Excel’s Stock Data Functions)
Google Sheets

How to Use Google Sheets’ GOOGLEFINANCE Function (Versus Excel’s Stock Data Functions)

Posted on September 24, 2024 by Shamima Sultana

Google Sheets’ GOOGLEFINANCE function and Excel’s stock data functions extract real-time financial data from stock markets. Both functions serve similar purposes providing access to real-time…

How to Use Google Sheets’ QUERY Function for Pivot Table-like Analysis (Versus Excel’s PivotTables)
Google Sheets

How to Use Google Sheets’ QUERY Function for Pivot Table-like Analysis (Versus Excel’s PivotTables)

Posted on September 23, 2024September 22, 2024 by Shamima Sultana

Google Sheets QUERY function is a powerful alternative to Excel’s PivotTables. It offers dynamic pivot table-like analysis of data without requiring constant manual updates. Excel’s…

Utilizing Google Sheets’ SPARKLINE Function for Inline Charts (Versus Excel’s Sparklines)
Google Sheets

Utilizing Google Sheets’ SPARKLINE Function for Inline Charts (Versus Excel’s Sparklines)

Posted on September 20, 2024September 20, 2024 by Shamima Sultana

To create inline chart both Google Sheets and Excel offer the SPARKLINE function and the Sparklines built-in feature. Google Sheets SPARKLINE function allows you to…

Creating Custom Functions in Google Sheets with Apps Script (Versus Excel’s User-Defined Functions)
Google Sheets

Creating Custom Functions in Google Sheets with Apps Script (Versus Excel’s User-Defined Functions)

Posted on September 18, 2024 by Shamima Sultana

When working with Google Sheets or Excel, you may find situations where built-in functions won’t meet your needs. However, you can use both platforms to…

How to Create Dynamic Charts in Google Sheets (Versus Excel’s Chart Features)
Google Sheets

How to Create Dynamic Charts in Google Sheets (Versus Excel’s Chart Features)

Posted on September 17, 2024September 17, 2024 by Shamima Sultana

Dynamic charts are useful when data changes frequently. Both Google Sheets and Excel create dynamic charts that update automatically as new data is added. Creating…

How to Use Google Sheets’ QUERY Function for Advanced Data Analysis (Versus Excel’s Power Query)
Google Sheets

How to Use Google Sheets’ QUERY Function for Advanced Data Analysis (Versus Excel’s Power Query)

Posted on September 10, 2024 by Shamima Sultana

Google Sheets’s QUERY function and Excel’s Power are among the most useful and powerful tools for advanced data analysis. Both have strong key functionalities to…

Posts pagination

Previous Page Page 1 … Page 8 Page 9

Search

ABOUT STATOLOGY

Statology makes learning statistics easy by explaining topics in simple and straightforward ways. Our team of writers have over 40 years of experience in the fields of Machine Learning, AI and Statistics. Learn more about our team here.

Featured Posts

  • 5 Things a Box Plot Tells You at a GlanceNovember 17, 2026
  • When the Mean Lies: Choosing the Right Average for Your DataNovember 12, 2026
  • 5 Famous Experiments That Changed How We Think About StatisticsNovember 10, 2026
  • Before You Run That Test, Check These 3 ThingsNovember 6, 2026
  • Quantifying Network Latency: How Routing and Encryption Impact Statistical Data Pipelines
    Quantifying Network Latency: How Routing and Encryption Impact Statistical Data PipelinesNovember 5, 2026
  • Skewness, Explained in 60 SecondsNovember 4, 2026

Statology Study

Statology Study is the ultimate online statistics study guide that helps you study and practice all of the core concepts taught in any elementary statistics course and makes your life so much easier as a student.

statology study

Introduction to Statistics Course

Introduction to Statistics is our premier online video course that teaches you all of the topics covered in introductory statistics. Get started with our course today.

introduction to statistics

© 2025 Statology | Privacy Policy | Terms of Use
Wisteria Theme by WPFriendship ⋅ Powered by WordPress

Join the Statology Community

Sign up to receive Statology's exclusive study resource: 100 practice problems with step-by-step solutions. Plus, get our latest insights, tutorials, and data analysis tips straight to your inbox!

By subscribing you accept Statology's Privacy Policy.