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.
Overview
Syllabus
- 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
Taught by
Simon Sez IT
Related Courses
Related articles
Reviews
4.5 rating, based on 6 Class Central reviews
-
It is really amazing. I now understand a lot more when I use Excel.Absolute value, adding, removing, and remaining sheet are the best brief tutorials within the function overview lesson that follows.
-
Absoultey good one for every beginner explanation from scrath and a detailed explanation I recently completed an Excel course designed for beginners, and it was exactly what I needed! The course provided a solid foundation, covering the essentials of Excel in a structured and easy-to-follow format
-
Dear Simon ,
I m kamran Afridi i love the way of your teching it was so simple but i capture all course secondly before start a course i thought that its very difficul for me but i was totally wrong its too easy with the hlep you
Thanks -
Bhatia HarmeetThe course is just excellent. The way of explanation is so so good . This course really help me a lot -
Yanisa ChavengprasertIt's helpful for me and I will find other courses to learn more
I am beginner I am hopefully you will create new courses as soon as possible -
Pixule MogGood course for beginners, it explains the basics of how to use the program, how to format the date, ahat formulas are and how to print the data.
