Excel’s Tools & Features | Go from Intermediate to Advanced

سرفصل های دوره

A 90 minute crash course on Excel's most useful features | Write fewer formulas, master keyboard navigation and more!

1. Introduction

1. Introduction

2. Make life easier with Excels tools

1. Pivot Tables - Table View & Key Operations

2. Pivot any data set with Power Query

3. Using the solver tool to find complex solutions

4. Do basic calculations using the quick analysis tool

5. Get Data from any source

6. Using the Formula Bar effectively

7. Troubleshoot issues using Evaluate Formula

8. Cleaning Text data with text processing formulas

9. Understanding how date and time work in Excel

3. Quickly make your work look professional and efficient to use

1. Duplicating windows and using the Camera

2. Creating dynamic drop down menus

3. Quickly understand a data set using conditional formatting

4. How to clear comments, formatting and hyperlinks quickly

5. Filter data in a few clicks using Slicers

6. Organise and hide data using Groups

7. How to build and structure your analysis

4. Saving time with keyboard and shortcuts

1. Navigation within sheets

2. Navigation between sheets and windows

3. Useful keyboard shortcuts 1

4. Useful Keyboard Shortcuts 2

5. How to find your own shortcuts

5. Wrap-Up

1.1 data table image.zip

1.2 Example pdf Data.pdf

1.3 Example Workbook Structure.xlsx

1.4 Excel Course V1 Completed.xlsx

1.5 Excel Course V1 Original.xlsx

1.6 Turbocharge your Excel skills in 90 minutes presentation V1.pdf

1. Whats next

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training