Excel Essentials for Professionals: Boost Your Productivity

This course is designed to teach students an overview of end-user SharePoint interface and functionality. Students will begin with an overview of Sharepoint including how to navigate and how to locate sites, libraries and lists. Students will also learn how to work with document libraries. They will learn how to work with document library settings, how to check a document in and out, and how to set alerts. They will also learn how to work with SharePoint lists, including calendar lists, contact lists, and task lists, as well as how to work with list settings. This course also covers how to enhance the SharePoint experience, how to work with various views, update personal profiles, use the Newsfeed, and learn about SharePoint integration with other Microsoft Office products.This course aligns with the CAP Body of Knowledge and should be approved for 4.25 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!

Many people who use two fingers to type, generally have to look at the keyboard and often have to look for the individual keys, depending on how long they have been using that method.It can mean they take longer to write their documents, and mistakes can occur more often.Whereas with touch typing, you are reading text, while you are typing into the document and not looking at the screen. It’s a bit like playing the piano where the pianist reads the music and hits the appropriate piano keys without looking at the keyboard, to create music.You can learn where the letters are without looking at the keyboard and hitting them at the appropriate time to create correctly spelled words. Touch typing is a quick and efficient way to type using all your fingers on the keyboard and typing without looking at the keyboard or the computer screen. The skills are not hard to learn, it just takes practice. To assist you to learn this skill, the step by step instructions give you typing exercises starting from basic keying tasks to words and then sentences. You will learn where to place each finger for each keyboard key. When you are happy will your progress, you can advance to speed tests and there is several of these to attempt. So you can see how fast you type, there is an instruction on the method of how you calculate your words per minute speed.

Google Docs has truly transformed how I create documents, store, access and share files and collaborate with colleagues. I would like to give you the opportunity to also dramatically improve how you interact with and manage your word processed documents.Share my expertise and over 25 years teaching experience to make you, and potentially your workplace, effectively utilise the cloud-based features integral to Google Docs' ongoing success.Google Docs is cloud-based word processing software created by Google. It allows users to store files in "the cloud", share files with other collaborators and edit documents with ease.This course is suitable for people from any profession as the skills developed are applicable on both a personal level as well as having tremendous potential in any workplace.Students will:Develop the ability to create files and synchronise these across your various devices.Always access the most recent version of a document.Collaborate in real-time with colleagues on documents.Share files with other parties setting restrictions and limits as to the access privileges of all groups who can access the file/s.Remove the need to email documents as attachments, simply allow access to the document online.Where necessary, convert existing Microsoft Word documents into Google Docs format.This course will positively change how you interact with your documents and the information you work with on a daily basis. You will save time, money and reduce your stress levels by working smarter rather than harderI look forward to assisting you to develop an understanding of, and the ability to efficiently use Google Docs.

The Art Science of Excel Modeling is an in-depth exploration of how to plan, design, and maintain superior Excel models. Ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to gain a deeper understanding of the “art-science” of data modeling and how it can lead to improved business decisions.Kicking off with a bigger-picture, more philosophical view of spreadsheet design principles, our aim is to inspire critical thinking skills and confidence in an increasingly competitive job market. In our “real world based” case studies, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of “big” data that seem to be “pushing the boundaries” that Excel is naturally equipped to handle.Designed with the intermediate to advanced level Excel user in mind, as well as technical professionals seeking to build better alliances with “the Excel people.” To keep up during this course, we recommend you have a very solid understanding of the basics of the spreadsheet environment. Formula construction and concepts, in particular structured referencing (proper use of the ‘$’ signs) is also extremely helpful.The instructor, Szilvia Juhasz, is an Excel book author and a frequent co-host at Excel TV.

Advanced Excel for Business Level III is the last of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level II or already have a strong working knowledge of excel and would like to take their skills and efficiency to an advanced level. By the end of this course, you will feel confident using advanced formatting techniques, multi-input and conditional functions and recording basic macros. Additionally, you will gain experience will advanced excel features and plug-ins such as scenario management and solver. Your peers, colleagues and employers will be impressed with you ability to tackle complex problems in excel dynamically and efficiently after you take this course. The course comes with a revolutionary video tutorial suite, and is taught by engaging instructors with several years of in-field and training experience.

Microsoft Publisher is part of Office 365 and is an easy-to-use yet powerful application to design publications. In his course, you will be learning the various tools and techniques to create new publications from scratch or by utilizing templates.We will cover various aspects of the application such as managing business information, saving publications in various formats and page formatting. Also, we will see, how we can use various navigation options in the application to ease the workflow of designing publications.Also, we will see different ways to format text and insert text from external sources. And then we will also see how we can work with shapes, and tables and manage content with the use of master pages.After that, we will look at how we can apply various effects to different elements as well along with the management of page numbers and headers and footers.Then, we will also see how we can optimize the publication for the web and other publication options that there are and then finally end the course with an example project.This course is designed for those who do not have any design background so even if you are a beginner, you can easily follow along this course.