Advertisements

microsoft excel

  • Technology s a very important element in today’s society and no branch of society escapes the grasp of technology. Accounting is no exception and if you want to do your books you are going to need a program like Excel or else you’re just not going to be very efficient nowadays.  However, not a lot of people know how Excel can help them improve their accounting situation. Some people don’t have their own accountant and have to handle the accounting by themselves even though it’s not their primary attribute or concern within their context of work. Still, it doesn’t hurt to know these simple tricks that you can pull off with Excel in order to make accounting easier. Number formatting shortcuts Formatting can be a tricky business and often times it’s a very tedious process. That is, of course, if you don’t know how to use Excel’s formatting shortcuts to your advantage. If you don’t know about the formatting shortcuts, prepare to be amazed as you can use these to save precious time. Ctrl+Shift+1 – introduces two decimal places into your number formatting Ctrl+Shift+2 – Allows you to format your selection as time Ctrl+Shift+3 – Allows you to format your selection as a date Ctrl+Shift+4 – Allows you to format your selection as a currency Ctrl+Shift+5 – Allows you to format your selection as a percentage Ctrl+Shift+6 – Allows you to format your selection in exponential form Navigating through results Navigating through formulas and your cell data can be a very tedious task also and it can slowly eat away at your peace of mind. However, there is a simple solution for this. You can use a combination of two keys, specifically the Ctrl and tilde “~” combination in order to switch seamlessly between the two types of information. This...
  • Microsoft released a large update to Office386 today adding long new pieces of software and new features to existing software Kirk Koenigsbauer posted on the Office365 blog  “Office 365 provides the broadest and deepest toolkit for collaboration between individuals, teams and entire organizations. Updates this month make the experience even better with co-authoring in Excel, the general availability of Microsoft Teams and more.” Co-authoring in Excel  Co-authoring which is already available in Word, Excel, and PowerPoint. The update to Excel now enables co-authoring in Excel on Windows desktops for Office Insiders Fast. The feature allows users to know who else is working with the spreadsheet, see where they’re working and view changes automatically. Co-authoring is already available in Excel Online, Excel on Android, Windows Mobile and iOS (for Office Insiders).  Co-authoring in Excel for the Mac is in the works to be released as well. AutoSave  Microsoft is bringing AutoSave to Word, Excel, and PowerPoint on Windows desktops, for files stored in SharePoint Online, OneDrive and OneDrive for Business. Microsoft Teams  Microsoft is pushing teams really hard which is one of many collaboration tools that Microsoft has released over the last few years to compete with Slack and Salesforce. Microsoft Teams released earlier this month to all Office 365 commercial and educational companies. Microsoft Teams has over 150 integrations with other apps, services, and bots.  Microsoft Teams is now generally available in 181 markets and in 19 languages. Microsoft Bookings  Microsoft rolled out Bookings worldwide last week to Office 365 Business Premium subscribers. Bookings is making it easy for small businesses to schedule and manage appointments with their customers. Microsoft added the connection to your Office 365 calendar to manage appointments, customize your Bookings page, and stay connected on the go with iOS and Android apps. OneNote  Microsoft added many new improvements to OneNote this month. Microsoft added OneNote inking and accessibility update to the list with making inking more powerful and available...