When we talk about online streaming and OTT, we come across many terms, among which IPTV is one of them. We are undergoing a transition from traditional broadcasting modes such as cable or satellite television to streaming based on the Internet, and IPTV as a system will play an important role in this transitional stage.
Basically, customers are not as concerned about owning content as they are about accessing it. This is where IPTV appeared. Let's carefully study the exact meaning of IPTV, its working mode and architecture, the types of IPTV services, and the future of IPTV. So, what is IPTV?
IPTV refers to protocol television based on the Internet, where the Internet is used to provide live or on-demand television programs and videos. IPTV is a system in which digital television services are transmitted to subscribers through broadband or Internet connected media through Internet protocol technology. It is slightly different from the digital videos accessed by millions of users on websites or applications such as YouTube or Netflix, but it has ubiquitous universality. Unlike standard cable or satellite connections, in IPTV, multiple televisions can use a single subscription in a single home.
IPTV brings more advantages and convenience to viewers, allowing them to choose the programs they want to watch anytime, anywhere, without having to watch any live TV programs currently playing. To understand how IPTV differs from traditional television, let's compare traditional television viewing methods with IPTV - both cable and satellite can work by allowing users to "tune" to specific channels within the signal, while the fundamental difference is that the cable is connected through cable while the satellite is wireless (until it reaches your house). The main example of cable TV is Time Warner cable, which is transmitted through coaxial cable connections, while the example of satellite TV comes from providers like DirecTV, which is transmitted and transmitted to the audience through radio waves.
IPTV uses an Internet Protocol (IP) based network to transmit TV channels to users' set-top boxes. Unlike cable and Satellite Network, the Internet provides content by providing the same client server model that presents e-mail, websites, and other Internet based services. As we will further mention in this blog, IP or Internet protocol is a language used to transmit data packets between computers connected to the Internet network.
Consumers request and receive TV programs, and video content is transmitted to viewers through an Internet Protocol (IP) based network (rather than cable or satellite). IPTV does not transmit content in real-time like cables or satellites, but forgets the model through transmission. IPTV can store programs on servers at the transmission end, allowing users to request content anytime through the Internet.
Compared to traditional channel surfing, IPTV is very similar to browsing the internet. It only uses IP (Internet Protocol), which is a transmission mechanism used to transmit videos to viewers. When viewers click on any TV program or request a video, videos from different sources (servers) will be divided into packets and sent over the Internet. The video server transmits the program to an existing home through an internet connection through a fiber optic cable, sends a request, and puts the program back in.
In the past few years, IPTV has been continuously growing. The total number of global IPTV users has now exceeded the 130 million mark. As of the end of 2015, there was a net increase of 6 million subscribers in the past 24 months. On this basis, many young people will tailor their home IPTV usage to OTT services.

It is possible that the Microsoft Office version on your computer is not bound to the same Microsoft account as yours. Uninstalled Microsoft Office on the new computer in the control panel, and then logged in using a Microsoft account on the official website to download and install it again.
Step 1: Office reinstallation steps? Firstly, enter the Microsoft official website at account. microsoft.com/
Step 2, log in to a Microsoft account that has already activated the office.
Step 3. After entering the website, click on Services and Subscribe.
Step 4. From now on, you can see that all the installed offices are here. If your Microsoft account has not been bound to any version of Microsoft Office, you can obtain an activation key from Microsoft Office product key - officech.com and input it to bind before downloading.
Step 5. Choose any office to install.
Step 6. Click on download, it is recommended to download to the desktop, which is easier to find.
Step 7. Finally, double-click the downloaded office to install it.
Step 8: Double click to open the downloaded OfficeSetup.exe file and wait for the download.
Step 9: After the installation is completed, simply click [Close] to complete the installation.
Step 10: After installation, open any Office component [Excel, Word, PowerPoint], click on [File] in the upper left corner, and click on [Account] - [Login] in the lower left corner to reactivate Office.

