Basic Excel for Data Analysis
Fundamentals. You’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis.
Boost your Data analytics career with powerful new Microsoft Excel skills by taking this Data Analytics course, which includes training on Business Analytics.
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
WEEK 1-2 | 15 Modules | 10+ Hours | 10+ Skills
Course Modules: Getting Started in Excel | Creating Your First Excel Spreadsheet | Introduction to Excel Formulas and Functions | Using Named Ranges | Formatting Numbers and Cells | Formatting Worksheets | Working with Excel Lists | An Introduction to Intermediate Formulas | Conditional Formatting | Inserting Items into a Spreadsheet | Working with Views and Zoom | Page Layout and Print Options | Finalizing the Spreadsheet | 30 Excel Tips and Tricks.
Course Contents