Відео

Recorded at Chart College on Feb. 22, 2024 Elizabeth Ann Nofs, Microsoft Office Expert A demonstration of the IF Functions using TestOut

A Digital Flier We are online! This lesson shows how to create a digital flier. The design begins with a Table which will hold the assets- Headline, logo, picture and video. The Media Editors Did you notice that when you click on a picture, the Picture Tools are available? Each object has its own Ribbon: Picture, Video, SmartArt. This lesson looks at some interesting options!

Microsoft Outlook and Teams is our secure communications channel. But which Outlook are we using at work? This little demo shows the different versions of Microsoft Outlook, and how the Ribbons are different.

Live Lectures in PowerPoint: WORKING WITH TEXT BOXES By definition, a Text Box is a Shape. A Text Box has specific formatting because it is working with Text. Nevertheless, a Text Box is still a Shape, with or without a bulleted list or a Title. Shapes have Outlines, Fill, and Styles. Shapes are formatted with the Drawing Tools. This Live Lecture was recorded at Charter College, Oct. 18, 2023.

Live Lectures in Microsoft Excel: DATE AND TEXT DATE and TEXT are what Excel does best. This lesson teaches options to find the Day, Month and Year from a Date. We use Dates to run a business. The TEXT functions can combine (CONCATENATE) cells together, say first name and last name. Other Text functions can trim (select) just a few characters. This Live Lecture was recorded at Charter College, ...

Live Lectures in Microsoft Excel: THE IF LOGICAL FORMULA A Logical formula makes sense. There are only two answers: True/False, Yes/No. It begins with a Logical Test. This lesson uses the Logical IF Formula to get the data based on our criteria. This Live Lecture was recorded at Charter College, July 29, 2023.

Power BI uses Artificial Intelligence, AI, to group, organize and rank the data. AI can be used to display the visuals by specific factors. Key Process Indicators (KPI) can be used to filter a report or a dashboard by category. For example, by County, State, and City.

By definition, Microsoft Excel is the premier tool for data analysis. Excel is the most widely used software for data analysis in all fields. It is the Power of the Grid. Microsoft Power BI is the new, powerful tool for data visualizations and rich dashboard experiences. Power BI queries, transforms, shapes and visualizes data into interactive reports.

Power BI: Create Advanced Interactive Reports We can use Power BI Reports to display the data tables and visualizations based on a criteria or value. It is interesting to note how selecting one data point filters the other Visualizations.

A short demonstration of the steps required in this TestOut LabSim: Word: Insert Images

That Depends Miles of Road and Thousands of Bridges The Michigan Department of Transportation is responsible for keeping all bridges are designed, built, maintained and operated to ensure safety. The inspections are timely- in compliance with National Bridge Inspection Standards (NBIS). We can use Smartsheet to outline a bridge Project and use Dependencies to link one Task to another.

Data Driven Decisions - A Dashboard is a live, interactive, view of the data. Dashboards are visual tools for users to see important information at a glance. Data dashboards can be linked to datasets and updated live. We can use Smartsheet Dashboard to display and share reports, tables, charts, and images

Who Pays for This? Local governments receive funding disbursements in parts throughout the year. We can use Smartsheet reports to document the projects, people, funding, and equipment. Let's put Smartsheet to work.

Fix the @$*% Roads The Infrastructure Bill of 2021 intends to fund repair and rebuilding of our roads and bridges, with attention to the future in terms of resiliency and safety. Each Smartsheet Project has different business intelligence that can be used to assign and manage Tasks. Let’s put Smartsheet to work.

Smartsheet More Formulas

Smartsheet IF and WHEN

Smartsheet Formulas

Smartsheet Form Design

Smartsheet Contact Management

Smartsheet Assignments

Smartsheet Advanced Form Design

Outlook Email Design -From Me to You

Outlook Messages and Messengers

Watch the Game with You

Tea for the Tillerman

Build a House

Pumpky Pumpkin

By the Spirit

3Chairs