new users – Search Results

itstraining.wichita.edu

Teams: Breakout Rooms

…clicking on the ellipses next to each room and selecting Join Room. Returning Participants to the Main Room In the Breakout Rooms menu, where you opened the rooms, will be a new option to Close Rooms. This will return all the participants to the main meeting. If you had toggled on the ability for attendees to return to the main meeting on their own, they…

https://itstraining.wichita.edu/teams-breakout-rooms/

itstraining.wichita.edu

Excel: Remove All Blank Rows in a Document

…Excel stops at the blank row. In a document with 5,000 rows and numerous blank rows, you probably don’t want to have to manually autofill every time you insert a new formula… PivotTables and Tables How about creation of Tables and PivotTables? We know to put our cursor in the middle of the data and let Excel select all the information that will create our …

https://itstraining.wichita.edu/excel-remove-all-blank-rows-in-a-document/

WSU Newsletters

New look for Blackboard Support

The new Wichita State Blackboard Support portal is open for business. In addition to a frequently asked questions section, users can also access to connect via chat, calls or email for assistance. Simply search by phrase or keyword.

https://news.wichita.edu/2021/08/06/new-look-for-blackboard-support/

WSU Newsletters

Hiring dates standardization starts July 1

Human Resources has identified opportunities to increase compliance and improve the experience for new hires and front-end users. This includes streamlining the onboarding experience and reducing the possibility for errors and delays to help ensure new hires have a great experience starting with their first day on the job. To achieve this, HR is adopting…

https://news.wichita.edu/2025/06/25/hiring-dates-standardization-starts-july-1/

itstraining.wichita.edu

Word: Mail Merge with PDF Attachments

… merged PDF files. This creates separate PDFs for each of the merge results, for your records. If there you don’t see a location that will work, notice you can also create a new folder in the lower left. Double Check Results Open your Outlook.Since you are working Offline, these files are going to be sitting in your Outbox. You should see a number on the…

https://itstraining.wichita.edu/word-mail-merge-with-pdf-attachments/

itstraining.wichita.edu

Outlook: Free Up Space FAST by Taming Large Emails

…5-10 MB emails Large: 1-5 MB emails Medium: 25KB – 1 MB emails Small: 10-25KB emails. This is often an “aha!” moment for people. You might discover, for instance, that a newsletter you receive weekly is the culprit for the size inflation in your inbox. Perhaps you forgot about how a month ago a large quantity of pictures were sent to you, and so on. Combing …

https://itstraining.wichita.edu/outlook-free-up-space-fast-by-taming-large-emails/

WSU Newsletters

New log-on banner comes to university devices

Due to State of Kansas policy requirements, starting the weekend of July 2, a new log-on warning will be rolling out over the course of the weekend to all university devices What is a log-on warning? Prior to logging onto any device on campus, a log-on warning will appear on the screen. The log-on warning defines that the system is monitored for improper use…

https://news.wichita.edu/2021/06/24/new-log-on-banner-comes-to-university-devices/

itstraining.wichita.edu

Outlook: The Power of Drag and Drop

…your mouse, and drag it to another location. Sometimes it is as simple as moving a file from one folder to another; the action of clicking on the file and dragging it to the new folder. But there are other tools you can access with this action. Outlook takes this feature to another level, and contains a remarkable number of possible uses for drag and drop.…

https://itstraining.wichita.edu/outlook-the-power-of-drag-and-drop/

itstraining.wichita.edu

Microsoft Office: Color Themes and Custom Color Palettes

…ability to select colors from a color wheel, or select More Colors to enter an exact RGB color. 4. When you are finished, name the color palette and click Save. 5. The new color set will appear in a new section at the top of the Colors dropdown called Custom. You will be able to access this color palette anytime you create a new document on this computer.…

https://itstraining.wichita.edu/microsoft-office-color-themes-and-custom-color-palettes/

itstraining.wichita.edu

Excel: Calculating Scenarios with What If Analysis

… and for the different possible loss amounts and start dates. 7. Select a scenario and press show to run the What If Analysis. There is also an option to generate a summary on a new sheet with all the possible scenarios. Press Summary to generate this. Accessing Scenarios You can access scenarios this way: 1. Go to the Data tab, What-If Analysis dropdown,…

https://itstraining.wichita.edu/excel-calculating-scenarios-with-what-if-analysis/

itstraining.wichita.edu

Excel: Create Stunning Map Charts with Geography Data Types

