Fundamentals Of Microsoft Excel 2013

About Course
COURSE DESCRIPTION
Excel is typically used to organize data and perform financial analysis. It is used across all business functions and at companies from small to large. Microsoft Excel is the industry-leading spreadsheet software program, a powerful data visualization, and analysis tool. This course is taking you through the basic and fundamental aspects of this great software. take this course seriously because this is where you can earn as a data scientist.
CERTIFICATION
Going forward, the advanced part of this program will reward students who pass the course exams, being both theory and practicals. The certificate will be rewarded to only students who have studied this course and will go on to the intermediate level and through to the master’s level.
LEARNING OUTCOMES
- Gain a rock-solid foundation for using Excel to process data.
- Learn the basics of entering and formatting data and numbers.
- Build simple formulas to calculate totals and averages.
- Create and format professional-looking spreadsheets.
- Editing Workbooks
- Editing Cell Data
- Inserting and Moving Cells
- Hiding Columns and Rows
- Basic Formulas In Excel
- Sums and Averages
- MIN and MAX in Excel
- More Pasting Options
- Aligning and Merging Cells
- Formating Numbers and Dates
- Object Properties and Alt Text
- Insert, Rename, and Delete Worksheets
- Freeze Rows and Columns
- Hide Worksheets and Gridlines
- Multiple Windows
Course Content
The Basics
-
Understand the Excel Screen
-
Create Workbooks
-
Navigate Worksheets
-
Open Workbooks
-
Save Workbooks
-
AutoRecover
Important Practice
Editing a Workbook
Basic Formulas
Basic Formatting
Insert Objects
Manage Worksheets
Student Ratings & Reviews
No Review Yet