Microsoft Excel Tutorial for Beginners

Embark on a comprehensive 3-hour journey to master Microsoft Excel 2019 for beginners. Learn essential skills including creating formulas and functions, working with dates and time, printing specific pages, managing ranges, handling large files, and utilizing freeze panes. Explore the intricacies of Excel formulas, discover numerous tips and tricks, and gain confidence in spreadsheet manipulation. Follow along with downloadable exercises to reinforce your learning. Suitable for Excel 365, 2016, and 2013 users, this tutorial covers everything from basic navigation to advanced topics like 3-dimensional formulas, ensuring a solid foundation for Excel proficiency.

- Intro to Excel
- What's New In Excel 2019
- Course Overview
- Overview of the Excel window
- Mouse-Features
- Backstage View
- Entering Text and Numbers in Excel
- Creating Basic Formulas in Excel
- Relative References in Excel
- Order of Operations in Excel
- Working with Ranges in Excel
- Module 2 - Practice Exercise
- Working with the Save and Save As Commands
- File Extensions, Share, Export and Publish Files
- Module 3 - Practice Exercise
- Opening a File in Excel
- Working with Larger Files in Excel
- Freeze Panes in Excel
- Split Screen in Excel
- Module 4 Exercise
- Headers and Footers in Excel
- Print Titles
- Comments in Excel
- Page Setup Options in Excel
- Fit to Print on One Page in Excel
- Printing Workbooks in Excel
- Module 5 Exercise
- Adding and Deleting Columns and Cells
- Changing Column and Rows Widths
- Module 6 Exercise
- Copt, Cut and Paste
- Copying Formulas
- Module 7 Exercise
- Overview of Formulas
- Create Formulas Using Functions part1
- Create Formulas Using Functions part2
- Absolute Values
- Module 8 Exercise
- Adding Deleting and Renaming Sheets
- Additional Sheet Tab Options
- 3 Dimensional Formulas
- Module 9 Exercise