Microsoft Excel is a powerful and widely used tool in data analysis, and digital marketing professionals must demonstrate expertise using Excel and its features. In this hands-on workshop, learn and practice the most important components of Excel.
Microsoft Excel is a powerful and widely used tool in data analysis, and digital marketing professionals must demonstrate expertise using Excel and its features. In this hands-on workshop, learn and practice the most important components of Excel.
Course Outline
Functions: the most useful functions to support data manipulation and analysis.
Formulas: essential Excel formulas that every digital analyst should know.
Tables: tools to organize, structure, and present data to provide informed answers and drive decisions.
Text to Columns: built-in tools to merge and separate data points to analyze information more effectively.
Data Visualization: features like graphs and other graphic elements to align with your audience and brand.
Forecasting: methods and tools to predict future KPI trends, including applications for metrics like traffic and revenue.
Camera Images: an exciting tool to support dashboards and reports.
Macros: features to automate processes in recurring reports for efficiency.
Prerequisites
Basic Excel skills required to take this class.
SMU Continuing and Professional Education (CAPE) has offered noncredit learning experiences for the DFW community and beyond since 1953. SMU CAPE programs provide accessible and meaningful learning experiences in today’s hottest topics.
Choose from more than 14 professional certificates and boot camps in technology, communications, marketing, design, law and finance. Join us for interactive and on-demand short courses to impact your career or inspire creativity.
This course will illustrate data analytics with Excel using fundamental statistical concepts (i.e., descriptive statistics, statistical inference, and regression analysis).
Virtually every industry can benefit from the use of Microsoft Access to organize, store and document essential information. Data ranging from inventory and customer information, to orders, details and vendors can be effectively organized with Microsoft's longstanding software.
While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. Most jobs now require you to know the ins and outs of electronic word processing. Microsoft Word is designed to help you move smoothly through the task of creating
Our Word course will introduce you to the Word application to work with your documents more confidently. Create and edit with the right tools to transform a page of text into a professionally formatted document.
Microsoft Excel course is offered by Phoenix Computer Consultants for all skill level. A comprehensive MS Excel 2013 course, covering Excel functions, formatting, PivotTables, PivotCharts and more.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy