40% Off Career-Building Certificates
AI Engineer - Learn how to integrate AI into software applications
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master essential Microsoft Excel skills in this fast-paced 24-minute tutorial designed for beginners. Navigate through the interface, create workbooks, and learn efficient data entry techniques. Progress from basic spreadsheet formatting to advanced features like conditional formatting, formulas, IF functions, and PivotTables. Practice data analysis using tables and charts while discovering productivity-boosting keyboard shortcuts and expert tips. Follow along with downloadable practice files to reinforce learning as you explore everything from basic cell manipulation to complex data visualization techniques. Includes comprehensive timestamps for easy reference and links to additional resources for deeper learning in specific areas like formulas, charts, shortcuts, AutoFill features, and pivot tables.
Syllabus
Introduction
Accessing Microsoft Excel
Create a Excel Workbook and layout
Entering and formatting data
Adding and deleting columns and rows
Formatting numbers in cells
Moving completed columns and rows
Sorting and filtering data in Excel
Applying Conditional formatting in Excel
Using formulas and functions in Excel
How to use the IF function in Excel
Using tables in Excel
How to add a Chart in Excel
How to add a PivotTable in Excel
Taught by
Teacher's Tech