Both S Office and Microsoft Office software are the most commonly used productivity office software in the era of digital office on the Internet. Both software are used by over billions of users, making it essential for students, teachers, and workplace workers to interact with them. Are you thinking about the relationship and differences between WPS and Office? This article will come together for you.
1. Different software development companies
WPS is an office software launched by Chinese internet company Jinshan Company, which first appeared in 1989 and is the world's first Chinese based word processing software. Office (Microsoft Office) is a set of office software developed by the American internet company Microsoft, which originated from Word 1.0 software developed by Microsoft in 1984 for Apple's Mac computer.
2. The product suite software is different
WPS typically includes WPS text, WPS tables, WPS presentations, WPS PDFs, and Kingsoft documents, while MS Office includes software such as Word, Excel, PowerPoint, Outlook, OneNote, Access, Publisher, Visio, Project, SharePoint, etc.
3. Different operating systems supported
WPS supports iOS, Android, Windows, Mac, Linux operating systems, as well as online web collaboration documents. Microsoft's Office platform is the same as WPS, except that it cannot run natively on the Linux operating system.
4. Different software volume sizes
The WPS installation package is relatively small, and the desktop typically only takes up hundreds of MB of hard disk space, resulting in faster startup. MS Office, on the other hand, has a larger volume and requires a longer installation time, typically occupying several GB of space.
5. Different software functions and performance
WPS software has a better localization experience for Chinese users, with more user-friendly functions and interface operations. It provides many convenient and fast operations and template materials, but there are slight performance disadvantages, such as opening thousands of rows of Excel table data, which may cause some lag. Although Office requires a certain learning curve, its functionality and performance are more powerful, and it can load documents with large amounts of data at a faster speed.
6. Different pricing models for fees
WPS adopts a free value-added pricing model, and the vast majority of features can be used for free for life. The membership version charges 89 yuan per year, while the super membership version charges 179 yuan per year. Microsoft Office adopts a trial or buyout system. The Office 365 personal version costs 398 yuan per year, while the home version costs 498 yuan per year and can be used by 1 to 6 people. The Office 2021 one-time buyout costs 1998 yuan.
7. File cloud storage space is different
The free version of WPS provides 1GB of cloud storage space, the member version has 100GB of cloud storage, and the super member version has 365GB of cloud storage. For Microsoft Office, free users have 5GB of OneDrive cloud storage space, and paid individual users have 1TB of cloud storage space.
8. Different software compatibility
As early as 1996, Microsoft proposed to collaborate with Kingsoft to share WPS Office format with Microsoft Office format in order to enter the Chinese market, making the two compatible. Later on, with the popularity of the Windows system, more and more users turned to Office software. Microsoft Office was no longer compatible with WPS document formats, while WPS had to be overturned to fully compatible with Office software formats.

Office 2021 includes Word, Excel, PowerPoint, Outlook, OneDrive. The latest version of Office will come with new dark mode support, auxiliary function improvement, performance improvement for Word, Excel, PowerPoint, Outlook, excel dynamic array, XLOOKUP for Excel and other new functions.
Office 2021 Highlights and Features
Undoubtedly, it is an office designed specifically for Mac
Get started quickly, using the new modern versions of Word, Excel, PowerPoint, Outlook, and OneNote, combined with familiar Office and your favorite unique Mac features.
To do for the sake of doing
Quickly find the features you need and create documents more easily with built-in automated design and research tools.
Collaborate
You can work online or offline, on your own or with others in real-time - no matter what you are doing.
move
With 1 TB of cloud storage, your documents can be used anytime, anywhere, so you can continue where you left off.
Office meets your needs
Use Office to continuously execute tasks in a faster and new way, achieving the desired results.
Search for commands using 'operating instructions'
Simply inform Word, Excel, or PowerPoint of the desired operation, and the "Operation Instructions Search" function will guide you to find the command.
Implementing verification using Bing supported 'intelligent search'
Intelligent Find uses highlighted terms and other contextual information of the document to provide search results from the web, and all operations are completed within the document.

