
Explore Excel basics for beginners, covering basic calculations, conditional formatting, data shaping and visualization, and splitting and concatenating names across cells, plus shortcuts.
Master basic Excel calculations by building formulas that start with equals and reference cells like A1 and B1, applying addition, multiplication, division, subtraction, and formatting results as whole numbers.
Master conditional formatting to visualize data in Excel, using data bars, color scales, and icon sets, with rules for greater than, less than, between, and percent thresholds to highlight insights.
Learn to split text in Excel with the text to column tool, using space or other delimiters and choosing limited width or fixed width. Lionel Messi splits into two cells.
Master the concatenate function in Excel to join text from two cells with a space, the opposite of split, using a quoted space to separate them.
Perform a fast revision of excel basics, using the sum function and range selection for totals, then apply conditional formatting, text to column, concatenate, and flash fill tips.
The purpose of this course is to provide students with the basic skills necessary to use Excel for personal and business purposes. The course will provide a foundation in Excel that can be expanded upon as students gain more experience. During the course, students will become familiar with the most commonly used features of the Excel application and be taught various formulas that can be used in everyday calculations. They will also be introduced to some more advanced techniques which will allow them to utilize the full potential of Excel’s features. After completing this course, students will be equipped to start using Excel confidently and successfully.
Course Objectives This course will provide students with an overview of the basic functions of Microsoft Excel and the skills required to master those functions. It will cover the following topics:
Introduction to Excel – Students will learn about the basic functions of the application and how to navigate the interface.
Introduction to Formulas – Students will learn about the different types of formulas in Excel and how to set them up to perform simple calculations.
Students will learn how to use conditional formatting in order to be able to highlight cells that contain errors or perform other functions based on the values in cells.