Connect with us

Technology

Ultimate Microsoft Office Mastery: 90+ Tips, Tricks, and Tutorials for You

Published

on


Use Microsoft Office every day? Check out our tips, tricks, and tutorials that’ll turn you into an efficiency machine with both Microsoft Word and Microsoft Excel.

Microsoft Office is powerful; there’s a reason why nearly every serious business in the world relies on it for office productivity. Yes, Microsoft Office can be daunting to learn, what with all of its crazy menus and features—but it doesn’t have to be difficult at all.

If you use either Microsoft Word or Microsoft Excel on a regular basis and want to become a more fluent user, we have all kinds of tips, tricks, and tutorials that’ll help you effortlessly learn the ins and outs of each program. You’ll be a master in no time!

Getting Started With Microsoft Office

If you’re a new user, or if you don’t even have Microsoft Office yet, you may want to check out our articles on how to acquire a copy of Microsoft Office for free—without breaking the law. Did you know you can even use Microsoft Office on Linux computers?

Once Microsoft Office is installed, you may also want to make a few tweaks and install a few add-ins that’ll ease your overall experience:

Mastering Microsoft Word

microsoft-word-auto-update

Beginner Tips for Microsoft Word

The first step to getting comfortable with Microsoft Word is making sure it’s set up properly. With a few tweaks to the settings, and some familiarity with basic features, you’ll feel much more at home when using the software:

And then once you’re comfortable with Microsoft Word, that’s when you’ll want to check out our various tutorials on how to do things with it, which will give you a quick boost to productivity:

Advanced Tips for Microsoft Word

After acquainting yourself with the basics of Microsoft Word, that’s when you’ll be ready to try full-fledged projects that are more than just simple essays and typed reports. Here are some of the cooler things you can do with Microsoft Word:

Useful Templates for Microsoft Word

Don’t have time to make new documents from scratch? You aren’t alone. That’s why you should check out our roundups of the best Microsoft Word templates for all kinds of needs and use-cases:

Mastering Microsoft Excel

For many, Excel is the much tougher software compared to Word. Numbers and formulas will do that to you. That’s why before you dive into our Excel tips and tricks, we recommend starting with these introductory articles:

Beginner Tips for Microsoft Excel

The first and most important skill to learn in Microsoft Excel is understanding worksheets and tabs. Check out our beginner articles that teach you how to set up, edit, recover, and compare Excel worksheets with ease:

And then learn the other essential skills that’ll give you a leg up when it comes to creating and modifying Excel spreadsheets. There’s a lot of cool stuff you can do, and most of it’s quite easy once you know how to do them:

Advanced Tips for Microsoft Excel

Microsoft Excel is a powerhouse application, and with a bit of know-how, you can effortlessly pull off some crazy cool tasks. Here are some of the more advanced techniques you can use to manage your Excel worksheets:

And there are plenty of more advanced tricks you can use to automate much of the process when dealing with complex Excel spreadsheets, and these automations will save a ton of time over the long run:

Useful Templates for Microsoft Excel

Who has the time to build new Excel spreadsheets from scratch? Whether for personal or business use, you should consider downloading one of the many free templates available on the web and customizing it to your specific needs:

Read the full article: Ultimate Microsoft Office Mastery: 90+ Tips, Tricks, and Tutorials for You



Source link

قالب وردپرس

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Technology

Hackaday Links: March 29, 2020

Published

on


It turns out that whacking busted things to fix them works as well on Mars as it does on Earth, as NASA managed to fix its wonky “mole” with a little help from the InSight lander’s robotic arm. Calling it “percussive maintenance” is perhaps a touch overwrought; as we explained last week, NASA prepped carefully for this last-ditch effort to salvage the HP³ experiment, and it was really more of a gentle nudge that a solid smack with the spacecraft’s backhoe bucket. From the before and after pictures, it still looks like the mole is a little off-kilter, and there was talk that the shovel fix was only the first step in a more involved repair. We’ll keep an ear open for more details — this kind of stuff is fascinating, and beats the news from Earth these days by a long shot.

