Learn to navigate interfaces, format data, use basic formulas, and create charts with essential skills for data organization, calculation, and visualization.
This course covers the fundamentals including navigating the interface, entering and formatting data, basic formulas, and creating simple charts. By the end of the course, you will be equipped with the essential skills to organize data, perform basic calculations, and visualize information, making you more efficient and productive in your personal and professional tasks.
Course Outline ( Free Preview)
Class Files
Module 01 - Introduction to Excel
This video is an introduction to the Microsoft Excel Fundamentals course, taught by Angelica. Angelica explains what Excel is, what topics the course will cover, and how to access Excel on the desktop or the web. She also tells you a little bit about her background and how to contact her if you have any questions.
Module 02 - Getting Started
This video is an introduction to the Excel Fundamentals course, where Angelica explains how to create and customize workbooks, use the ribbon and the Quick Access toolbar, and navigate the Excel interface. She also shows how to choose between a blank workbook or a pre-built template, and how to insert, rename, and color worksheets.
Module 03 - Entering Data19 min.
This tutorial is on how to enter data into Excel, using different methods and formats. Angelica explains the basics of cells, ranges, and references, and demonstrates how to use the fill handle to create series and custom lists. She also shows how to import data from a text file using the Text Import Wizard.
Module 4A - Formulas and Functions (Formulas and Operators)21 min.
This video is a tutorial on how to use basic formulas and functions in Excel. Angelica explains the concepts of relative and absolute cell references, the different types of operators, and how to avoid common errors. She also demonstrates some examples of formulas and functions on a sample workbook.
Module 4B - Formulas and Functions (Frequent Functions)18 min.
In this video, Angelica demonstrates how to use some basic and common functions in Excel, such as SUM, AVERAGE, COUNT, MIN, MAX, IF, SUMIF, and XLOOKUP. She uses a grade book worksheet as an example and shows how to create formulas that calculate the final grades, usernames, and other statistics for a class of students. She also explains how to use the formula bar, the auto sum feature, and the Intellisense helper to enter and format the formulas correctly.
Module 05 - Formatting Data22 min.
In this video, Angelica teaches you how to format data in Excel using various tools and options. She shows you how to apply styles, colors, borders, alignment, and conditional formatting to your cells and ranges. She also explains how to adjust the row height and column width, how to merge and unmerge cells, and how to format your data as numbers, dates, text, and more.
Module 06 - Format As An Excel Table9 min.
This a tutorial is on how to format data as an Excel table and use its features to sort, filter, and analyze data. Angelica demonstrates how to create a table from a range of cells, apply different styles and options, and use the freeze panes function to keep some columns visible while scrolling. She also shows how to use the filter and sort buttons in the column headers to manipulate the data in the table.
Module 07 - Creating Custom Charts8 min.
In this video, Angelica shows you how to create and customize different types of charts in Excel to visualize your data. She demonstrates how to select the data, choose a chart from the insert or quick analysis options, and modify the chart elements, styles, and colors. She also explains how to add features like data labels, error bars, trend lines, and sparklines to enhance your charts.
Module 08 - Sharing and Collaborating8 min.
This video is about how to share and collaborate in Excel with others. Angelica shows how to upload your workbook to OneDrive, send a link to your co-authors, and manage their permissions. She also explains how to protect your workbook or worksheet with passwords and lock or unlock certain cells.
Module 09 - Conclusion1 min.
This video is a summary of the Excel Fundamentals and Excel Course for Beginners, taught by Angelica. She recommends some courses that you can take next to improve your Excel skills, such as the art and science of Excel modeling, building BI with pivot tables, and Power BI with Excel. She also invites you to check out the Excel Boot Camp, a four-day training on Excel, and to contact her by e-mail if you have any questions.
Shortly after graduating from the University of Florida in 2012, Angelica moved to Jacksonville and began her career as a high school Biology teacher. As a trainer at Pragmatic Works, her primary goal is to help individuals feel more comfortable and confident using Power BI. While not in the office, she enjoys traveling around the city of Jax to check out local eateries, live music events, and performing arts.
.png)