Excel Examples Excel Examples
Basics
Rows Columns Formulas Worksheets Ribbon Workbook Templates Format Cells Shortcuts Print Share Protect Find Flowcharts Formula Errors Round Range AutoFill Union and Intersect Skip Blanks Comments Lists Calculator Invoice
Functions
Text Array Formulas Count and Sum Lookup & Reference Date & Time Statistical Logical Cell References Financial Formula Errors Round Characters Count
VBA
Loop Userform String Manipulation Range Object Events Function Date and Time Macro Errors If Then Statement Array Worksheet Workbook ActiveX Controls MsgBox Variables Create a Macro Function and Sub Application Object
Data Analysis
Pivot Tables Analysis ToolPak Charts Filter What-If Analysis Sort Solver Conditional Formatting Tables
About
Python

Data analysis automation with Python and Powershell, to be used with Excel .xls & .xlsx files

Data analysis automation with Python and Powershell, to be used with Excel .xls & .xlsx files
13 April 2022
Spreadsheets

A Python library to alleviate the pain of using Excel spreadsheets to collect data from your stakeholders

A Python library to alleviate the pain of using Excel spreadsheets to collect data from your stakeholders
13 April 2022
Tools

Tool for generating assignment correction sheets for lecture groups

Tool for generating assignment correction sheets for lecture groups
13 April 2022
Export

Exports data from OpenEDX MySQL Database into an Excel Spreedsheet

Exports data from OpenEDX MySQL Database into an Excel Spreedsheet
13 April 2022
Graph

A pipeline for plotting data scattered across multiple MS excel files

A pipeline for plotting data scattered across multiple MS excel files
13 April 2022
Tables

Aims to convert tables in pds or Excel Spreedsheets to a uniform CSV format

Aims to convert tables in pds or Excel Spreedsheets to a uniform CSV format
13 April 2022
A simple python GUI application for adding information in excel sheets and help making reports
Report

A simple python GUI application for adding information in excel sheets and help making reports

A simple python GUI application for adding information in excel sheets and help making reports
13 April 2022
Convert

Convert HTML Table to Excel xlsx via Python

Convert HTML Table to Excel xlsx via Python
13 April 2022
Convert

Convert Excel data to Github markdown table

Convert Excel data to Github markdown table
13 April 2022
PDF

App can extracts relevant information from factsheets

App can extracts relevant information from factsheets
13 April 2022
Analysis

Import dataset from excel to sql for more efficient analysis

Import dataset from excel to sql for more efficient analysis
13 April 2022
Excel macro that solves 154 sudoku puzzles
Macro

Excel macro that solves 154 sudoku puzzles

Excel macro that solves 154 sudoku puzzles
13 April 2022
Merge Cells

Consolidate excels file into one or split multiple tabs of excel file into an individual file

Consolidate excels file into one or split multiple tabs of excel file into an individual file
13 April 2022
Simulation

Compare two similar excel files in python

Compare two similar excel files in python
13 April 2022
Generate

Generates ppt from template ppt with data in excel

Generates ppt from template ppt with data in excel
13 April 2022
load *.xls* as two-dimensional array(one base)
Array

load *.xls* as two-dimensional array(one base)

load *.xls* as two-dimensional array(one base)
13 April 2022
Python

Simple python3 bot for automating boring excel tasks

Simple python3 bot for automating boring excel tasks
13 April 2022
Creates an Excel file with the costs of travelling to configured locations in configured vehicles with best live fuel and price history graph
Graph

Creates an Excel file with the costs of travelling to configured locations in configured vehicles with best live fuel and price history graph

Creates an Excel file with the costs of travelling to configured locations in configured vehicles with best live fuel and price history graph
13 April 2022
Import data from excel file and display it on the web using streamlit
Python

Import data from excel file and display it on the web using streamlit

Import data from excel file and display it on the web using streamlit
13 April 2022
Spreadsheets

Generate MS Word Document From Excel Spreadsheets

Generate MS Word Document From Excel Spreadsheets
13 April 2022
Plot

Plot excel points using python

Plot excel points using python
13 April 2022
Calculator

Calculates my total income and expense and prints it into a excel sheets

Calculates my total income and expense and prints it into a excel sheets
13 April 2022
Parser

Demo project for parsing Excel files to CSV using pandas

Demo project for parsing Excel files to CSV using pandas
13 April 2022
Build a Web App to Group - Plot Excel Files in Python with Streamlit
Python

Build a Web App to Group - Plot Excel Files in Python with Streamlit

Build a Web App to Group - Plot Excel Files in Python with Streamlit
13 April 2022
How to Split Each Excel Sheet Into a Separate File Using Python
Tutorial

How to Split Each Excel Sheet Into a Separate File Using Python

How to Split Each Excel Sheet Into a Separate File Using Python
13 April 2022
Group Excel Sheets - Save Them As Separate Workbooks
Spreadsheets

Group Excel Sheets - Save Them As Separate Workbooks

