Jump to content

Search the Community

Showing results for tags 'excel'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Site Related
    • News & Updates
    • Site / Forum Feedback
    • Member Introduction
  • News
    • General News
    • FileSharing News
    • Mobile News
    • Software News
    • Security & Privacy News
    • Technology News
  • Downloads
    • nsane.down
  • General Discussions & Support
    • Filesharing Chat
    • Security & Privacy Center
    • Software Chat
    • Mobile Mania
    • Technology Talk
    • Entertainment Exchange
    • Guides & Tutorials
  • Off-Topic Chat
    • The Chat Bar
    • Jokes & Funny Stuff
    • Polling Station

Categories

  • Drivers
  • Filesharing
    • BitTorrent
    • eDonkey & Direct Connect (DC)
    • NewsReaders (Usenet)
    • Other P2P Clients & Tools
  • Internet
    • Download Managers & FTP Clients
    • Messengers
    • Web Browsers
    • Other Internet Tools
  • Multimedia
    • Codecs & Converters
    • Image Viewers & Editors
    • Media Players
    • Other Multimedia Software
  • Security
    • Anti-Malware
    • Firewalls
    • Other Security Tools
  • System
    • Benchmarking & System Info
    • Customization
    • Defrag Tools
    • Disc & Registry Cleaners
    • Management Suites
    • Other System Tools
  • Other Apps
    • Burning & Imaging
    • Document Viewers & Editors
    • File Managers & Archivers
    • Miscellaneous Applications
  • Linux Distributions