Top Five Features of Office 2021 Update
Dynamic array in Excel (one formula returns multiple cells)
XLOOKUP in Excel is more powerful and easier to write than VLOOKUP
Inventory images built into PowerPoint (and other applications)
Simultaneously editing Excel, PowerPoint, and Word desktop applications
Translation tools for emails, phrases, and almost everything
All Microsoft Office apps
You will notice the rounded edges, performance updates, and other small user interface changes on the ribbon tab (such as the undo/redo button being moved, the search bar being updated, and text, commands, documents, help, etc. can now be found). Microsoft documentation has made some updates to all applications here, but this list is more complete:
Hide Quick Access Toolbar: Your Quick Access toolbar may disappear by default, but you can restore it by right-clicking the ribbon and selecting Show it. Then, when you right-click the toolbar, you can choose to display the command label.
Collaborate with Excel, PowerPoint, and Word
Co author: Documents saved on OneDrive or SharePoint can now be edited by multiple people using desktop applications in Word, Excel, or PowerPoint, and you will see icons of each person's photo currently in the file. In addition to co creation, some enhanced features have also been introduced
Auto save: stored on OneDrive or SharePoint, you will be able to turn on/off auto save
Modern comments: Insert>comments and start a thread that may reply or @ mention colleagues. You can open the comment pane from the top right corner. The function previously known as' comments' in Excel has been renamed to 'comments' and can still be used from the' review 'tab.
Accessibility Checker: Review>Inspection Accessibility Now suggest how to improve the document.
Translation: Use 'Review'>'Translation' on phrases or entire documents/worksheets/slides
Excel Overview
A Microsoft blog about the new features of Excel 2021 is available for reading, but our list is more complete (for example, with Power Query functionality). The image shows the new features in this version and the features you may have missed from the past 10 years:
Unhide multiple worksheets: right-click on the worksheet → Unhide and then select multiple worksheets
LET: Simplify long formulas by assigning names to certain parts and then referencing them, usually referred to as variables in programming. Rewrite=IF (C6 * 1.05<200200+C6, C6 * 1.05) with=LET (FiveP, C6 * 1.05, IF (FiveP>200, FiveP, 200+C6)), where FiveP is the given and reused name.
Workbook Statistics: This review tab feature displays an overview of your worksheet and workbook. Identifying the last cell with data is also useful, as it can lead to particularly large file sizes.
Worksheet view: One person's filters may interfere with others' processes during simultaneous editing, so you can now filter or sort only for yourself, and you can also save the filter/sort view and reuse it.
XLOOKUP for Excel
XLOOKUP: VLOOKUP (the third most commonly used function in Excel) is now largely considered a legacy function and will continue to exist simply because most Excel users regretfully do not explore new features. Merging two tables by looking up values in another table is useful in many cases. VLOOKUP has always been necessary, but it is not convenient. Experts have always turned to the extremely complex INDEX MATCH combination. XLOOKUP not only fixes most of VLOOKUP's defects, but also more intuitively writes and understands for beginners while doing so.
The required syntax is XLOOKUP (lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]). Input 1-3 is required, I sometimes use 4 but rarely use 5-6. The following are its inherent VLOOKUP issues:
a) Default exact match (the most common use case).
b) Find from right to left or left to right because you specified columns instead of table arrays
c) Inserting columns in the lookup table will not cause problems.
d) XLOOKUP also replaces HLOOKUP as it applies to arrays (one column or one row)
e) If not found, returns the selected value with the fourth input.
Benefits of being more ambiguous based on the last two inputs
f) By approximate matching of the next maximum or next minimum item.
g) Search in reverse order.
XLOOKUP is not perfect as it still cannot handle duplicates in lookup tables or merge columns for lookup, but Power Query's merge queries can fill these gaps.
For bidirectional lookups using INDEX MATCH MATCH combinations, XMATCH (lookup_value, lookup_array, [match_mode], [search_mode]) is also useful.
Excel's dynamic array
A formula returns an output on a cell, which is how Excel has been working until now
Premise of dynamic array: a formula can now return multiple cells, replacing the overly complex concept of "array formula". Now you can execute=A3: A15 * B3: B15 in C3 instead of using=A3 * B3 and drag down to C15, and the results will be displayed in cells C3: C15:
You may see # SPILL! If the data is already in cell C4: C15, or if the dynamic array is set to return a value in an Excel table (although the table can be used as an input source), an error will occur.
#Reference: A5 # refers to a dynamic array starting from A5 (which can be a dynamic number of multiple rows or columns).
TRANSPOSE: Although this is not a new function, it is now easier to flip rows and columns linked to the source array.
ANYTHINGIFS: Nest an IF in TEXTJOIN to concatenate text according to standards, copy MEDIANIFS, STDEVIFS, or any similar method you prefer.
Six new functions have been released with dynamic array:
UNIQUE:=UNIQUE (Column) returns a unique value, and there are more advanced multi column options. The generated dynamic array grows or shrinks according to the source data.
SORT: I often use=SORT (UNIQUE (Array)) to create a sorted data validation list.
SORTBY: Use SORT to sort by the first column, otherwise I recommend SORTBY. Using SORTBY, you can refer to the columns to sort compared to SORT's column index numbers (which may be out of range).
FILTER: Generate a filtered output array for certain columns.
SEQUENCE: Generate a continuous number of specified array sizes, and set the start and step sizes. Use cases include TOP5 sales or all sales in the past 7 days.
RANDARRAY: Generate a random number matrix, specifying the required columns, rows, minimum and maximum values, as well as whether they must be integer values.
Power Query in Excel
Extract from PDF: Data>Get Data>From PDF, and even merge multiple PDFs into one folder
Fuzzy matching: Match Fred, Freddy, or Elizabeth with Lizzie or 078-524 with+4478542. When merging queries, check this option to match tight but imprecise text, specify ignoring case or spaces, match must be tight from 0 to 1 (default is 0.8), and the maximum number of matches is or matches with completely different conversion tables (such as UK to UK).
M IntelliSense: Obtain autocomplete functionality when writing custom M code in custom columns, advanced editors, or formula bars, such as in Excel, double-click or press Tab to lock suggestions
Input data: Add custom data directly in Power Query from this homepage tab function
Column analysis: A colored bar appears below the column name, displaying errors, null values, and values, but the view tab has new options.
By default, the first 1000 rows are displayed as all rows in the bottom left corner of the screen.
PowerPoint
The new features of PPT 2021 can be found on the Microsoft blog, but our list is more complete.
In addition to the first three, these features are also available in Excel, Word, and Outlook, but are most commonly used in PowerPoint
Slide link: If the document is saved in the cloud, you will get this option when you right-click on the slide
Reading order: Select how screen readers prioritize objects from "Review">"Check accessibility"
Enhanced recording: Slide Show>Recording now supports your videos, laser pens, and ink
Image transparency: configured through "Image Format">"Transparency"
Sketch lines: The new line format option means that the lines around the shape can now have curves that mimic hand drawn shapes
Hexadecimal code coloring: Set the color by clicking on 'More Colors', where you can change the color to type in hexadecimal or RGB codes
Auto Play Gif: Insert any Gif and automatically play, or click | | to pause
Ink update: Drawing>Ink can replay animations of previously created hand drawn ink, and also provides rulers, erasers, and lasso selectors (not in Outlook). By default, the drawing tab may not be open and can be enabled through File>Options>Customize Ribbon
Built in inventory image library
The 1000 types of inventory content in 6 categories are mainly used for PowerPoint, but can also be used for Excel, Word, and Outlook. More content is added every month, but non advanced subscribers can only access a portion of the library.
Inventory photos: Pixel perfect high-definition photos from Insert>Pictures>Inventory images, some with many blank spaces for eye-catching full screen slide backgrounds
More icons: Insert>Icons are now part of the library and larger
Cute character: Microsoft hires models to pose in different positions with transparent backgrounds
Sticker: Telegram/Snapchat generation will prefer these characters over cutting them out
Video: A subtle video that automatically plays without sound, looping through once completed, perfect for eye-catching title slides, only available in PowerPoint
Word
Word and Outlook have relatively few features besides the ones mentioned above
Dark mode: Click File>Account and select Black to obtain the true dark mode, with white text on the black canvas
Line Focus: View>Immersive Reader has a new 'Line Focus' view
Outlook
Translation function: Translate messages by right-clicking on the translation phrase or setting automatic translation from File>Options
Inking: The drawing tab in emails allows you to annotate emails or draw on a separate canvas. The drawing tab may not be open by default and can be enabled through File>Options>Customize Ribbon
With the help of dynamic array, XLOOKUP, Stock content and other updates, the Office 2021 upgrade may really change the rules of the game.