Group Excel Sheets - Save Them As Separate Workbooks
13 April 2022
Find and Replace Multiple Values in Excel using Python
Value

Find and Replace Multiple Values in Excel using Python

Find and Replace Multiple Values in Excel using Python
13 April 2022
Export Excel Named Range Into Text-file
Export

Export Excel Named Range Into Text-file

Export Excel Named Range Into Text-file
13 April 2022
Python: Combine All Excel Files in a Folder into One Workbook
Tutorial

Python: Combine All Excel Files in a Folder into One Workbook

Python: Combine All Excel Files in a Folder into One Workbook
13 April 2022
Save MorePro V19 Smartwatch data as Excel sheet via phone logs
Python

Save MorePro V19 Smartwatch data as Excel sheet via phone logs

Save MorePro V19 Smartwatch data as Excel sheet via phone logs
13 April 2022
Python

A script to combine several Excel files for one

A script to combine several Excel files for one
13 April 2022
Calendar

Generates an iCal file from a Microsoft Excel schedule

Generates an iCal file from a Microsoft Excel schedule
13 April 2022
Python

Plotting from an uploaded excel file

Plotting from an uploaded excel file
13 April 2022
Save the running status of the pc to excel files
Date & Time

Save the running status of the pc to excel files

Save the running status of the pc to excel files
13 April 2022
Automation

Automated SMS texts from excel list

Automated SMS texts from excel list
13 April 2022
Spreadsheets

Project to generate quotes at any time using pandas, saving to Excel spreadsheet

Project to generate quotes at any time using pandas, saving to Excel spreadsheet
13 April 2022
Tools

Sipadu Contonge - Tools for importing members data from excel

Sipadu Contonge - Tools for importing members data from excel
13 April 2022
Python

A python script to handle/manage given scores and to generate excel sheet scores using pandas

A python script to handle/manage given scores and to generate excel sheet scores using pandas
13 April 2022
Python

An example DRF project on how to upload and process excel files using openpyxl

An example DRF project on how to upload and process excel files using openpyxl
13 April 2022
Convert

Command-line tool to convert CSV-files (.csv) to Excel-files (.xlsx)

Command-line tool to convert CSV-files (.csv) to Excel-files (.xlsx)
13 April 2022
Python

A tiny module that prepares *.xls, *.xlsx and *.csv files for their processing in sqlite3

A tiny module that prepares *.xls, *.xlsx and *.csv files for their processing in sqlite3
13 April 2022
A Tool for creating announcement sound files from an excel file and an exported audio track
Tools

A Tool for creating announcement sound files from an excel file and an exported audio track

A Tool for creating announcement sound files from an excel file and an exported audio track
13 April 2022
PDF

Watermark multiple PDF files from an Excel sheet list of recipients

Watermark multiple PDF files from an Excel sheet list of recipients
13 April 2022
Convert

Data assistant program for fill automatic data , download sheet excel and convert mutilate to pdf

Data assistant program for fill automatic data , download sheet excel and convert mutilate to pdf
13 April 2022
Python

Send multiple images and messages via whatsapp using excel contact list

Send multiple images and messages via whatsapp using excel contact list
13 April 2022
Report

Quickly turn pandas dataframes into shareable Excel reports

Quickly turn pandas dataframes into shareable Excel reports
13 April 2022
Spreadsheets

Makes an excel pixel spreadsheet from an image

Makes an excel pixel spreadsheet from an image
13 April 2022
Enhanced version of tradestat, using multiprocessing to export excel files
Export

Enhanced version of tradestat, using multiprocessing to export excel files

Enhanced version of tradestat, using multiprocessing to export excel files
13 April 2022
This software generates and upload an Excel file (also JSON) containing all information
Generate

This software generates and upload an Excel file (also JSON) containing all information

This software generates and upload an Excel file (also JSON) containing all information
13 April 2022
Python

Library focusing on row-major organization of tabular data and control over the Excel application

Library focusing on row-major organization of tabular data and control over the Excel application
13 April 2022

Tags

Tutorial 350
How To 341
Python 232
VBA 102
Functions 99
Data Analysis 63
Convert 53
Spreadsheets 45
Tools 44
Script 36
Generate 29
Templates 23
JSON 23
Formulas 22
Tables 22
Format Cells 21
PDF 21
Workbook 20
Tips 19
Report 18
Automation 17
Charts 15
Export 15
Range 14
Date & Time 12
Range Object 12
Document 12
Shortcuts 11
Worksheets 11
Text 11

Recent Posts

Data analysis automation with Python and Powershell, to be used with Excel .xls & .xlsx files
Apr 13, 2022
A Python library to alleviate the pain of using Excel spreadsheets to collect data from your stakeholders
Apr 13, 2022
Tool for generating assignment correction sheets for lecture groups
Apr 13, 2022
Exports data from OpenEDX MySQL Database into an Excel Spreedsheet
Apr 13, 2022
A pipeline for plotting data scattered across multiple MS excel files
Apr 13, 2022
About  |  Privacy Policy  |  Best Excel Books
Powered by Excel Examples