background preloader

Excel Formulas: 10 Formulas That Helped Me Keep My Job

Excel Formulas: 10 Formulas That Helped Me Keep My Job
Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. Excel Formulas You Should Definitely Know: Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. The above shows you different examples. Formula: =COUNT(A1:A10) The count formula counts the number of cells in a range that have numbers in them. This formula only works with numbers though: It only counts the cells where there are numbers. **Learn more about the COUNT function in this on-demand, online course. Formula: =COUNTA(A1:A10) Counts the number of non-empty cells in a range. The COUNTA Formula works with all data types. It counts the number of non-empty cells no matter the data type. Formula: =LEN(A1) The LEN formula counts the number of characters in a cell. Formula: =TRIM(A1) 8.

https://www.udemy.com/blog/excel-formulas/

Related:  technology & internetICT Tools etc

Completely Uninstall Programs And More With Revo Uninstaller Don’t you hate it when you try to uninstall a program it either does not include an uninstaller or when using Add / Remove Programs in Windows, there are several traces of the software left? It is definitely one of my bigger pet peeves … just check out my iTunes uninstall rant. I came across a cool little program the other day that claims to do a much better job of uninstalling applications and all of the tidbits and left-overs associated with them. Revo Uninstaller. When first launching Revo the first thing I noticed were all of the additional features not included with Window’s Add / Remove utility. Here I am going to show the process of uninstalling an unwanted toolbar from a Vista machine.

Free online tutorials for learning to use technology and ict in education How to work with screencasting tools www.teachertrainingvideos.com uses Camtasia for making the training videos. I also use JING for making short videos. If you look at the menu on the left-hand side, you can see a complete list of the screencasting tools that I have worked with and made videos for. Here are a few of my favourites. Camtasia 7-Two sets of videos All the videos I have made on this site use Camtasia 7. Everything You Wanted to Do With Office... But Didn't Know How English | Español | Français Menu ≡ home > resources > articles > everything you wanted to do with office... but didn't know how Everything You Wanted to Do With Office...But Didn't Know How You use Microsoft Word, Excel and PowerPoint on a daily basis and are still be trying to figure out where things are and how they work, using only 10% of the applications power.

Download and Install Google Fonts on your Computer Google Fonts are beautiful web fonts that can be used without restrictions. You can download and install Google Fonts on your computer for writing Office documents. Google Fonts is an absolutely awesome collection of web fonts that you may use in your HTML web pages without any restrictions. These fonts not only look more beautiful than the common typefaces like Arial and Verdana but they are more readable as well since the fonts have been designed specifically for the web. Also, all Google web fonts are offered under the Open Font License meaning you may use them even in commercial projects without having to worry about licensing issues. Google Fonts are hosted on google.com and all you need to do is include a few lines of CSS (or JavaScript) to embed one or more of these fonts in your web pages.

25 New Script Libraries and Plugins on GitHub Git is a powerful, open-source distributed version control system and social code repository. GitHub is the world's largest open-source community, hosting millions of public repositories. Users add innovative new projects on a daily basis. With the latest new Repos available to fork and explore, it can be difficult to stay updated. We'll cover 25 exciting new script libraries and plugins hosted on GitHub, ranging from image galleries to physics engines.

Change the Windows 7 Login Screen Background Image When you login to your Windows 7 computer (assuming you haven’t used something like this tutorial to turn on automatic login), you’ll generally see a login window with a background looking something like this. It’s fine; there’s nothing wrong with it. But sometimes a change is good so in this article we’ll show you how to change the background image behind the login screen to anything you want. The first step is to open up the Start Menu by clicking the orb in the lower left corner of the screen. Now, in the Start Menu search box, type regedit, to open up the Registry Editor. When the Registry Editor appears in the Start Menu, click the Enter key to launch it. Sleipnir 4 Web browser for Mac - The ultimate advance in Web browsing without an address bar The page title is shown when the cursor is aligned and when switching tabs. It has been designed so that the page title can be checked at the most necessary timing. You can modify the address by clicking it. All the necessary functions are included.

70 Things Every Computer Geek Should Know. The term ‘geek’, once used to label a circus freak, has morphed in meaning over the years. What was once an unusual profession transferred into a word indicating social awkwardness. As time has gone on, the word has yet again morphed to indicate a new type of individual: someone who is obsessive over one (or more) particular subjects, whether it be science, photography, electronics, computers, media, or any other field. Photoshop Shortcuts – The Fun Way In this post I’m going to focus on several Photoshop shortcuts that I tend to use more often than others. Sure I could sit here and spell out every single shortcut available, but why reinvent the wheel? Here is a list of 10 of my favorite and most used Photoshop shortcuts delivered to you via Mr. Stickman.

Kevin William Pang 10. Comments explaining “what”, but not “why” Introductory-level programming courses teach students to comment early and often. And while this may be a useful practice during programming infancy (when even the simplest line of code can be incomprehensible), many programmers never bother to shake the habit. Do you have any idea what the code above does?

The 50 Best How-To Geek Windows Articles of 2010 Even though we cover plenty of other topics, Windows has always been a primary focus around here, and we’ve got one of the largest collections of Windows-related how-to articles anywhere. Here’s the fifty best Windows articles that we wrote in 2010. Want even more? The 18 Best Free Web Tools Chosen By You It’s the start of a new year and that means there’s infinite possibilities that lay before you. But you can’t move forward without arming yourself with the best free web tools and apps. I was perusing some of my favorite education blogs, social networks, and other time-sucking online spots when I came back to the Edublog Awards . I’m proud that Edudemic was nominated for a bunch of awards (didn’t win but what can ya do) but more importantly I’m impressed with the amount of effort put forward by the Edublogs team. They’ve rounded up some of the best education and technology resources on the planet.

The Freelancer's Toolset: 100 Web Apps for Everything You Will Possibly Need : Codswallop Posted by nitzan on Thursday, May 10th, 2007 Running a business for yourself means you have to be inventive and always on the lookout for a new and better way to get things done. Innovation junkies, take note: the Internet has a lot to offer. From invoicing to marketing, these are tools that freelancers need to know about. Organization

The 101 Most Useful Websites on the Internet Here are some of the most useful websites on the internet that you may not know about. These web sites, well most of them, solve at least one problem really well and they all have simple web addresses (URLs) that you can memorize thus saving you a trip to Google. And if you find this list useful, also check out the expanded version – The Most Useful Websites – which now offers a collection of 150+ undiscovered and incredibly useful websites to enhance your productivity. ctrlq.org/screenshots – for capturing screenshots of web pages on mobile and desktops. dictation.io – online voice recognition in the browser itself.

Related:  Utilemoversti