Categories

  • General News
  • File Sharing News
  • Mobile News
  • Software News
  • Security & Privacy News
  • Technology News

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Found 8 results

  1. Microsoft will soon begin disabling Excel 4.0 XLM macros by default in Microsoft 365 tenants to protect customers from malicious documents. Excel 4.0 macros, or XLM macros, were first added to Excel in 1992 and allowed users to enter various commands into cells that are then executed to perform a task. Malicious XLS document with obfuscated Excel 4.0 macro While VBA macros were introduced in Excel 5.0, threat actors continue to XLM macros twenty years later in malicious documents that download malware or perform other unwanted behavior. Malicious campaigns utilizing Excel 4.0 XLM macros include ones for malware, such as TrickBot, Qbot, Dridex, Zloader, and many more. Due to their continued abuse, Microsoft has been recommending users switch from and disable Excel 4.0 XLM macros for years in favor of VBA macros. This recommendation is because VBA macros support the Antimalware Scan Interface (AMSI), which can be used by security software to scan macros for malicious behavior. To disable Excel 4.0 macros, Windows admins can use group policies to disable the feature, and users can disable it via the Excel Trust Center using the Enable XLM macros when VBA macros are enabled setting. Enable XLM macros when VBA macros are enabled in Excel Trust Center Microsoft to disable Excel 4.0 macros in all tenants Instead of waiting for organizations to disable XLM macros on their own, Microsoft announced yesterday that they would be disabling Excel 4.0 macros by default starting in October in preview builds and then moving onto the current channel in November. "We are introducing a change to the Excel Trust Center Macro settings to provide a more secure experience for users by default. This new default behavior will disable Excel 4.0 macros," explained an advisory in the Microsoft 365 message center. Microsoft will begin disabling Excel 4.0 macros in all tenants using this rollout schedule: Insiders-Slow: will rollout in late October and be complete in early November. Current Channel: will rollout in early November and be complete in mid-November. Monthly Enterprise Channel (MEC): will begin and complete rollout in mid-December. Microsoft will not be making any changes for users who have manually configured this setting or configured it via group policies. When the change rolls out, the Enable XLM macros when VBA macros are enabled setting will be unchecked by default, which disables XLM macros. Microsoft states that users who wish to enable XLM macros after this rollout has finished can do so in the Excel Trust Center. Microsoft is disabling Excel 4.0 macros by default to protect users
  2. Excel is being used as fresh bait for phishers- here’s how Evil Corp has found a new way to phish their victims- using Microsoft Excel documents. The cybercrime group, also known as TA505 and SectorJo4, are financially motivated cybercriminals. They’re renowned for targeting retail companies and financial institutions with large-sized malicious spam campaigns, using Necurs botnet; but now, they’ve adopted a new technique. In their latest scam, they’re sending attachments featuring HTML redirectors with malicious Excel documents. Through the links, they’re distributing remote access Trojans (RATs), as well as the malware downloaders that delivered the Dridex and Trick banking Trojans. This also includes Locky, BitPaymer, Philadelphia, GlobeImposter, Jaff ransomware strains. “The new campaign uses HTML redirectors attached to emails. When opened, the HTML leads to the download Dudear, a malicious macro-laden Excel file that drops the payload,” “In contrast, past Dudear email campaigns carried the malware as an attachment or used malicious URLs.” -Microsoft Security Intelligence’s researchers. Upon opening the HTML attachment, the victim will automatically download the Excel file. Once they open it, this is what they’re met with: Once the target clicks on “Enable Editing” as they’re instructed to in the document, they’ll unleash the malware on their system. After this point, their device will also be infected with an IP traceback service, which “track(s) the IP addresses of machines that download the malicious Excel file.” Threat Analytics report (Microsoft) As well as this, the malware includes GraceWire- an info-stealing Trojan, which collects sensitive information and relays it back to the perpetrators via a command-and-control server. View the full list of Indicators of Compromise (IOCs), including SHA-256 hashes of the malware samples used in the campaign, here and here. Source: bleepingcomputer Source: Excel is being used as fresh bait for phishers- here’s how (MSPoweruser)
  3. Excel's new XLOOKUP function is now generally available Today, Microsoft announced that the new XLOOKUP function for Microsoft Excel is now generally available for Office 365 users. XLOOKUP was first announced back in August of last year and in November, at Ignite, Microsoft said it would hit general availability in the following months. It has been in testing with Office Insiders in the meantime. As the name might suggest to those already familiar with Excel, XLOOKUP is a successor to VLOOKUP, but it can also replace HLOOKUP, since it combines the features of both. That means you can use XLOOKUP to find values both vertically and horizontally across the spreadsheet. What's more, XLOOKUP can find values to the left of the cell where you insert the function, so you won't be as restricted as you would be with the previous functions. Additionally, the function supports column insertions and deletions, so the changes you make to your spreadsheet won't break the outcome. If you'd rather stick to the old VLOOKUP function, it isn't going away, at least for now. However, Microsoft says the new XLOOKUP is faster and more efficient, so you may want to give it a spin. Source: Excel's new XLOOKUP function is now generally available (Neowin)
  4. Kutools - Combines More Than 300 Advanced Functions and Tools for Microsoft Excel Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. Undoubtedly, this powerful and user-friendly add-in will save Excel users a mass of working time and greatly improve working efficiency. 110,000+ Excel users’ choice. Full feature free trial 60-day, no credit card required! Combine multiple worksheet or workbooks into one workbook Count and sum cells based on background/font color Split cell contents into multiple rows/columns by space/comma/delimiter Batch Remove leading spaces in cells Homepage Changelog v19.00 Official Installer Keygen by OnLyOnE Keygen + Installer Size: 63,8MB Site: https://www86.zippyshare.com Sharecode: /v/dkGCAK5h/file.html Not Tested
  5. Microsoft announces natural language queries and more for Excel At this year's Ignite event, Microsoft has announced some improvements coming to Excel in the coming weeks and months. Some of these were already known about, such as the new XLOOKUP function and dynamic arrays, which make formulas more capable by allowing a single formula to display results in multiple cells. Microsoft did announce that dynamic arrays feature is hitting general availability in Excel on the web this week, but XLOOKUP is still planned to be generally available "in the coming months". There are other new features coming to Excel though, starting with natural language queries, which are part of the Ideas feature in Excel. It lets you use natural language to ask Excel certain questions and it will return the relevant insights using the data in your document. This capability is rolling out to Office Insiders today, and it will be available on Mac, Windows, and the web, but only in English for now. Another new feature is called Sheet View, which is meant to be used when co-authoring spreadsheets. It lets users choose whether their sorting and filtering criteria should apply to everyone working on the document or only to the user, so that data doesn't mysteriously go missing for other people working on the document. If the user makes changes just for themselves, that view can also be saved so it can be accessed later as a separate view without disrupting work for other users. Sheet View will be available in Excel on the web before the end of 2019. There's also a new Office Scripts feature, which lets users easily record a series of actions and save that sequence as a script to automate those actions in the future, without the need for any code. The scripts are saved on OneDrive for Business and can be reused across workbooks. The feature is coming to Excel on the web before the end of the year. Finally, Microsoft announced the ability to classify documents based on the sensitivity of the information. Manual labeling is already available on Mac and mobile devices, but it's rolling out now to Excel on Windows and the web. It's also possible to make it so that sensitivity labeling is applied automatically, and that feature is rolling out to Fast ring Insiders on Windows. It's also available in private preview on the web. Source: Microsoft announces natural language queries and more for Excel (Neowin)
  6. Microsoft announces new Excel function that lets you visualize stock history Microsoft has announced a new function for Excel, which is designed to help users visualize the historical data data for a company over time. Called STOCKHISTORY, the new function leverages the Stocks data type, and the dynamic arrays feature that was added recently to grab stock values for different dates and list them all. For those unfamiliar, dynamic arrays made it possible for a function to be introduced in a single cell but spill out data in multiple cells. This capability launched with functions such as SORT, FILTER, and more, but now STOCKHISTORY is also making use of it to display historical stock data. The function can be used with a multitude of arguments that let you set what data you want to see. The stock argument defines which company or financial instrument you want the data on, and it can also be used to define which exchange to get the data from; start_date defines the first point in time when data should be collected; end_date defines the last point you want data on, but it's optional; interval defines whether you want daily, weekly, or monthly data, and it's also optional, setting to daily by default; and headings lets users create additional header rows are needed for the results returned by the function. There are also five properties that can be added to select which information to be includes, such as the date, the opening or closing value, high, low, and volume. The new STOCKHISTORY function is currently available to Microsoft 365 users in the Beta channel, which used to be known as the Office Insider Fast ring on Windows devices prior to a name change announced yesterday. It should make its way to everyone over time. Microsoft announces new Excel function that lets you visualize stock history
  7. Beware the wrong tool in the wrong hands Who, Me? If there is one Microsoft product guaranteed to send a shiver down the spine of an IT pro more than Excel shoehorned into the wrong place, it's Access inserted into any place. Welcome to Who, Me? Our story comes from an anonymous financial services company where a reader Regomised as "Chris" used to work back in the day. He ran a branch office, which employed 20 people and was responsible for supplying custom servers, built in-house, to connect customers to the outfit's POS network. The IT team initially consisted of our hero and a PFY, and the duo performed all the duties required to keep the lights on, as well as building servers to order. It was a delightfully simple system. An order would come in, one of the pair would eyeball the stockroom, collect required hardware, and order in any components that were running low. It all went swimmingly… "until the Operations Manager got involved," explained Chris. The manager looked at the value of some of the parts ("Ariel 32 DSP Modems and the like") and decided that a stock control application was needed to keep track of everything. The Been-There-Done-That merchants will be unsurprised to learn that "the cost of upgrading our accounts package with a stock module was deemed too expensive, so the Operations Manager, who thought of himself as a bit of a coding wizard, decided he would build one." What could possibly go wrong with such an approach? "His choice of database left a lot to be desired," sighed Chris, "and we ended up with MS Access as the back-end database as he had done a course on it and liked it." To be fair, Microsoft Access does have its uses. It is, however, not always "the right tool for the job" and has frequently been found rammed into the most distressing of places by over-enthusiastic amateurs delighted to find it in the Office suite. "The PFY and I waited," said Chris, "with various degrees of trepidation for the new stock database to land." "Test versions were rolled out and tested, and we reported the catalogue of faults to the ops manager. Most of the faults were related to adding and removing stock." "Which is pretty vital in a stock system," he understated. Back and forth the bug reports went, until the Operations Manager finally declared his baby fit for production. The big red button was pushed and… "From the start it was a train crash," stated Chris. Every month there were discrepancies between what was in that .mdb file and what was actually on the shelves. Every month the Ops Manager fiddled with the code to fix the errors and would end up breaking something else. Chris and his PFY eventually tired of the shenanigans and simply performed a variant on month-end stocktaking. Each month the pair would pull up a report of what the app thought was in stock, compare it to the shelves and, where there was excess… Hide the items under the floor. "Bigger items like the 4u chassis we used," he added, "were taken up to the plant room on the roof and hidden in there." Of course they were. If there was a shortfall, the duo simply hauled things out of hiding to make up the numbers. The Operations Manager was overjoyed – as far as he was concerned, his magical Access app was now working correctly. He was never told of the physical hack implemented to kick things ticking over. Presumably up until Chris and the PFY both moved on and the bugs made a mysterious reappearance. "I still wonder if anybody ever found the untold thousands of pounds worth of kit we had hidden under the floor or in the plant room," mused Chris. Source
  8. LjubeGVG

    Microsoft Office excel

    I want to make a workbook that calculates average in excel. for ex. 45667234. to calculate i must type each number in new cell. Can i make somehow type 45667234 in 1 cell and calculates average of separate numbers. Thanks. PS. I know whis is not the place to ask this but i don't know where else to post an nsanedown nas been of much much help to me.
×
×
  • Create New...