Microsoft Excel – Excel from Beginner to Advanced

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

Category:

Introduction to Microsoft Excel – Excel from Beginner to Advanced Course

After you finish this Intro Course, enroll in the Full Microsoft Excel Course and become an Excel Guru

https://firsteacademy.com/home/course/microsoft-excel-excel-from-beginner-to-advanced/86

You will learn the following:

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:

  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
  • Create dynamic report with Excel PivotTables
  • Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot
  • Audit Excel Worksheet formulas to ensure clean formulas
  • 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

  1. Introduction
  2. Course Outcome
  3. Study Skills Required
  4. How to get most out of the course

2 Getting Started With Excel

  1. Why Excel
  2. Excel Menu System
  3. Quick Access Toolbar
  4. Workbook and Worksheet
  5. Status Bar
  6. Navigation
  7. Shortcut Menus and Mini Toolbar
  8. New Workbook
  9. Save and Save As

3 Working With Formula

  1. Formula Bar
  2. Creating Simple Formula
  3. Copying a Formula
  4. Calculating Year To Date Total
  5. Percentage Change
  6. Working With Functions under Formula

4 Formatting

  1. Fonts
  2. Row Height and Column Width
  3. Font color and toggle button
  4. Alignment and Text Wrapping
  5. Borders
  6. Numeric and Special Formatting
  7. Formatting Date and Time
  8. Conditional Formatting
  9. Inserting Table
  10. Shapes and Visual Effects
  11. Smart Art

5 Adjusting Worksheet Layout

  1. Inserting Rows and Columns
  2. Shifting Rows and Columns
  3. Hiding and Unhiding Rows and Columns
  4. Copying and Moving Data

6 Printing

  1. Print Preview
  2. Page Layout
  3. Final Print

7 Charts

  1. Creating Charts
  2. Changing Chart Types
  3. Formatting Chart
  4. Chart Design
  5. Creating Spark lines

8 Worksheet Views

  1. Freezing and Unfreezing Panes
  2. Splitting Rows and Columns Horizontally and Vertically

9 Multiform Workbook and Worksheets

  1. Renaming Worksheet
  2. Inserting and Deleting Worksheet
  3. Moving and Copying Worksheet

10 IF Function

  1. IF Function

11 Vlookup

  1. Vlookup

12 Security and Protection

  1. Locking and Protecting Data
  2. Protecting Worksheet Part 1
  3. Protecting Worksheet Part 2

13 Sharing

  1. Sharing Workbooks

14 Data Management

  1. Sorting Data
  2. Calculating Sub-Total
  3. Filtering Data
  4. Splitting Data Into Different Columns
  5. Removing Duplicates

15 Data Analysis

  1. Goal Seek
  2. Scenario Manager
  3. Data Table

16 Pivot Table

  1. Creating A New Pivot Table
  2. Manipulation of pivot table
  3. Grouping Data by Date and Time
  4. Filtering Data
  5. Slicer
  6. Pivot Chart

17 Macros

  1. Using Macros

18 Conclusion

  1. Conclusion

19 Bonus Material

  1. Sorting Data
  2. Sub-total
  3. Goal Seek
  4. Scenario manager
  5. Pivot table
  6. Macros

20 Additional Content: Grand Finale

  1. 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.

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel – Excel from Beginner to Advanced”

Your email address will not be published. Required fields are marked *

Translate »