Course Cost: $ 195
Duration: 3 hours
PDUs/Contact Hours: 3 | CEUs: .3
Access Time: 90 Days

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.

Learning Outcomes:

• Employ copy and paste shortcuts
• Arrange, filter, and sort data by text, color, and by custom criterions
• Modify the worksheet view with various display tools, such as Freeze Panes, Hide/Unhide, Text-To Column, and Zoom In/Out
• Understand and apply data organization tools and functions
• Retrieve data using VLOOKUP, HLOOKUP, and Find + Replace
• Apply patterns, gradients, cell borders, and other style elements to data
• Experiment with the Quick Analysis Tools to create charts, graphs, and calculations
• Make use of the lock/unlock and track changes features

Course Cost: $ 195
Duration: 3 hours
PDUs/Contact Hours: 3 | CEUs: .3
Access Time: 90 Days

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.

Learning Outcomes:
• Identify and understand the different components of the Excel interface
• Enter and convert numerical and text data, dates, and times
• Select, copy, and paste data in a workbook
• Employ elements of style to the workbook
• Create images, illustrations, shapes, and hyperlinks in a worksheet
• Arrange, filter, and sort lists of data
• Apply basic formatting elements to the worksheet
• Formulate basic mathematical formulas and functions, including SUM, AVERAGE, and MAX and MIN VALUE
• Reorganize data by removing duplicates, blanks spaces, and misspellings in a worksheet
• Open, save, and protect the workbook

Course Cost: $ 229
Duration: 5 hours
PDUs/Contact Hours: 5 | CEUs: .5
Access Time: 90 Days

The ability to deliver an effective presentation is critical in most job functions. This introductory-level course helps learners organize, structure, and create effective presentations that feature slides as a visual aid. Because many organizations use PowerPoint as a way of communicating information, this course offers advice and guidance on the most effective and persuasive uses of PowerPoint, including best practices on word count, graphics, and structure.

Learning Outcomes:
• Recognize what makes communication effective
• Understand the elements in the communications process
• Organize your communications and presentations
• Understand PowerPoint graphic rules of thumb
• Create an effective summary slide
• Describe and employ the four steps of purposeful communication in your presentations
• Understand the forecast, present, and echo structure for presentations
• Recognize key visual considerations for PowerPoint slides and presentations
• Understand how to organize and create PowerPoint presentations
• Revise PowerPoint slides to make them more effective
• Understand the success factors for face-to-face presentations

Course Cost: $ 145
Duration: 3 hours
PDUs/Contact Hours: 3 | CEUs: .3
Access Time: 90 Days

This is an introductory-level course designed to both build a foundation of essential skills in Microsoft Word and to gain a greater understanding of its interface and design elements. The course focuses on mastering the fundamental tasks performed in Word, including writing, proofing, finalizing, and printing a document.

Learning Outcomes:
• Identify the interface components of a Word document
• Summarize the purpose of a Word document
• Choose appropriate customization options for the Ribbon and the Quick Access Toolbar
• Change the font, typeface, document, and paragraph formats
• Demonstrate proficiency with document and paragraph layout formats
• Change themes and styles to match the document's purpose
• Use track changes, word count, and spell check
• Create a formatted, proofed, and printed Word document

Course Cost: $ 145
Duration: 3 hours
PDUs/Contact Hours: 3 | CEUs: .3
Access Time: 90 Days

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.

Learning Outcomes:
• Define effective communication
• Describe the qualities of a well-designed slideshow presentation
• Identify common problems when using PowerPoint to design slideshows
• Differentiate between effective and ineffective PowerPoint slides
• Discuss the importance of having a clear purpose or goal for your presentation
• Explain the four components of goal-oriented communication
• Consider the importance of understanding your audience
• Conduct audience analysis
• Map your presentation using the "Forecast, Present, Echo" structure
• Incorporate research into your presentation
• Assess websites for reliability and credibility
• Use slideshow templates effectively
• Select images that are professional and well-designed
• Choose visually appealing colors and fonts
• Consider how design trends can be applied to slideshows
• Define the minimalist approach to design
• Identify the signs and symptoms of speaking anxiety
• Describe methods for managing speaking anxiety, including relaxation strategies
• Design a PowerPoint presentation that features recommended design principles

Course Cost: $ 145
Duration: 3 hours
PDUs/Contact Hours: 3 | CEUs: .3
Access Time: 90 Days

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.

Learning Outcomes:
• Define basic design principles, such as readability, color, consistency, contrast, arrangement, and information display
•Explain how font choice and color can affect slideshow readability
•Design slides that effectively implement the principles of consistency and contrast
•Place images throughout a presentation while adhering to the principles of proximity, alignment, repetition, space, and the "big picture"
•Select appealing and appropriate images to use in a slideshow
•Use photographs in a slideshow as an attention grabber and storytelling device
•Utilize the Shapes and SmartArt tools to communicate concepts visually
•Present data clearly and effectively
•Consider how design trends can be applied to slideshow presentation

Course Cost: $145
Duration: 3 hours
PDUs/Contact Hours: 3 | CEUs: .3
Access Time: 90 Days

A capital campaign raises money that a nonprofit organization uses for any physical asset, such as purchasing or renovating a building. It's a critical part of managing in the nonprofit sector. This introductory-level course covers the key terminology and practices surrounding running a successful capital campaign within a nonprofit organization. You will learn about the phases of conducting a capital campaign (evaluation, feasibility study, organization, solicitation, and post-campaign activities) as well as how to avoid common pitfalls in capital campaigns.

