Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
2019 is the 150th anniversary for the Periodic Table of Elements. There are some great Periodic Tables available in Word documents, Excel spreadsheets and PowerPoint slides.
There are many Periodic Table ‘documents’ on the net but most are PDF’s or images. We’re looking for editable documents that you can adapt, recolor or redesign to suit your needs.
Excel spreadsheet from Jeff Bigler
Microsoft has a download they immodestly and wrongly call the Ultimate Periodic Table worksheet. It’s hardly the ‘Ultimate’, that award goes to a Massachusetts high school teacher.
The wonderful Periodic Table worksheet at MrBigler.com is more than just a table of elements. It also has lists of the elements. Jeff Bigler must have spent a lot of time putting it together.
The main Periodic Table tab is filled with links to the list of elements on the ‘PT Included Fields’ tab.
It’s the most comprehensive Excel Periodic Table of Elements we could find. Each element cell has the atomic number, ions commonly formed, symbol, name and atomic mass.
All that detail is in the list on the ‘PT Included Fields’ tab. There are other tabs with more element data in list form.
The Excel lists are not modern Excel Tables with all the benefits they have, but that makes little difference to the usefulness of this worksheet.
Our only concern is that the MrBigler.com download is in the older .xls format. We generally recommended avoiding downloads/email attachments in the old .doc .xls .ppt formats. See Why you should delete .doc .xls .ppt files. But this worksheet is so damn good. Download it and convert to .xlsx. If you use the worksheet, make sure to credit Jeff Bigler.
As we said, PDF Periodic Tables are aplenty. Editable Word documents in .docx format are a little harder to find.
There are many variations on the Periodic Table document. Some have minimal information, for use in exams while others have a lot of information or nicer designs.
A forum page at IonicViper.org has some nice contributions.
Barbara Reisner has a minimalist, exam-ready Periodic Table
Matthew Riehl contributes a more informative Periodic Table document.
Any of the Word or Excel versions can be copied/pasted into PowerPoint, either directly or as an image. But if you’re looking for something in PPTX format …
There are more elements to be found ….
Well, plenty more Periodic Tables variations. If the above options don’t suit you, go hunting the web for others. Use the
filetype: search parameter to limit your results to Word
filetype:xlsx or PowerPoint
Tex / LaTex versions
No real connection with Microsoft Office, but if you’re looking for a Tex/LaTex version of the Periodic Table, head over to GitHub.
Tom Lehrer’s Periodic Table song
No mention of the Periodic Table is complete without Tom Lehrer, the world’s funniest mathematician. There are several videos that have added animations to his song …
A scrolling list of the elements, useful if you’re trying to memorize the song.
The great man himself, live in Copenhagen.
Periodic Table of Videos
Brady Haran and the University of Nottingham have made a video about each of the known elements.
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.