Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
EXTREMELY USEFUL TO UNDERSTAND THE BASIC CONCEPTS OF EXCEL
At the end of this course, you will get the knowledge of...
Excel Environment, Excel Worksheet, Working with Excel Functions, Excel Security & Sharing Features, Dynamic Formatting in Excel, Sorting and Filtering Data in Excel, Using conditional Aggregate Functions in Excel, Working with Reports & Charts, Presenting Data Using Charts in Excel.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Overview of the Basics|
Quick Access Toolbar and common options in ExcelPreview
Absolute and Relative Cells
Working with the Excel Environment
About Excel Worksheet
Enhance Worksheets Using Themes
Working with Comments
Access External Resources Using Hyperlinks
Auto Fill Features
Printing the Worksheet
|Section 2: Working with Functions|
Writing conditional expressions (using IF)
Using logical functions (AND, OR)
Using Date Functions
Using Text Function
Using Time Functions
|Section 3: Security & Sharing Features|
Protecting and un-protecting worksheets and cells
Saving files with passwords
|Section 4: Dynamic Formatting|
Applying auto formatting option to worksheets
Applying conditional formatting to cells
|Section 5: Sorting and Filtering Data|
Filtering data for selected view (Auto Filter)
|Section 6: Using conditional Aggregate Functions|
|Section 7: Working with Reports & Charts|
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
|Section 8: Presenting Data Using Charts|
Creating a Chart
Create a Chart Template
We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach to e-learning and a perfect way to Jump Start your career.
In today’s job market, it’s important to have the skills to match current needs and to stay on par with technological advances. The flexible, affordable and high-quality online technical courses at Parallel Branch provide the opportunity for you to learn the skills you need to move ahead and stay there.