Of course, the COVID-19 pandemic news isn’t all bad. Yes, the death toll is rising, the number of cases is still growing exponentially, and billions of people are living in fear and isolation. But ironically, we’re getting good at community again, and the hacker community is no exception. People really want to pitch in and do something to help, and we’ve put together some resources to help. Check out our Hackaday How You Can Help spreadsheet, a comprehensive list of what efforts are currently looking for help, plus what’s out there in terms of Discord and Slack channels, lists of materials you might need if you choose to volunteer to build something, and even a list of recent COVID-19 Hackaday articles if you need inspiration. You’ll also want to check out our calendar of free events and classes, which might be a great way to use the isolation time to better your lot.

Individual hackers aren’t the only ones pitching in, of course. Maybe of the companies in the hacker and maker space are doing what they can to help, too. Ponoko is offering heavy discounts for hardware startups to help them survive the current economic pinch. They’ve also enlisted other companies, like Adafruit and PCBWay, to join with them in offering similar breaks to certain customers.

More good news from the fight against COVID-19. Folding@Home, the distributed computing network that is currently working on folding models from many of the SARS-CoV-2 virus proteins, has broken the exaFLOP barrier and is now the most powerful computer ever built. True, not every core is active at any given time, but the 4.6 million cores and 400,000-plus GPUs in the network pushed it over from the petaFLOP range of computers like IBM’s Summit, until recently the most powerful supercomputer ever built. Also good news is that Team Hackaday is forming a large chunk of the soul of this new machine, with 3,900 users and almost a million work units completed. Got an old machine around? Read Mike Sczcys’ article on getting started and join Team Hackaday.

And finally, just because we all need a little joy in our lives right now, and because many of you are going through sports withdrawal, we present what could prove to be the new spectator sports sensation: marble racing. Longtime readers will no doubt recognize the mad genius of Martin and his Marble Machine X, the magnificent marble-dropping music machine that’s intended as a follow-up to the original Marble Machine. It’s also a great racetrack, and Martin does an amazing job doing both the color and turn-by-turn commentary in the mock race. It’s hugely entertaining, and a great tour of the 15,000-piece contraption. And when you’re done with the race, it’s nice to go back to listen to the original Marble Machine tune — it’s a happy little song for these trying times.



Source link

قالب وردپرس

Continue Reading

Technology

WHO to launch coronavirus app for iPhone and Android

Published

on



  • The World Health Organization will release an official coronavirus information app for iPhone, Android, and the web.
  • The WHO MyHealth app will launch on March 30th and will include all the information the organization already pushes to its official WhatsApp chatbot.
  • The first version of the app will provide self-diagnose help and assistance, while future releases might help combat the spread of epidemics.
  • Visit BGR’s homepage for more stories.

Combating misinformation campaigns meant to spread fear and uncertainty about the novel coronavirus is just as important as staying indoors for as long as possible and washing your hands with soap for at least 20 seconds as often as you can. That’s why websites such as Google’s COVID-19 site are a great resource for staying updated on the coronavirus facts and developments.

But even Google sources its information from various authoritative organizations, including the Centers for Disease Control and Prevention (CDC) and the World Health Organization (WHO). Those two will provide all the COVID-19 information you need, including symptoms and guidance on what to do if you’re infected, so it’s a good idea to have them bookmarked. WHO access is going to get even better in the weeks to come, though, thanks to an official coronavirus app that the organization will launch on iPhone, Android, and the web.

Working on the project are former Google and Microsoft employees as well as WHO advisors and ambassadors, according to 9to5Google. The organization is set to release the WHO MyHealth app on March 30th, although the code is already available as the app is open source. 9to5Google looked at the current version of the app, as seen in the screenshots below:

The app will relay the same information the WHO offers on its official WhatsApp bot, including helpful tips on what to do if you think you may be infected with the new coronavirus.

