Please download one of these browsers:
Keep your browser version up-to-date for a fast, secure, web experience.
This is a basic-level Excel course for beginners that introduces core spreadsheet skills. Skills you’ll gain: basic Excel interface navigation, workbook and worksheet understanding, data entry in cells, rows, and columns, basic formatting (fonts, numbers, alignment, merging cells), worksheet navigation (switching sheets, workbook views, freeze panes), hiding and unhiding rows and columns, and Quick Access Toolbar customization.
This course builds on foundational Excel skills by focusing on advanced techniques for working with cells and ranges. Skills you’ll gain: advanced cell and range management, applying conditional formatting rules, using custom number formats, setting up data validation rules, working with dynamic arrays and spill functions, sorting and filtering data, identifying and resolving common Excel errors, and using cell referencing and range-based functions for data analysis.
This course introduces the fundamental concepts of working with cells and ranges in Microsoft Excel. Skills you’ll gain: understanding Excel ranges, selecting and navigating cell ranges, modifying ranges, using basic Excel functions (SUM, AVERAGE, MAX, MIN, COUNT), and using named ranges in formulas.
This course focuses on essentials tools for improving data accuracy, consistency, and visibility in Excel. Skills you'll gain: applying conditional formatting rules, creating and customizing formatting conditions, setting up data validation rules, creating drop-down lists, and using formulas in data validation to control data input.
This course covers essential Excel skills for managing and analyzing data, from structured data entry and formatting to applying formulas and creating meaningful visualizations. Skills you’ll gain: structured data entry and formatting, using AutoFill and named ranges, applying advanced formulas and functions, creating and managing tables, sorting and filtering data, importing external data, building and analyzing PivotTables, and creating and customizing charts for data visualization.
This course introduces foundational Excel skills for working with data, including basic data entry, simple calculations, and essential data handling techniques. Skills you’ll gain: basic data entry and editing, performing simple calculations using formulas, using basic Excel functions (SUM, AVERAGE, IF, COUNT, MAX), sorting and filtering data, using copy and paste options effectively, and applying basic data cleaning techniques such as find and replace.
This course introduces essential Excel skills for managing and analyzing data, from basic navigation and calculations to working with larger datasets and summarizing information using PivotTables. Skills you’ll gain: navigating the Excel interface, entering and formatting data, creating basic formulas, handling common errors, sorting and filtering datasets, using core functions (SUM, AVERAGE, COUNT), creating charts, building and customizing PivotTables, and managing and sharing workbooks.
This course focuses on improving how data is presented and managed in Excel by combining formatting, organization, and optimization techniques. Skills you'll gain: applying cell styles and themes, organizing data using sorting and filtering, using conditional formatting, creating and managing tables, customizing charts and sparklines, applying data validation techniques, and protecting and sharing workbooks.
This course focuses on advanced Excel formatting techniques used to enhance data presentation beyond basic styling, while also providing a review of fundamental formatting concepts. Skills you’ll gain: applying advanced conditional formatting, creating custom number formats, using cell styles and themes, combining formatting techniques strategically, using text functions for formatting, and automating formatting tasks using macros.
This course focuses on preparing Excel worksheets for clear and professional presentation, especially for printing and sharing. Learners will explore how to organize worksheet appearance and adjust page settings to ensure content is properly displayed. Skills you’ll gain: changing worksheet tab colors, organizing worksheets visually, adjusting page setup settings, modifying margins, setting orientation and paper size, and configuring print elements such as gridlines, headers, and footers.
This course combines key Excel skills into a structured workflow, guiding learners from navigating workbooks and managing worksheets to applying formulas and creating data-driven reports. Skills you’ll gain: navigating workbooks and worksheets, managing multiple workbooks, applying formulas and functions, linking data across workbooks, ensuring data accuracy with validation and error checking, creating charts, building and customizing PivotTables, and summarizing data for reporting.
This course introduces essential Excel navigation skills focused on improving efficiency in working with workbooks and worksheets. Skills you’ll gain: navigating the Excel interface, managing workbooks and worksheets, using Ribbon and Quick Access Toolbar, applying search and navigation tools such as Go To and Find and Replace, inserting and managing hyperlinks, and improving workflow efficiency through interface customization.
This course focuses on improving how users view, organize, and secure Excel workbooks. Skills you’ll gain: using and customizing workbook views, optimizing workspace layout with freeze panes and split windows, adjusting Excel settings for improved workflow, applying workbook protection methods, and securing data using passwords, encryption, and permission settings.
This course focuses on preparing Excel worksheets for professional output, including printing, sharing, and optimizing files for different formats. Skills you’ll gain: configuring page layout settings, adjusting margins and orientation, setting print areas and print titles, customizing headers and footers, scaling worksheets for print, managing workbook protection, performing batch printing, troubleshooting printing issues, and optimizing Excel files for web and mobile use.
This course focuses on essential Excel output tasks, including preparing worksheets for printing, managing file formats, and protecting workbook data. Skills you’ll gain: using print preview and print settings, adjusting page layout (orientation, margins, scaling), selecting print options (print selection, titles, gridlines, headings), setting print areas, saving files in multiple formats such as Excel, CSV, and PDF, and applying workbook and worksheet protection.
This course focuses on managing Excel workbooks from creation to organization and data import. Learners will explore how to create and customize workbooks, work with templates, and import data from various file formats, while organizing and structuring content efficiently. Skills you’ll gain: creating and saving workbooks, using templates, customizing workbook layouts, importing data from multiple file formats (CSV, TXT, XML, HTML), linking external data, creating and managing worksheets, modifying workbook elements, and opening non-native files in Excel.
This course focuses on building and managing Excel workbooks while integrating formulas, data visualization, and automation tools. Skills you’ll gain: creating and managing workbooks, navigating the Excel interface, entering data and creating formulas, applying basic formatting, using advanced functions, creating charts and PivotCharts, applying data validation and workbook security, and automating tasks using macros.
(2).jpg?lmsauth=f4484650b65fe1c39698b19f83fd0d7b370a8344){kind=small}