Learning Outcomes:
• Explain the five phases of a capital campaign
• Define what a feasibility study is and why one should be conducted prior to a capital campaign
• Discuss what role consultants can play in conducting a feasibility study
• Describe important factors for evaluating consultants
• Explain how tools like a gift range chart can help to organize campaign solicitations
• Describe the different types of leadership teams and committees that may be formed to support a capital campaign
• Discuss different techniques that can be used to troubleshoot a stalled capital campaign
• Understand what is required for a successful solicitation meeting

Course Cost: $209
Duration: 4 hours
PDUs/Contact Hours: 4 | CEUs: .4
Access Time: 90 Days

Writing grants is often a critical part of gaining funding for any nonprofit organization's mission. Strategic grant writing aligns the needs of a nonprofit with funding sources, whether foundations, government agencies, corporations, or individuals. This introductory-level course offers a guide to the basics of grant writing. The course explores the relationship between grant writing and an organization's strategy for fundraising. It also outlines the six stages of grant writing and highlights grant writing best practices.

Learning Outcomes:
• Discuss the importance of grant writing to nonprofits and other organizations seeking funding
• Describe how capital grants and endowment grants can be integrated into fundraising efforts, including matching funds
• Explain how grant writing and fundraising represent complimentary methods of ensuring a nonprofit's financial stability
• Outline the six stages of the grant writing process
• Discuss the process of identifying and establishing a need for funding (Stage One)
• Describe how to research grantmakers and available grants (Stage Two)
• Explain the process of establishing relationships with potential funders (Stage Three)
• Discuss the importance of alignment between a nonprofit and a funder's mission (Stage Four)
• Outline the grant writing process (Stage Five)
• Explore tools and techniques employed in writing the grant proposal
• Explain how a nonprofit should follow-up after winning or losing a grant award (Stage Six)
• Outline best practices for grant writing
• Apply your understanding of the grant writing process to case studies covering the six stages

Course Cost: $169
Duration: 5 hours
PDUs/Contact Hours: 5 | CEUs: .5
Access Time: 90 Days

There are many differences between nonprofit organizations and for-profit organizations. Before delving into the details of nonprofit management, this course serves as a critical introduction to the fundamentals of nonprofit organizations. You will gain an understanding of the nonprofit sector and the issues that leaders face in this exciting and growing field. You will also be exposed to the major areas of responsibility for nonprofit leaders, including strategy, managing employees and volunteers, fundraising, grant writing, board governance, marketing, innovation, and social media.

Learning Outcomes:
• Discuss the purpose and structure of the nonprofit sector
• Describe the governance of nonprofits, including the types of boards and the relationship between boards and executive directors
• Explain how nonprofits establish their vision and strategic direction
• Describe the nonprofit leadership role and what it entails
• Discuss servant leadership
• Outline key ethical issues faced by nonprofits
• Discuss how nonprofits managers handle staff and volunteers
• Outline the key financial issues facing nonprofits
• Describe the key legal issues facing nonprofits
• Discuss the importance of marketing and communication for a nonprofit
• Explain the basics of nonprofit fundraising
• Outline the grant writing process
• Discuss the growing importance of social media for nonprofits

Course Cost: $169
Duration: 5 hours
PDUs/Contact Hours: 5 | CEUs: .5
Access Time: 90 Days

Effective use of social media as a marketing tool is often essential for nonprofits to get attention in this digital world. This course introduces learners to the use of social media in communicating, marketing, public relations, and fundraising for nonprofits. It explores the major social media platforms (Facebook, LinkedIn, Twitter, YouTube, Pinterest) as vehicles for nonprofits to reach their members, volunteers, and donors.

Learning Outcomes:
• Discuss the importance of social media to nonprofits for communicating, marketing, public relations, and fundraising
• Explain how social media can be used to better engage a nonprofit's audience
• Outline the key questions nonprofits should consider as they become involved in social media
• Discuss the strengths and weaknesses of Facebook, LinkedIn, Twitter, YouTube, Pinterest and other social media platforms
• Discuss the costs involved in social media
• Explain the importance of establishing social media policies for your nonprofit
• Discuss the measurement of social media effectiveness in communicating messages and in fundraising
• Outline tools and techniques for successful social media use by a nonprofit
• Apply your understanding of the social media environment to case studies

Course Cost: $209
Duration: 4 hours
PDUs/Contact Hours: 4 | CEUs: .4
Access Time: 90 Days

Fundraising is one of the central activities of a nonprofit organization and nonprofit management. To help finance operating budgets, nonprofits must raise money every year. In addition, special projects and improvements to facilities may be needed. In these situations, fundraisers will often launch large capital campaigns or apply for foundation grants. This course offers an introduction to fundraising for nonprofit organizations, with an emphasis on the fundamental issues.

Learning Outcomes:
• Describe the key concepts related to nonprofit fundraising, such as annual campaigns, capital campaigns, and planned giving
• Discuss how nonprofit funds can be raised through direct mail and telemarketing
• Explain how the Internet and social media channels may be used to generate donations
• Compare and contrast fundraising through corporate donations versus foundation grants
• Explain the different sections of a grant application
• Describe methods for evaluating annual campaign performance
• Discuss how ethics applies to nonprofit fundraising
• Explain the importance of donor relations