… your chart, but a cool trick in Excel worth mentioning. Here are a few extracted fields, so you can see how they look: image, largest city, area. Notice how Excel creates a new column for each one. Here is a bit of inspiration: imagine that you have a list of zip codes and figures and you need to create a map by county. Simply convert the zip codes to…

https://itstraining.wichita.edu/excel-create-stunning-map-charts-with-geography-data-types/

itstraining.wichita.edu

Microsoft Office: Customizing the Ribbon

…Customize the Ribbon. Notice this looks similar to the QAT customization screen, but this time Customize Ribbon is highlighted. Highlight the Home tab on the right and press New Group at the lower right of the screen. A new group will appear in the home tab list. Select it and press Rename to name it something else. I am going to name mine Special. Add…

https://itstraining.wichita.edu/microsoft-office-customizing-the-ribbon/

itstraining.wichita.edu

Compatibility Mode: How to Re-Activate Your Favorite Features

…in the ribbon… … But this happens in other Excel tabs, PowerPoint, and Word as well. The features that gray out vary from version to version, but bottom line, newer features are what disappear in Compatibility Mode. When someone is experiencing these ghosts of buttons, this is almost always the culprit. How to identify Compatibility Mode How do you…

https://itstraining.wichita.edu/compatibility-mode-how-to-re-activate-your-favorite-features/

WSU Newsletters

OneStop’s new self help portal is here

…more. All services can still be accessed at wichita.edu/onestop or clicking the “OneStop” link at the top of Wichita State’s website. Chat experience: Students can use the new chat tool to get quick answers. If the chatbot can’t resolve the issue, users will be seamlessly connected to a live agent. Every interaction will generate a ticket. Phone support:…

https://news.wichita.edu/2025/06/30/onestops-new-self-help-portal-is-here/

itstraining.wichita.edu

Word: Solutions for Common Issues with Numbered Lists

…numbered lists caused you trouble in the past? Will any of these tips help you going forward? I would love to hear from you! Congratulations, Power Users! Congratulations to our newest Power Users! For the full gallery, and more information about the WSU Microsoft Office Power User Program, please visit: wichita.edu/poweruser

https://itstraining.wichita.edu/word-solutions-for-common-issues-with-numbered-lists/

itstraining.wichita.edu

OneNote/Teams: Collaboration Inspiration

…to share with you some collaboration inspiration utilizing OneNote in Teams. These examples are by no means the only ways to collaborate, but this may incorporate something new you hadn’t thought of. These tips would be great for a Team used for a class, or for coworker collaboration. Let’s check it out. The Scenario The particular scenario I am going to …

https://itstraining.wichita.edu/onenote-teams-collaboration-inspiration/

itstraining.wichita.edu

What is Microsoft Stream, and how does it integrate with Teams? (plus Video!)

…Accessing Stream via O365 In addition to clicking on the Open in Microsoft Stream option above, you can also access Stream by visiting Office 365 Online. In a new browser window, type into your address bar: o365.wichita.edu. You can also access Office 365 via the link at the upper right of myWSU. Sign in information is always your…

https://itstraining.wichita.edu/what-is-microsoft-stream-and-how-does-it-integrate-with-teams-plus-video/

itstraining.wichita.edu

Excel: Merging Data with Power Query (Bonus Video!)

…on the double headed arrow to expand. And leave only Candy selected. Press OK. 4. Select Close and Load To… but this time keep the default selected: Table on a New Worksheet. Press OK. Final Table Our merged query is visible as a table on a new worksheet. A Couple Notes It helps if you think about your final table like a Pivot Table: If you need to change…

https://itstraining.wichita.edu/excel-merging-data-with-power-query/

itstraining.wichita.edu

Excel: Don’t Merge Those Cells! Here is an Alternative.

…What do you think? Has this convinced you to unmerge and never merge again? Either way, I will be here to help you. Congratulations, Power Users! Congratulations to our newest Power Users! For the full gallery, and more information about the WSU Microsoft Office Power User Program, please visit: wichita.edu/poweruser Sheree Smith (First Power User of…

https://itstraining.wichita.edu/excel-dont-merge-those-cells-here-is-an-alternative/

itstraining.wichita.edu

Word: The Spike Feature

… AutoText Select Spike. The Third Method: Ctrl + Shift + F3 This method will clear out what has been store in the Spike as well as paste the joined contents in a new location. Place your cursor in the desired location Press Ctrl + Shift + F3 on your keyboard. Remember, if you picked one of the first two methods, at some point you will need to do this last…

https://itstraining.wichita.edu/word-the-spike-feature/