In this hands-on course, we will demonstrate and practice the essential skills you need to work with SharePoint. This course is designed for Microsoft Office users who are transitioning to a SharePoint environment, and who need to share information and collaborate with team members. We cover essential features such as log in, navigation, use of team and communication sites, editing and coauthoring documents, working with lists, integration with Microsoft 365, and document storage.
A well-designed document reflects well on you because a good page layout makes any document more readable. Your audience is more likely to read and remember it. In this course, you’ll learn how to use basic design principles to make your work attract attention. After this course, you will be proud of your Word documents look, and surprised at how much time you saved making them.
SharePoint features are robust and complex. Site owners can determine which features and options to make available, and how to configure those features to meet organizational and user needs. By properly implementing these features, owners can increase group efficiency, automate business processes, and facilitate speedy retrieval of information.
This course is comprehensive -- you will learn how to store, retrieve, and generally make sense of your data. We cover all the essentials: how to source and connect to data, build a brand-new database with tables and relationships, add calculated fields, create powerful queries, and generate reports and charts to share your insights. This course proves you don’t need to be a developer to work with databases; you just need Access.
This course is designed for students wishing to gain intermediate-level database skills or individuals whose job requires constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs. You will expand your knowledge of relational database design, write advanced queries, share data across applications, and customize reports.
This two-day course provides students with the knowledge and skills to analyze data with Power BI.
No matter where your data comes from – whether it’s a small or very large data set – you can connect, clean, analyze, and share your data faster using Power Query. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources and transform the time-consuming chore of data preparation into an efficient, automated process.
In this course, you’ll learn the basics of creating, editing, and formatting documents in Word 2013. Discover how to leverage templates to build better documents, collaborate with other team members, create numbered and bulleted lists, and work with tables.
This comprehensive hands-on course teaches you how to use Microsoft Visio to create professional diagrams to visualise complex systems, sharpen communication and fine tune business processes. You will practice building both simple and complex diagrams, using templates, shapes and Smartshapes.
In this hands-on course, we’ll show you how to use Microsoft Project to schedule and manage projects both large and small. Set up projects, add and link tasks, assign resources, fix scheduling issues, deal with resource conflicts, and track project progress.
This one-day seminar is for people with experience in Microsoft Project. We cover managing and reporting to management with multi-project roll-up responsibilities. You will see how to share resources across multiple projects. You will learn how to customize views, columns, filters and other Project objects for custom views and printout. You will also learn how to print Microsoft Project’s built-in reports and how to customize your own reports.
This course teaches the basics of creating, editing, and sharing presentations with Microsoft PowerPoint. You will learn how to build a slideshow from scratch, or leverage PowerPoint templates and themes for quick construction. We’ll show you how to add and edit text, images, graphs, video, and animation; format slides for consistency; and add speaker notes to ensure a smooth delivery.
In this class, you will learn to send and receive e-mail, to work with contacts, calendars, task lists, notes, and the journal. You will connect to your social media, cloud, and other mail accounts and we’ll give you tips on how to quickly and efficiently read, organize and send your mail.
This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors. You will also learn how to organize and manage lists and tables (including sorting, filtering, and analyzing).
With this intermediate Excel course you’ll really ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener.
Are you an advanced Excel user? Do you need to consolidate data from several worksheets, work with external data, or perform What-IFs? Would you like to learn how to use macros or create rolling charts? This two-day course will teach you all that and a whole lot more with sought-after techniques and formulas. Where the entire class is using Excel 365 or later, you will be introduced to the exciting new Dynamic Array formulas.
Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible.
This course is especially beneficial to accountants, financial managers, and analysts. We explore: » determining monthly payments for a loan» creating an amortization table for a mortgage» computing present and future value for a series of payments or amounts» calculating internal rate of return for cash flows» calculating the number of months to pay off […]
Forecasting is a valuable tool in business planning. It allows you to reliably predict company performance, trends, etc. Forecasting applies to expenses as well as revenues, and can provide a clearer understanding of future profits and losses. Ultimately, business forecasting enables better decision-making. Historical data is analyzed to detect patterns which helps to predict future […]
When other Excel courses do not fit your needs, you can cherry-pick your own topics of interest and create a course agenda that meets your needs. If you want, we can help you plan exactly how you want to enhance your productivity with Excel. Custom Training courses have a very high satisfaction rating from our […]
Dynamic Arrays are the most significant enhancement to Excel in years. Traditional array formulas (one formula, multiple results) have always been possible but they’re complicated and cumbersome to use, and usually require careful replication. New functions you will learn include: XLOOKUP, UNIQUE, FILTER, and SORT. Now, with Dynamic Arrays, formulas are simpler and easier to manage, and they usually require no replication at all. Dynamic Arrays are available to users of Excel 365 or later.