A Manager's Guide to Information Technology course is designed to help managers develop a solid understanding of the basic concepts and technologies that they will encounter in the information technology field. Learners in this course will expand their knowledge of IT through games, videos, interactive exercises, quizzes, and other engaging content.
This course designed for the learner who already has a solid understanding of Excel's basic tools and functions. The course teaches learners some of the more advanced skills and features available in Excel, which may be useful in data analysis. These skills include style templates, conditional formatting, data validation, data manipulation, and pivot tables.
As big data continues to change the way businesses operate and drive strategy, the ability to efficiently and effectively organize and analyze data is crucial. Managers need to be able to utilize tools to identify trends and help make better business decisions. Microsoft's Excel is a powerful spreadsheet software to organize and manage data related to business operations. This course focuses on mastering the fundamental tasks performed in Excel, including data entry, basic formula calculations, and formatting and style operations. During the course, you will learn how to build a spreadsheet from scratch and gain a greater understanding of the most popular Excel commands and functions.
This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace.
As technology continues to change the way that we engage in business communications, the art of presenting has also undergone a shift. No longer can presenters rely solely on their spoken words to deliver their messages. Now, audiences expect to see multimedia slideshows that both inform and entertain. This course will consider how to plan and design effective slideshow presentations using Microsoft's PowerPoint software. It includes practical tips and examples for mapping the presentation, incorporating research, using templates, selecting visual elements, and delivering the presentation.
In today's professional landscape, PowerPoint presentations can be effective platforms for sharing information and garnering audience interest and support. At the same time, a poorly designed PowerPoint slideshow can quickly turn an audience away. By focusing on how to apply basic design principles to slideshow creation, this course will help learners use Microsoft's PowerPoint 365 software to build visually engaging slideshow presentations. Learners will consider how to select images and photographs for use in slides, the importance of arrangement and placement of images, the use of tools like Shapes and SmartArt, methods for presenting data, and the selection of colors and fonts that increase the readability of content.