100 Top Tips: Microsoft Excel
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
29 July 2024
Issue 144 of the MagPi is out now, including my cover feature on getting started with electronics and part two of my Productive Python series.
If you're a Raspberry Pi user who's never dabbled with electronics, I hope my feature will give you the confidence to begin. It shows you how to wire up an LED safely and control it from Python. There is also a shopping list of useful components and a guide to follow-on projects you can find online to build your skills. The program in this article turns your LED into a Morse code transmitter. I've extended it slightly to take your text input and convert it into the flashing Morse code. The photo I've used to illustrate this on my site shows strips of paper with Morse code messages stamped into them. I photographed it at the Porthcurno Museum of Global Communications.
Last issue, part one of Productive Python looked at time travel experiments in Python, showing how to create clocks and calendars to help you manage your time. This issue, I shared two programs I've written to automate frequent tasks. The first Python program searches through PDFs (such as ebooks and magazine back issues). The other is a Python program to download web pages and put them into a Word document. The examples show you how to process files and web content, and how to save the output to text files and Word files. I hope these programs are useful starting points for readers as they think about other routine tasks they could delegate to Python.
If you encounter errors when trying to use pip install in an old tutorial (for example Raspberry Radio or ArtEvolver in my free Coding Compendium ebook), you need to set up a virtual environment. My latest Productive Python tutorial also walks you through the steps involved in doing this using Thonny. It's easy, but it's new, so I recommend you take a look if you haven't done it before.
The MagPi can be ordered or downloaded online and is available in newsagents, including WH Smiths.
Permanent link for this post | Blog Home | Website Home | Email feedback
© Sean McManus. All rights reserved.
Visit www.sean.co.uk for free chapters from Sean's coding books (including Mission Python, Scratch Programming in Easy Steps and Coder Academy) and more!
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
This book, now fully updated for Scratch 3, will take you from the basics of the Scratch language into the depths of its more advanced features. A great way to start programming.
Code a space adventure game in this Python programming book published by No Starch Press.
Discover how to make 3D games, create mazes, build a drum machine, make a game with cartoon animals and more!
Set up your Raspberry Pi, then learn how to use the Linux command line, Scratch, Python, Sonic Pi, Minecraft and electronics projects with it.
In this entertaining techno-thriller, Sean McManus takes a slice through the music industry: from the boardroom to the stage; from the studio to the record fair.