This course aims to help beginners master Microsoft Excel 2019 by covering topics such as Excel formulas and functions, working with ranges, handling larger files, freezing panes, printing options, managing sheets, and creating formulas using functions. The course includes hands-on exercises and is suitable for Excel users of various versions. The teaching method involves a 3-hour tutorial with practical exercises to reinforce learning. The intended audience for this course is beginners who are new to Excel or feel intimidated by spreadsheets.
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.7 rating, based on 3 Class Central reviews
-
Bhatia HarmeetThe course is just excellent. The way of explanation is so so good . This course really help me a lot -
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. -
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
