Build on your Excel 2 skills, and learn how to set up your data to take full advantage of pivot tables and charts and avoid problems. Learn how to format data, work with more than one field in the values area, pivot fields, add simple and complex calculated fields, create calculated items, build and format a custom dashboard and add slicers.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. Leave class with a set of skills that are in high demand and will be a deciding factor in your future success. Software requirements: Microsoft Excel This class can be taken on its own, as part of the Certificate in Mastering Computer Skills for the Workplace, or as part of the Certificate in Mastering Excel. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned.  Students need to have an understanding of Microsoft Excel to complete this certificate. This Certificate is comprised of the following courses. (Scroll down for class details): Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Data Analysis Unit 1: Understanding Data Identify sources of Data Discover methods of Collecting Data Examine Quantitative Data Examine Qualitative Data Unit 2: Processing Data Introduction to Statistics Determine the Appropriate Statistical Method for use in various scenarios Identify methods of Sorting and Filtering Data Categorize Data Unit 3: Analyzing Data Discuss Probability and the Normal Distribution Perform Trend Analysis Perform Breakeven Analysis Understand basic Statistical Modelling Unit 4: Interpreting and Presenting Results Design Professional-looking Tables Generate Effective Charts Create Pivot Tables and Pivot Charts Compile a Dashboard for Management Intermediate Data Analysis Unit 1: Looking for Differences between Groups Two separate groups Two related groups Three or more groups Unit 2: Looking for Relationships Pairs of variables Clusters of variables Predicting one variable from one or more variable Unit 3: Looking at Ratings Tests of difference using ratings Tests of relationship using ratings Unit 4: Looking at How to Report the Results Visual displays How to draft the narrative How to engage your audience Advanced Data Analysis Unit 1: Developing a Survey Purposes of surveys Fundamentals of Survey Research Ethical Considerations Likert Scales Unit 2: Comparing Means Chi-Square Statistical Significance Communicating Results Graphically and Textually Practical Problems involving Means Comparisons Unit 3: Finding Differences between Groups ANOVA Post Hoc Comparisons Communicating Results Graphically and Textually Practical Problems Involving ANOVA Unit 4: Individual Research Inquiries Developing Research Questions Setting Up Study Communicating Results Graphically and Textually