Skip to content

Home
Excel
Online Collaboration
Outlook
Python Automation
Office Automation
Data Analysis

VBA and Automation Tips

Helping you save plenty of time by automating your work with simple scripts

VBA scripts

How to work with Message and Input Boxes in PowerPoint VBA?

How to subset a dataframe by one or multiple columns?

How to create and insert shapes in PowerPoint with VBA?

How to create and add slides to PowerPoint presentations with VBA?

How to display the developer tab in Excel, Outlook and Word 2019 / 365?

How to copy add slides into your PowerPoint presentation with VBA Macros?

Python Automation and Data Analysis

How to remove newlines from a string in Python 3?

How to write lists and dictionaries into a CSV file with Python 3?

How to get the length of a string in Python?

How to remove a character from a string in Python 3?

How to print a string in reverse in Python 3?

How to open and read an excel file with Python?

How to write text files in Python 3?

How to convert a Python string to Hex format?

How to find unique occurrences in a Python list?

Find the sum of all elements in a Python list

How to round up a float number in Python?

Convert a list of strings to float numbers in Python?

How to read from an SQL database with pd.read_sql in Python?

Output Pandas DataFrame to Excel (one or multiple worksheets) with Python

How to write Python / Pandas rows and columns into a list?

© 2007-2021 by EasyTweaks.com. All rights reserved. Posts in this site may contain affiliate links.
Contact Us || Sitemap || Privacy || Terms of Service

Cookies

This website uses cookies. To find out more about our privacy policy and how to control cookies, see here.