Microsoft Excel - Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course, Advanced Excel Formulas & Functions, data analysis & Much More

Beginner 0(0 Ratings) 0 Students enrolled
Created by Online Courses Learn Online, On Your Schedule | Firste Last updated Fri, 18-Jun-2021 English
What will i learn?
  • • Master Microsoft Excel from Beginner to Advanced
  • • Build a solid understanding on the Basics of Microsoft Excel
  • • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • • Learn the most common Excel functions used in the Office
  • • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and More
  • • Maintain large sets of Excel data in a list or table
  • • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • • Works for all US and International students, wherever you are on this planet

Curriculum for this course
76 Lessons 02:27:33 Hours
1 Introduction
4 Lessons 00:06:49 Hours
  • 1. Introduction 00:01:56
  • 2. Course Outcome 00:01:38
  • 3. Study Skills Required 00:01:10
  • 4. How to get most out of the course 00:02:05
  • 5. Why Excel 00:01:51
  • 6. Excel Menu System 00:01:34
  • 7. Quick Access Toolbar 00:02:58
  • 8. Workbook and Worksheet 00:03:41
  • 9. Status Bar 00:02:19
  • 10. Navigation 00:01:22
  • 11. Shortcut Menus and Mini Toolbar 00:00:58
  • 12. New Workbook 00:01:44
  • 13. Save and Save As 00:01:32
  • 14. Formula Bar 00:01:23
  • 15. Creating Simple Formula 00:05:22
  • 16. Copying a Formula 00:02:04
  • 17. Calculating Year To Date Total 00:01:27
  • 18. Percentage Change 00:02:57
  • 19. Working With Functions under Formula 00:01:12
  • 20. Fonts 00:01:19
  • 21. Row Height and Column Width 00:02:17
  • 22. Font color and toggle button 00:01:30
  • 23. Alignment and Text Wrapping 00:02:58
  • 24. Borders 00:01:21
  • 25. Numeric and Special Formatting 00:03:17
  • 26. Formatting Date and Time 00:03:11
  • 27. Conditional Formatting 00:03:15
  • 28. Inserting Table 00:01:25
  • 29. Shapes and Visual Effects 00:02:05
  • 30. Smart Art 00:01:13
  • 31. Inserting Rows and Columns 00:01:21
  • 32. Shifting Rows and Columns 00:01:57
  • 33. Hiding and Unhiding Rows and Columns 00:01:46
  • 34. Copying and Moving Data 00:00:58
  • 35. Print Preview 00:01:29
  • 36. Page Layout 00:02:33
  • 37. Final Print 00:00:47
  • 38. Creating Charts 00:01:23
  • 39. Changing Chart Types 00:01:11
  • 40. Formatting Chart 00:01:04
  • 41. Chart Design 00:01:40
  • 42. Creating Spark lines 00:01:38
  • 43. Freezing and Unfreezing Panes 00:01:55
  • 44. Splitting Rows and Columns Horizontally and Vertically 00:02:05
  • 45. Renaming Worksheet 00:01:01
  • 46. Inserting and Deleting Worksheet 00:01:53
  • 47. Moving and Copying Worksheet 00:01:25
  • 48. IF Function 00:04:07
  • 49. Vlookup 00:03:12
  • 50. Locking and Protecting Data 00:01:48
  • 51. Protecting Worksheet Part 1 00:02:29
  • 52. Protecting Worksheet Part 2 00:01:03
  • 53. Sharing Workbooks 00:01:41
  • 54. Sorting Data 00:01:35
  • 55. Calculating Sub-Total 00:02:13
  • 56. Filtering Data 00:01:30
  • 57. Splitting Data Into Different Columns 00:01:43
  • 58. Removing Duplicates 00:01:40
  • 59. Goal Seek 00:02:57
  • 60. Scenario Manager 00:07:32
  • 61. Data Table 00:03:22
  • 62. Creating A New Pivot Table 00:05:48
  • 63. Manipulation of pivot table 00:02:09
  • 64. Grouping Data by Date and Time 00:01:26
  • 65. Filtering Data 00:01:57
  • 66. Slicer 00:02:25
  • 67. Pivot Chart 00:02:40
  • 68. Using Macros 00:04:10
  • 69. Conclusion 00:00:56
  • 70. Sorting Data
  • 71. Sub-total
  • 72. Goal Seek
  • 73. Scenario manager
  • 74. Pivot table
  • 75. Macros
  • 76. Bonus Lectures. Enjoy the Benefits
Requirements
  • • All Levels. No prior Excel experience is necessary.
  • • You will need a computer, Laptop, Tablet or a smartphone.
  • • All devices work: Mac or PC, iOS or Android
  • • Microsoft Excel 2007 - 2019 or Office 365
  • • All you need is YOU and YOU! Just have an open mind and willingness to learn and implement
+ View more
Description

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. We will guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 65+ Lectures that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

<!--[if !supportLists]-->·       <!--[endif]-->Creating effective spreadsheets

<!--[if !supportLists]-->·       <!--[endif]-->Managing large sets of data

<!--[if !supportLists]-->·       <!--[endif]-->Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

<!--[if !supportLists]-->·       <!--[endif]-->Create dynamic report with Excel PivotTables

<!--[if !supportLists]-->·       <!--[endif]-->Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

<!--[if !supportLists]-->·       <!--[endif]-->Audit Excel Worksheet formulas to ensure clean formulas

<!--[if !supportLists]-->·       <!--[endif]-->Automate your day-to-day Excel tasks by mastering the power of Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!

 

You will Learn by Practice:

By the end of this Unique Course, you will go from #Newbie to #Advanced as an #Excel #Spreadsheet_Expert. Here is what you’ll learn:

 

1 Introduction

<!--[if !supportLists]-->1.       <!--[endif]-->Introduction

<!--[if !supportLists]-->2.       <!--[endif]-->Course Outcome

<!--[if !supportLists]-->3.       <!--[endif]-->Study Skills Required

<!--[if !supportLists]-->4.       <!--[endif]-->How to get most out of the course

 

2 Getting Started With Excel

<!--[if !supportLists]-->5.       <!--[endif]-->Why Excel

<!--[if !supportLists]-->6.       <!--[endif]-->Excel Menu System

<!--[if !supportLists]-->7.       <!--[endif]-->Quick Access Toolbar

<!--[if !supportLists]-->8.       <!--[endif]-->Workbook and Worksheet

<!--[if !supportLists]-->9.       <!--[endif]-->Status Bar

<!--[if !supportLists]-->10.   <!--[endif]-->Navigation

<!--[if !supportLists]-->11.   <!--[endif]-->Shortcut Menus and Mini Toolbar

<!--[if !supportLists]-->12.   <!--[endif]-->New Workbook

<!--[if !supportLists]-->13.   <!--[endif]-->Save and Save As

 

3 Working With Formula

<!--[if !supportLists]-->14.   <!--[endif]-->Formula Bar

<!--[if !supportLists]-->15.   <!--[endif]-->Creating Simple Formula

<!--[if !supportLists]-->16.   <!--[endif]-->Copying a Formula

<!--[if !supportLists]-->17.   <!--[endif]-->Calculating Year To Date Total

<!--[if !supportLists]-->18.   <!--[endif]-->Percentage Change

<!--[if !supportLists]-->19.   <!--[endif]-->Working With Functions under Formula

 

4 Formatting

<!--[if !supportLists]-->20.   <!--[endif]-->Fonts

<!--[if !supportLists]-->21.   <!--[endif]-->Row Height and Column Width

<!--[if !supportLists]-->22.   <!--[endif]-->Font color and toggle button

<!--[if !supportLists]-->23.   <!--[endif]-->Alignment and Text Wrapping

<!--[if !supportLists]-->24.   <!--[endif]-->Borders

<!--[if !supportLists]-->25.   <!--[endif]-->Numeric and Special Formatting

<!--[if !supportLists]-->26.   <!--[endif]-->Formatting Date and Time

<!--[if !supportLists]-->27.   <!--[endif]-->Conditional Formatting

<!--[if !supportLists]-->28.   <!--[endif]-->Inserting Table

<!--[if !supportLists]-->29.   <!--[endif]-->Shapes and Visual Effects

<!--[if !supportLists]-->30.   <!--[endif]-->Smart Art

 

5 Adjusting Worksheet Layout

<!--[if !supportLists]-->31.   <!--[endif]-->Inserting Rows and Columns

<!--[if !supportLists]-->32.   <!--[endif]-->Shifting Rows and Columns

<!--[if !supportLists]-->33.   <!--[endif]-->Hiding and Unhiding Rows and Columns

<!--[if !supportLists]-->34.   <!--[endif]-->Copying and Moving Data

 

6 Printing

<!--[if !supportLists]-->35.   <!--[endif]-->Print Preview

<!--[if !supportLists]-->36.   <!--[endif]-->Page Layout

<!--[if !supportLists]-->37.   <!--[endif]-->Final Print

 

7 Charts

<!--[if !supportLists]-->38.   <!--[endif]-->Creating Charts

<!--[if !supportLists]-->39.   <!--[endif]-->Changing Chart Types

<!--[if !supportLists]-->40.   <!--[endif]-->Formatting Chart

<!--[if !supportLists]-->41.   <!--[endif]-->Chart Design

<!--[if !supportLists]-->42.   <!--[endif]-->Creating Spark lines

 

8 Worksheet Views

<!--[if !supportLists]-->43.   <!--[endif]-->Freezing and Unfreezing Panes

<!--[if !supportLists]-->44.   <!--[endif]-->Splitting Rows and Columns Horizontally and Vertically

 

9 Multiform Workbook and Worksheets

<!--[if !supportLists]-->45.   <!--[endif]-->Renaming Worksheet

<!--[if !supportLists]-->46.   <!--[endif]-->Inserting and Deleting Worksheet

<!--[if !supportLists]-->47.   <!--[endif]-->Moving and Copying Worksheet

 

10 IF Function

<!--[if !supportLists]-->48.   <!--[endif]-->IF Function

 

11 Vlookup

<!--[if !supportLists]-->49.   <!--[endif]-->Vlookup

 

12 Security and Protection

<!--[if !supportLists]-->50.   <!--[endif]-->Locking and Protecting Data

<!--[if !supportLists]-->51.   <!--[endif]-->Protecting Worksheet Part 1

<!--[if !supportLists]-->52.   <!--[endif]-->Protecting Worksheet Part 2

 

13 Sharing

<!--[if !supportLists]-->53.   <!--[endif]-->Sharing Workbooks

 

14 Data Management

<!--[if !supportLists]-->54.   <!--[endif]-->Sorting Data

<!--[if !supportLists]-->55.   <!--[endif]-->Calculating Sub-Total

<!--[if !supportLists]-->56.   <!--[endif]-->Filtering Data

<!--[if !supportLists]-->57.   <!--[endif]-->Splitting Data Into Different Columns

<!--[if !supportLists]-->58.   <!--[endif]-->Removing Duplicates

 

15 Data Analysis

<!--[if !supportLists]-->59.   <!--[endif]-->Goal Seek

<!--[if !supportLists]-->60.   <!--[endif]-->Scenario Manager

<!--[if !supportLists]-->61.   <!--[endif]-->Data Table

 

16 Pivot Table

<!--[if !supportLists]-->62.   <!--[endif]-->Creating A New Pivot Table

<!--[if !supportLists]-->63.   <!--[endif]-->Manipulation of pivot table

<!--[if !supportLists]-->64.   <!--[endif]-->Grouping Data by Date and Time

<!--[if !supportLists]-->65.   <!--[endif]-->Filtering Data

<!--[if !supportLists]-->66.   <!--[endif]-->Slicer

<!--[if !supportLists]-->67.   <!--[endif]-->Pivot Chart

 

17 Macros

<!--[if !supportLists]-->68.   <!--[endif]-->Using Macros

 

18 Conclusion

<!--[if !supportLists]-->69.   <!--[endif]-->Conclusion

 

19 Bonus Material

<!--[if !supportLists]-->70.   <!--[endif]-->Sorting Data

<!--[if !supportLists]-->71.   <!--[endif]-->Sub-total

<!--[if !supportLists]-->72.   <!--[endif]-->Goal Seek

<!--[if !supportLists]-->73.   <!--[endif]-->Scenario manager

<!--[if !supportLists]-->74.   <!--[endif]-->Pivot table

<!--[if !supportLists]-->75.   <!--[endif]-->Macros

 

20 Additional Content: Grand Finale

<!--[if !supportLists]-->76.         <!--[endif]-->Bonus Lectures. Enjoy the Benefits

 

You could also end up using these skills in your work for Your #Clients, and much more.

 

You'll Also Get:

* Lifetime Access to course updates

So wait no more! Learn Excel, increase your knowledge, become an Excel Expert and advance your career all in a fun and practical way!

WE'D LOVE TO SEE YOU INSIDE AND HELP YOU MASTER EXCEL the Right Way!

Pls leave your much-valued Review.

 

+ View more
Other related courses
17:26:01 Hours
0 1 $199 $8
33:50:11 Hours
0 1 $149 $5
14:14:43 Hours
Updated Mon, 07-Jun-2021
0 1 $149 $5
27:28:08 Hours
0 1 $199 $8
22:43:57 Hours
0 1 $199 $8
About the instructor
  • 0 Reviews
  • 2 Students
  • 86 Courses
+ View more
Online Courses - Learn Online, On Your Schedule | Firste

Firste Academy is an online learning platform with online top best online courses taught by the world's best instructors. Personalized, on-demand e-learning in programming, marketing, data science, development and more.

Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
$5 $149
Buy now
Includes:
  • 02:27:33 Hours On demand videos
  • 76 Lessons
  • Full lifetime access
  • Access on mobile and tv