Guided Learning Hours Course Material. Number of Modules Accredited By. Enquire Now. Learn a highly important software for any career path. Understand the basic level functions of Microsoft Excel, to gain a complete introduction to the programme. Ability to become a master of Excel. Learn many different formulas which could benefit your daily operations immensely.
Learn how to save time and create easy work of calculating, displaying and sharing data. Register today and get free access to this Microsoft Excel Beginner course! Who is this course aimed at? This course is introduction level, so will be suitable for those who have never used Excel before, or who would like an introduction to the programme.
This online training course is comprehensive and designed to cover the topics listed under the curriculum. Learners on this course must be over the age of 16 and should have a basic grasp of English, Maths and ICT. At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course. The hard copy will be sent via the post and will arrive in days.
The soft copy comes in the form of a PDF and will be with you in 24 hours. As Excel is so widely used this course provides transferable skills that will be useful in a wide range of job roles, and could help you land your next job, or get a pay rise. The qualification will be of particular interest to anyone hoping to work in administration, accounting or bookkeeping. Access to Excellent Quality Study Materials.
Personalised Learning Experience. Support by Phone, Live Chat, and Email. Course Curriculum. The course begins with a quick review of the fundamentals, then dive into each formula category from basic stats functions, conditional statements to more advanced array formulas, named ranges, and data tools like WebService and FilterXML.
You will also learn to work with texts, dates, times and arrays and build custom interactive dashboards. With this bestselling course you get 7 hours of video content, downloadable project files, quizzes and homework assignments and one-on-one instructor support. Duration : 7 hours on-demand video Rating : 4.
This is an introductory course in the use of Excel and is a part of the Business Statistics and Analysis Specialization by Rice University. It has been designed for two kinds of learners — those who have a basic functional knowledge of Excel and those who use Excel regularly and wish to improve their knowhow. This Excel training consists of 4 modules that progressively take you from learning basic operations such as reading data into Excel using various data formats, editing and organizing data etc.
The instructor Sharad Borle has structured the course very well and uses easy to understand examples that make learners understand everything quickly and be able to apply them in real life scenarios. There are plenty of quizzes and assignments in the course which will require access to Windows Microsoft Excel or later to complete.
The details of course modules are as follows: 1. Module 1: Introduction to Spreadsheets — Introduction to Excel spreadsheets and basic data functions and formulas 2. Module 4: Advanced Graphing and Charting — Introduction to advanced graphing and charting techniques available in Excel. Duration : 4 weeks, hours per week Rating : 4. It is the best course in Excel to take your data analysis skills to the next level.
You will learn when, why, and how to use Excel Pivot Tables and Charts. You will learn how to explore and shape raw data and indentify patterns, trends and insights from that data. The course uses sample data from IMDB Movie database to review core Pivot table functionality including sorting, filtering and grouping tools, conditional formatting and calculated values. You will also learn data visualization, how to build interactive dashboards using Pivot Charts, Slicers and Timelines. The course also includes 10 real-world case studies for demonstration.
This Excel course has been developed by Chris Dutton who is a Microsoft Certified, best-selling Excel instructor and teaches the course in a fun, interactive and effective style. It includes Excel project files, 6 downloadable resources, 22 articles, homework assignments and quizzes and lifetime access to course material.
It is the best course to learn Advanced Excel. It comprises of 4 modules where you will get hands-on instruction of advanced Excel functions and skills to use PowerPivot for building databases and models. The Course modules are: 1. Preparing a Professional excel — Covers data models and databases, PowerPivot tool 2. Advanced Scenario Analysis — Explores different analytical methods and how to use them 3.
Data Visualization — Covers elements of data visualization like charts and graphs in details 4. Dashboarding — Details design principles and requirements for building a dashboard. The course is taught by Alex Mannella and contains several graded quizzes and assignments with peer feedback. You will earn an electronic Certificate at the end of the course.
This is a whole Excel Mastery Series combined in one course that takes a learner from being a complete novice to a skilled VBA programmer. It imparts complete and comprehensive understanding of Microsoft Excel in 3 levels where you progressively master all the basics, master the advanced functions of Excel and Master programming Excel using VBA.
It covers Excel , Excel and Excel You will cover the following in three levels: 1. Level 2 — Learn to use Excel like professionals using advanced functions, conditional formatting, custom formatting, calculations with time and dates, macros, creating databases, Gantt charts etc 3. The course has been designed and is instructed by Alan Jarvis who has been teaching Microsoft Excel for over 20 years.
He has created this all-in-one Excel master course for anybody who is a complete beginner, or someone who wants to take their Excel skills a notch higher, or someone who wants to create efficient business solutions using Excel. Upon enrolling for the course, you get access to all the video lectures, articles, quizzes, projects, and downloadable resources for lifetime. Duration : It has been created by Kyle Pew who is a certified Microsoft trainer with decades of experience.
He has set up handful of different projects through which he introduces you to how you can learn and excel at Macros and VBA. The course covers key foundational concepts of programming within Excel like procedures, variables, loops, conditional statements etc , so no prior programming experience is needed. Greater learning is guaranteed with project based scenarios.