A future version of the app might prove to be even more helpful, as it could offer real-time alerts based on your location. In the future, the app could be used to track confirmed cases and access their location history in an attempt to perform contact tracing. The information could be used to better understand how the virus has traveled inside a community, at the cost of privacy:

Leveraging existing technology like Google Maps, allows users to indicate whether they have been diagnosed or have come into contact with COVID-19 patients. In addition, request permission to track historic location data on their device.

That’s only a proposal, however. The app won’t track you unless you explicitly let it do so, provided the first version has any built-in tracking abilities. But future releases could help the WHO react better to other pandemics. The primary purpose of the app is to provide the immediate assistance you might need, including quick answers to help you self-diagnose your condition.

There’s one other interesting aspect of the app, on the technical side of things. The app has been built with Flutter, which is Google’s new SDK that allows developers to code a single app and release it on iPhone, Android, the web, as well as the exciting operating system that will soon replace Android: Fuchsia.



Source link

قالب وردپرس

Continue Reading

Technology

Marine species ‘relocating towards the poles’ due to rising temperatures

Published

on


Marine species are moving towards the Earth’s poles to escape the warming oceans (Getty)

Marine species are relocating towards the poles due to rising ocean temperatures, scientists have said.

The researchers, including scientists from the universities of Bristol and Exeter, looked at data on over 300 marine plants, birds and animals spanning more than a century.

They found a ‘general pattern’ where species showed increasing population densities towards the poles but declines in numbers in the habitats near the equator.

The team believes its findings, published in the journal Current Biology, indicate rising temperatures have led to widespread changes in the population size and distribution of marine species.

Martin Genner, an evolutionary ecologist at the University of Bristol and senior study author, said: ‘The main surprise is how pervasive the effects were.

‘We found the same trend across all groups of marine life we looked at, from plankton to marine invertebrates, and from fish to seabirds.’

The world’s oceans have warmed by an average of 1C since pre-industrial times, the researchers said.

To find out how this temperature change has affected marine life, the team reviewed 540 published records of species abundance changes – their occupancy trend over time.

Climate change is warming the Earth's oceans (Alexis Rosenfeld/Getty Images)

Climate change is warming the Earth’s oceans (Alexis Rosenfeld/Getty Images)

They found certain species to be thriving well in the cooler regions of the oceans, with rising temperatures opening up previously inaccessible habitats.

For example, the researchers said, the populations of Atlantic herring and Adelie penguins were both declining in abundance near the equator but increasing in abundance towards the polar regions.

But they found conditions of habitats near the equator were too warm to tolerate.

Louise Rutterford, a study author based at both Exeter and Bristol universities, said: ‘Some marine species appear to benefit from climate change, particularly some populations at the poleward limits that are now able to thrive.

‘Meanwhile, some marine life suffers as it is not able to adapt fast enough to survive warming, and this is most noticeable in populations nearer the equator.

‘This is concerning as both increasing and decreasing abundances may have harmful knock-on effects for the wider ecosystem.’

VINCENNES BAY, ANTARTICA - JANUARY 11: Giant tabular icebergs are surrounded by ice floe drift in Vincennes Bay on January 11, 2008 in the Australian Antarctic Territory. Australia's CSIRO's atmospheric research unit has found the world is warming faster than predicted by the United Nations' top climate change body, with harmful emissions exceeding worst-case estimates. (Photo by Torsten Blackwood - Pool/Getty Images)

Warming is predicted to increase throughout this century (Torsten Blackwood – Pool/Getty Images)

With warming predicted to increase up to 1.5C over pre-industrial levels by 2050, the researchers said species are likely to undergo further shifts in population distribution in coming decades.

Mr Genner said: ‘This matters because it means that climate change is not only leading to abundance changes, but intrinsically affecting the performance of species locally.

‘We see species such as Emperor penguin becoming less abundant as water becomes too warm at their equatorward edge, and we see some fish such as European seabass thriving at their poleward edge where historically they were uncommon.’



Source link

قالب وردپرس

Continue Reading

Trending