Marketing Automation Analyst Journey

There is a science behind communication, including how we react neuro-physiologically to others - through verbal communication such as their words and tone, as well as the non-verbal communication of their actions and body language. There's also an art to communication, allowing your authentic self to shine through and allowing the exchange with another person to unfold naturally. In this course, you'll learn about the art and science of communication. You'll explore techniques for connecting with your audience and building trust with them so that your communication intention is clear and understood. You'll also learn the basic principles of assertive communication that is positive and not aggressive.

Communicating effectively can be challenging when having difficult conversations. Because these challenges typically involve emotions such as hurt, anger, or confusion, it's not uncommon for people to avoid one another or shut down, preventing what could be a productive exchange at many levels. In this course, you'll examine some common communication challenges and how you can successfully navigate them. By showing patience, perseverance, and accountability, you can effectively deal with tough conversations, communicate your message, and reach mutual understanding and agreement.

Communicating with confidence is critical to your message being successfully received. Feeling confident in a high stakes situation is not always easy but with effort, confidence can be cultivated and improved. In this course, you'll learn about being an effective speaker. You'll discover ways to prepare, techniques to avoid being nervous and how to use your voice and body language to communicate with self-confidence.

Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting & Manipulating Data Exercise as well as the associated materials in the Resources section.

Put formulas to work with Excel 2019 for Windows. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this, you will learn how to count cells in a range by using different formulas, and then rank values, which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number, to round up or down your data values; use replacement formulas when you need to make changes; convert number types, and factorize the results of a division. Conclude the course by observing how to create random values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.

To customize data, you can use the built-in formats in Excel 2019, or you can use your own. In this 10-video course, learners will observe how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting. To begin, discover how to customize your number formats, formatting currency, percentages, and phone numbers for data values. Next, observe how to customize your text formats, changing the text format by adding or modifying a text element's appearance; create custom color formatting for data entries; and apply conditional custom formatting to data values. Delve into creating conditional format rules to enhance your data values display; use conditional formatting to highlight data in cells, rows, and columns; and use conditional formatting tools to analyze your data further. This leads into exploring advanced conditional formatting tools, and using these tools to find duplicate values or hide values. Conclude the course by discovering how to organize conditional formatting rules applied to a worksheet. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Custom & Conditional Formatting Exercise as well as the associated materials in the Resources section.

Excel 2019 includes a number of methods for locating, displaying, and manipulating data entries. In this 8-video course, learners observe how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools. Begin by learning how to find items in a worksheet, by using the Find tools to jump to locations in a worksheet and find items with basic search queries. Then learn how to use advanced Find tools to customize and refine search queries; the Selection tools to locate and select graphical objects in a worksheet; and the Replace tools to replace cell contents and formats. Next, examine how to use the Find and Replace tools when working specifically with formulas, and use the Freeze tools to change the view settings within a worksheet. Finally, observe how to group rows and columns in a worksheet and control their display, and use the Group tools to create Outlines in a worksheet. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Grouping Data Exercise as well as the associated materials in the Resources section.

The first step in analyzing the data in a worksheet is often taken with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column filters to filter data in a worksheet; to use column filters to apply multiple filters to data in a worksheet; and to create filter arguments by using text and number data types. Finally, you will learn to sort and filter data by using colors applied to data; learn to use the advanced filter tools to filter and extract data; and learn to use filter tools to hide duplicate values in a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sorting & Filtering Data Exercise as well as the associated materials in the Resources section.

Even if you know what's important to do, losing focus can stop your progress. No matter who you are or what job you do, focusing at work can be hard. Even with great schedule management and organizing skills, it's easy to get off track if you're not careful. In this course, you'll learn how to stay focused and stay on top of your schedule. You'll learn strategies for dealing with focus challenges and distractions at work. You'll also find out how to beat fatigue, manage your time, and decline work-related requests. And you'll explore how to adjust your focus to deal with change, and how to regain focus when you've lost it.

Even when you know your priorities and have an organized time management routine, you'll still be challenged every day by distractions, temptations, interruptions, and procrastination. To avoid causing internal time management detours, you have to develop ways to stay focused, and this often means using personal and interpersonal skills in very specific ways. In this course, you'll learn strategies to manage challenges to your personal focus, techniques to help you shut out distractions and manage time conflicts, and ways to regain focus and develop mental resilience when faced with change.

Spelling errors are all too common, and are one of the main culprits behind poor business writing. A wrong letter here, an extra letter there, and your reader may lose confidence in your communication skills and overall competence as a professional. That's why writing well doesn't just mean writing persuasively - it also means knowing the rules, as well as the exceptions, of spelling. In this course, you'll learn how to spell words with prefixes and suffixes, and how to form the plural and possessive forms of words. You'll also learn general rules on how to spell correctly, as well as some handy tips for better writing in general.

Whether you're entering a new market, looking for new customers, launching a new product, or trying to identify new opportunities to generate business with existing customers. conducting market research can give you valuable insights. In this course, you will learn the uses for market research, the different things you can learn from primary and secondary research, the different methods of market research, the stages of a market research project, and the different types of market research projects.

