# Excel for Data Analytics Course Online (Self-Paced) Canonical URL: ## Overview #### Apply Excel to Data Analytics If you want to learn Excel and dive into data analytics, this is the class for you. #### Build Skills with Hands-On Projects To learn efficient data analysis, you'll complete projects under the guidance of an experienced instructor. #### Learn Core Functions & Formulas Learn advanced techniques to sort, filter, group, and visualize data in Excel. ## What you'll learn - Learn Excel functions and formulas for organizing, calculating, and summarizing data efficiently - Create and customize visual charts, including line, column, and pie charts, to present data clearly - Use logical statements, database functions, and data validation to manage and filter large datasets - Build and manipulate Pivot Tables to quickly summarize, sort, and group information - Explore advanced tools like named ranges, date calculations, and macro recording for custom reporting - Apply auditing techniques, cell locking, and Excel hot keys to optimize your spreadsheet workflow ## Curriculum ### Excel Level I: Fundamentals - Learn how to use functions to speed up your workflow - Add formatting and other visual effects - Turn data into visual charts, including line, column, and pie charts - Learn tips and tricks for easy workbook management ### Excel Level II: Intermediate - Learn to split and join text, add data validation, and named ranges - Use database functions and logical statements - Create Pivot Tables to quickly summarize large databases - Create advanced combo charts from multiple charts ### Excel Level III: Advanced - Cell management, including cell locking, auditing, and hot keys - Special formatting for calculating dates - Use advanced functions and advanced analytical tools - Record macros and relative reference macros for ad hoc reporting ## FAQ ### Is this course open to beginners? Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required. ### Do you offer payment plans or student financing for this course? This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify. ### What is the cancellation and refund policy for this single course? For this course, you are entitled to a 90% refund (your payment less the nonrefundable 10% registration fee) within 30 days of purchase if you have not accessed the course materials. ### What’s included with my tuition? A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Expert support with answers to your questions from real instructors throughout your learning journey Top-notch curricula that have been tried and tested over many years and are consistently improved for an optimal learning experience 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment ### Are there any additional fees or expenses? There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us. However, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost. ### Do you offer any discounts for this course? We don’t currently offer discounts as we do our best to affordably prices our courses. Take this course as part of a certificate program and save: Data Analytics & AI Certificate (Self-Paced) Price: $6,995 | Hours: 210 Hours ## Pricing **Tuition:** $595