Cambridge-Isanti Community Education

Advanced Excel contains tools that can help you prepare your worksheets accurately, examine your data for authentication, and find answers to your most difficult questions. Learn required business functions along with tools required to analyze data efficiently within the workplace. Save time by protecting your valuable data. Discover how to attractively visualize your data into meaningful information with confidence. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details 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 For more information, visit our question and answer page - Click Here.

Data analysis is one of the most sought after skills in the workplace. Companies have vast amounts of data and need people with the ability to analyze it. Get an understanding of how to analyze data in a business setting. This course can be taken alone or as part of the 3 course Certificate in Data Analysis. Class Details 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 For more information, visit our question and answer page - Click Here.

Data analysis is one of the most sought-after skills in the workplace. Companies have vast amounts of data and need people with the ability to analyze it. Get an understanding of how to analyze data in a business setting. Learn how many of your business decisions involve comparing groups for differences. This is a series of 3 courses. Spring 24 Dates Summer 24 Dates Introduction to Data Analysis 04/01/24-04/26/24 06/03/24-06/28/24 Intermediate Data Analysis 05/06/24-05/31/24 07/01/24-07/26/24 Advanced Data Analysis 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.

Microsoft Excel is the most used spreadsheet tool in the world. Discover 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. This is a series of 3 courses: Spring 24 Dates Summer 24 Dates Mastering Microsoft Excel 04/01/24-04/26/24 06/03/24-06/28/24 Intermediate Excel 05/06/24-05/31/24 07/01/24-07/26/24 Advanced Excel 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.