What you’ll learn
- quick overview of the user interface
- how to save your excel worksheet
- drag & drop gesture
- excel rows, columns, cells
- how to move between cells quickly
- excel data entry
- excel data types
- excel formulas & references
- excel operators
- how to select cells, ranges, columns, rows in excel
- copy & paste data
- AutoComplete feature
- AutoFill feature
- what is function
- define Name
- how to sort & filter your data in excel
- how to create a simple chart with a few clicks
- multiple worksheets
- zoom function
Shortcuts covered in seven categories:
- general shortcuts
- shortcuts for navigation
- shortcuts for data entry
- Excel formatting shortcuts
- selection shortcuts
- shortcuts for formulas
- miscellaneous shortcut keys
I created a section for the most frequently used Excel functions. You will find lots of real-world examples in these topics:
- Relative vs Absolute cell references explained
- working with date functions
- SUM(), SUMIF(), SUMIFS() functions
- MIN(), MAX(), AVERAGE(), COUNT() functions
- VLOOKUP(), HLOOKUP() functions examples
- INDEX(), MATCH(), XLOOKUP() functions to search data
Who this course is for:
- Students who want to stand out with special Excel knowledge
How to Enroll Excel – Microsoft Excel Beginner to Advanced [2021] course?
How many members can access this course with a coupon?
Excel – Microsoft Excel Beginner to Advanced [2021] Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!