Friday, November 22, 2019

Excel macros: Essential rules, tips and tricks

An Excel macro is an abbreviation for macroinstruction—a sequence of commands (or directives) that tell a computer program or a programming language (such as Visual Basic, C, Assembler, PHP, etc.) to perform a series of tasks; generally repetitive tasks, which are prone to errors if repeatedly keyed by hand. Application macros are often created using a macro recorder, which records the user's keystrokes while performing the repetitive task, then replays those keystrokes every time the macro name or shortcut key is executed. JD Sartain / PC World Application macros created using a macro recorder What macros doProgrammers and end-users create and use macros for similar reasons: to simplify a complex procedure, to reduce a sequence of instructions down to a single program statement, or to automate repetitive tasks. For example, instead of manually separating city, state, and ZIP code from one column into three, create a macro; and instead of retyping the same header data on every s..

Excel databases: Creating relational tables

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. How relational databases workExcel's organizational structure lends itself well to how databases work. A database is a collection of connected items (spreadsheet) that, when associated, creates a single record (row) inside a group of multiple records (table). One spreadsheet, alone, is a database, but not a relational one. The relational database is a combination of the Master spreadsheet table and all of its Slave tables or spreadsheets. [ Further reading: Your new PC needs these 15 free, excellent programs ] Microsoft Office Home and Business 2016 Viewon Amazon For example, your driver's license is a single record in a flat-file database that resides on a computer at the Department of Motor Vehicles (DMV). Your license contains your name, gender, height, weight, eyes and hair color, address, ..

How to use Android 8.0 Oreo’s autofill API

Android 8.0 Oreo's autofill API is here to save you from one of technology's biggest hassles: passwords. Google's API allows apps to act as autofill providers at the system level. So, instead of opening a password manager and copying your passwords, the app can simply authenticate you and fill in the information automatically. This feature requires some setup, but it's well worth your time. Autofill was somewhat possible in older versions of Android using the Accessibility service, which allows apps to input text and highlight fields. However, this process was slow and extremely buggy. Filling in passwords is not what it was designed to do. Google's Smart Lock came to Android in Nougat, and it worked a little better, but most developers didn't add support. So, the autofill API was devised to make password managers easier to use. Not all password manager apps work with this feature, but most of the big ones have announced support. 1Password, Dashlane, and L..

How to build a Raspberry Pi retrogaming emulation console

This RetroPie really happened: Watch (above) as our own Adam Patrick Murray and Alaina Yee build a RetroPie system after they weren't able to buy an SNES Classic. Go ahead, laugh at (and learn from) our mistakes. For the past 20 years, retrogaming enthusiasts have dreamed of building a “universal game console” capable of playing games from dozens of different systems. Their ideal was inexpensive, easy to control with a gamepad, and capable of hooking into a TV set. Thanks to the Raspberry Pi 3 hobbyist platform and the RetroPie software distribution, that dream is finally possible. For under $110, you can build a very nice emulation system that can play tens of thousands of retro games for systems such as the NES, Atari 2600, Sega Genesis, Super NES, Game Boy, and even the PlayStation. [ Further reading: These 20 absorbing PC games will eat days of your life ]All you need to do is buy a handful of components, put them together, and configure some software. You’ll also have to prov..

How to delete or disable your Facebook account

Deleting your Facebook account may be a fantasy you entertain briefly every time you see one too many intrusive ads or political posts on your feed. We understand. The good news is, you have two options for fulfilling this fantasy: deactivation, which can be undone, or full-on deletion—and even then, you have a chance to change your mind. Here’s how they both work. Deactivate your Facebook account Melissa Riofrio/IDG Go to your Facebook Settings and select General to find the deactivate option. Deactivating your Facebook account puts it on hiatus. Your profile will be removed from the site, as will most of what you posted to Facebook, though messages and other things will stick around). Deactivation can be undone. Facebook will retain your data in case you decide to come back. You can always reactivate your account later by logging in to Facebook. If you're not sure you want to leave permanently, this is a great way to try the Facebook-free life before you make a final decision..

Xbox One X PC live build prep

We're so excited for the Xbox One X that we're building a PC clone of it.

Excel charts: Mastering pie charts, bar charts and more

Excel’s chart features can turn your spreadsheet data into compelling visual communications—if you know what to do. This guide will walk you through the basics of setting up trends, percentages, relationships, averages, and much more. We’ll keep adding information over time, so bookmark this page to learn more. Chart DesignsExcel has 16 chart designs with several models in each design, plus a dozen or so styles, colors, and layouts for each model in each design. According to Microsoft, specific types of data are paired with the chart design that showcases that data best. When you select Recommended Charts from the Insert tab, Excel displays a visual list of the charts that would most successfully represent your current dataset. Microsoft Office Home and Business 2016 Viewon Amazon For example, Column charts illustrate how data changes over time, but they’re also the best design to show comparisons among items. Bar charts are, essentially, just horizontal Column charts and are general..

Android Instant Apps: What they are and how to use them...

Now that Google’s Instant Apps have made it to the Play Store, you can expect to see a lot more of them. While the initial rollout is limited to just a handful of apps, dozens of apps and games will soon be available in instant form. But what exactly are Instant Apps? And how do you get them on your phone? We’re here to help you get started: What are Instant Apps?Instant Apps are the next step in app evolution, a universal Android solution that brings the speed and power of a native app with the ease and immediacy of a web app. They look and operate just like one of the apps that are installed on your phone, but you don’t need to download anything. So Instant Apps don’t live on my phone?Correct. Using an Instant App is similar to browsing to a web page. Once you close the window, it disappears. Are there any limitations?Yes and no. Instant Apps don’t have any technical limitations, and developers can deliver things like account signup, purchasing, and videos, just like they would in a ..

SNES Classic RetroPie emulator build post-mortem

Adam Patrick Murray and Alaina Yee have been using their Raspberry Pi based RetroPie emulator builds for a couple weeks now and are ready to share their thoughts.

How to remove malware from your Windows PC

Beware the signs of a potentially malware-infested PC: slower-than-usual performance, the recent occurrence of lots of pop-ups, and other weird issues. It’s possible your system has been infected by a virus, spyware, or other nefarious entity—even if you have an antivirus program installed. Yes, out-of-the-ordinary behavior is sometimes the result of hardware issues, but it’s best to first rule out malware if your PC is acting up. Here’s a step-by-step guide for taking action. Step 1: Enter Safe ModeBefore you do anything, you need to disconnect your PC from the internet, and don’t use it until you’re ready to clean your PC. This can help prevent the malware from spreading and/or leaking your private data. If you think your PC may have a malware infection, boot your PC into Microsoft’s Safe Mode. In this mode, only the minimum required programs and services are loaded. If any malware is set to load automatically when Windows starts, entering in this mode may prevent it from doing so. T..

Recent Posts