Excel tutorial interactive. It explains the code module too which is an interesting take on the entire databasing process. Using excel as your database. A worksheet is a collection of cells where you keep and manipulate the dataeach excel workbook can contain multiple worksheets. Watch the lecture videos complete the hands on exercises pass the exam and earn certifications.
Before making a dashboard you need to consider the decisions the end user will make based on the data the look and feel of it. Get started with excel to start we recommend going through our one of a kind completely free interactive excel tutorials. The excel interactive controls will be available in the developer tab on the ribbon. An interactive dashboard in excel is basically slices of visualization which enables your data to tell a story.
A workbook is another word for your excel filewhen you start excel click blank workbook to create an excel workbook from scratch. A nice tutorial from chandoo. Courses provide an online on demand interactive training experience. Free interactive excel tutorial provides a comprehensive and comprehensive pathway for students to see progress after the end of each module.
This page gives you access to a completely free online excel training 26 video lessons with 12 hours of learning. If you do not find the developer tab on the ribbon do the following click on customize ribbon in the excel options box. A dashboard is only useful if they are dynamic easy to use as well as compatible with the pc you are using. You dont need to sign up or do anything to get access to the course.
Excel formulas functions vba and keyboard shortcuts. If youre an excel beginner or an intermediate and want to learn excel this is the perfect place for you to start. Excel university is a nasba cpe sponsor and our courses are offered for cpe credit. You will be asked to create a formula use a shortcut or type a line of vba code directly into our web apps receiving immediate feedback.
Excel interactive controls are simple to use and does not require any expertise in excel.