Excel Business Download The Week

This week you will learn how you can manage your spreadsheets find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.

Within six weeks, you will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.

Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses.

We have brought together a great teaching team that will be with you every step of the way.

A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset.

Work through each new challenge with our team and in no time you will surprise yourself with how far you have come.

Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world.

Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.

At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.

User Learner Career Outcomes Career direction 31 started a new career after completing these courses Career Benefit 31 got a tangible career benefit from this course Career promotion 13 got a pay increase or promotion Shareable Certificate Shareable Certificate Earn a Certificate upon completion 100 online 100 online Start instantly and learn at your own schedule.

Specialization Course 1 of 4 in the Excel Skills for Business Specialization Flexible deadlines Flexible deadlines Reset deadlines in accordance to your schedule.

Beginner Level Beginner Level This Course is appropriate for anyone who is interested in learning about Microsoft Excel.

Available languages English Subtitles: Arabic, French, Portuguese (Brazilian), Vietnamese, Russian, English, Spanish, Hungarian.

More Skills you will gain Graphs Spreadsheet Microsoft Excel Chart User Learner Career Outcomes Career direction 31 started a new career after completing these courses Career Benefit 31 got a tangible career benefit from this course Career promotion 13 got a pay increase or promotion Shareable Certificate Shareable Certificate Earn a Certificate upon completion 100 online 100 online Start instantly and learn at your own schedule.

More Instructors Instructor rating 4.885 (7,034 Ratings) Info Nicky Bull Excel Consultant Macquarie Business School 445,683 Learners 5 Courses Dr Prashan S.

M. Karunaratne Lecturer - Teaching Leadership FHEA Department of Actuarial Studies and Business Analytics, Macquarie Business School 445,683 Learners 5 Courses AProfessor Yvonne Breyer Director, Learning Teaching Head, Learning Futures Macquarie Business School 439,505 Learners 5 Courses Offered by Macquarie University Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world.

Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.

Syllabus - What you will learn from this course Content Rating Thumbs Up 98 (132,678 ratings) Info Week 1 Week 1 Hours to complete 6 hours to complete Critical Core of Excel In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.

Excel Business Download The Week

Hours to complete 6 hours to complete Reading 10 videos (Total 46 min), 8 readings, 8 quizzes See All Video 10 videos Week 1 Introduction 2m Week 1 Discussion 3m Practice Video: Taking Charge of Excel 7m Practice Video: Navigating and Selecting 5m Practice Video: View Options 5m Practice Video: Data Entry, Data Types, Editing and Deleting 6m Practice Video: Fill Handle 5m Week 1 Wrap-up 1m Copy and Paste 5m Templates 2m Reading 8 readings Welcome to Excel Skills for Business: Essentials 20m Course goals and weekly learning objectives 10m Important information about versions and regions 10m Read me before you start: Quizzes and Navigation 10m Download the Week 1 workbooks 5m Week 1: Practice Challenge 20m Week 1: Keyboard Shortcuts, Terminology, and Ninja Tips 25m Week 1: Excellent Tips and Resources 25m Quiz 8 practice exercises Are essential skills too basic for me 10m Taking Charge of Excel 10m Navigating and Selecting 10m View Options 10m Data Entry 10m Fill handle 30m Taking Charge of Excel: Test your skills, Part 1 30m Taking Charge of Excel: Test your skills, Part 2 30m Week 2 Week 2 Hours to complete 4 hours to complete Performing calculations The syntax of formulas is very important in Excel.

Hours to complete 4 hours to complete Reading 11 videos (Total 44 min), 5 readings, 7 quizzes See All Video 11 videos Week 2 Introduction 2m Week 2 Discussion 4m Practice Video: Formulas 3m Practice Video: Formulas in Context 4m Practice Video: Functions I: SUM and AUTOSUM 4m Practice Video: Functions II: AVERAGE, MIN and MAX 4m Discussion: Absolute Cell References 4m Practice Video: Absolute Cell References 3m Practice Video: Calculations across sheets 4m Week 2 Wrap-up 1m Excel Options 6m Reading 5 readings Download the Week 2 workbooks 5m Week 2: Practice Challenges 1h Word Search Puzzle: Master ranges 15m Week 2: Keyboard Shortcuts, Terminology, and Ninja Tips 25m Week 2: Excellent Tips and Resources 20m Quiz 7 practice exercises Formulas 6m Formulas in Context 30m Functions I 6m Functions II 6m Absolute Cell References 6m Calculations across Sheets 6m Performing Calculations: Test your skills 30m Week 3 Week 3 Hours to complete 3 hours to complete Formatting Formatting helps to highlight key messages and make the data presentable.

This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.

Hours to complete 3 hours to complete Reading 10 videos (Total 40 min), 4 readings, 7 quizzes See All Video 10 videos Week 3 Introduction 2m Week 3 Discussion 3m Practice Video: Formatting 3m Practice Video: Borders 3m Practice Video: Alignment Tools 4m Practice Video: Format Painter 3m Practice Video: Number Formats 5m Practice Video: Styles and Themes 5m Week 3 Wrap-up 1m Graphics 6m Reading 4 readings Download the Week 3 workbooks 5m Week 3: Practice Challenge 30m Week 3: Keyboard Shortcuts and Ninja Tips 10m Week 3: Excellent Tips and Resources 15m Quiz 7 practice exercises Formatting 8m Borders 8m Alignment Tools 8m Format Painter 12m Number Formats 8m Styles and Themes 5m Formatting: Test your skills 30m Week 4 Week 4 Hours to complete 3 hours to complete Working with Data This module is all about working with data and making it easy to work with.

Excel For Mac Business