Product managers have many ideas on how to design their product to meet the customers' needs. The challenge is to determine which of those ideas have the best chance of working. Increasingly, product managers are using large-scale randomized experiments to test the effectiveness of their ideas. In this course, you will learn how to use experimentation to make the best product management decisions, best practices for conducting effective experiments, the stages of conducting an experiment, how to optimize your product process with the design of experiments approach, and how to increase customer satisfaction with the user-experience-based design approach.

Create presentations quickly using PowerPoint 2019 for Windows. Key concepts covered in this course include how to open the app from the Search bar or the Start menu, or pin the app to your taskbar for quicker access. Learners will observe how to use the variety of different tools such as the Office tool ribbon to operate key menus and functions and different ways of navigating and visualizing presentation slides. There are also topics on how to activate rulers and gridlines to align and adjust slide elements. Conclude by discovering how to handle several documents at the same time and move between open windows and presentations.

Create your slides, and finesse them like a pro. Discover how to use themes, create and manipulate slides, and work with slide elements in PowerPoint 2019, in this 13-video course. Key concepts covered here include how to create and edit a new presentation; how to use themes and templates to create presentations; and how to specify the preset layout that can be applied when you insert a new slide. Begin by learning how to insert slides from an existing presentation; how to adjust a slide layout to add structure to your presentation and insert text elements and objects into the presentation automatically; and how to add slides quickly and easily move them around in presentations. Next, learn how to create a template from scratch which can be used to speed up the creation process; how to create sections to help structure your presentation; and how to use headers and footers. Finally, observe how using Master mode allows changes to the overall appearance of your presentation and changes to multiple slides at once.

Explore the methods for saving, backing up, exporting, and protecting PowerPoint 2019 presentations. Key concepts in this 15-video course include how to save presentations; how to back up and recover presentations; and how to save your presentation as a PDF, a good format for sharing presentation. Begin by observing how to create a video presentation and run a slideshow automatically; how to create a presentation package, a tool which allows you to export elements you will need to deliver your presentation; and how to create a version of your presentation in Word. Next, learn how to use PowerPoint to check for compatibility issues that might be present in your document and help you correct them; how to edit your presentation properties; and how to access and configure layouts to adjust the print page layout. Finally, learn how to check for personal and confidential information in your presentation using the Document Inspector feature; how to protect presentations by adding password encryption; and how to use Compare function to differentiate multiple versions of a presentation.

PowerPoint 2019 presentations contain two key elements: graphics and text. Discover how to manipulate text and images like a pro in this 10-video course. Key concepts covered in this course include how to insert text into your presentation by creating and formatting text boxes to position your text; how to insert special characters from the symbols library by using the symbols menu on your tool ribbon; and how to insert icons by using the tool ribbon. Begin by learning about keyboard shortcuts to make quick changes; how to adjust the language settings to select your spellcheck options; and how to adjust the AutoCorrect options to catch typing and spelling errors as they happen. Next, you will learn how to use the Find tool if looking for a particular word or section in your presentation; you can use the Find function to scan through different matches throughout your presentation one by one. Finally, learn how to use the Replace tool to replace instances of a word or phrase.

Once you start adding text elements to a presentation, you will need to know how to format and organize them. In this 9-video course, learners will observe how to adjust text, add elements such as bulleted lists, and modify paragraph settings within PowerPoint 2019. Key concepts covered here include how to adjust the appearance of text by using font and text size tools and adding effects; how to align your text and adjust its position on the slide by using the standard horizontal and vertical alignment options; and how to rotate your text by adjusting the text position on your slide by using the Rotate tool. Begin by learning how to organize your text into columns to help maximize the space within a slide; how to insert bullet points and to adjust the points' style and appearance; and how to insert a number list. Finally, learn how to modify your paragraph indentation to help give your text element structure, and learn to modify your line and paragraph spacing to make text easier to read.

Believe it or not, everyone has the potential to be creative. If you're struggling to express your ideas, then something is getting in the way. But with the right approach and techniques, team leaders can provide a safe space that encourages brainstorming, innovating, and creative thinking. In this course, you'll learn about characteristics of creative people, how to overcome personal barriers, and how to foster team innovation in a work environment. It describes personal barriers to creativity and how to overcome them and provides strategies for enhancing creativity in the workplace. It also outlines key requirements for promoting creativity and explores techniques for fostering creativity in teams.

You might not describe yourself as a creative person, but everyday activities - like problem solving or spotting opportunities - rely on your creative thinking and innovation. Originality is key, but your ideas also have to work within real-world constraints. In this course, you'll learn about the different stages of innovating and techniques for verifying the workability of your ideas. You'll also discover guidelines and techniques for building on and testing an idea, such as brainstorming. The course outlines when to use research and simulations to check the workability of an idea, and it discusses ways to build on ideas effectively.

Everyone could benefit from a boost in creativity. Whether you're in marketing and advertising, management, or software development, all professionals need to be able to come up with original ideas and think outside the box every now and then. But sometimes the pressure to think creatively is the very thing that blocks the flow of fresh ideas and results in the type of procrastination that is an obstacle to efficient time management. This course focuses on the relationship between procrastinating and creativity. You'll learn about how the optimal amount of procrastination actually boosts creativity and efficiency. You'll also learn how to use creativity boosters to help you past those times when you procrastinate a little too much.