Office 2021 is a software that comes in two different versions: Office 2021 for large business and government users, and Office 2021 for consumers and small business users.
New feature 1: confidently create
Create captivating documents and presentations using new visual objects, and quickly find the content you need through improved navigation and search capabilities.
New feature 2: Arrange work and life
Efficiently manage messages, appointments, contacts, and tasks in one location. At the same time, easily control meetings, deadlines, and family time.
New feature 3: Easy tracking and organization
Use fewer and more powerful formulas to quickly build spreadsheets that update with information changes. Quickly find data using improved navigation and search functions.
New feature 4: Seamless collaborative work
Easily share files, receive notifications when others edit or mention you in comments, and quickly understand changes every time a document is opened. Better performance features can help the system run faster, and the new automatic save feature means that work content will never be lost again.
Compared to previous 2020 versions, Office 2021 has made functional improvements in the following areas, including:
1. Improved calculation functionality has been added to the new version of Excel software.
2. It can provide better insertion methods when adding functions.
3. The built-in functions are more diverse and the calculation process is easier.
4. It is also very useful for creating data models.
5. Office 2021 has also updated multiple functions in designing PPTs.
5. Provided a better icon design solution.
6. Support for a better UI interface, and scrolling to view PPT results is better.
7. When designing the PPT, the function of inserting icons online was provided.
8. Provides an icon library for easy insertion of desired icons.
The new version of Word also has many features.
10. Provides interface color adjustment function for better editing of Word.
11. Provided a new 'immersive learning mode'.
12. The article layout function is better, and adjusting text spacing, page width, etc. is better.
In addition, the new version of Word can also read articles aloud.
14. Added a new Microsoft voice engine to easily convert text to speech.
What's New in Office 2021
Improved operation interface: Office 2021 has made significant improvements to the operation interface, removing the 3D ribbon image at the beginning of opening Office2021 files and adding a large single image. The improvement of Office 2021 has only done some superficial work. The 'File Tab' has taken on a completely new look, making it more efficient for users to operate. For example, when a user wants to create a new document, they can see preview images of many available templates.
Full editing of PDF documents: PDF documents are really a headache, and it is said that they are headache because they have many inconveniences to use in work. Even if users want to extract some formatted or unformatted text from PDF documents, it is maddening. However, with the new version of the Office 2021 suite, this issue will no longer be an issue. Word in the suite can open PDF files and users can edit them as they please. You can save the modified results in PDF files or in any file type supported by Word.
Automatically create bookmarks: This is a new feature in Office 2021, which will undoubtedly improve the efficiency of those who work with large Word documents. Users can directly navigate to the previous work or browsing page without dragging the 'scroll bar'.
Built in image search function: It is not easy to search for images on the internet and insert them into PowerPoint presentations. Microsoft has also taken into account users' needs in this regard, and users can use Bing Search to find suitable images in Office 2021 and then insert them into any Office document.
Excel Quick Analysis Tool: For most users, using good methods to analyze and present data has always been a headache. With the Excel quick analysis tool in Office 2021, this issue has become much simpler. After users input data, Excel will provide some suggestions to better format, analyze, and present the data, and so on. Even some experienced Excel users will love this feature very much.

