Skip to main content

Posts

Showing posts from December 30, 2018

10 Most Useful Microsoft Excel Tips

1. Conditional Formatting   Making sense of our data-rich, noisy world is hard but vital. Used well, Conditional Formatting brings out the patterns of the universe, as captured by your spreadsheet. That's why Excel experts and Excel users alike vote this the #1 most important feature. This can be sophisticated. But even the simplest colour changes can be hugely beneficial. Suppose you have volumes sold by sales staff each month. Just three clicks can reveal the top 10% performing salespeople and tee up an important business conversation. 2. PivotTables At 4 hours to get to proficiency, you may be put off learning PivotTables, but don't be. Use them to sort, count, total or average data stored in one large spreadsheet and display them in a n1ew table, cut however you want. That's the key thing here. If you want to look only at sales figures for certain countries, product lines or marketing channels, it's trivial. Warning: Make sure your data is clean first

12 of the Most Important Phrases to Know in Every Language

1. Hello! Good day. These will likely be the words you hear most in your travels, whether it’s from hoteliers, waiters, shopkeepers, or people around town. Practice your accent by throwing out a hearty “bonjour!” or “buenos d├нas!” 2. I don’t speak ___. Do you speak English? Almost immediately after your greeting, you’ll probably have to break this one out. Commit it to memory for those times when someone comes up to you on the street or in a store with a rapid-fire slew of words that are foreign to you. In that moment, you’ll probably be at a loss for words, and you don’t want to have to shuffle around for your phrasebook for too long. 3. Please and Thank You Endear yourself to those around you by being as polite as you can. Know the words for please and thank you, and use them often. No doubt it will make people a little more patient when you’re confused or trying to figure out unfamiliar customs. 4. Help! When exploring a new place, it’s good to be well versed in how t