Duration: 2h 1m | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 659 MB
Genre: eLearning | Language: English
Hello, my name is Luis Carlos and I will be the instructor in this class of Microsoft Excel.
This class ismadefor beginners, being divided into different sections.
In the first partyou will learn the interface excel and how it is divided. The ribbon customization and quick access toolbar will be another important point that allows to adapt the working environment to the needs of the user.
In a second part we will learn how to create and open excel files, add, delete and change the name of worksheets and in a third part of the course we learn to insert data manually and automatically and work with cell and text formatting tools.
The last part will bededicated to formulas and functions that will be an important step to work the data automatically in the worksheet.
To follow all the lessons, is available a file exercises.xlsxin the project section that can be usedby the students to make all exercises made in the videos.
This class is compatible with the latest versions of Microsoft Excel (2007 / 2010 / 2013 / 2016)
List of main topics:
Excel interface
Customizing the Excel Quick Access Toolbar
Understanding the Structure of an Excel Workbook(anatomy)
Customize ribbon and quick access toolbar
Create, Save and open an Excel Document
Add, rename, delete worksheet
Enter text manually and automatically with autofill tool
Format data
Wrap, shrink and merge text
Format painter tool
Format numbers - Change format to date and time
Cell references - relative, absolute and mixed
Create formulas using logical operators
Functions syntax - Learn and apply the main used functions
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
