Take your Excel skills to the next level. Go beyond what others know, equipping you with advanced functions to efficiently analyze and manipulate data. Explore the advantages of these functions in various contexts, enhancing your productivity and data insights. Unit 1 Sum and Count Excel offers powerful functions for data analysis and manipulation. Core functions provide fundamental calculations. However, the real value lies in advanced functions. Explore functions that enable conditional summation, allowing for complex data analysis and reducing manual calculations. We also look at dynamic summaries that adjust with filtering, crucial for analyzing filtered datasets. We move one to functions that are essential for data quality checks, helping identify data completeness and empty cells. Lastly, we investigate functions that are used for identifying data patterns and frequencies based on specific criteria. Proficiency in these functions streamlines data analysis, improves efficiency, and facilitates informed decision-making. Unit 2 Error Checking & Dates Mastering Excel's error-handling functions is crucial for robust analysis. We investigate functions that allow you to gracefully manage formula errors, preventing them from disrupting your entire dataset and enabling you to provide alternative, sensible values. We then move on to functions that can enhance formula readability, making complex calculations easier to follow. Finally, we explore the ability to extract specific date components which opens up detailed analysis of time-series data. Combined with real-time date and time information, you can perform precise time duration calculations giving you the power to perform sophisticated, time-sensitive analyses. Proficiency in these areas ensures your spreadsheets are not only accurate but also insightful, providing a competitive edge in data interpretation. Unit 3 Text Unlock the power of text manipulation to extract specific parts of text strings – essential for data cleaning and formatting. These functions are your go-to tools for isolating relevant information from messy or inconsistent data. Standardize text for consistent analysis, manage text lengths and eliminate unwanted spaces, which is essential for consistent formulas. Finally, we examine functions that enable you to combine text strings, creating custom labels and summaries. These skills are fundamental for anyone working with text-based data, transforming raw information into organized, analyzable insights. Unit 4 Lookup Excel’s new Lookup functions offer significant improvements over previous methods. Elevate your skills so you can provide a more powerful and flexible alternative to your current lookups, offering enhanced error handling and versatility. Learn how to reference cells or ranges based on text strings, often used to dynamically find tables or ranges by name. Furthermore, other advanced functions allow you to reference cells or ranges based on their location within a dataset, rather than by specific cell addresses or table names. These functions provide a deeper level of control and flexibility in data retrieval and analysis, making your spreadsheets more dynamic and adaptable.

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

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.Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence. Students must have Microsoft Excel installed to complete this certificate. Courses must be taken in order: Mastering Microsoft Excel Intermediate Excel Advanced 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: Mastering Microsoft Excel 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 Intermediate Excel Unit 1: Organizing Worksheet and Table Data Introduction to tables Formatting tables using table styles Using formulas in tables Sorting and Filtering table data Unit 2: Understanding Popular Excel Functions Understanding Named Ranges Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3: Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using templates Customizing Excel toolbar Unit 4: Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables Advanced Excel Unit 1: Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2: Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3: Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4: Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data