Excel in Microsoft Excel 1: beginner to Excel intermediate
4.3 /5- Offered byUDEMY
Excel in Microsoft Excel 1: beginner to Excel intermediate at UDEMY Overview
Duration | 12 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
Excel in Microsoft Excel 1: beginner to Excel intermediate at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 50 articles + resources
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Excel in Microsoft Excel 1: beginner to Excel intermediate at UDEMY Course details
- This course is for you if you want to develop your Microsoft Excel skills
- This course will use the latest version of Excel, but is ideal for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 365
- This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions
- Create, configure and save Excel worksheets and workbooks
- Navigate through and format worksheets and workbooks
- Customise options and views for worksheets and workbooks
- Configure Excel worksheets and workbooks to print (e.g. page setup)
- Insert data into and format cells and ranges, and create and modify tables
- Highlight, filter, sort and group cells, ranges and tables
- This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013 and 2007
- By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam
Excel in Microsoft Excel 1: beginner to Excel intermediate at UDEMY Curriculum
Welcome
Introduction
Introduction to Udemy
Curriculum
Level 1, Section 1 - An Introduction to Excel
Creating new blank workbooks
Entering data
An introduction to fonts and highlighting
Saving and closing your workbook
Practice Activity Number 1
Practice Activity Number 1 - The Solution
Level 1, Section 2 - Create worksheets and workbooks
Creating new workbooks using templates
Menus and toolbars
Managing multiple workbooks - Excel 2013 and 2016
Managing multiple workbooks - Excel 2007 and 2010
Importing files and Opening non-native files directly in Excel
Adding worksheets to existing workbooks
Copying and moving worksheets, and changing spreadsheet order
Level 1, Section 3 - Configure worksheets and workbooks to save
Saving workbooks in alternate file formats
Maintaining backward compatibility
Saving files to remote locations
Level 1, Section 4 - Basic Formulas
Using basic operators
Order of operations
How to enter numbers and dates in Excel
Referencing cell ranges in formulas
Solution to the above exercise
Practice Activity Number 2
Practice Activity Number 2 - Solution
Level 2, Section 1: Navigate through Excel worksheets and workbooks
Searching for data within a workbook
Hyperlinks
Using Go To and Using Name Box
Hot Keys
Level 2, Section 2: Format worksheets and workbooks
Changing worksheet tab colour
Inserting and deleting columns and rows
Undo and Redo
File Management tips
Adjusting row height and column width
Hiding columns and rows
Selecting multiple ranges
Level 2, Section 3: Customise options and views for worksheets and workbooks
Hiding worksheets
Customising the Quick Access toolbar
Customising the Ribbon
Assigning shortcut keys
Recording simple macros
Managing macro security
Changing workbook views
Using zoom
Adding values to workbook properties
Displaying formulas
Freezing panes
Splitting the window
Excel in Microsoft Excel 1: beginner to Excel intermediate at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?