Microsoft just shipped a brand new cumulative update for Windows 10 devices, this time as a preview in front of the next Patch Tuesday rollout due in March.

The brand new update is KB5022906, and it is targeted at the latest versions of Windows 10 still receiving support, namely Windows 10 version 20h2, version 21H2, and version 22H2.

Microsoft reveals in the changelog that Windows Spotlight is getting further improvements around the lock screen, with links now opening faster when clicked.

The next changes are members of update KB5022906:

This update improves your experience if you use Windows Spotlight on your lock screen. The informational links open faster.
This update addresses an element that affects IE mode. The text around the status bar is not always visible.
This update addresses accessibility issues. They affect Narrator around the Settings webpage.
This update addresses an issue that stops hyperlinks from employed in Microsoft Excel.
This update addresses an issue that affects a particular streaming app. The issue stops video playback after an advert plays within the app.

With regards to known issues, Microsoft disapproves new bugs are included. However, the update ships with the same old glitch that impacts Microsoft Edge, with the legacy version of the browser removed although not automatically replaced by the brand new Chromium-powered browser.

Windows 10 will continue to get support until October 2025, as Microsoft is otherwise fully committed to increasing the experience with Windows 11. The discharge of Windows 11 came with upgraded system requirements, so some Windows 10 devices weren't permitted to move to the new operating-system.

As such, when the 2025 deadline is reached, Windows 10 could be pulled, with devices running it without other option rather than be replaced with hardware entitled to the switch to Windows 11.

