One click to fix access errors: Accessibility Checker runs better than before thanks to updated international standards support and utility suggestions to help you access documents more easily.Use the Surface Pen to select and change objects : In Excel, with the Surface pen, you can select areas, without even touching the selection tool on the ribbon. Just press the function button on the pen and draw to select the area. You can then use the pen to move, resize, or rotate the ink object.Convert an ink drawing to a template : The Draw tab allows you to select an ink style and start creating ink annotations on your touch device. However, you can also convert the ink annotation to a template. Just select them, then click Convert to Shapes. In this way, you can draw freely while maintaining the uniformity and normalization of graphic shapes in Office.Easy Lasso Selection : Excel now also includes Lasso selection – a free profiling tool for selecting inks. Drag this tool to select the desired ink drawing area, then you can manipulate the object as you like.New Ink Replay Button : Using Ink in Spreadsheet? You can now replay or rewind the ink to better understand its flow. Your colleagues can also “replay” it for step-by-step instructions. You will find Ink Replay on the Draw tab.Write equations in ink : Writing math equations is easier. You can now Insert > Equation > Ink Equation , any time you want to attach a complex math equation in a workbook. If you have a touch device, you can use your finger or a stylus to manually write a math equation and Excel will convert it to text. If you don’t have a touch device, you can use a mouse to write.) You can also delete, select, and edit what you’ve written.Customizable Portable Pen Set : Create a portable pen set to suit your needs. Office remembers your pens in Excel on all Windows devices.Digital Pen : Write or sketch ideas with the new style pen.New ink effects : Express your ideas using metallic pens and ink effects like rainbow, galaxy, lava, ocean, gold, silver….Insert 3D models to see all angles: Use 3D to increase visual impact and creativity on workbooks. Easily insert 3D model, then you can rotate it 360 degrees.Convert SVG icons to shapes: Turn all SVG images and icons into Office shapes so you can change the color, size, and texture.Scalable Vector Graphics (SVG) : Make documents, spreadsheets, presentations visually appealing by inserting scalable vector graphics (SVG).Funnel Graph: A funnel graph shows multi-stage values in a process. For example, you can use a funnel chart to show sales prospects at each stage in a sales funnel. The values usually decrease gradually, causing the histogram bars to merge into a channel.Map charts : You can create cartographic charts to compare values and show categories across geographies. Use it when you have geographic areas in your data, such as country/region, state, county, zip code, etc.TEXTJOIN : This function combines content from multiple ranges, and each item is split by the delimiter you choose.SWITCH: This function evaluates the expression against an ordered list of values and returns the first match. If there is no match, the result will be “else”. MINIFS: This function is similar to MAXIFS, but it returns the smallest number in a range of numbers that meets one or more criteria.MAXIFS: This function returns the largest number in an array of numbers, which meets one or more criteria.IFS: Tired of complicated, overlapping IF functions? The IFS function will take care of that. With this function, the test conditions will be in the order you choose. If all is well, the result will be returned. You can also select “catch-all” if there are no matching conditions.CONCAT: This new feature is like CONCATENATE but better. Conspicuous, its name is shorter and easier to type. In addition, it also supports a range of references in addition to cell references.What’s New in Microsoft Excel 2019 New function
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |