Group items tagged

Working with Excel - creating, viewing, editing and moving records - and understanding details thereof and deriving conclusion from it become easier with the advanced tools integrated with the Excel tables. For instance, if you want a row or column to come with total value, it would do so. Formatting and sorting data can be done in a quick and easy way without having much competence. And, eventually you can create a professional Excel tables that would help you manage information in a better manner.

Anyone who has used Microsoft Excel since 1993 has likely dabbled at least once with VBA, or Visual Basic for Applications, scripting: That's the year Excel 5.0 arrived with VBA support. The feature allows users to create automated tasks and functions in the spreadsheet application, extending the software's potential.

If you're setting up a worksheet only for yourself, you can simply leave an empty cell for this purpose. To check it, just type in an x or any other character. Then use a formula with the =isblank() function to make the contents of that cell affect the rest of the spreadsheet. But you might want something more mouse-friendly--especially if you're designing a spreadsheet for other people. I've tested the technique below on Excel 2007, 2010, and 2013. I'm not sure about earlier versions. You can insert checkboxes on Excel's Developer tab. Unfortunately, that tab is hidden by default. To make it visible in Excel 2010 or 2013, click the File tab and select Options. ClickCustomize Ribbon. You'll see two lists. Make sure that the one on the right is titled Main Tabs. Check Developer.

Are you facing problems related to Office 2013 applications? Remember, it may happen with all bundled software including Excel, Word, Outlook, PowerPoint, Publisher, or Visio, especially at the startup.

"iPhone 5 Called ""Gadget off the Year"" by Time Magazine, Apple's iPhone 5 (from $199 on 2-year AT&T, Sprint or Verizon plan) is a serious piece of hardware. Along with its powerful new A6 chip, iPhone 5 works on 4G/Long Term Evolution (LTE) networks for wireless speeds that rivals your home's broadband connection. iPhone 5 also has improved cameras: an eight-megapixel iSight rear-facing camera (3264 x 2448 pixels) and front-facing FaceTime camera with 720p HD quality for video calling. Samsung Galaxy S III The Samsung Galaxy S III (from $149 on 2-year plan with AT&T, Sprint, T-Mobile, U.S. Cellular, Verizon) is a true smartphone in every sense of the word -- and we're not even referring to its stunning 4.8-inch display, fast LTE speeds or versatile Android operating system. the Galaxy S III's front-facing camera knows when you're looking at the screen, so it'll give you the bright display you seek, but if your eyes look away it'll dim itself to preserve its battery. It also knows when you want to talk: if you're messaging with someone and want to call them, simply lift the smartphone to your ear and it'll dial for you. Nokia Lumia 920 As the flagship Windows Phone 8 device, Nokia's Lumia 920 (from $99.99 on 2-year AT&T plan), has a lot to offer, including a colorful Start screen with ""live tiles""; familiar Microsoft apps like Outlook, Word, Excel, PowerPoint and OneNote; and a People hub that aggregates all your contacts into one page per person (so you don't need to close, say Outlook, to see what that friend is up to on Facebook or Twitter). HTC Droid DNA and HTC One X+ A pair of Android-powered HTC devices are also worthy of ""best of 2012"" nods: the HTC Droid DNA ($149.99 on 2-year Verizon Wireless plan) and HTC One X+ ($199.99 on 2-year AT&T plan). Protected by Corning's uber-durable Gorilla Glass 2 technology, the Droid DNA's 5-inch 1080p HD screen was built for video, games, ebooks and web browsing. Integrated Beats Audio - an

An excellent list (with links)

Excellent video (biased for Google since it's from Google) about the evolution of Google search

An excellent TED video from a cybercrime and malware expert. My class found this video quite funny and Mikko covers some excellent ground from the curriculum.

Though Microsoft office 2013 has much to boast of, you may dislike some of its newly introduced features. Once such is the inclusion of start screen with Word, Excel, Outlook or other applications.

Intro Small Basic tutorial from Microsoft. Excellent place to start.

An excellent set of programming challenges.

Excellent summary of the realities of teaching a subject like mathematics or physics, with some tips on how to overcome the hurdles. Equally applies to CS.

This article about Pair Programming is an excellent description of the process and how it can improve productivity. The company, Xtreme Labs, has set work hours and they are still very productive. Xtreme Labs is a mobile app developer primarily from Toronto that is growing extremely quickly.

While making PowerPoint presentations, you must face the need of adding values, tables or graphs. Well, here is the solution in this tutorial.

Julia, a language for technical computing

Looks interesting. Once mastered, it might be an excellent language to use in programming competitions.

There was some discussion at the CEMC conference about coding guidelines. I found this excellent article about the topic of Reading Code and best practices. I plan to use this in my senior (ICS4U) course early to set the standards and probably a simplified version after a few months in ICS3U.

So, you want to learn the Python programming language but can't find a concise and yet full-featured tutorial. This tutorial will attempt to teach you Python in 10 minutes. It's probably not so much a tutorial as it is a cross between a tutorial and a cheatsheet, so it will just show you some basic concepts to start you off.

Fantastic series of tutorials for the Arduino.

I frequently see a problem when people (especially techies) try to teach programming to someone (especially non-techies). Many programming tutorials begin with basic programming principles: variables, loops, data types. This is both an obvious way to teach programming and almost certainly a wrong way to teach programming. It's wrong because nobody wants to learn how to program

Good find, Doug. His book is excellent: http://inventwithpython.com/chapters/