In 2021 when Microsoft announced Windows 11, one of the biggest changes the new operating-system included did not concern the new features however the computers where it had been supposed to be installed.

Windows 11 was therefore offered with upgraded system requirements, essentially abandoning lots of devices which, at least initially, seemed perfectly able to running the OS.

Leaving aside the controversy produced by this approach, Windows 11 was therefore blocked on lots of computers.

The upgrade mysteriously turned up on unsupported devices this past year, despite Microsoft clearly proclaiming that computers not meeting the machine requirements would stick to Windows 10 until 2025 when the support comes to an end.

And earlier this week, everything happened again, with Microsoft once more providing the upgrade to Windows 11 to unsupported devices because of what Microsoft describes being an accident.

Inside a post around the Windows Health Dashboard, Microsoft says that the computers offered the upgrade weren't allowed to complete installing Windows 11 anyway. The issue has already been resolved, the company claims.

"Some hardware ineligible Windows 10 and Windows 11, version 21H2 devices were offered an inaccurate upgrade to Windows 11. These ineligible devices didn't meet the minimum requirements to operate Windows 11. Devices that experienced this issue were not able to to accomplish the upgrade installation process. This issue was detected on February 23, 2023, and resolved on the same day," Microsoft explains.

The organization still recommends users to stay with Windows 10 if their devices don't meet the system requirements to run Windows 11. Windows 10 will receive updates until 2025, at which point this OS version is going to be retired. Upgrading the hardware will become the only option, as otherwise, no further security updates could be available.

The release of the Windows 11 Moment 2 update witnesses a brand new improvement visiting the Start menu.

As most users have no doubt about, the debut of Windows 11 brought us a significant Start menu makeover. Now centered alongside all of those other taskbar icons, the beginning menu no more uses the live tiles that were available in Windows 10, but a more static design borrowed from Windows 10X.

Since the first form of Windows 11 rolled out, the beginning menu continues to be constantly getting further refinements. And the Moment 2 update continues this trend with goodies targeted at business users.

Devices running Windows 11 Pro will begin displaying recommendations and suggestions regarding files along with other content within the Start menu.

AI for the win

Microsoft says the whole experience is powered by AI, and also the purpose would be to make it easier for users to find the content they need in a easier and straightforward way.

"For those of you who use Windows in business setting, we're assisting you get to what you need more quickly and easily?awhether that be considered a file you'll need in an instant, or your cloud PC so that you can work the way you want," Microsoft says.

"Available on Windows 11 Pro devices and higher which are Azure Active Directory (AAD) joined, we're personalizing your experience by delivering AI-powered recommended content in your Start menu. Simply click to open the Start menu and discover related happy to assist you to get ready for upcoming meetings, quickly access files you're collaborating on, and more."

Moment 2 is now available for users who manually look for updates in Windows 11, however in business environments, the rollout is controlled by system administrators.

Microsoft has detailed the company's latest method to improve the delivery of Windows updates, especially in the case of companies where deploying urgent patches is important.

Available for devices enrolled in the Windows Update for Business deployment service (in Intune and Windows Update for Business), this program is mainly targeted at resolving zero-day security vulnerabilities in a timelier manner.

Microsoft says a great way is to configure the number of days necessary for a reboot to 1 or 2 days, as it prevents forced reboots to minimize the disruption within the organization.

Full focus on security updates

At the same time, additionally, it provides a reasonable window to deploy security updates, though when zero-days are now being involved, immediate rebooting might be required.

"If you are using the expedite capability the very first time, then just before reaching a zero-day vulnerability scenario, identify in case your devices are eligible to receive expedited updates or not. If your devices are current and active, perform a test run and expedite these to an older security update," Microsoft explains.

"For example, in case your devices possess the August security update, then you could test the expedite capability by utilizing target release as June. The Summary and Device reports in Intune will notify you if there are devices that could 't be expedited, together with reasons and mitigations. Note: We're exploring a future capability to test the expedite capability without needing to create an expedite policy for a quality update."

Microsoft says this program happens to be focused specifically on security updates, but at the same time, the organization reveals that it's also working on an identical approach specifically aimed at non-security patches. This expansion will make it possible for organizations to urgently deploy certain bug fixes and enhancements on their Windows 10 and Windows 11 devices, whilst enforcing a time to reboot for every machine.