This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Programming blogs from Wise Owl (page 1 of 3)

Showing blogs 1-20 (out of 51)

What was your first programming language?

Posted by Andrew Gould on 08 May 2024

It's the BASIC programming language's 60th birthday this month! Some of the Owls have been reminiscing about their first forays into programming and I wrote this blog as fun look back on my own experience.

Tags:
Writing VBA > Other

You can now run Python programs within Excel

Posted by Andy Brown on 29 August 2023

If you subscribe to the Excel Beta Preview channel (and are lucky) you can now insert Python code within Excel. The rest of us may have to wait a bit for the official release, but the wait will be worth it, as this blog shows.

Tags:
Excel > General Python > General

Comparing Office Scripts with VBA

Posted by Andrew Gould on 29 June 2023

Until recently, if you wanted to automate a Microsoft Excel workbook your only real choice was the VBA (Visual Basic for Applications) programming language. Now, there's a new option for adding code to Excel: Office Scripts for Excel. There are many similarities between Office Scripts and VBA, as well as some significant differences. This blog provides a comparison of the two systems.

Tags:
Office Scripts > General

We've changed our Python courses

Posted by Andy Brown on 29 June 2023

We've introduced a new (shorter) two-day Introduction to Python course, a (longer) three-day advanced course and created a three-day fast-track course for those who want a more intensive learning experience.

Tags:
Python > General

Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools

Posted by Andy Brown on 07 June 2023

One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most).

Tags:
SQL > General Python > Progamming VBA macros > General Client script > JQuery Office Scripts > General

Introducing two new Wise Owl courses on Office Scripts

Posted by Andy Brown on 30 November 2022

This blog gives the background to Microsoft's decision to roll out Office Scripts, and explains why you might want to learn how to automate Excel using scripts, rather than VBA (and how you'd then go about doing this).

Tags:
Office Scripts > General

Should you be using QT for Python as a GUI?

Posted by Andy Brown on 21 June 2022

If you need to build a GUI system in Python, PyQt5 is probably the best choice, but don't take our word for it - read this blog and see what you think.

Tags:
Python > QT

A couple of software quirks

Posted by Andy Brown on 26 April 2022

What happens when you try to defy gravity in Python, and why Excel sometimes creates worksheets with foreign names

Tags:
Python > General Excel > General

Running a Python script within Power Automate Desktop

Posted by Andy Brown on 28 March 2022

How can you pass a value from Power Automate Desktop to a Python script, and then get the results back? This blog explains how.

Tags:
Python > General Power Automate Desktop > Scripting

Playing Wordle in Python

Posted by Andy Brown on 31 January 2022

A modest Python program to mimic the popular online Wordle game, using a Tkinter form and some basic classes.

Tags:
Python > Progamming

Looping over rows and columns for a Pandas dataframe

Posted by Andy Brown on 17 December 2021

This blog shows you various ways in which you can loop over the columns of a pandas dataframe, and also explains how to loop over the rows of a dataframe (together with why you should avoid doing this!).

Tags:
Python > Progamming

Creating executable files from Python programs using pyinstaller

Posted by Andy Brown on 17 December 2021

A summary of how to package up your Python program (including any referenced modules) into a single executable file.

Tags:
Python > Installation

A comparison of Python and C#

Posted by Andy Brown on 24 November 2021

Ten reasons why Python is a better programmng language than C# (and most other languages), as well as two reasons why it might not be.

Tags:
Python > General Visual C# > General

Reading Outlook emails and downloading attachments using Python

Posted by Andy Brown on 08 October 2021

This blog shows how you can use Python to loop over all of the emails in a folder in Outlook, saving the attachments for each to your hard disk.

Tags:
Python > Progamming

Python ModuleNotFoundError in VS Code using Code Runner

Posted by Andy Brown on 08 October 2021

How to solve the problem that Visual Studio Code can't find a module that you've imported.

Tags:
Python > Visual Studio Code

Five differences between Python and other languages

Posted by Andy Brown on 31 August 2021

How does Python compare with other programming languages like C#, VB or SQL? This blog looks at the differences we've come across in preparing our Python courses and videos.

Tags:
Python > General

How to use a $ symbol to introduce a string expression, and fill in the blanks

Posted by Andy Brown on 22 December 2017

Introduced in Visual Studio, string interpolation allows you to linking different C# expressions contained in curly parentheses, with everything preceded by a dollar sign. This blog explains how to use this handy new short-cut.

Tags:
Visual C# > Variables

How to get Excel to read out cell values on calculation

Posted by Andy Brown on 26 September 2016

A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.

Tags:
VBA macros > Working with ranges Writing VBA > Other

In SSMS, how to add multiple aliases to tables using the ALT key

Posted by Andy Brown on 23 March 2016

It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.

Tags:
SQL > Tables and columns T-SQL > Other

Common Table Expressions are even better than I'd realised, as this blog shows

Posted by Andy Brown on 01 February 2016

CTEs (or Common Table Expressions) allow you to divide complicated queries up into two or more simple discrete tasks, as this blog explains.

Tags:
SQL > CTEs, subqueries T-SQL > Other

This page has 0 threads

Add a new post

BY TOPIC