Windows PowerShell 2 for Dummies

Yes, I am aware of the fact that this blog has started to look like a Dummies bookstore! 🙂 I am using the Windows command prompt these days for my work. This is mostly to run command-line programs, process their output and to do minor editing using Vim. I found the archaic Windows command prompt quite limiting and decided to try PowerShell. For someone coming from Windows commands or the Linux shells, the PowerShell commands and usage can seem out of this world. So, I chose Windows PowerShell 2 for Dummies, written by Steve Seguis, to familiarize myself with this shell.

Parts I and II of the book provide a basic introduction to PowerShell. The commands of PowerShell are called cmdlets, pronounced as command-lets. All of them are of the form verb-noun, for example Get-Help. Windows and Linux pros need not worry as most of their familiar commands (like dir or ls) are available as aliases for the PowerShell cmdlets. Just like bashrc for bash, PowerShell can be customized with user-written profile scripts. The most power-ful aspect of PowerShell is that its cmdlets deal with .Net objects. Much like text is piped and processed using Linux commands, objects can be handled in the same way in PowerShell. The rest of the book delves deeper into the PowerShell language constructs and some basic Windows administration tasks. Since, I only need PowerShell for basic tasks, I skimmed through these chapters.

I continue to be surprised by the quality of the Dummies books. Windows PowerShell 2 for Dummies was a delight to read and experiment with. I highly recommend this book for all the folks who want to dip their toes into PowerShell.

Weight Training for Dummies

After being a physically inactive guy all my life, I joined a gym for the first time about a decade ago. My intention was to get active, gain some strength and muscle in the process. The gym experience turned out to be a disaster! I had no idea about the body and how to work its various muscles. The trainers handed me a cookie-cutter workout program and totally ignored me. It looked like the gym was a rip off for underweight guys (like me) and overweight people. The trainers spent all their time and attention on people who did not need any help: muscular guys grunting at their weights and shapely women bending at their routines.

Thankfully, I have gotten more active and fitter (?) over the years since. But, I recently sprained my back after doing a back extension and could not bend for a couple of days. That experience awoke me to the fact that I needed to have a basic understanding of the body and how to work it safely at the gym. I picked up Weight Training for Dummies (Third Edition), which to my pleasant surprise is written by three ladies: Liz Neporent, Suzanne Schlosberg and Shirley Archer. Like most Dummies books, the book is aimed at total newbies who want to learn about the body and how to work it using weights for strength and endurance.

Parts I and II of the book give an introduction to weight training. If like me, you too felt overwhelmed and awkward looking at all the machines, the weights and the people working out, these pages are a godsend! Nothing is spared, all the exercise/gym jargon and the complex-looking equipment are demystified. The authors explain how weight training is useful for anyone, whether your aim is to gain endurance or to gain strength. In this part and in the rest of the book, the authors constantly point out how to exercise safely without harming any muscle or getting injured.

Part III is the meat of the book which describes the exercises for the different parts of the body. I have read innumerable articles on the Internet and complex body charts at gyms, but this book easily beats them all in its clarity. It breaks the body down into back, chest, shoulders, arms, abdominals, butt-legs and the core. There are 1-2 major muscles in each of these areas and the book elaborates on exercises for each of them. For each such major muscle, at least 3 kinds of exercises are described: using a machine, using free weights (dumbbells or barbells) and using your own body weight. I found this kind of breakdown very useful since knowing this I can work out no matter where I am: at the gym, at the park or at home. Knowledge is truly liberating! 🙂

Part IV helps the reader create workout programs to accomplish their objectives. For example, one might design a full-body routine or a split routine that covers upper-body one day and the lower body on another day. Part V has the Part of Tens chapters, with ten ways to use a rubber band and exercise ball for fitness. And not to forget that like all Dummies books, this one too has some rib-tickling cartoons by Rich Tennant.

I definitely think that it is the female touch in this book that makes the subject of weight training so refreshing and easy. This book is for you if you find the testosterone-filled gym atmosphere nauseating or intimidating. Read this book and you will be able to confidently workout at any place with any equipment and easily talk about curls, glutes or reps without breaking a sweat! 😉 Whether you want to work your body for endurance or strength, this is a good reference. Who knows, it might turn you into a gym rat! 🙂

Excel 2007 for Dummies

In the Indian computer teaching centers of the mid-90s, the two entries that were de rigueur in all beginner computer courses were Wordstar (word processor) and Lotus 1-2-3 (spreadsheet). After one such cursory brush at the spreadsheet program, I had been mostly avoiding the spreadsheet for more than a decade. The spreadsheet would go on to become the ubiquitous sidekick to the wordprocessor in all office suites from Microsoft Office to (now LibreOffice) and Google Docs. Recently, when dealing with numerical data that needed analysis, a friend played around so deftly with the data using Excel 2007, that I finally realized the power of the spreadsheet. Having to process some data and being close to a total illiterate, I again fell back on the Dummies series. I picked up Excel 2007 for Dummies written by Greg Harvey to introduce myself to the capabilities and possibilities of the killer application of the PC revolution.

Excel 2007 for Dummies is no exception to the good quality introductions that are the hallmark of the Dummies series. (And can you really resist whizzing through Dummies books looking for those super-funny Rich Tennant cartoons?) This book has two aims: introduce you to use the spreadsheet for your work and also familiarize you with the Ribbon interface, that was introduced in Office 2007. Since I had a certain idea of what I wanted to learn, the book took only a few hours of my time. By the end, I was familiar with the kind of problems I could quickly throw at Excel 2007 and get them solved and the what-if analysis I could do. I also realized that the unfamiliar Ribbon interface was a true innovation over the hierarchical-menu driven UI. Excel 2007 is also full of multiple keyboard or keyboard-mouse shortcuts for almost every task. You can pick what is most intuitive to you and use it accelerate your most common operations. (For example, press Alt in any Office 2007 program to visually see all the Alt-based keyboard shortcuts possible at any time.)

Excel 2007 for Dummies is a good easy-to-read introduction to the spreadsheet program. It only deals with the basics and if you feel the need for more (like I do), you will have to pick up a more advanced book after this. Whether commerical or free, today everyone has access to a full-fledged spreadsheet program, and you will be surprised at the myriad kinds of data you could enter, track and analyze with it. The basics learnt with Excel 2007 translate easily to LibreOffice Calc, Google Docs or any other spreadsheet program you might want to use. Dive in and spend just a few hours with Excel 2007 for Dummies and you will not be disappointed! 🙂

Create a free website or blog at